Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Table name for Sales Org/Plant combination for a given material?

Hi Experts,

I hv to find out that, weather the given material(actually, item of a sales order) have not been extended to the Sales Organisation / Plant on the sales order? or not?

So, in this context am looking A555 table......but, here I found 300 entries, where as MARA does hv tonns of materails!!

(A152, A153 tables do not hv any entry).

1 - So, am I lookimg the correct table? or is there any other good table?

2 - Is there any alternative(like FM) to validate the given materail againmst above said condition?


Former Member
Former Member replied

MVKE is the best table, the Sales view displayed in MM03 is referenced from this table.

data: t_mvke like mvke.



FROM mvke

WHERE matnr = p_matnr

AND lvorm <> 'X'

AND dwerk = p_werks.

Hope this helps, if not let us know your requirement.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question