pankaj.delmade

 Profile Answers by pankaj.delmade Questions by pankaj.delmade

• Nov 8th, 2005

 

As i know when we define foriegn key in an value table then its is called as check table.but i dont have clear idea about value table and chech table i have confusion in my mind.

pankaj.delmade

 Profile Answers by pankaj.delmade Questions by pankaj.delmade

• Nov 8th, 2005

 

As i know when we define foriegn key in an value table then its is called as check table.but i dont have clear idea about value table and chech table i have confusion in my mind.

pankaj.delmade

 Profile Answers by pankaj.delmade Questions by pankaj.delmade

• Nov 8th, 2005

 

As i know when we define foriegn key in an value table then its is called as check table.but i dont have clear idea about value table and chech table i have confusion in my mind.

basanth patil

• Dec 21st, 2005

 

Value table - It's a field in a domain it helps in domain level data validation.

Check table - unlike value table it helps in feild level data validation.

alok saxena

• Feb 2nd, 2006

 

check table is nothing bt field level checking & value table is domain level checking. u can understand it with this ex scarr table is check table for carried. 

Vishal

• Jun 6th, 2006

 

The relational data model contains not only tables, but also relationships between tables. These relationships are defined in the ABAP/4 Dictionary by foreign keys. An important function of foreign keys is to support data integrity in the relational data model. Foreign key fields may assume only those values allowed by the check table, in other words, values occurring in the primary key of the check table.

A foreign key provides a link between two tables, for eg.,T1 and T2 by including a reference in table T1 to the primary key of table T2. For this purpose, Foreign key fields assigned to the primary key fields of T2 are included in T1. Table T1, which is the one being checked, is called a foreign key table, and table T2 is called a check table. The terms dependent (foreign key) table and referenced (check) table are also used.

 

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.