How To Fix >0128 - Totals records exist for reconciliation key &1, deletion not possible

SAP Error Message - Details

• Message type: E = Error

• Message class: >0 - General Basis texts

• Message number: 128

• Message text: Totals records exist for reconciliation key &1, deletion not possible

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message >0128 - Totals records exist for reconciliation key &1, deletion not possible ?

  The SAP error message 0128 indicates that there are existing total records for a reconciliation key, which prevents the deletion of that key. This typically occurs in the context of financial accounting or controlling modules where reconciliation keys are used to summarize or aggregate financial data.
  Cause:
  The error arises when you attempt to delete a reconciliation key (such as a cost center, profit center, or internal order) that has associated total records in the system. These total records are usually created during the posting of transactions and are necessary for maintaining the integrity of financial reporting.
  Solution:
  To resolve this error, you can follow these steps:
  
  
  Check for Existing Total Records:
  
  Use transaction codes like S_ALR_87013611 (for cost centers) or S_ALR_87013612 (for profit centers) to review the total records associated with the reconciliation key.
  You can also use transaction SE16 or SE11 to check the relevant database tables (e.g., COSS for cost totals, COSP for cost line items) for any entries related to the reconciliation key.
  
  
  
  Delete or Archive Total Records:
  
  If you determine that the total records are no longer needed, you may need to delete or archive them. This can often be done through specific SAP programs or transactions designed for data archiving.
  Be cautious with this step, as deleting total records can affect financial reporting and historical data integrity.
  
  
  
  Consult with Finance Team:
  
  Before proceeding with deletion, consult with your finance or controlling team to ensure that the reconciliation key and its associated records are no longer required for reporting or analysis.
  
  
  
  Use the Correct Transaction:
  
  If you are trying to delete a reconciliation key, ensure you are using the correct transaction code (e.g., OKB9 for cost centers) and that you have the necessary authorizations.
  
  
  
  Check for Dependencies:
  
  Ensure that there are no other dependencies or references to the reconciliation key in other areas of the system that might prevent deletion.
  
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes for managing reconciliation keys, such as OKB9 (for cost centers) or KSV5 (for profit centers).
  Documentation: Review SAP documentation or help files related to financial accounting and controlling for more detailed procedures on managing reconciliation keys and total records.
  SAP Notes: Check SAP Notes for any known issues or additional guidance related to this error message.
  
  By following these steps, you should be able to address the error message and proceed with your intended actions in SAP.