what is Foreign key, check table and value table ....?
what is the difference between CHECK AND VALUE TABLE ..?
PLEASE GIVE THE APPROPRIATE ANSWERS......

Answer Posted / jayasree

A foreign key links two tables T1 and T2 by assigning
fields of table T1 to the primary key fields of table T2.

Table T1 is called the foreign key table (dependent table)
and table T2 the check table (referenced table). The pair
of fields for the two tables must have the same data type
and length. One field of the foreign key table therefore
corresponds to each key field of the check table. This
field is called the foreign key field.

A foreign key permits you to assign data records in the
foreign key table and check table. One record of the
foreign key table uniquely identifies one record of the
check table using the entries in the foreign key fields.

When an entry is made in the check field, there is a check
whether the check table contains a record with the key
defined by the values in the foreign key fields. If this is
so, the entry is valid. Otherwise the system rejects the
entry.

Is This Answer Correct ?    15 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is static attribute

1081


stock transfer from one plant to another plant ? i want the total description.

1572


What is pnp-sw-found ? : abap hr

863


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

628


What are the page headers for secondary lists?

606






WHAT ARE THE MANDATORY FIELDS TO BE FILLED FROM TABLES BAPIITEMIN, BAPIPARTNR, BAPIITEMEX, BAPICUCFG, BAPICUINS, BAPICUPRT, AND BAPICUVAL IN BAPI 'BAPI_QUOTATION_CREATEFROMDATA

2035


Did you create any joins?

549


When value table becomes check table?

574


Explain what are the various types of selection screen event?

553


How to load data from ms excel sheet to sap by using bdc method ? : abap bdc

724


What is the difference between synchronous and asynchronous update?

644


What is img? : sap abap hr

698


What is direct input method ?

1466


What will happen when we use single buffered selected?

620


What are the system fields? Explain?

638