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 happens if a function module runs in an update task?
What is meant by exclusive, not cumulative lock? : sap abap data dictionary
How do you find if a logical database exists for your program requirements?
What is sap abap data dictionary?
How many structures can be created in a Ztable ?
what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.
What are the types of the programming language used in the sap abap software?
What are the update types possible? : abap data dictionary
How does the system handle roll areas for external program components?
what is defference between repository and non repository Object?
What are different ABAP editors? What are the differences?
In the `select' statement what is group by ?
What are logical data bases used in hr module? : abap hr
What is the function of the transport system and workbench organiser? : abap data dictionary
How to create a check box/option button in a list?