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

[Former Member]

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?

thanq

[Former Member]

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

data: t_mvke like mvke.

SELECT *

INTO TABLE t_mvke

FROM mvke

WHERE matnr = p_matnr

AND lvorm <> 'X'

AND dwerk = p_werks.

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

Thanks,

Sudhir.