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
What are plan versions used for? : sap abap hr
What is the syntax for ‘call transaction’?
Some Realtime Examples on Exits .
What is the difference between refresh and free statements?
Difference between sap script and report?
I am getting the (first) page number and the remaining records displayed in another list in another page BUT the PAGE Number is not displayed? What is the code/solution?
How do you retrieve the data for repetitive structures ? : abap hr
What is the difference between retroactive accounting period, earliest retroactive accounting period? : sap abap hr
What is the transaction code to display the payroll results ? : abap hr
What are the advantages and disadvantages of different types of bdc's?
Can we control the sequence in which multiple implementations of a multiple use BADI are called? If yes, how?
Explain what are extracts?
How many detail lists can be created in interactive reporting?
How many ways can a sap system be accessed?
What is use of transparent table in abap? How it is different from pool tables?