topic Re: Table for Deleted Order details in Application Development and Automation Discussions

Table for Deleted Order details

Former Member — Mon, 27 Jul 2009 06:31:27 GMT

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

Re: Table for Deleted Order details

kesavadas_thekkillath — Mon, 27 Jul 2009 06:34:07 GMT

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

check the deletion indicator field of the table

Re: Table for Deleted Order details

GauthamV — Mon, 27 Jul 2009 06:36:03 GMT

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.

Re: Table for Deleted Order details

Former Member — Mon, 27 Jul 2009 06:39:51 GMT

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

Re: Table for Deleted Order details

Former Member — Mon, 27 Jul 2009 06:46:29 GMT

use FM CHANGEDOCUMENT_READ

Re: Table for Deleted Order details

Former Member — Mon, 27 Jul 2009 07:01:09 GMT

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

Re: Table for Deleted Order details

Former Member — Mon, 27 Jul 2009 08:48:44 GMT

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

Re: Table for Deleted Order details

Former Member — Mon, 27 Jul 2009 08:52:25 GMT

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

Re: Table for Deleted Order details

Former Member — Mon, 27 Jul 2009 09:11:30 GMT

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!

Re: Table for Deleted Order details

matt — Mon, 27 Jul 2009 11:17:51 GMT

Maybe it's not possible.

Re: Table for Deleted Order details

Former Member — Mon, 27 Jul 2009 11:37:09 GMT

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.

Re: Table for Deleted Order details

Former Member — Mon, 27 Jul 2009 11:56:31 GMT

Hi,

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

Regards, Dieter

Re: Table for Deleted Order details

Former Member — Tue, 28 Jul 2009 07:55:49 GMT

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.

Re: Table for Deleted Order details

Former Member — Tue, 28 Jul 2009 07:56:36 GMT

Closing the Query

Re: Table for Deleted Order details

Former Member — Tue, 28 Jul 2009 07:57:59 GMT


> 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

Re: Table for Deleted Order details

Former Member — Tue, 28 Jul 2009 08:05:11 GMT

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