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


Please Help Members By Posting Answers For Below Questions

What are secondary indexes. How can we know which index is being used in a select query?

1006


What is the difference between pnp and pnpce? : abap hr

1096


What is an abap/4 query? : abap hr

617


What are the domains and data elements?

942


What is the difference between a dialog program and a report?

567






What is the difference between RETURNING and CHANGING parameters for a method?

1017


Explain open dataset in sap abap?

807


What are pooled tables?

628


How to combine multiple billing into one RV document ( Step by Step)?

1548


What will happen when we use fully buffered in abap?

570


What are the payroll related infotypes? : abap hr

581


java script for push button in adobe forms.

1903


What are the data classes in abap?

616


Why we are using Macros instead of Function Modules

1625


What are the attributes of the data? : abap data dictionary

656