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


Please Help Members By Posting Answers For Below Questions

On abap: did you set up a workflow? Are you familiar with all the steps for setting up a workflow?

749


Performance tuning techniques

1070


What is the different between abap and ooabap? Why do we use ooabap?

869


What’s value table?

775


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.

2698






What is the maximum number of match code id's that can be defined for one match code object? : abap data dictionary

795


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.

1755


what is leave to TRANSACTION?

1204


What are the aggregate objects in the dictionary? : abap data dictionary

938


What are the parameters in bdc_open_group? : abap bdc

808


The commands through which an abap/4 module can “branch to “ or “call” the next screen are?

859


What are system variable in abap?

793


Difference between Field groups and internal tables?

808


What was the requirement of IDoc in your project? How it was working?

1732


What are conversion & interface programs in sap?

813