topic foreign key in Application Development and Automation Discussions

foreign key

Former Member — Thu, 23 Aug 2007 14:28:03 GMT

what is a foreign key?

Regards,

swathi

Re: foreign key

Former Member — Thu, 23 Aug 2007 14:30:39 GMT

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.

Re: foreign key

Former Member — Thu, 23 Aug 2007 14:31:06 GMT

Swathi,

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

Regards

Aneesh.

Re: foreign key

Former Member — Thu, 23 Aug 2007 14:35:39 GMT

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>

Re: foreign key

Former Member — Sun, 26 Aug 2007 06:47:43 GMT

relationship betweel two table