topic Difference between a check table and a value table in Application Development and Automation Discussions

Difference between a check table and a value table

Former Member — Mon, 19 Nov 2007 04:13:33 GMT

Iyappa

Re: Difference between a check table and a value table

Former Member — Mon, 19 Nov 2007 04:14:33 GMT

<copy&paste_and_everything_else_removed_by_moderator>

Edited by: Julius Bussche on Sep 3, 2008 8:52 AM

Re: Difference between a check table and a value table

Former Member — Mon, 19 Nov 2007 04:34:32 GMT

Hi Iyappa ,

Check Table is Field level checking, but value table is domain level checking

Regards,

Vijay

Re: Difference between a check table and a value table

Former Member — Wed, 21 Nov 2007 18:06:04 GMT

Check table: An input check for the field can be defined with a foreign key. This input check appears on all the screens in which the field is used.

,or first you must know the concept of foreign keys

foreign key is a field in the table that is connected to another table via a foreign key relationship. the purpose of the foreign key is to validate the data being entered in one table by checking against the valid set of values in another table.the table that contains the foreign key is called the foreign key table.the table that contains the valid set of values is called the check table.