topic Re: Inventory Report in Application Development and Automation Discussions

Inventory Report

Former Member — Wed, 18 Sep 2013 12:10:38 GMT

Hi every one,

Recently i started development for Inventory Report.

my client need day wise current stock data. i am using MBEW table for Current stock.

and Previous stock data in MBEWH.

But i need data for day wise in MBEWH table stores period wise only how to get this data from MBEWH table or any other tables

Please provide tables and logic if required.

Thanks

Sureder

Re: Inventory Report

RaymondGiuseppi — Wed, 18 Sep 2013 14:56:30 GMT

Look for the "nearest" MBEWH / MBEW record, and then select every related movement between this date and the required date (MSEG+MKPF) and build the stock level. (You can also replace MBEWH by the multiple history table of MM from MARCH to MVEWH depending on the level of stock aggregation)

Regards,

Raymond

Re: Inventory Report

Former Member — Thu, 19 Sep 2013 12:02:46 GMT

Thanks Raymond,

I got the solution but some materials quantity not matching with MB51 Tcode.

i used MKPF and MSEG tables and i get the current stock currectly that is tally with MARD table. But Previous periods data is not matching with MB51 .

which report need to verify the value.

Please provide Tcode and tables which MovementTypes need to consider.

Re: Inventory Report

RaymondGiuseppi — Mon, 23 Sep 2013 12:17:37 GMT

To get the movements related to a value of MBEW you must read T001K bwkey or T001 bukrs (depend on Customizing) -> T001W werks, then also filter movements not related to MBEW like T134M where wertu NE 'X' or mengu NE 'X' as well as special stocks checking T148 sobfi. (Better ask functional to provides you the rules with your Customizing)

Regards,

Raymond