How ARFCSSTATE,ARFCDATA and TRFCQOUT data to be deleted - withNO Impact ?

[Former Member]

Hi All,

Here I am opening this thread to discuss how the tRFC and qRFC tables data can be deleted by analyzing the quality of the data.

The report RSTRFCQODS and RSARFCER can be used to delete the entries from the table , But how do we analyze that what data should we delete and what not.

Please guide me that what field I choose to select the BW , QNAME only from TRFCQOUT table and which is more than old for three month.

Can anyone provide me any SQL for that. ?

Thanks and Regards,

Biswajit.

[Former Member]

hi Bisawajit,

Please refer below threads to delete the trfc data:-

TRFC and ARFC deletion - SAP NetWeaver Business Warehouse - SCN Wiki

http://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=147424192

Deletion of data table in ARFCSDATA - ABAP Connectivity - SCN Wiki

Let us know if this helped you.

Regards,

Ram

[Former Member]

Hi Ramkrishana,

Thanks for your reply.

Yes I have gone through the links . But what I have understood is that deleting entries from tables related to OUTBOUNS Qs. needs to be analyzed like BW * queues , so for that you need to construct TID from table ARFCSSTATE and find the particular queue name from TRFCQOUT . So what I need to make an SQL which will give me like ,

make the TID from ARFCSSTATE table from first four column and map it with ARFCRETURN not equal to empty and then find the QNAME from TRFCQOUT.

So that the SAP report,  RSTRFCQODS can delete those Qs entries only.

And where ARFCRETURN is empty that will be deleted by SM58 as those are transactional RFCs.

Hope you got what I am saying.