topic Value Table Purpose (Beyond standard SAP Documentation) in Application Development and Automation Discussions

Value Table Purpose (Beyond standard SAP Documentation)

Former Member — Thu, 28 Jan 2016 11:32:28 GMT

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 ?

Re: Value Table Purpose (Beyond standard SAP Documentation)

kakshat — Thu, 28 Jan 2016 11:43:53 GMT

It provides values for F4 help.

Re: Value Table Purpose (Beyond standard SAP Documentation)

Former Member — Thu, 28 Jan 2016 11:47:15 GMT

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 ?

Re: Value Table Purpose (Beyond standard SAP Documentation)

sabirshah1 — Thu, 28 Jan 2016 11:47:53 GMT

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

Re: Value Table Purpose (Beyond standard SAP Documentation)

Former Member — Thu, 28 Jan 2016 11:50:36 GMT

Hi Simon,

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

Regards,

Rahul

Re: Value Table Purpose (Beyond standard SAP Documentation)

kakshat — Thu, 28 Jan 2016 11:57:46 GMT

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

Re: Value Table Purpose (Beyond standard SAP Documentation)

PeterJonker — Thu, 28 Jan 2016 12:04:49 GMT

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.

Re: Value Table Purpose (Beyond standard SAP Documentation)

Former Member — Thu, 28 Jan 2016 13:14:22 GMT

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."

Re: Value Table Purpose (Beyond standard SAP Documentation)

Former Member — Thu, 28 Jan 2016 13:44:34 GMT

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 ?

Re: Value Table Purpose (Beyond standard SAP Documentation)

kakshat — Thu, 28 Jan 2016 16:30:35 GMT

Yes.

Re: Value Table Purpose (Beyond standard SAP Documentation)

sabirshah1 — Fri, 29 Jan 2016 06:26:49 GMT

Hi Simon,

Kindly Correct me , where i am going wrong .