Inventory Report

[Former Member]

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

[RaymondGiuseppi]

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

[Former Member]

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.

[RaymondGiuseppi]

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