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
Explain the properties of selection screen?
What are the different types of views and their definition?
How to upload more than 2GB file from External Source to SAP?
Why grouping of fields is required? What is the max no of modification groups for each field?
what is defference between repository and non repository Object?
What is the difference between ABAP and HR ABAP
Explain the difference between free and refresh?
wat is the default file name of BAPI trace?
Search help exit details.
How to insert a line into abap internal tables?
What are the two methods for modifying sap standard tables?
Is there any method apart from bdc for data upload to sap? : abap bdc
What are the various events associated with screen programming?
How to combine multiple order in one Delivery ( Step by Step)?
Explain how do you move on to the next screen in interactive reporting?