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 user exits? What is involved in writing them? What precations are needed?
How many types of tables exist and what are they in data dictionary?
Can we use write statements in screen fields?if not how is data transferred from field data to screen fields?
What is Buffering Concept? When should a Table be buffered?
Tell me a scenario where did you use secondary index?
Explain about workbench request and customization requests?
What is difference between float and packed data type?
What is collective search help? : sap abap data dictionary
Exception handling and how does it transfer from called method to calling method?
What are the different modes of processing batch input sessions? : abap bdc
Explain how do you use structures in the abap programs?
What is example class
Final class
What two statements are required in an abap program to output an icon using a written statement?
how to use table control?if suppose i have 6 records and i want more 4 records in sequence.How to handle this scenario?