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 user exits? What is involved in writing them? What precations are needed?

1113


How many types of tables exist and what are they in data dictionary?

1244


Can we use write statements in screen fields?if not how is data transferred from field data to screen fields?

1060


What is Buffering Concept? When should a Table be buffered?

13067


Tell me a scenario where did you use secondary index?

1097


Explain about workbench request and customization requests?

1137


What is difference between float and packed data type?

1260


What is collective search help? : sap abap data dictionary

1074


Exception handling and how does it transfer from called method to calling method?

1641


What are the different modes of processing batch input sessions? : abap bdc

1270


Explain how do you use structures in the abap programs?

1061


What is example class

1395


Final class

1606


What two statements are required in an abap program to output an icon using a written statement?

1178


how to use table control?if suppose i have 6 records and i want more 4 records in sequence.How to handle this scenario?

2081