Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

SAP MBEWH Day wise Stock

Hi All,

I am facing an issue when I am referring 2 SAP Tables MSEG and MBEWH. Kindly help in this scenario if you have faced

this challenge.

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


Community Browser