topic Check table and value table in Application Development and Automation Discussions

Check table and value table

Former Member — Tue, 29 Aug 2006 04:15:36 GMT

Hi all

What is a check table and what is a value table?

Regards

Re: Check table and value table

Former Member — Tue, 29 Aug 2006 04:16:43 GMT

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.

value table : 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.

Regards

Re: Check table and value table

Former Member — Tue, 29 Aug 2006 04:17:20 GMT

Check Table:The Check Table is the table used by system to check if a data exist or not exist.

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.

value table:

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.

Differences:1)check table will carry out the check for input values for the table field being entered in any application and value table will provide values on F4 help for that table field.

2)The check table defines the foreign keys and is part of the table definition. The value table is part of the domain definition.

plz rewards the point if it is useful..:-)

Re: Check table and value table

Former Member — Wed, 15 Nov 2006 18:31:01 GMT

Check table - is for checking the foreign key relation.

for example if there is material a table T1. and there is another table T2 with material and qty. If T1 is check table without a particular material containing in the T1 we cannot create a qty in table T2.

value table - holds the possible values in the table.

SHKZG - the possible value for this is "H" and "S". This can take only these fields ( it will not take any other values).