Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 plan versions used for? : sap abap hr

993


What is the syntax for ‘call transaction’?

1069


Some Realtime Examples on Exits .

2116


What is the difference between refresh and free statements?

1124


Difference between sap script and report?

1155


I am getting the (first) page number and the remaining records displayed in another list in another page BUT the PAGE Number is not displayed? What is the code/solution?

1912


How do you retrieve the data for repetitive structures ? : abap hr

1137


What is the difference between retroactive accounting period, earliest retroactive accounting period? : sap abap hr

1061


What is the transaction code to display the payroll results ? : abap hr

1012


What are the advantages and disadvantages of different types of bdc's?

1013


Can we control the sequence in which multiple implementations of a multiple use BADI are called? If yes, how?

1294


Explain what are extracts?

1033


How many detail lists can be created in interactive reporting?

1154


How many ways can a sap system be accessed?

1184


What is use of transparent table in abap? How it is different from pool tables?

1211