Deleted SD Delivery Documents

[Former Member]

For a given SD Sales Order, is there a way to tell if a Delivery document was ever created for it and then subsequently deleted?

[Lakshmipathi · Accepted solution]

No it is not possible to see from sale order. But you can see what are all the deliveries deleted and by whom, via TCode AUT10

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

I don't have access to that t-code. I can request it however. Before I do, does that report tell me for what order the delivery document was for?

[Lakshmipathi · Accepted solution]

does that report tell me for what order the delivery document was for?

Unfortunately the answer is NO. You have to develop a zee report for this.

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Hey sorry, thats not report, you can develop Z report if required.

[Former Member · Accepted solution]

I don't have a problem creating a Z report... but in what tables is this information kept? I know I can create a Z table and record it going forward. However I need to know historically.

[Former Member · Accepted solution]

No, past data will not get. the report will only save the date when deleting delivery

[Lakshmipathi · Accepted solution]

Once a delivery is deleted, it will not store in any table. Hence, you need to apply an exit in such a way that whenever, VL09 is executed, in the background, system should store the delivery number along with field VGBEL.

thanks

G. Lakshmipathi

[Former Member]

There is no way to find deleted numbers with sales order,

you can achive by writing code to store in Ztable when delivery is deleted,

MV50AFZ1 - USEREXIT_SAVE_DOCUMENT_PREPARE

In Z table add fileds called user id/sales order no/Delivery no/material/qyty ect.

[Former Member]

I guess that would work going forward. I am interested in what has happened in the past.