data dictionary

[Former Member]

what is the difference between check table and value table .

[Former Member]

Hi,

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.

Regards,

Shiva

[Former Member]

Hi Praveen,

Value table :

Value table is a domain level checking .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.A check is not implemented by simply entering a value table! The check against the value table only takes effect when a foreign key has been defined

Check table :

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.. 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.

Important Difference

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.

Regards,

Sunil.

[Former Member]

Hi Praveen,

Value table :

Value table is a domain level checking .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.A check is not implemented by simply entering a value table! The check against the value table only takes effect when a foreign key has been defined

Check table :

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.. 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.

Important Difference

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.

[Former Member]

Hi

Difference Between Check Table and Value Table :

Check Table :

check table is nothing but field level checking & value table is domain level checking.

Value Table :

If the domain of the check field has a value table, this is proposed by the system as check table in the foreign field maintenance. The key fields of the value table are in this case assigned fields of the foreign key table with the same domain. These fields may assume only those values allowed by the value table.

The value range of the domain can be defined by specifying value table.All table fields referring to this domain can then be checked against the corresponding field of this value table.In order the check can be executed, a foreign key must be defined for the value table

useful link :

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

Regards

Nikunj Shah

[Former Member]

Foreign key is used to create the relationship between two tables,

so in simple terms we can say,

the field which is acting as a foreign key field in a table is called Value Table and

the same field which is acting as a primary key field in a table is called Check Table.

Check table is used when we validate the values at field level checking.

Value table will be at domain level checking.

murashali...