Program to delete all idocs required

[Former Member]

Hi,

We had sent more than 3 lac idocs from R3 to XI 7.0.

Now we do not require these idocs to be processed in XI. I have locked the RFC user in XI, so that the idocs are not transferred from R3 to XI. But all are stuck in sm58.

Deleting 3 lac entries from sm58 is not possible. So is there any way or program to delete all the idocs from sm58 trx in R3; or a program that will continuously delete messages from smq2 trx in XI, if i unlock the user.

Please suggest.

Regards,

Chintan

[Former Member]

Chintan,

Check out this sap help doc.

http://help.sap.com/saphelp_nw04s/helpdata/en/22/042585488911d189490000e829fbbd/frameset.htm

Nilesh

[former_member431549]

All the other answers are good for deleting the idocs, but what you want is to delete the messages from the tRFC queue on the sending system. Use report RSARFCER or the reorganize option from the menu of SM58.

Be careful !

[Former Member]

Hi

We dont have to delete any data from database instead delete follwing functional module:

EDI_ARCHIVE_IDOCS

EDI_DELETE_ARCHIVED_IDOCS

For More refer -Note 40088 - EDI/IDoc: Deleting and reorganizing IDocs

*****Please Rewards Points if find helpful*********

[Former Member]

Hi

use this function module EDI_DOCUMENT_DELETE.

and also use can use we11.

Thanks

sudhir sharma

[Former Member]

I used we11 trx to delete all the entries as suggested by Sudhir. I didn't try other options as suggested by others.

Anyways thanks to all.

[Former Member]

Hi Chintan,

Not sure if there is any standard program provided.

what you can do is write your own report(copy program RSTRFCM3 and modify as per your requirements) and schedule the same as a background job.

Or Alternatively go to SMQ2. Enter the client number and press execute.

In the next screen you will get all the entries which are blocked in the queue.

Press F5 to select all the entries and then press the Delete button.

Regards,

Sumit