Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14853 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
What is the collect statement?
pls if any one have idea ,reply as soon as possible 1.Allied solution group inc. is a genuine company or not ? 2.what is update module. 3.Transaction: scc3 what it is?
What is the max no of match code id’s that can be defined for one match code object?
Can we display a list in a pop-up screen other than full-size stacked list?
identify valid statement when coding a field exit ? a) submit RSCA101X b)MESSAGE E101 C)MESSAGE I101 d)BREASK-POINT
What is sequence of event triggered in report?
If yes then why do we require logical database
What happens if a function module runs in an update task?
Explain what is a foreign key relationship? Explain this with the help of an example.
What are the field and chain statements?
How table control cn be generated using bdc? : abap bdc
What functions does a data dictionary perform ?
What is meant by hot spots? : abap data dictionary
What are the time related infotypes? : abap hr
Is a logical database a requirement/must to write an abap/4 query?
