Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between value table and check table?
- 4 Answers
- 11510 Views
- Accenture, TechCatalyst, I also Faced
- E-Mail Answers
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
Tell me a scenario where did you use secondary index?
How do you find out who has transported a transport request?
What is an abap data dictionary? : abap data dictionary
How do you write manual bdc session method? : abap bdc
Static and instance variable and method with live example. Why and when to use
What are the two ways for restricting the value range for a domain? : abap data dictionary
How do you find the tables to report from when the user just tell you the transaction he uses? And all the underlying data is from SAP structures?
What are the components in sap application server?
What are the names of the function modules that will be generated upon activation of a lock object?
What are the different types joins?
What are the dynapro keywords?
Can we make use of flow logic control key words in abap/4 and vice-versa?
How do you convert non-char field into char type fields ?
What are the events used for logical database?
What are the different abap editors? What is the used of different editors in abap?
