what do you have in field LQUA-BESTQ ?
If this field is empty, then the quant is in unrestricted use.
Can it be that your MMBE shows different stock types than your WM? If this is a yes, then this may be caused by unprocessed posting change notices. Check LU04 transaction for open PCNs.
Thanks for your reply Jurgeon.My aim is to find the unrestricted stock qtys by bin.When i am selecting the field stock category in LQUA table for unresticted qtys . it is also showing the blocked and quality stock in the ouput.Can u guide me how to get unresricted qty by bin.
My aim is to find the unrestricted stock qtys by bin.When i am selecting the field stock category in LQUA table for unresticted qtys . it is also showing the blocked and quality stock in the ouput.Can u guide me how to get unresricted qty by bin.
If you are using SE16 for this, then you have to put an Equal sign in front of an empty field to enable SAP to search only for records where this field is blank.
Put the cursor into this field in the selection screen. then press F2 and select EQUAL.
You will not able to directly get the bin stock like MARD in WM. But if you are looking for a getting different stock types with respect WM then you can check LTBP table.
are your certain what you are talking here?`
How can you get a stock with its status from a transprot request item (table LTBP)?
And I said already that each stock in WM is stored in table LQUA. field BESTQ has the status like unrestricted, blocked or quality.
of course there is not always just one record in Lqua, as the stock may be stored in several bins.
LQUA is the lowest level a stock can have.
it is at this level: material, batch, bin, storage unit, stock status.
whenever one of these charcteristics changes, a new quant is created