Skip to Content
0
Former Member
Jun 22, 2010 at 01:02 PM

Inventory details for a particular date

266 Views

All,

I need to get all the inventory details from MBEW/MBEWH table for a particular date. Since these tables store data only period wise, getting the data for a particular date (or for certain months alone) is not easy. So, I am querying MKPF and MSEG for all material documents (and other details such as material number, plant, company code...) posted for a particular date (BUDAT field). Based on MKPF/MSEG data (material number, plant) I am querying MBEW/MBEWH for data.

Can some one confirm if this is a good idea? Will material document numbers be updated in MKPF/MSEG for all inventory related movement? Will MBEW/MBEWH reflect data as per this inventory movements?

Thanks in advance,

Keerthi