Internal Tables

[Former Member]

what is the difference between CHECK TABLE and VALUE TABLE in simple terms ?

[Former Member]

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.

Hope it will be useful.

Thanks,

Sandeep.

[seshatalpasai_madala]

Hi,

Check table is the term that is used when we talk about foriegn key relation ship.

Check table is a table whose key fields are used to check the foreign key fields (see Foreign Keys). Only entries that are contained in the key fields of the check table can be contained in the foreign key fields.

The check table is used to check whether the input values are valid and for the input help (F4 help).

When we create foriegn key relation ship the value table that is mentioned in the domain of the field will be used for proposing the foriegn key relation ship.

In some cases you already know when you define a domain that all the fields 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 this field. You can override this proposal.

Entering a value table does not implement a check. The check against the value table only takes place when a foreign key is defined.

Regards,

Sesh

.

[Former Member]

hi,

value table: used for giving option to users for selecting values form a list given. its similar to fixed domains but has more than one value. user can only select any of the values from the displayed list for the field.

check table: mainly useful in referential integrity purpose. used to check data integrity for foreign keys. means for checking whether the value exists in a table to relates to another primary key value s in such scenarios we go for check table concept.

if useful reward some points.

with regards,

Suresh.A