Base table name for fields from Material Master

[Former Member]

Hi All,

I want base table name which holds all possible values of following column:

1)Material Master : X-plant matl status from tab -basic data 1

2)Material Master: X-distr.chain status from tab -sales org 1

for example: Base table for Prod.hierarchy is T179/T179T.

Many thanks to all

Yogesh

[Former Member · Accepted solution]

Dear,

Please check MARA table and field name MSTAE for material.

Regards,

Mahesh Wagh

[Former Member · Accepted solution]

Thanks Mahesh but I know its value available in MARA table for eery material. But i want to know where all possible distinct values are stored?... In other word, when we click on button which is next to this field and from that list we normally select value and then assign to above fields. Where this list is stored for

X-plant matl status

X-distr.chain status

[pankaj_singh9 · Accepted solution]

Hi,

For Basic data 1, it is T141 - Material Status from Materials Management/PPC View

And for Sales view, it is TVMS - Materials: Status in Sales and Distribution

[Former Member · Accepted solution]

Many thanks pankaj....

This is what is i am looking for. Giving points.

[pankaj_singh9]

Hi,

For Basic data 1, it is T141 - Material Status from Materials Management/PPC View

And for Sales view, it is TVMS - Materials: Status in Sales and Distribution