Material Availability Date

[Former Member]

Experts,

We are trying to create an ABAP program to create and EDI 846 (inventory advice). We are looking to use the BAPI_MATERIAL_AVAILABILITY to get the ATP quatity for each of the products we are sending to the customer. If the quantity is 0 (zero), we want to be able to tell them when the product will be available.

It was suggested that we use BAPI_MATERIAL_STOCK_REQ_LIST, but we are having a problem understanding where to look for the date that the product will be replenished/available. Or, is there a different FM/BAPI you would suggest we use?

Thanks for all your help.

[sjeevan]

If you configured scope of check, checking rule, checking group (TCode: OVZ9, OVZ2, OVZ0 etc) and assigned the group to each material in master (view Sales:General/Plant) why not use BAPI_MATERIAL_AVAILABILITY?

Looks like BAPI_MATERIAL_STOCK_REQ_LIST gets the data that MD04 does. It does give you the real time values of different stocks and you can choose only those fields which you want to be included you availability calculation like excluding reservations etc and doesn't have to wait for an MRP run. A thing to note is it will show you stock at MRP area level which is by default plant unless you defined more MRP areas and assigned to that particular material.

[Former Member]

Thanks Jeevan - I've checked and we have a checking group assigned to all the products. I just don't see where BAPI_MATERIAL_AVAILBAILITY gives me the date that an out of stock material will be back in stock. ATP and MM are not my strong suits so please forgive me if I am missing the obvious.

[Former Member]

Hi Paul,

In general , ATP brings back the date when the stock can be available. Eg If you have a receipt that is coming in next week then the BAPI willl add another line to the internal table with the quantity and the date it is going to be available. If it returns nothing then it means that there is no receipt coming in and the stock is not going to be available anytime later.You should check table WMDVEX , REQ_DATE and REQ_QTY is the one that you requested and COM_DATE ,COM_QTY , is the one that it can commit the stock to , Basically the date you are looking for. It is the data when the stock is available.

Eg if there is PO coming on 21/09/2011 for a qty 2, the REQ_DATE and REQ_QTY should be 19/09/2011 (todays date you are requesting the stock ) and COM_DATE ,COM_QTY should be 21/09/2011.

Hope that helps

Amber