Find ref.doc.of a deleted delivery

[Former Member]

Hello Experts,

I would like to ask how can I find the reference documents of an already deleted delivery?

I mean how can I find for ex.the sales order document number which was related to an already deleted delivery?

I would like to mention that I know the deleted delivery number & I want to know for ex.with which sales order number was related at the flow before deletion.

If you could please be so kind and inform me also about the relevant tables & fields which gives this information.

Great thanks in advance.!!!

Kind Regards

George

[Former Member · Accepted solution]

Hello

Once delivery is deleted, we can't retrive the delivery docuemnt. It is difficult to find out the relevant Sales order number.

Not sure, but try with the transaction AUT10 by inputing the required data.

warm regards

Ramakrishna

Edited by: Ramakrishna Ponnapati on Oct 14, 2010 4:16 PM

[Former Member · Accepted solution]

Hi,

An idea: You create additional ZVBFA table where you will store data similar to VBFA. Then you populate this table either by delivery user exit or by standalone program which runs periodically checking document flow. When you remove your delivery from the system, then standard SAP will remove entry from VBFA, but additional record in ZVBFA will remain.

Best regards

Witek Prawecki

[Former Member]

Hi,

As far as my knowledge goes, you will not be able to find out the sales order number by using a deleted delivery document number. The reason is, when you delete the delivery, the reference will be deleted from VBFA table which stores the details of document flow. As there is no reference maintained, you will not be able to retrive the data.

However, you can try to get the sales order number if you know

a. Customer PO number for which the sales order is created (VA02 / 03)

b. Sold to party + Material combination (VA05)

Hope this helps.

Thanks

Mukund S