what are value table and check table ?and what are the
difference between them?
Answer Posted / malli.gontla
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 ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is a table cluster? : abap data dictionary
What is the logo in sap script?
What are the different buffering methods?
In the abap/4 dictionary tables can be defined independent of the underlying database (t/f). : abap data dictionary
How do you save data in bdc tables? : abap bdc
What are the field and chain statements?
What is the difference between a substructure and an append structure? : abap data dictionary
How the Sy-Mandt value gets updated in the table and Is this having any foreign key relationship.
How move-corresponding works
What are two methods of modifying sap standard tables? : abap data dictionary
What are critical issues you have faced in your project
When value table becomes check table?
What are the functional areas? User groups?
What are field groups?
Work most on which module: name a few tables?