Value Table Purpose (Beyond standard SAP Documentation)

[Former Member]

So, to cover previous posts & documentation;   the value table ...

• is at Domain level
• is proposed as a check table when you create a FK
• does no entry check unless FK is in place.

Given that the Value Table is not used as a check at data entry unless a FK is created, and any FK would specify the Check Table explicitly anyway ...

... what purpose does a value table serve ?

Is it simply to provide a 'hint' to anyone creating a new FK, as to what the check table should be ?

[kakshat]

It provides values for F4 help.

[Former Member]

Thanks, is helpful.

Though one assumes that it would only do this if was also established as the FK ?

And if that were the case, could help simply not be fed with the values in the FK ?

[kakshat]

There may be scenarios where you do not want to restrict the possible values to a finite set (that defined by the foreign key).

[PeterJonker]

Yes for example the E071 table, foreign lock is defined with values space and X, but in relaity other values are in there as well.

[Former Member]

So in this case, you would use the Value Table to 'suggest' values to enter; but not enforce adherence to them ?

That makes sense.

Think I could mark correct if you can confirm I'm understanding you correctly ?

[kakshat]

Yes.

[sabirshah1]

Hi,

Value table is list of values predefined to particular Domain/Data Element .

for example : we have field meins field in MARA table  i.e unit of measurement . navigate to meins field by double clicking on it , Go to value range tab at domain level , You will find a value table (T006) at last .

So we can say that meins will only allow those values which are present in T006 table other than that it will not accept . and we can say that T006 is the value table for mara-meins .

While coming to check table

Take example of EKKO and EKPO

whenener you enter any PO in EKPO it first checks that value is present in EKKO or not .If PO is present in EKKO than only it will allow values otherwise EKPO will throw an error.

here  EKPO is checking value in EKKO , we can say that EKKO is check table for EKPO.

Regards

Sabir

[Former Member]

Sabir,

Your example is a little misleading if I understand correctly.

You suggest that because a value table is assigned to the field/domain, that then restricts entries.

Yet SAPs own documentation states :

"A check is not implemented by simply entering a value table. The check against the value table takes effect only when a foreign key has been defined."

[sabirshah1]

Hi Simon,

Kindly Correct me , where i am going wrong .

[Former Member]

Hi Simon,

The purpose of value table is not similar to check table, it is a value help at domain level.

Regards,

Rahul