Table name for Sales Org/Plant combination for a given material?
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?
Sudhir Rayapureddy replied
MVKE is the best table, the Sales view displayed in MM03 is referenced from this table.
data: t_mvke like mvke.
INTO TABLE t_mvke
WHERE matnr = p_matnr
AND lvorm <> 'X'
AND dwerk = p_werks.
Hope this helps, if not let us know your requirement.