Retrieving data from MBEW based on valuation area

[Former Member]

Hi all,

Can any body tell me how to retrive data from MBEW table based on valuation area of the plant of the info record .

Thanks in advance

Sahitya

[former_member156446]

SELECT * FROM mbew INTO TABLE gt_mbew

FOR ALL ENTRIES IN gt_mara

WHERE matnr = gt_mara-matnr

AND bwkey IN so_werks

AND lvorm = ' '.

the material in ur system would be split valuated, find out with ur FC.

valuation ares might be 'U' or 'D' or GOOD and BAD, add it to ur select as per ur req