How to find deleted Sales Orders & Deliveries?

[umasankarparavada]

Hi Guys

How to find information about deleted Sales Orders & Deliveries? Any Tables or Programs or Tcodes.

Thanks in Advance

Regards

Uma

[Former Member]

Dear Umasankar,

Even though the sales order is gone from the database, you can still see the change history of who deleted the order and when. To do this go to Sales Order --> Display --> put the number in and go to Environment --> Changes. Then Green check and it will tell you the history.

Other than that, after the record (order) gets deleted from the database, to get a list of records deleted you will need to run a report (user defined), with the query for VBAK table, for order type and the missing numbers. The date may also be required. Once you get this, you can find out when and who changed (deleted) the documents.

Hope this helps you.

Do award points if you found them useful.

Regards,

Rakesh

[Former Member]

Hi,

If some one deletes an order it will be stored in CDHDR and CDPOS tables.

To know the deleted orders, go to CDPOS

enter "VERKBELEG" in change document object.

VBAK in Table name.

"D" in Change ID.

Reward points pls.

Regards,

Govind.

[Former Member]

HI Uma,

I followed the exact procedure but still could n't find my deleted document ?

I'm learning on ECC 6.0.

thanks

venkat

[umasankarparavada]

Hi,

Deleted orders will be stored in CDHDR and CDPOS tables.

To know the deleted orders, go to CDPOS

enter "VERKBELEG" in change document object.

VBAK in Table name.

"D" in Change ID.

Regards

Uma