I am facing an issue when I am referring 2 SAP Tables MSEG and MBEWH. Kindly help in this scenario if you have faced
MBEWH table stores historical data (prior months/years) month wise. There is no procedure in this table to store data on daily basis. But in SAP it stores somewhere internally not in this table. So if SAP peoples required the can see the historical Stock and its values historical date wise as well.There is some standard report in SAP like MB5B in this report we can see the historical data date wise.But in Qlik we can take only the tables but in MBEWH table date/day wise Stock and Value is not present it is only present year month wise.
If we are referring MSEG tables for date wise Stock and Amount, we are not getting the actual stock
and amount whatever we are getting in MBEWH. Because in MSEG all the materials will not be present, only those
materials will present for which Movement will happen, If there is no movement for a particular period it will
not be captured in MSEG tables. That is the reason when we are referring the MSEG tables we are getting different
values. But MBEWH values are the required values for Stock and its values.
Looking help from someone if you have faced this challenge.
Thanks & Best Regards