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

How does the interection between the dynpro and the abap/4 modules takes place?

1179


How to upload more than 2GB file from External Source to SAP?

1346


What is the meaning of sap r/3?

1184


What are local objects?

1116


What are the events in abap/4 language? : abap hr

1090


What kind of financial periods exist in sap? What is the relavent table for that?

1128


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 ?

2490


Explain what are interactive reports?

1057


What are two methods of modifying sap standard tables? : abap data dictionary

1297


How do you read files from the presentation server ? : abap bdc

1094


Different types of locks?

1051


What are the aggregate objects in the data dictionary? : abap data dictionary

1541


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

1303


How do we assign dynamic views while creating material master and generating bdc? : abap bdc

1155


Why do we use abstract class

1496