12-27-2007 11:15 AM
12-27-2007 11:19 AM
Value Table is the Table that tells u from where did the domain values are reflected. When u use this domain and if search help event is performed on the field having this domain , then the values from the value table are displayed so that u can select one value.
This Simplifies user task from not entering unknown data during usage of that field.
Awrd Points if useful
Bhupal
12-27-2007 11:17 AM
Hi,
Its a domain level checking , praposed check table.
Regards,
Prashant
12-27-2007 11:19 AM
Value Table is the Table that tells u from where did the domain values are reflected. When u use this domain and if search help event is performed on the field having this domain , then the values from the value table are displayed so that u can select one value.
This Simplifies user task from not entering unknown data during usage of that field.
Awrd Points if useful
Bhupal
12-27-2007 11:20 AM
Hi,
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.
Domain S_CARR_ID (data type CHAR, length 3) in the flight model describes the three-place code of the airlines. All the airlines are listed together with their codes in table SCARR. It is generally advisable to check fields referring to domain S_CARR_ID against table SCARR. SCARR is therefore entered as value table for domain S_CARR_ID. If you want to define a foreign key for a field referring to S_CARR_ID, SCARR is proposed as the check 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.
Regards,
Nagaraj
12-27-2007 11:20 AM