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
On abap: did you set up a workflow? Are you familiar with all the steps for setting up a workflow?
Performance tuning techniques
What is the different between abap and ooabap? Why do we use ooabap?
What’s value table?
B -Credit Note report Selection Screen Ranges: Creation date Sales Org Sold to Party Selection condition: Document Category – VBTYP should be ‘O’ Table to be used: VBRK, VBRP,VBPA,ADRC List the CR order types or credit billing type by customer number (or selected customer) and displays the: - Billing Document date (FKDAT) - Customer number (KUNRG) - Name of the reseller (on top of the SAP No) (NAME1) - Billing document number,(VBELN) - order reason (AUGRU_AUFT) - Amount (NETWR) - Currency (WAERK) Group Currency wise, billing type wise sum of Net value. When user double click on field ‘Billing Document #’ , display the document in VF03 Do this using OO ABAP.
What is the maximum number of match code id's that can be defined for one match code object? : abap data dictionary
hi,i worked mostly in core abap.know iam assigned to XI utility project.can u experts let me know what r the basic things i need to learn to work in XI utility project.i already searched in forum.thanks in advance.
what is leave to TRANSACTION?
What are the aggregate objects in the dictionary? : abap data dictionary
What are the parameters in bdc_open_group? : abap bdc
The commands through which an abap/4 module can “branch to “ or “call” the next screen are?
What are system variable in abap?
Difference between Field groups and internal tables?
What was the requirement of IDoc in your project? How it was working?
What are conversion & interface programs in sap?