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 secondary indexes. How can we know which index is being used in a select query?
What is the difference between pnp and pnpce? : abap hr
What is an abap/4 query? : abap hr
What are the domains and data elements?
What is the difference between a dialog program and a report?
What is the difference between RETURNING and CHANGING parameters for a method?
Explain open dataset in sap abap?
What are pooled tables?
How to combine multiple billing into one RV document ( Step by Step)?
What will happen when we use fully buffered in abap?
What are the payroll related infotypes? : abap hr
java script for push button in adobe forms.
What are the data classes in abap?
Why we are using Macros instead of Function Modules
What are the attributes of the data? : abap data dictionary