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.



  • ashrar

    wel thanks for the help this can serve the purpose

  • Vijay

    Thanks alot for giving such information.

  • vkbm

    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?

  • ashwani

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

  • upender

    very nice . it will b useful for learners.

  • jaideep

    Nice tutorial

  • shailesh

    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.

  • Kumar Mitra

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

    Kumar from Germany

  • srinivasa sankar

    Well presented.. very useful

  • SNEHA

    WELL EXPLAINED…….. THUMBS UP!!!

  • Sumit Das

    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

  • Xiaoping

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

  • Saurabh Khadilkar

    Really wonderful explination!