foreign key

[Former Member]

what is a foreign key?

Regards,

swathi

[Former Member]

Relationships between tables are represented in the ABAP Dictionary by foreign keys.

A foreign key is a field (or combination of fields) that represents the primary key of another table.

The table that is referenced by the foreign key is called the check table. The check table is also known as the “referenced” or “parent” table.

The table that contains the foreign key fields is called the foreign key table. The foreign key table is also known as the “dependent” or “child” table.

[Former Member]

Swathi,

It has already been asked on the forum. Check this thread.

Regards

Aneesh.

[Former Member]

You can define the relationships between tables in the ABAP Dictionary by creating foreign keys.

Using foreign keys, you can easily create value checks for input fields. Foreign keys can also be used to link several tables in a Structure link view or a Structure link lock object.

refer

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ea77446011d189700000e8322d00/content.htm">FOREIGN KEYS</a>

<a href="http://www.sapdb.org/7.4/htmhelp/ee/1c5bd9eba711d4aa2800a0c9430730/content.htm">DEFINING FOREIGN KEYS</a>

regards,

srinivas

<b>*reward for useful answers*</b>

[Former Member]

relationship betweel two table