Take a look at running report RBDCPCLR from SE38 in the backgorund. You will probably have to up a varient we run the report weekely and keep the last 6 weeks of data. You will be removing from table BDCPS take a look and it will all make sense.
Report RBDCPCLR selection screen is for deleting change pointers. My question is deleting IDocs which are created by Change Pointers. Please guide me to next step. What should I do......
Aplogises thought that we were talking change pointers ....
From note 40088
"There is no special deletion program for IDocs.
Use the archiving programs. IDoc is a separate archiving class. The following programs are available:
1. Archive RSEXARCA and RSEXARCB (as of Release 3.0C)
2. Delete RSEXARCD
3. Read archiveRSEXARCR
4. Restore RSEXARCL
The Idoc archiving is checked against the status. The statuses which can be archived and those that cannot be archived are stored in the "Status maintenance" table. You can change the standard settings. Menu path:
Area menu "WEDI", control, status maintenance.
The archiving procedure is described in the documentation 'IDoc interface for EDI'."
I tried as like you said, first tried with RSEXARCA (Archived) then deleted from SAP R/3 RSEXARCD(Deleted from R/3) I tried this for few IDocs and it worked fine.
but after tried for more no of IDocs(20000). then given like 'last create archive file without data objects was deleted' for report RSEXARCA. and not showed any thing for report RSEXARCD.
I am not that familiar with the transaction but it may be possible to break down the IDOCS in to batches of 5000 and run these in the background ??
Have you checked the customizing for object 'IDOC' - I mean not only in transaction SARA but also the application-related customizing. There might be a parameter, defining the minimun-duration time of idocs ... unfortunately I don't remember the transaction ...