cancel
Showing results for 
Search instead for 
Did you mean: 

Deleting list for sale order

former_member358181
Active Participant
0 Kudos

Hi Guru’s

How can get the deleting list for sale order?

Useful answer duly rewarded back.

Regards,

Devendra

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

With transaction <b>SE16 </b>you can view table CDHDR for header changes and

CDPOS for item changes. This includes deletion.

former_member358181
Active Participant
0 Kudos

Thank for reply. But I need report for deleting sale order.

Is there any stander report?

Regards,

Devendra

Former Member
0 Kudos

looks like you need a report to give a list of the sales orders that need to be deleted.....but how would the system know what has to be deleted...its not like an incompletion log report..where system know whats fields to look to get the list....

i don't know the reason why you want to delete sales orders..but if you are looking to delete all the OLD sales orders...may be then you should go on the path or archiving!

former_member358181
Active Participant
0 Kudos

Thank for reply, How can use the report for path or archiving & pl tell steps.

Regards,

Devendra

Former Member
0 Kudos

Hi Devendra,

General Sales order will be deleted form the database after archiving.

Step for Archiving:

Sales Order is archived and deleted by the Archiving object know as SD_VBAK.

If you just want to delete the sales order with out thinking of saving to archive server then please follow the path:

1.GOTO SARA ---> Click Customizing -> click Archiving Object specific customizing (Technical settings)> In delete jobs mention start automatic --> Leave other settings as per the standard save and close it.

2. Click write --> Mention Variant name -->Click on Maintain --> Select all the sales orders that you want to archive and delete --> Mention sales organinsation under which you have created --> Select Production Mode --> Click on Attributes --> Mention meaning of that attribute it could be any text --> Enter and save.

3. Click on Spool parameters --> mention the output type --> Enter now you can see green signal light

4. Click on Start date --> Click on Immediate --> Save.

5. Execute or click F8 and see the job.

6. After some time you can see the data is archived and deleted form the database.

Hope this will help you in deleting the sales order form the database.

Please Note: It is bit complicated you should take help of SAP Archiving consultant.

-Thanks,

Ajay

Message was edited by:

Ajay Kumar

Message was edited by:

Ajay Kumar

Answers (1)

Answers (1)

Former Member
0 Kudos

If u want to see all deleted sale order

<b>Go to SE16</b>

Check in history table <b>CDPOS.</b>

Object class = VERKBELEG (sales order)

Table name = VBAK

Change ID = D

It will give u all the sales orders deleted