0 Replies Latest reply: Sep 28, 2017 11:58 AM by Rishi Tiwari RSS

    SAP MBEWH Day wise Stock

    Rishi Tiwari

      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

      Rishi