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

Explain buffering concept usage?

605


How to create user interfaces for lists?

619


What are the events driven batch jobs?

593


Which FM do you use to find out who is reporting to whom

5183


List the various components of the enterprise structure in systems, applications, and products (sap) in human capital management (him)? : sap abap hr

521






Mention some important events in abap programming.

588


How we can retrieve data using secondary index. Explain with simple example?

614


How can you display frames (horizontal and vertical lines) in lists?

618


What do you do when the system crashes in the middle of a BDC batch session?

697


Explain the use of insert and append statement in sap abap?

598


How many types of views are there ?

645


How many structures can be created in a Ztable ?

3129


where do we store all custom programs in SD module?

4896


Can a filed occur in several field groups? : abap modularization

662


What is the use of abap data dictionary? : abap data dictionary

586