What is the difference between value table and check table?
Answer Posted / sameera
Value Table
This is maintained at Domain Level.
When ever you create a domain , you can entered allowed
values. For example you go to Domain SHKZG -
Debit/credit indicator. Here only allowed values is H or
S.
When ever you use this Domain, the system will forces you
to enter only these values.
This is a sort of master check . To be maintained as a
customization object. This mean that if you want to enter
values to this table you have to create a development
request & transport the same.
Check table
For example you have Employee master table & Employee
Transaction table.
When ever an employee Transacts we need to check whether
that employee exists , so we can refer to the employee
master table.
This is nothing but a Parent & Child relationship . Here
data can be maintained at client level , no development
involved.
As per DBMS what we call foregin key table, is called as
check table in SAP.
There is 1 more important Difference in Value Table and
Check Table is that:
1. The contents of the check will be used as an input help
(F4 Help) for a particular field on which a check table is
assigned.
But the contents of Value Table are never used in Input
Help.
The Heirarchy which decides from where to used the Input
Help is:
1. Input help defined explicitly in ABAP Program or Dialog
Module.
2. Input Help Attached to the referenced Database Table
field.
3. Using the contents of Check Table as an input help if
neither (1) or (2) help are there.
4. Input help from Fixed value or Value range given in
Domain.
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Application Category?
What is the difference between retroactive accounting period, earliest retroactive accounting period? : sap abap hr
What are the uses of interactive reporting?
What are the different types joins?
Explain the structure of a bdc sessions?
Explain the disadvantage of using exec sql statement in abap?
Describe the data classes?
Explain the function module in bdc?
What are th control break events in abap?
Can we make use of flow logic control key words in abap/4 and vice-versa?
Explain about sap fico testing and the tools used? : abap bdc
We have got some values for Field F1 say 1,2,3,4 and F2 say 10,10,10,10.Now can you tell me what would be the output for F1 if we use At End Of event?and what would be the output for F2 if we use At Last event?Also i want to know what is the difference between Total calculation for At end event and grand total for At last event???
Explain the advantage of structures?
Explain open dataset in sap abap?
How do you find out who has transported a transport request?