SAP MBEWH Day wise Stock

[rishikeshtiwari]

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

[felipeyague]

Hi, i would like no know if you solved this problem. thanks.

[felipeyague]

Hello, to get the quantity stock on a current date i have worked with mkpf and mseg tables, by adding quantity prior to selected date you get the stock, the problem is valuation i need valuation of stock at the ends of the months but i can´t do that in that way. I was working with mbewh but not all periods are in that table, if you have no movements in a period the table has no entry for that material and valuation class. Did you solve it? Thanks.