cancel
Showing results for 
Search instead for 
Did you mean: 

Open Sales order details in APO

Former Member
0 Kudos
2,131

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

Accepted Solutions (1)

Accepted Solutions (1)

marianoc
Active Contributor
0 Kudos

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

Answers (2)

Answers (2)

thanga_prakash
Active Contributor
0 Kudos

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
Contributor
0 Kudos

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