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
How does the interection between the dynpro and the abap/4 modules takes place?
How to upload more than 2GB file from External Source to SAP?
What is the meaning of sap r/3?
What are local objects?
What are the events in abap/4 language? : abap hr
What kind of financial periods exist in sap? What is the relavent table for that?
any one can tell me which is the tables can store in ddic plese dont say db02l,please give me different ways of resideing the tables ?
Explain what are interactive reports?
What are two methods of modifying sap standard tables? : abap data dictionary
How do you read files from the presentation server ? : abap bdc
Different types of locks?
What are the aggregate objects in the data dictionary? : abap data dictionary
What is the purpose of creating symbolic a/c, what is transaction code for same? Can we assign one symbolic a/c to multiple wage types? : sap abap hr
How do we assign dynamic views while creating material master and generating bdc? : abap bdc
Why do we use abstract class