Table relations

[Former Member]

Hi all,

Iam new to ABAP programming and Iam in the process of learning of it.

I was doing java programming until now and I think Iam making good progress in learning ABAP.

I have a question which have made me pull my hair for a while now.

I want to know the table relation of the following table structure for sales activities.

In real world,If I want to read or check somethings out from 2 tables ,how is it going to be.

Please Refer the attached sales activities.jpg file.

http://img689.imageshack.us/img689/5954/salesactivities.jpg

Also I downloaded from the internet,the following file.

P[http://gassems.com/SAP%20Reources/SD%20Tables.pdf]

In page number 5 is the sales tables

How to read this diagram.how are the tables related?,what are the primary ,foreign keys,which table is called the foreign key table and check table.

Have a mini SAP installed installed in my laptop.Dont have access to the sales order table.

So I was trying to understand the concept by using the flight model transparent tables which was there.

For the Flight Tables the table are - SCARR,SPFLI,SFLIGHT and SBOOK.

see attached diagram "FlightModel.jpg"

http://img693.imageshack.us/img693/8021/flightmodel.jpg

If I go to the ABAP dictionary to look the table SPFLI- mandt,carrid and connid are primary keys and in the foreign key field where 5 or 6 fields.Of which the "carrid" field was also there.

So in this case,the table "SPFLI" is the foreign key table and SCARR is the check table.Is that So?

Would be great if some one could put some light into this.

Thanks

[Former Member]

Hi ,

to answer your statement on

"I want to know the table relation of the following table structure for sales activities."

&

"In real world,If I want to read or check somethings out from 2 tables ,how is it going to be."

...

If you want to be successful as an ABAPer and understand the relation between the underlying tables, you need to put in efforts to understand the process.(e.g. SD cycle,MM cycle,PP cycle,FI cycle, whereall these integrate etc..)

In the post you have given link for sales activities.jpg file.

If you need to understand the relation between the table you need to understand the sales process.

The same rule applies to MM material management activities or any other module for that matter.

Try to invest some time and acquaint yourself in understanding a bit of the industry process, then these lots of tables would make sense to you

Sure, initially everything would look Greek and Latin to you.

Time and judicious effort will help you understand how the tables are linked.

else ..in your own words..you would be left pulling your hair forever...

Regards,

SuryaD.

[Former Member]

I am not sure how the group could answer such a large and open question. This is quite the book to truly explain.

Have you taken the Data Dictionary class? I would start there. This will go through most of these terms about how to create and change tables, foreign keys and check tables as well. I do not believe the course will discuss any of the SAP tables. But, it will definitely help you understand what you are looking at and how they are related.

The foreign key is the relationship between two tables. These are the fields that give you the relationship. And, SAP shows you this table in as the Check Table.

It would take a lot of writing to explain the links that you have included. What might be more benefical is to ask more specific questions about specific tables.

Cheers

John

Edited by: John Louk on Dec 21, 2009 9:22 PM

[Former Member]

Thanks Guys.....

[Former Member]

Hi,

please learn step by step , finally you can understand.

Thanking you.