How to create a Foreign Key in SAP table?

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.

foreign-key-1

Step 2: In the popup window enter the check table name and press Generate proposal button.

foreign-key-2

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-3

Foreign key is created, now save and activate the table. To check the foreign key go to menu path Utilities->Table Contents->Create Entries.

foreign-key-4

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.

foreign-key-5

Observe the error message in the status bar. The user interface does the foreign key validation before creating the entries.


15 Comments

  1. ashrar says:

    wel thanks for the help this can serve the purpose

  2. Vijay says:

    Thanks alot for giving such information.

  3. vkbm says:

    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?

  4. ashwani says:

    wel thanks for the help this can serve the purpose thanks again

  5. upender says:

    very nice . it will b useful for learners.

  6. jaideep says:

    Nice tutorial

  7. shailesh says:

    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.

  8. Kumar Mitra says:

    Real good stuff and very helpful for sappers. Carry on please.

    Kumar from Germany

  9. srinivasa sankar says:

    Well presented.. very useful

  10. SNEHA says:

    WELL EXPLAINED…….. THUMBS UP!!!

  11. Sumit Das says:

    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

  12. Xiaoping says:

    the Primary key and foreign key all come from Relational Database theory. some concepts in this artical about foreign key are not accurate.

  13. Saurabh Khadilkar says:

    Really wonderful explination!

0 Trackbacks

Leave a Reply

Your email address will not be published. Required fields are marked *