Purpose
This wiki provides information on how to delete unwanted entries in the RFC tables.
Overview
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.
Tables used
tRFC qRFC
Outbound ARFCSDATA ARFCSDATA
ARFCSSTATE ARFCSSTATE
TRFCQOUT
Inbound --------- TRFCQDATA
TRFCQSTATE
TRFCQIN
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:
Reports
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).
For qRFC records, you can use report RSTRFCQDS (SAP Note 760113). For inconsistent qRFC records use report RSTRFCEG (SAP Note 779664).
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
763255
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 Content
Related Documents
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
2 Comments
Damean-BF Chen
HI...I notice that some of the table entries ARFCSSTATE .arfcreturn = ''O" ; any idea what this meant? I could tell it was generated by APO CIF Order Function.
Yasin Kurtulus
Damean-BF Chen I think "X" and "O" are same things.