10-10-2007 1:52 PM
q 1 ) I have heard that tables SPFLI , SFLIGHT ,& SBOOK are related
how are they related ?
q 2 ) How to get the list of the related tables while I am writing code say?
q 3 ) Could you name some of them
q 4) Are these demo tables ( the ones listed) ?
10-10-2007 2:08 PM
Hi
yes above mentioned tables are DEMO tablkes which is used by SAP
it had used in the example proggrams given by SAP
SPFLI , SFLIGHT, SBOOK
these three realted based on the primary key
SFLIGHT, check table is SPFLI
SBOOK check table is SFLIGHT
the relation between any tables is known by useing check tables
there will be check table option in the table SE11 if you click on that table you will know what are the table relatde to that table
Reward if usefull
10-10-2007 2:01 PM
Hi,
Go to se11, type the table name and type ctrlshiftf3.
Will popup to you a screen with the link utilizations of the table that you input.
Mark the table table that you want to see the link and press ctrl+f1, will popup to you now the link with the fields that you need.
Regards.
RP
Message was edited by:
Rodrigo Paisante
10-10-2007 2:01 PM
the three tables you mentioned is used for testing or demo or training purposes. To get the relation of those tables, find the fields that are common from the three tables.
10-10-2007 2:05 PM
Hi,
Yes they are demo tables used for training.
You can find the relations graphically also.go to se11 and press ctrlshiftf11.
If useful, please reward points
Message was edited by:
Raghu Devagiri
10-10-2007 2:08 PM
Hi
yes above mentioned tables are DEMO tablkes which is used by SAP
it had used in the example proggrams given by SAP
SPFLI , SFLIGHT, SBOOK
these three realted based on the primary key
SFLIGHT, check table is SPFLI
SBOOK check table is SFLIGHT
the relation between any tables is known by useing check tables
there will be check table option in the table SE11 if you click on that table you will know what are the table relatde to that table
Reward if usefull