Table for Deleted Order details

[Former Member]

Hi Experts

I have deleted a Sales Order.

Now I want to retrieve the details of the deleted order (Which Sales Organization it belonged to)?{

Which table stores the details of a deleted Sales Order?

Similarly, is there a Table storing the details of the deleted Line Items of a Sales Order?

Regards

BD

[kesavadas_thekkillath]

i think there is no separate table for deleted data..

check the deletion indicator field of the table

[GauthamV]

Hi,

You can get those details from CDHDR, CDPOS tables.

Give OBJECTCLAS = VERKBELEG and CHNGIND = 'D' in CDPOS table.

You will the List of all Deleted Sales Orders.

[Former Member]

Hi Gautham..

Thx for reply. Yes.. CDHDR and CDPOS will give us info on which order got deleted and whichever items got deleted.

But, my issue is,

I need to get the deleted Order numbers and Item numbers from CDHDR and CDPOS. Then I should get more details about these deleted stuff.

Like.. if VBELN from CDHDR = '000345', I want to know which Sales Org it belonged to when created? Is there any possibility to get these sort of info?

Rgds

BD

[Former Member]

use FM CHANGEDOCUMENT_READ

[Former Member]

HI,

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 check and it will tell you the history. Hope this helps somewhat!

As a List

Though Sales orders are Deleted, they will be available in Change document tables CDHDR for header changes and CDPOS for item changes . Changes includes deletion also.

So run a Logic based on these two tables.

You shud get a report of all deleted sales order.

Use the report in the following link to base your logic.

[http://www.sap-img.com/ab024.htm|http://www.sap-img.com/ab024.htm]

Hope this Helps

[Former Member]

Hi Experts

To the least and highly specific, I can express my requirement as below:

I want to find the Sales Organization of a deleted Sales Order. HOW?

Regards

BD

[Former Member]

How many times you will ask the same question...??

[Former Member]

Have a look into the responses I got! Only those responses make me to ask the same question again and again!

This is always disappointing me too to ask the same stuff, Mr. Vijay!

[matt]

Maybe it's not possible.

[Former Member]

Hi Bobby,

Unfortunately for you, deleting a sales order from the system is not reversable. It is deleted from the database. so u cannot trace the sales organisation. (As per my knowledge).

Regards.

Pavan.

[Former Member]

Thank you Matt. See.. How decent you are in your response.

But, I hate Vijay Babu Dudla. He is indescent. As if a Lord, he questions me.

He is showing his dirty culture through SDN.

[Former Member]

>

> Thank you Matt. See.. How decent you are in your response. 
> 
> But, I hate Vijay Babu Dudla. He is indescent. As if a Lord, he questions me.
> 
> He is showing his dirty culture through SDN.

R.I.P Mr. Bobby Deol

pk

[Former Member]

Hi,

i think it's not possible. If you realy need the deleted data, ask you basis to restore a data backup.

Regards, Dieter

[Former Member]

Closing the Query

[Former Member]

This is the end of the road for you and your [fake identity|http://www.utrace.de/whois/64.26.204.100] ...

Thread locked and user ID deleted.

Edited by: Julius Bussche on Jul 28, 2009 10:13 AM