What primary key and foreign key relationship

Answer Posted / harish

the primary key defines the uniqueness of the table.

Let's take the example.MARA..the unique key or the primary key is MATERIAL number.So you cannot have two records of the same material number..the primary key is used to avoid duplicates..

By setting a foreign key brings a relation between two tables..

Let's take the example..VBAP-MATNR it has got the foreign key to the table MARA...so that you cannot enter a value which is not in the table MARA.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write the bdc table structure? : abap bdc

778


What are the differences between session method and call transaction method? : abap bdc

739


wat is the default file name of BAPI trace?

1984


what are the various types of parameters and how are they distinguished from one another?

937


Define subtype ? : abap hr

763






What is an update type with reference to a match code id?

741


what is user specific parameter?

1842


What are the parameters in bdc_open_group? : abap bdc

808


What two statements are required in an abap program to output an icon using a write statement?

701


what is difference between user exit, customer exit and badi?

4546


How do you move on to the next screen in interactive reporting?

867


SM35 transaction, How to automate BDC ?

820


How can we send data to external programs?

841


What are the types of subroutines? : abap modularization

753


Define dispatcher?

997