topic Re: abt value table in Application Development and Automation Discussions

abt value table

prasanth_kasturi — Thu, 27 Dec 2007 11:15:17 GMT

what is value table present in domain?

Re: abt value table

former_member386202 — Thu, 27 Dec 2007 11:17:53 GMT

Hi,

Its a domain level checking , praposed check table.

Regards,

Prashant

Re: abt value table

Former Member — Thu, 27 Dec 2007 11:19:15 GMT

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

Re: abt value table

former_member404244 — Thu, 27 Dec 2007 11:20:25 GMT

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

Re: abt value table

former_member188829 — Thu, 27 Dec 2007 11:20:29 GMT

http://help.sap.com/saphelp_nw70/helpdata/en/e2/667092730811d2959500a0c929b3c3/content.htm