Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

abt value table

prasanth_kasturi
Active Contributor
0 Kudos

what is value table present in domain?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

4 REPLIES 4

former_member386202
Active Contributor
0 Kudos

Hi,

Its a domain level checking , praposed check table.

Regards,

Prashant

Former Member
0 Kudos

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

former_member404244
Active Contributor
0 Kudos

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