batch based material valuation mb52

[omkar_zemse]

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.

[Nawanandana]

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

[RaymondGiuseppi]

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)

[omkar_zemse]

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.

[RaymondGiuseppi]

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

[omkar_zemse]

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

Now it is matching with mb52.

Thanks for reply.