Check table Vs Value Table

[Former Member]

Hi All,

Can you say the difference between the check table and value table.

And i need to know the use of these two.

Thanks,

Ram M

[former_member404244]

Hi,

plz go through the below link..

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

Reagrds,

Nagaraj

[ferry_lianto]

Hi,

Please check this from ABAP Dictionary Wikipedia ...

The Check Table is the dependent table to which the relationship is defined using foreign keys. The contents of the check table field are shown in the input help for the referenced field.

The Value Table is the table attached to a field at the domain level, where the entry to the field can be only from the value table. They are not used in the Input Help.

Regards,

Ferry Lianto

[Former Member]

Hi,

The Check Table is the dependent table to which the relationship is defined using foreign keys. The contents of the check table field are shown in the input help for the referenced field.

A foreign key links two tables T1 and T2 by assigning fields of table T1 to the primary key fields of table T2. Table T2 is then known as the check table of the foreign key.

The Value table is the table attached to a field at the domain level, where the entry to the field can be only from the value table. They are not used in the Input Help.

when you define a domain, you already know that all fields that use the domain will need to be checked against a particular table. You can store this information in the domain definition by specifying a value table.

If you try to define a foreign key for a field that points to this domain, the value table of the domain is proposed as the check table for the foreign key.

***do reward if usefull

vijay

[Former Member]

Check Table: The ABAP Dictionary allows you to define relationships between tables using foreign keys . 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.

In cases where this kind of value help was appropriate, you can reconstruct it by creating a search help for the data elements that use the domain in question, and using the value table as the selection method.

Check table will be at field level checking.

Value table will be at domain level checking ex: scarr table is check table for carrid.