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 functions does a data dictionary perform? : abap data dictionary
Why do we declare a method of a class final? What can be the purpose? Give a scenario.
While sorting field groups we cannot use more than one key field. State true or false. : abap modularization
What are the different types of view?
What is the tcode to create indexes?
Tell me a scenario where did you use secondary index?
Static and instance variable and method with live example. Why and when to use
What is the name of the system variable that holds the contents of the selected line in interactive reporting?
Explain what is the difference between primary key and unique key?
what are the important fields while preparing sales order,inquiry?
What is off cycle payroll run
Explain the use of table maintenance allowed?
What is the use of 'for all entries'?
What are the sequences of event block?
How to transfer the objects? Have to transferred any objects?