On-order stock quantity from MMBE transaction

[Former Member]

Hi all,

I am developing a Z report in which i want to get the ON-ORDER STOCK which is display in MMBE transaction. So i need the linkage for deriving the on-order stock , iam having material no, plant, storage location, batch . Or any table from which i can dereive the on-order stock

Regards,

Madhukar Shetty

[Former Member · Accepted solution]

Check the table MSKA....

[former_member214878]

Hello Madhukar,

As you are referring MMBE, I am not sure whether MSKA (Which is SO stock) is helpful. This could give you the stock and u can refer your VBELN there.

I think you need MCHB or MCHA tables to see the stock from MMBE. These tables will give you a specific stock per company per batch in all storage location.

Hope this will help you.

Regards,

Ravindra Sonar

[Former Member]

Hi ,

Thanks for your reply. I had to manually calculate On-order stock quantity.

Regards,

Madhukar Shetty

[former_member211991]

Availability function gives the un restricted stock. I need On Order Stock Quantity ( open po qty).

Please let me know how did you calculate manually

[Former Member]

Dear Madhukar Shetty,

I have issue that is same yours.

Can you show me how to calcalate On Order Stock Quantity?

Thanks,

BinhTC

[raymond_giuseppi]

Read this wiki : [Stock Tables and Stock Types|http://wiki.sdn.sap.com/wiki/display/ERPSCM/StockTablesandStockTypes]

Regards,

Raymond

[Former Member]

Hi ,

Use Bapi BAPI_MATERIAL_AVAILABILITY.

pass the input values like plant, material no, unit of measure so that in export parameters you will get the available stock in the field AV_QTY_PLT.

BR,

Lokeswari.