Skip to Content

Program to delete delivery in APO after being PGIed .

Hello Experts,

Client wants a background program to delete the Obsolete deliveries which are are existing in APO.

For example, for a plant 0822 several deliveries have been PGIed on 20.06.2016, but still those deliveries are holding in APO.

We have to execute the this program /SAPAPO/SDORDER_DEL - ATP: (SD) - Delete Orders from the Database.

Is there any background job which can help in deleting those obsolete deliveries after being PGIed?

Appreciate your reply

Best regards

Shailesh Mishra

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Jul 13, 2016 at 08:30 AM

    And as expert Former Member mentioned - it does remove the data from the Product view, LC and MD04. However, the contents are not deleted from DB. This is where the report /SAPAPO/SDORDER_DEL comes into picture. It is generally recommended to delete 90 days old data. I am not sure if you would have the PGI reversal process ? So - make sure you delete the right set of data. In case if you had not been running the above mentioned program for years; then there is a custom version of the same program developed by SAP. It is direct DB update to delete the orders. So., you need to run the program /SAPAPO/ZRD_SDORDER_DEL ( via SAP Note 1008133 )during off-business hours.


    Hope this helps


    Babu Kilari

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Babu,

      Yes, client do conduct PGI reversal also. The main bottleneck is deliveries which are PGIed from ECC are holding in APO system. In this regard, we are already executing the report /SAPAPO/SDORDER_DEL for certain Products and locations.

      Business wants a strong solution of this. Everytime, when issue is raised, then we resort to above mentioned program to delete the sales data.

      Is there any workaround of running a background job so that inconsistent sales data can be deleted from APO?

      Appreciate your reply

      Best regards

      Shailesh Mishra

  • Posted on Jul 14, 2016 at 04:28 PM

    Hello Experts,

    I present the proper screen shots against which delivery is no more existent in ECC, Md04, PGIed in November 2015, but delivery is trapped in APO in /N/SAPAPO/RRP3 t code.

    Best regards

    Shailesh Mishra


    5.PNG (237.2 kB)
    6.PNG (302.3 kB)
    7.PNG (222.6 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Hello DB,

      I am sorry, i put wrong material in MD04 and different materials in APO RRP3.

      The issue remains the same. Delivery after PGI is holding in sap.

      Well, I am closing this question because you guys have already answered the basic question which i had asked. I will open different question related to core issue.

      Thanks a lot

      best regards

      Shailesh mishra

  • author's profile photo Former Member
    Former Member
    Posted on Jul 13, 2016 at 01:17 AM

    Shailesh,

    ???? In standard SAP ECC and APO, when you PGI a Delivery complete (PGI the entire quantity of the delivery), the delivery requirement is automatically removed in ECC, and the LiveCache order is also deleted in APO. You should not be able to see the delivery any more using //RRP3 or similar in APO, nor should you be able to see it in MD04 in ECC.

    .

    If this is not happening, I would suspect an enhancement is interfering with standard processing.

    FYI /SAPAPO/SDORDER_DEL can be run in background via batch job.

    Best Regards,

    DB49

    Message was edited by: Dogboy 49

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 13, 2016 at 05:23 AM

    Hello,

    You should first check whether the requirement of the deliveries still exists in ECC as well (check table VBBE).
    If yes, it means you have requirement inconsistency in your system, in this case, you can execute report /sapapo/sdrqcr21 in APO system to delete these inconsistent requirements from both ECC and APO system. This report can be scheduled as background job.
    If no, you can use report /SAPAPO/SDORDER_DEL but it is not suggested to always use this report unless really necessary.

    Best Regards,
    Ada

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.