Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Retrieving data from MBEW based on valuation area

Former Member
0 Kudos
448

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

1 REPLY 1

former_member156446
Active Contributor
0 Kudos
166

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