How To Fix RQ421 - Totals records tables must be converted

SAP Error Message - Details

• Message type: E = Error

• Message class: RQ - Messages for Cash Management and Forecast

• Message number: 421

• Message text: Totals records tables must be converted

What causes this issue?

There are still entries in the old totals record tables FDSB and FDSR
even though the business function FIN_TRM_CM_DIMENSIONS is active.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

You have two options when converting the totals record tables:
Regenerate all tables using transaction 'FDFD' for all company codes.
Start program RFFDFT604 to transfer the data from the old totals record
tables to the new ones (FDSB2 und FDSR2). This does not enter the new
account assignments, however (see View V_T034).
Subsequently, the old totals record tables must be empty for all company
codes.
(If company codes are no longer relevant for Cash Management, you can
delete their data using program RFFDDL00.)

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RQ421 - Totals records tables must be converted ?

  The SAP error message RQ421, which states "Totals records tables must be converted," typically occurs in the context of SAP's Financial Accounting (FI) or Controlling (CO) modules. This error indicates that the totals records in the database need to be updated or converted to a new format or structure, often due to changes in the system or updates in the SAP version.
  Cause:
  
  Database Structure Changes: The error may arise after an upgrade or a system migration where the database structure for totals records has changed.
  Inconsistent Data: If the totals records are not consistent with the current configuration or if there are discrepancies in the data, this error can occur.
  Missing Conversion: If the necessary conversion programs or steps were not executed after an upgrade, the system may trigger this error.
  
  Solution:
  To resolve the RQ421 error, you can follow these steps:
  
  
  Run the Conversion Program:
  
  Use transaction code SARA to access the Archive Administration.
  Look for the relevant conversion program for totals records. This is often referred to as RFTBTR00 or similar, depending on your specific SAP version.
  Execute the program to convert the totals records.
  
  
  
  Check for Notes and Patches:
  
  Check the SAP Support Portal for any relevant SAP Notes that address this specific error. There may be specific instructions or patches provided by SAP to resolve the issue.
  
  
  
  Data Consistency Check:
  
  Use transaction SE38 to run the report RFUMSV00 or similar reports to check for inconsistencies in the totals records.
  If inconsistencies are found, follow the recommended steps to correct them.
  
  
  
  Consult Documentation:
  
  Review the SAP documentation related to your version and module for any specific instructions regarding totals records and their conversion.
  
  
  
  Contact SAP Support:
  
  If the issue persists after attempting the above solutions, consider reaching out to SAP Support for further assistance. They can provide guidance based on your specific system configuration and version.
  
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as SARA (Archive Administration), SE38 (ABAP Editor), and others that may be useful in troubleshooting.
  SAP Notes: Regularly check for SAP Notes related to your version of SAP, as they often contain important information about known issues and their resolutions.
  Backup: Always ensure that you have a backup of your data before running conversion programs or making significant changes to the database.
  
  By following these steps, you should be able to address the RQ421 error and ensure that your totals records are properly converted and consistent with the current system configuration.