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 are the payroll related Infotypes
Update types in Call transaction method. What is the difference?
What is the t-code for transaction recorder? : abap bdc
What is the difference between function group and function module?
Write the bdc table structure? : abap bdc
How to use messages in lists?
Can we call reports and transactions from interactive reporting lists?
HOW TO TRANSFER VENDOR MASTER DATA FROM LEGACY SYSTEM TO SAP SYSTEM THRU LSMW (IN LSMW, USING DIRECT INPUT PROGRAM:RFBIKR00)
Can matchcode object contain ids with different update types? : abap data dictionary
What are the types of search helps? : sap abap data dictionary
What are the events in screen programming?
What are the different types joins?
Explain how to create any functions?
Which one is better joins or views and why?
What is the transaction code to display the payroll results ? : abap hr