Skip to Content
Author's profile photo Kamal Mehta

TRFC Monitoring – Maintaining Table ARFCSDATA – BW Check

Introduction : Many a times we faced lot of issues with respect to TRFC’s because of which either we experience performance related issues or sometimes data load failure in BW Process Chains. This is typically a Basis task but from BW point of view it can get better if we know and can take care of the same ourselves as well as finally BW is only going to be used for Reporting and one can save some time if possible.

The table ARFCSDATA basically holds temporary data for tRFCs. It could contain many cancelled tRFCs. Using transaction SM58 we can identify and monitor all such tRFCs.  The table and its Index allocated can contribute to a large table space which can be reviewed to be deleted or executed as the need be. However very old entries in this table should be deleted on regular intervals. Normally, this table should only contain tRFCs that are currently being processed. Cancelled tRFCs should be monitored daily / weekly and either restarted or deleted. If these entries are deleted or the above mentioned table is maintained on regular basis then we can experience better performance in BW data loading as well.

Delete all entries in table ARFCSSTATE where Return field is blank and its status having SYSFAIL.  All these entries are unprocessed entries that should be deleted as best practice. 

Note : Entry in this table can be deleted by only that person who has created these entries. Including the one created by ALEREMOTE!!(Hence recommended to do this by way of Re-organize)

Proceed as follows:

Step 1: Log on to R3 / ECC, go to T Code SM58.

          Choose an appropriate time period and execute the report

/wp-content/uploads/2013/09/1_288918.jpg

Step2: The report will show ALL TRFCs.

/wp-content/uploads/2013/09/2_288919.jpg

Step3: From the output, Choose ‘Reorganize” as shown in above picture. Execute this after selecting * on user name and preferably error entries.

/wp-content/uploads/2013/09/3_288941.jpg

Better to take care of this on periodic basis may be include in Housekeeping periodic Tasks.

Thanks .

Assigned tags

      20 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Good house keeping activity 🙂 . Thanks for making..

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Thanks Suman.

      Author's profile photo Martin Grob
      Martin Grob

      Nicely made

      Martin

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Thanks Martin.

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Really helpful and useful.

      Thanks for sharing.

      Regards,

      AL

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Thanks Anshu for your valuable comments.

      Regards

      Kamal

      Author's profile photo Former Member
      Former Member

      Interesting and useful.

      Thanks.

      Ivan

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Hi Ivan ,

      Thanks for your comments.

      Author's profile photo Former Member
      Former Member

      Thanks kamal for providing valuable information

      Regards,

      Purushotham 🙂

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Thanks Purushotham for your comments .

      Author's profile photo CH Raman
      CH Raman

      Really good job and useful info.Thanks for sharing.

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Thanks for your valuable comments.

      Regards

      Kamal

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice Information.

      🙂

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Hi Satendra ,

      Thanks for your comments.

      Regards

      Kamal

      Author's profile photo Former Member
      Former Member

      Nice document Thanks for sharing.

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Thanks Kalpana.

      Can you rate it .

      Regards

      Kamal

      Author's profile photo Former Member
      Former Member

      Really a helpful document.

      Thanks for sharing. 🙂

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Thanks for your comments Pratik.

      Regards

      Kamal

      Author's profile photo Harish Allachervu
      Harish Allachervu

      informative kamal thanks for sharing... 🙂

      I have one query regarding the TRFC's as part of housekeeping activity daily i'll do reorganize which are stuck for long time, because as per knowladge if TRFC's are in the state like this Function module executed for long time it will create inconsistency in the data load from ECC---> BW so please tell me am i doing right....!!!

      I have gone through many docs and blogs but no answer to my question.... 😉

      please suggest me.

      Thanks & Regards,

      Harish

      Author's profile photo Kamal Mehta
      Kamal Mehta
      Blog Post Author

      Hi Harish,

      It depends ideally if you have TRFC's for quite some time may be 2 years back i don't think deleting the same would create any kind of inconsistencies. Hence, you should delete all old TRFC's(1-2 years back) and check and monitor all TRFC's with cancelled status and see whether they need to restarted or deleted.

      Also do a test in Quality environment to check and verify the same.

      Thanks

      Kamal