value tabe

[Former Member]

when we wil create a value table?what is the use to create value table?plzz tell

[Former Member]

Hi

CHECK this link

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

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.

REWARD if HELPFUL....

REGARDs,

GAURAV J.

[Former Member]

Value tables are similar to check tables.These are used for validating the field input on the selection screen.

[Former Member]

Value table is used to assure that you will have main data in tht table and it never used to validate the values. Validation will only takes place when you define it as foreign key table.

Reward points if useful.

Regards,

Nageswar

[Former Member]

Hi,

Vale table:

Please go to the correponding domain and select the value range tab. You can see the value table there.

These value table act as a Search Help. The user can select any values for the corresponding fields.

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.

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.

https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_help&query=value+table&adv=false&sortby=cm_rn...

Refer

Hope this resolves your query.

Value tableIn some cases you already know when you define a domain that all the fields 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 this field. You can override this proposal.

Entering a value table does not implement a check. The check against the value table only takes place when a foreign key is defined.

Value table Holds the master data and

check table used to create foreign key relationship

say u hv employee Id in the employeemaster table

u hv also another table for salary calculation

so considering above case u have to maintain the exact employee ID in salary calculation which is in employee master in that case ur employee master is value table and salary calculation is check table

Reward Points if found helpfull..

Cheers,

Chandra Sekhar.