How to get info on deleted sales order

[Former Member]

Hi

Can any of u tell us how to get information on deleted sales order...As the deleted sales orders are getting archived ,we need to get info on how many orders got deleted from system user wise....

[Former Member · Accepted solution]

Hi Sudha,

User name (BNAME) stored in the the table USR02.

Reward points

Regards,

Govind.

[Former Member · Accepted solution]

Hi

For deleted orders table of CDPOS we need user name....

[Former Member]

Hi Sudha,

Please check the following tables.

CDHDR--Change document Header

CDPOS-- Change document items

Reward points

Regards,

Govind.

[Former Member]

hi

CDPOS table is correct.we are able to get the deleted sales orders..But user name is not coming..

CDHDR table doesn't give information on deleted sales order....

Thanks for solving my query..But if u could get user name wise it will be very helpful

[Former Member]

hi

Once deleted it is not possible to know the details of sales order.

for deleted sales orders and who deleted check table <b>"cdhdr" and "cdpos".</b>

goto se16 and try with the above tables

chages header and item respectively

regards