The purpose of the foreign key is to validate the data that is being entered into a table by checking entries in a check table. Foreign keys are checked by the front end user interface only and it is not checked if you issue a direct a SQL statement to update the database.
Follow the steps given below to create a foreign key in SAP table.
Step 1: Open the table in Data Dictionary (SE11) for which you want to create a foreign key. Select the field for which you want to create the foreign key and press Foreign Keys button.
Step 2: In the popup window enter the check table name and press Generate proposal button.
Step 3: The system proposes the foreign key relation based on the domain. Check that the foreign key relationship proposed by the system is correct and press copy.
Foreign key is created, now save and activate the table. To check the foreign key go to menu path Utilities->Table Contents->Create Entries.
Try to create an entry in “Zemployee” table with “Department ID” that is not there in the “Department” table. Enter the values and try to save the entry.
Observe the error message in the status bar. The user interface does the foreign key validation before creating the entries.
wel thanks for the help this can serve the purpose
any one please can say me alv reports
Thanks alot for giving such information.
That’s a subtle way of thnnikig about it.
Hi, I have tried the method you said above, but while entering the value in the screen in the foreignkey table it is not checked in the check table. I dont know why? Can you pls help me?
wel thanks for the help this can serve the purpose thanks again
very nice . it will b useful for learners.
Nice tutorial
THANKS ALOT MAN.
I HAVE ONE MORE QUERY CAN ANYONE TELL ME IS THERE ANY SITE WHERE I CAN DO PRACTICE FOR SAP ABAP MODULE ONLINE.
OR IS THERE ANY SITE FROM WHERE I CAN DOWNLOAD THER SAP SETUP AND THEN I INSTALL IT IN MY SYSTEM.
Shailesh,
Try below link.
http://www.sdn.sap.com/irj/scn/nw-downloads
Real good stuff and very helpful for sappers. Carry on please.
Kumar from Germany
Well presented.. very useful
WELL EXPLAINED…….. THUMBS UP!!!
Can any one tell me which is the foreign key and which is the check table amongst these and why??please
give answers with using table field…..
VBAK
VBAP
VBUP
the Primary key and foreign key all come from Relational Database theory. some concepts in this artical about foreign key are not accurate.
Really wonderful explination!
Thanks for this good explanation 🙂
Sir,your material is very helpful forthosewho want to learn sap,please sen me the entire material.