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,