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

how to create view in bdc..??

2331


How can we declare a table control in the abap/4 program?

642


can any one answer these questions 1)How do you convert non-character field to character field? 2)How do you work with semi colon separated files? 3)why cant we use normal function module for data transfer? 4)what is the structure of CTU-PARAMS? 5)can we use transfer dataset to transfer data in internal table?

1544


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

561


What are the differences between the table and the structure in the data dictionary in the sap abap?

592






Give an example of interface from your project explaining why you used it?

892


What is pretty printer?

601


hi.. sap sd is installed in my PC .i m unable to start becoz ,i have given wrong password many times and it's locked.please tell me how can i open SAP logon. tell the process at my id dst.noida@rediffmail.com please advance thanx

1511


1/ How do u apprach if error occur in sending idocs ? 2/ where u assigned process code ?

1467


What takes most time in SAP script programming?

685


what is code to upload cost centers through call trans. and procedure

2159


what is a text table ?

1815


how to Create reports in SD module such as sales order report, which covers all organization levels, delivery status, invoice status, shipping details and partner function details. The data will be extracted from VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, LIPS, VBRP, MARA, VBEP and KONV tables. plz mention the detail coding Tahnks, Rahul

2873


What are the problems in processing batch input sessions? How is batch inputprocess different from processing online?

558


What is the different type of projects? : sap abap hr

532