This wiki provides information on how to delete unwanted entries in the RFC tables.
This wiki provides information on the reports used to delete unwanted tRFC and qRFC entries. Please ensure with the relavant application that entries are not needed before they are deleted.
Outbound ARFCSDATA ARFCSDATA
Inbound --------- TRFCQDATA
The RFC tables should be kept as small as possible - in some cases these tables can contain millions of entries.
To check the number of entries goto SE16, enter the table name, for example ARFCSDATA, then choose the "Number of Entries" Option:
Depending on whether you are trying to delete a tRFC or a qRFC call the reports used are different.
Checking if entry is a tRFC or qRFC call (outbound)
If you check the ARFCRETURN field in table ARFCSSTATE this will indicate whether the entry is a tRFC or a qRFC call.
If arfcreturn = '' " (blank) this indicates that the entry is a tRFC call.
If arfcreturn = "X" (value) this indicates that the entry is a qRFC call.
TRFC records can be deleted directly from SM58 (Log file / Reorganize - report RSARFCER) or via report RSTRFCQD (selection by TID - one by one).
Note that report RSTRFCEF is not to be used anymore, we have a new report to check inconsistencies as described in the SAP note: 779664
The report RSTRFCEF will be replaced by the report RSTRFCEG.
Note that report RSTRFCEG contains a parameter CHECK_ONLY, if you mark it, then the inconsistencies will not be deleted.
The standard way to delete queue entries is to run report RSTRFCQD/DS as a batchjob as mentioned in note
In SMQ1 if you can goto "QRFC" in the Menu and then choose reorganise, this will delete *ALL* queues in SMQ1. However, if you want to delete
selected queues then you could choose "Edit" in the menu and then choose "delete Selected objects".
Related SAP Notes/KBAs
375566 Large number of entries in tRFC and qRFC tables
366869 HOLD/EXECUTED/WCONFIRM entries in ARFCRSTATE
1621114 RSTRFCEH - Performance improvement with deletion
779664 Consistency check of qRFC queues with deletion
763255 Deleting a TID or a queue