Open Sales order details in APO

[Former Member]

Hello Guru

I have a requirement where I want the report of open sales order till current date in the APO system. I have already explored below tables:

/SAPAPO/POSMAPN –  R/3 Object = 3 (sales order), Sales order Number

/SAPAPO/ORDADM_I –  Time stamp created on, Product ID, location ID

But am not sure how I can get which are the open sales orders from that. Or is there any BAPI or FM which I can call from APO to ECC to get this details.

Regards

[marianoc · Accepted solution]

Hi Andy,

Check t-code /SAPAPO/RRP1. Here you have all the requirements: forecast, sales orderd, deliveries, etc. You can filter the Sales Orders. Note that you will see only the orders relevant for planning, that are the open orders.

Kind Regards,

Mariano

[thanga_prakash]

Hello Andy,

You can call BAPI "BAPI_SALESORDER_GETLIST" which is in ECC system.

In the bapi table parameters, you can find DOC_STATUS which gives you the status of the Sales order.

Regards,

Tp

[tibor_nagy]

Dear Andy,

these DB tables are also displaying the closed, delivered sales orders. These tables are only "reliable" and will displaying only the open sales order when you run at first the deletion report /sapapo/sdorder_del and deleting the obsolete entries from //posmapn and adjusting ATP tables with //posmapn.

Regards,

Tibor