Q
Problem solve Get help with specific problems with your technologies, process and projects.

How to delete processed IDocs

One of your earlier responses indicates that "In nearly most cases it is safe to delete IDoc that come from an...

ALE scenario (like BW) as soon as they are sent out or processed successfully." My question is, how can we delete them? Is this a simple process or do we have to configure everything for archiving? We are on 4.6C. Thanks! There is no regular housekeeping utility to delete the IDocs. The official way is to archive the IDocs via transaction SARA. However, a simple ABAP that deletes the IDocs from the three tables and cleans up the log files will do. Deleting IDocs only is done like this:

Select-options: s_docnum for edidc-docnum. Data: tedidc type standard table of edidc with header line. Select * from edidc Into table tedidc where docnum in s_docnum. Loop at tedidc. Delete edid4 where docnum eq edidc-docnum. Delete edids where docnum eq edidc-docnum. Endloop. Delete from table tedidc. .



Some IDoc handlers write application logs, so it would be neat to kill those entries also, unless the app log is not cleaned on a regular basis.
This was last published in September 2003

Dig Deeper on SAP Basis administration and NetWeaver administration

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

1 comment

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

IDocs are generally considered technical objects. Whether you need them to archive or delete, it depends upon your corporate retention policy.
Another thing that you should consider is custom reports. Are there any reports out there where you need to read historical data? If so then you may have to archive the IDOC instead of deleting it.

WE11 is a good SAP standard tool to delete IDOC but here are few issues:
1. IDoc selection is based upon some Dates and Message Type. So no way to restrict based upon IDoc numbers.
2. Program does not check the status. It will delete all the IDOCs that are selected based upon selection criteria entered.
3. No details provided as to which IDoc is deleted?

Cancel

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close