topic Re: batch based material valuation mb52 in Application Development and Automation Discussions

batch based material valuation mb52

omkar_zemse — Tue, 28 May 2019 12:49:14 GMT

I am working on a Z report which shows material value based on batch must be matched with mb52.

In mb52 unristricted quantity is showing but value shows 0 for certain batch when special stocks is checked.

What logic i put to match this.

Thanks And Regards.

Re: batch based material valuation mb52

Nawanandana — Tue, 28 May 2019 13:12:49 GMT

Hi,

I think if you need to get same logic why don't you copy the MB52 program or enhance and add whatever the additional field what you need.

you can try this FM.

BAPI_MATERIAL_STOCK_REQ_LIST.

Get the Stock data from the tables MCHB for the material/plant/batch combination

Regards,

Nawa

Re: batch based material valuation mb52

RaymondGiuseppi — Tue, 28 May 2019 15:09:08 GMT

Did you analyze MB52 to understand when and which table is read to valuate an item (MBEW, EBEW, QBEW, OBEW) and how to join those tables from MCHA/MCH1, MCHB.

Another solution is calling the report behind MB52 and in the standard report, export the data/suppress the dialog (with some enhancement of the transaction, e.g. add an hidden parameter, and before display if the parameter is set, export data to memory and return)

Re: batch based material valuation mb52

omkar_zemse — Wed, 29 May 2019 05:24:36 GMT

Yeah, stock & values are coming properly from mchb and mbew respectively , but how i can determine, which batch have zero values for materials in it.

Re: batch based material valuation mb52

RaymondGiuseppi — Sun, 02 Jun 2019 17:34:52 GMT

You have to analyze your data and customizing for fields such as SOBKZ or KZBWS.

Re: batch based material valuation mb52

omkar_zemse — Mon, 03 Jun 2019 05:05:11 GMT

Yes, Raymond Giuseppi, I inner join mcha with mssa and red value of kzbws.

Now it is matching with mb52.

Thanks for reply.