How To Fix UCF6656 - Equity data is located in totals database

SAP Error Message - Details

• Message type: E = Error

• Message class: UCF6 - Messages for Consolidation of Investments

• Message number: 656

• Message text: Equity data is located in totals database

What causes this issue?

The system reads the equity data from the totals database according to
the settings in <ZK>Location of Values</>.

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?

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 UCF6656 - Equity data is located in totals database ?

  The SAP error message UCF6656, which states "Equity data is located in totals database," typically occurs in the context of SAP's Financial Accounting (FI) or Controlling (CO) modules, particularly when dealing with equity data in the Universal Journal (ACDOCA) or when trying to access or report on equity-related financial data.
  Cause:
  This error usually arises when:
  
  Data Location: The equity data you are trying to access or manipulate is stored in the totals database (e.g., table BSIK, BSAK, or similar) rather than in the line item database.
  Reporting or Querying: You may be attempting to run a report or query that expects to find detailed line item data, but the data is only available in a summarized form in the totals database.
  Configuration Issues: There may be configuration settings in your SAP system that dictate how equity data is stored or accessed.
  
  Solution:
  To resolve this error, consider the following steps:
  
  
  Check Data Source: Verify if the equity data you are trying to access is indeed located in the totals database. You can do this by checking the relevant tables in the SAP database.
  
  
  Use Appropriate Reports: If you are trying to run a report, ensure that you are using a report that is designed to access the totals database. Some reports are specifically designed to work with line item data, while others can handle totals.
  
  
  Adjust Query Settings: If you are using a custom query or report, adjust the settings to ensure it can pull data from the totals database. This may involve modifying the query to aggregate data appropriately.
  
  
  Consult Documentation: Review SAP documentation or help resources related to the specific module you are working with. This can provide insights into how equity data is structured and accessed.
  
  
  Check Configuration: If you suspect a configuration issue, consult with your SAP Basis or Financial module consultant to review the settings related to data storage and reporting.
  
  
  SAP Notes: Search for relevant SAP Notes in the SAP Support Portal that may address this specific error or provide additional guidance.
  
  
  Related Information:
  
  SAP Tables: Familiarize yourself with the relevant SAP tables that store equity data, such as ACDOCA (Universal Journal) and other related totals tables.
  Reporting Tools: Understand the reporting tools available in SAP, such as SAP Query, Report Painter, or SAP Fiori apps, which may have different capabilities regarding data access.
  User Roles and Authorizations: Ensure that you have the necessary authorizations to access the data you are trying to retrieve.
  
  If the issue persists after following these steps, it may be beneficial to engage with SAP support or your internal SAP team for further assistance.