what is Foreign key, check table and value table ....?
what is the difference between CHECK AND VALUE TABLE ..?
PLEASE GIVE THE APPROPRIATE ANSWERS......
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nirmalafredrick
Value Table is maintained at DOMAIN Level for Value
Restrictions.
Is This Answer Correct ? | 11 Yes | 1 No |
Answer / jayaram
check table:check table is a master table
it will provide f4 help.
its a field level validation.
value table: its a item level table.
its a domain level validation.
Is This Answer Correct ? | 6 Yes | 3 No |
what next in SAP-ABAP/4 is it going to be change?
what is exact difference between uline ad sy-uline?
What are the different types of views in sap? : abap data dictionary
How collect statement is different from append?
how many subscreens we can create in a main screen?
what is ment by view?how many types are there ?what are they?and what is the difference between data base view and projection view?
12) How to add Text Modules in SMARTFORMS?
Explain what is the step-by-step process to create a table in data dictionary?
WHY WE NEED TO CREATE A PORT IN ALE IDOCS?
What are control tables? : abap data dictionary
How do you populate data into a multiple line field?
1.why dont use top of page. wat is the use? 2. wat is sub screen? 3. why u select the session method in bdc ? how many records wil be updated on that time? 4.why dont use start form in script? 5.wat is difference b/w dilldown and interactive report? 6. wat is pf status interactine report?