use of value table

[Former Member]

hi experts,

i have gone through many posts in SDN but couldnt understand the real use of value table.

According to my understanding,value table is not used for data validation and F4 help.Then what is the actual use of value table??

Please help

[Former Member]

Hi Kiran,

This Post should clarify all your questions :- http://scn.sap.com/thread/408436

PS: Basic yet good question!

BR,

Ankit.

[Former Member]

hi ankit,

  i have gone through the post and its mentioned that value table is used for domain level validation.

Can you please brief me on what actually is domain level validation??

[Former Member]

Hi Kiran,

By Domain Level it means all the permissible values are stored at the domain i.e. for every data element is associated with domain and all the values allowed can be seen via double clicking on it.

Eg :- Invoice Document types (Check values in VBRK table)   M - Invoice, O - Credit Memo, P - Debit Memo etc.

BR,

Ankit.

[Former Member]

Hi Ankit,

Thank you for your reply.

I have checked Invoice Document types (VBRK table)   M - Invoice, O - Credit Memo, P - Debit Memo etc.

But i can see that these are fixed values of domain VBTYP.

And i see data validation even in my Custom table when i specify fixed values at domain level.

I want the exact use and domain level validation using a value table.

Thanks

kiran reddy

[arindam_m]

Hi,

The value table allows you to restrict the values that can be used or given as input for the field. Also most values tables (Not the domain fixed values that's different from value table) gets updated by maintenance on part of functional guys like creating a new document type or output type and also allow validation st higher levels.

If you check the table VBPA(Sales Document segregated on Partner)  field VBELN with domain VBELN the value table is VBUK so basically it checks if the document exists in Header Status and Administrative Data in table VBUK.

Another good example is BUKRS (Company code) its always checked against value table T001 as its pre-requsite to create the the entry in T001 via creation of company code and use is via domain BUKRS in various tables. Ensures a good centralized check instead of querying individually at all program levels.

Cheers,

Arindam

[Former Member]

Hi Kiran,

Apologies for delayed response.

Value Table - After NetWeaver 4.0 it was not possible to use the values present here for input help. It is only used as default values for the check table values.

Check Table - They are used for defining Foreign Key relationship and are used for checking validity of  values. Also they are used for input help.

BR,

Ankit.

[raymond_giuseppi]

Data validation usually use foreign keys relation or domain values (can be a table) and must be coded in source as in a SE54/SM30 generated maintenance dialog, when F4/Search help comes from an hierarchical list

Ddic check/value tables don't actually generate constraints in the database.

Regards,

Raymond

[Former Member]

Hi Kiran,

In plain words there are 2 concepts you are confusing

1. Check Table [which becomes value table also but not at domain level but directly].

    It comes with foreign key and F4 is by default from the parent table in this case the value entered

    is checked on the fields. Similar is the case with Domain Fixed values you cannot enter any other

     Value than the ones specified in parent table or domain range or Fixed Values.

     So this is kind of an OBLIGATORY check to compile with.

    Example the WERKS Field in EKPO.

2. Value table: This is defined in the Domain and used generally to suggest values. But in this case the

     Value entered in NOT checked if it is not with check table. An example is the T001W table where WERKS_D is the data element WERKS is the DOMAIN and T001W is the value table here it will show the value in F4 but not check.

I hope it clears.

BR

[Former Member]

A value table only becomes a check table when a foreign key is defined. If you

refer to a domain with a value table in a field, but no foreign key was defined at

field level, there is no check.

Best Regards

Akhilesh