I am facing a situation in which the opening stock for the material is zero but it is showing a price for zero stock, i.e material is being valuated for zero quantity. I find this is MB5B. For the same material no material documents are found related to this in any transaction. Please help
Price and stock value are totally different. You can have a price(MAP or standard) without even having stock. but stock value is calculated by stock*qty = stock value. If there is no stock, only stock value will be different.
so check in material master, whether you're checking at price or value.
To check the stock and stock, use MC.9 report
In my case i am finding this in MB5B, and that is for stock. For opening balance on an earlier date before any transactions for the material has been done I found the stock to be zero but the value at some rupees.
So I wanted to know from where am I getting this value for zero stock. There has been no initial upload or any other material document relating the same in MB51 or even in the tables MSEG/MKPF
there is no material document related to tha transaction. What I am facing is for zero stock I am getting a value, i.e in MB5B i can see the opening stock from the earliest date as zero but value is present for that stock. Even before the first ever transaction for the material was made.
hope you understood what my problem is
stock value = stock * price.. but as you and everyone of us said this is a discrepancy in MB5B only or even in the table.. did you check the MBEW, MBEWH, MARDH and MSEG table? If these tables are fine perhaps its not a big problem and issue is with only MB5B behaviour.
If you checked all the options mentioned by all the freinds, then you have raise a ticket to SAP to fix your issue.