Expiring Lot-Controlled items and open orders/deliveries

[Former Member]

<h5> Hi,

We are writing a custom program to block lot-controlled items which are near expiry. The custom program query LQUA-VERME (available stock) field to determine the qty it can block. However, the LQUA-VERME field does not take open orders and open deliveries into consideration. For example, for an item, the available stock in the warehouse (LQUA-VERME) is 20. But there are 5 open deliveries and 5 open sales orders. So in reality, the custom program should block only 10 units. Is there a SD table/field which has consolidated open deliveries and open orders qty we can look at? Or available stock in WM after considering open deliveries and open orders? <h5>

Thank you.

[Former Member]

Hi,

SAP does availability check based on IM stock and not on WM stock.

So I dont think there are any such reports available that shows WM stock with considering delivery and sales order quantity.

regards,