what is Foreign key, check table and value table ....?
what is the difference between CHECK AND VALUE TABLE ..?
PLEASE GIVE THE APPROPRIATE ANSWERS......
- 3 Answers
- 14063 Views
- Patni, I also Faced
- E-Mail 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
In sap script how to print bar code in vertical manner
What was the requirement of IDoc in your project? How it was working?
hi..i hav developed an interactive report in which alv list display in basic list and 1st secondary list in alv grid display.I want to get summation(total) of the columns in the secondary list.I hav used 'do_sum' but i couldnt get.is there any other way to get summation(total) in secondary list which is an alv grid display
How to create any functions?
What are the two ways for restricting the value range for a domain? : sap abap data dictionary
Lock objects and what are parameters of ENQUEUE FM?
Explain what is sequence of event triggered in report?
What is the use of table maintenance allowed?
What is a view? : abap data dictionary
What are the prerequisites for creating foreign key relationship?
What are the different buffering methods?
What is sap abap data dictionary?
Why do we use logical blocks in abap program?
What is going life actually? What is the role of a functional consultant in it? : sap abap hr
How do you restrict the data to be entered in the payroll area? : sap abap hr
