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
What is the use of a pretty printer?
Explain some essential objects in abap dictionary?
What is human resource information systems (chris)? : sap abap hr
What is the use of the raising exception? : abap modularization
What are the two levels in defining a match code? : abap data dictionary
how do you transport lsmw data from one system to another?
What will happen when we use single buffered selected?
Explain Singleton class
What is the table buffer?
what is leave to TRANSACTION?
What is a help view? : abap data dictionary
How do you send files to the legacy systems from sap and vice versa? How does one know that the legacy files have come on to the sap server you are working on? : abap bdc
how to read the standard field value in your custom program.
What are the system table used in abap?
While using extract datasets it is required to have a special workarea for interface. State true or false. : abap modularization