wjhat is the exct difference between check table and value table

[Former Member]

I think most of technical guy having same doubt: that what is the difference between CHECK TABLE AND VALUE TABLE?

[Former Member]

Check Table: A dependent table is called a foreign key table, and the referenced table is called the check table. Each key field of the check table corresponds to a field in the foreign key table. These fields are called foreign key fields. One of the foreign key fields is designated as the check field for checking the validity of values. The key fields of the check table can serve as input help for the check field.

Value Table: Prior to Release 4.0, it was possible to use the value table of a domain to provide input help. This is no longer possible, primarily because unexpected results could occur if the value table had more than one key field. It was not possible to restrict the other key fields, which meant that the environment of the field was not considered, as is normal with check tables

finally check table depends on data type

value table depends on domain eg here is if there is only 2 possiblities like Female & Male then we'll go for one option..

hope it is cleared..

bye--

Pradeepa

[jayanthi_jayaraman]

Hi,

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.

[Former Member]

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

Svetlin

[Former Member]

Hi,

As the name suggests itself, 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.

Regards,

Jagath