abap-dictionary

[Former Member]

hi experts,

what is value table&check table in abap dictionary.

where we use it. and what is the purpose.

thank u,

cnu

[Former Member]

check table is use to check the value is valid in SAP system.

for example plant field, check table is T001k, when user enter plant 1000 in the system, the table will check the value is exit in T001k.

[Former Member]

In some cases you can see when you define a domain that all the table fields or structure components referring to this domain should be checked against a certain table. This information can be stored in the domain by entering a value table.

"The system proposes the value table as check table when you try to define a foreign key for the field or component".

[Former Member]

Check Table:The Check Table is the table used by system to check if a data exist or not exist.

While creating a table if you want to be sure that a field can have some values and these are in a certain table, you can give IT this table as CHECK TABLE.

value table:

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.

Differences:1)check table will carry out the check for input values for the table field being entered in any application and value table will provide values on F4 help for that table field.

2)The check table defines the foreign keys and is part of the table definition. The value table is part of the domain definition.

plz rewards the point if it is useful..:-)

[Former Member]

Hi,

Check this link

http://help.sap.com/saphelp_nw04s/helpdata/en/e2/667092730811d2959500a0c929b3c3/content.htm

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.

http://www.sap-img.com/abap/difference-between-a-check-table-and-a-value-table.htm

Hope thsi helps.

[Former Member]

hello,

let me explain.

value table is basically for offering list of possible values for the user input. this gives him some convenience while giving input.

when it comes to check table, the particular field of your interest will be the primary key in this table. if u define foreign key relationship, for the field of interest then user input for this field is checked against the values existing in check table. if not found an error is thrown.

<b>EXAMPLE</b>. u use SPART in your ztable. while entering a value, u press F4. u can possible values this is because u have value table defined in the domain SPART.

now if u give some non-existing division number, system does not say anything. bcoz no foreign key relationship is created yet by u.

now u create foreign key relationship in SE11. and then give a wrong division number, system says invalid input.

hope this will explain.

reward if useful....

[Former Member]

Check out these threads..

REgards,

Santosh

[Former Member]

Hi Srinivas,

Please close the existing threads opened by you.

[anversha_s]

hi srini,

its a very simple cncept.

Check Table is for Field level Validation whereas Value table is for Domain Level Validations.

Value Table proposes table for check table.

I think you are clear with this.

rgds

anevr

mark all helpful answers

[Former Member]

Hi Srinivas,

Value Table is created at domain level and is for restricting values for that particular field which has that domain.It conatins all possible enteries but does not validate.

Check table is the master table for particular field as for bukrs check table is T001 .whenever we validate a particular field the we need to check in the check table.

whenever we create a Foregin Key relation on particaulr field the control looks in value table if its there then that can be a check table also.<b>so a value table can be a check table also.</b>

Thanks

AB

[Former Member]

Value Table

This is maintained at Domain Level.

When ever you create a domain, you can enter 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 force you to enter only these values.

This is a sort of master check. To be maintained as a customization object. This means 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 foreign key table, is called as check table in SAP.

There is 1 more important Difference in Value Table and Check Table is that:

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 Hierarchy which decides from where to use 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.

Best Regards,

Vibha

*Reward points if it helps

[Former Member]

Hi friends

I am in the development of a report in Quality Management Module. I am using QAMV and QASE tables for picking the inspection results. i wanted to know the table name in which i will get summarized inspection results.