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 SAP Data conversion ?

704


Can we create field without data element? If yes, how?

776


How to transfer the objects? Have to transferred any objects?

680


Is it possible to run host command from SAP environment? How do you run?

708


What are standard layouts sets in the sap script?

641






Explain about the tables exists in a data dictionary and what are they? : abap data dictionary

720


what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.

2171


In events, start-of-selection is a default event. When we have to use this event explicitly? Why?

668


What type of user exits have you written ?

1593


How to create any functions?

651


What is the transaction code to display the payroll results ? : abap hr

648


What is the table & field to identify the no of items (bottles) stored in one case?

2071


Where do you create indexes in abap?

726


Update types in Call transaction method. What is the difference?

692


What is the difference between get and get late?

691