difference between check table and valuetable

[Former Member]

Hello sdn friends,

difference between check table and value table?

waiting for ur reply

[Former Member]

Hi Sreenu,

Check Table :

If suppose a foreign key links two tables T1 and T2 by assigning fields of table T1 to the primary key fields of table T2.

Table T1 is called the foreign key table (dependent table) and table T2 is the check table (referenced table). The pair of fields for the two tables must have the same data type and length. One field of the foreign key table therefore corresponds to each key field of the check table. This field is called the foreign key field.A foreign key permits you to assign data records in the foreign key table and check table. One record of the foreign key table uniquely identifies one record of the check table using the entries in the foreign key fields.

Value Table :

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.

The system proposes the value table as check table when you try to define a foreign key for the field or component. This proposal can be overridden.

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.

Regards,

Swapna.

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

There is 1 more important Difference in Value Table and Check Table is that:

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

The Heirarchy which decides from where to used the Input Help is:

1. Input help defined explicitly in ABAP Program or Dialog Module.

2. Input Help Attached to the referenced Database Table field.

3. Using the contents of Check Table as an input help if neither (1) or (2) help are there.

4. Input help from Fixed value or Value range given in Domain.

regards,

babu

[Former Member]

Hi,

for easy understanding, Foriegn key table in DBMS is your Check table in SAP.

and ur f4 help comes from this check table.

value table is wat you declare in domain level providing a customised master check

[Former Member]

foreign key is used to establish relationship between check table and value table.Whenever a value entered in the value table , a checking is always performed whether the value is already exist in the check table or not.If the value does not exist at the check table(also known as dependent table) SAP system rejects the value.

value table maintained at domain level.when u create a domain u can give some values, such as for Debit/credit indicator u can not give input other than H or S.Means a checking is performed against the check table which contains the value H/S.

The contents of the check table can be used as an input help (F4) for the particular field of the value table.

[Former Member]

Hello Sreenu vasu,

Value table is maintained at the data element level and check table at the dictionary level. If you enter a value table, and when you want to put a check table for your field, the system proposes whether you want to use the value table as the check table. You can accept or reject the proposal.

Hope it helps you

Regards

Indu.

[Former Member]

Hi Sreenu.

The Check Table is the dependent table to which the relationship is defined using foreign keys. The contents of the check table 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.

Value Table becomes a Check Table:

while establishing foriegn key relation between check table and foriegn key table if at the domain level value table is provided then the system will prapose that value table as check table if you accept this prposal then value table will becomes check table.

Other References Differences:

[SAP Reference|http://help.sap.com/saphelp_nw70/helpdata/en/e2/667092730811d2959500a0c929b3c3/frameset.htm]

[Reference 1|http://www.sap-img.com/abap/difference-between-a-check-table-and-a-value-table.htm]

Good Luck & Regards.

Harsh Dave

Edited by: Harsh Dave on Jul 11, 2008 10:46 AM

[Former Member]

hi,

Check out this link.

http://www.allinterview.com/showanswers/757.html

Hope this will help.

Regards

Sumit Agarwal

[Former Member]

Hi,

Value Table :

Is to display possible values for a field. When the particular field is placed on any screen when you press F4 then possible values are displayed from Value table.

Maintain value table at domain level.

Check Table:

When ther is a foreign key ralationship betwwen 2 tables then,

the first table is called as foreign key table and the table which you have a relationship from this table to the secon table is check table.

You can enter values in the foreign key table if there exist a record in check table.

Regards,

Rajitha.

[Former Member]

Hi sreenu,

http://www.geekinterview.com/question_details/16920

Regards,

Sravanthi

[Former Member]

Hiii!

Check out these links

http://www.abapprogramming.net/2007/06/lesson-12-abap-dictionery.html

http://abapdictionary.blogspot.com/2007/10/indexing-and-buffering.html

The value range of a field can be defined by specifying a value table in the domain.

In contrast to fixed values, simply specifying a value table does not cause the inpur to be checked. There is no input help either.

If you enter a value table, the system can make a proposal fot the foreign key definition.

A value table only becomes a check table when a foreign key is defined. If you refer to a domain with a value table in a field, but no foreign key was defined at field level, there is no check.

The check table is the table whose key fields are checked, during maintaining the foreign key relationship. This is also called referenced.

Regards

Abhijeet Kulshreshtha

[bpawanchand]

HI

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.

Further Reference follow the link

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

Regards

Pavan

[Former Member]

Hi Sreenu,

Value table contains all the possible values ofa field of a table.

Check table also contains all the possible values of a field of a table.

But the main difference is that value table is just a proposal, it is our decision whether we use is itor not. If we accept the value table as our possible values table, then it becomes our check table.

Value table is just a proposal and if we accept it it becomes our check table.

Chekc this link :

http://www.allinterview.com/viewpost/18841.html

Hope this helps you.

Regards,

Chandra Sekhar

Edited by: Chandrasekhar Gandla on Jul 11, 2008 7:01 AM