Calculating Free Stock

[former_member1009930]

I'm trying to calculate the Free Stock per plant. Can someone give some expertise on how to calculate this?

The idea was to use the LABST field from the MARD table to identify the Unrestricted stock.

After that we have to detract the stock from the open orders, because i don't think that the Unrestricted stock is excluding stock that should be reserved for the open orders?

For that i think i need to use the EKKO and EKPO table.
The EKPO table to identify the Orders and Quantity (MENGE field) but how can we identify the open orders?
EKKO table to join with the EKPO table to only select orders that with the BSART value = ZP, which are the market to factory orders.

Can someone share their thoughts on this? 🙂

[AnnePetteroe]

Hello Twan,

Thank you for visiting the SAP Community to get answers to your questions. Since this is your first question, I recommend you familiarise yourself with our Community Q&A, as this overview provides tips for preparing questions that draw responses from our members.
Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a Picture to your profile you encourage your readers to respond.

All the best,
Anne