How To Fix UCF6655 - Investment data is located in totals database

SAP Error Message - Details

• Message type: E = Error

• Message class: UCF6 - Messages for Consolidation of Investments

• Message number: 655

• Message text: Investment data is located in totals database

What causes this issue?

The system reads the investment 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 UCF6655 - Investment data is located in totals database ?

  The SAP error message UCF6655, which states "Investment data is located in totals database," typically occurs in the context of investment management or project system modules within SAP. This error indicates that the system is trying to access investment data that is stored in the totals database rather than in the line item database.
  Cause:
  
  Data Storage Location: The investment data you are trying to access is stored in the totals database, which is a summarized version of the data, rather than in the detailed line item database.
  Reporting or Query Issue: The report or transaction you are using may not be designed to access the totals database, or it may require specific settings to retrieve data from there.
  Configuration Settings: There may be configuration settings in the investment management module that dictate how data is stored and accessed.
  
  Solution:
  
  Check Report Settings: If you are running a report, check the settings to ensure that it is configured to access the totals database if that is your intention.
  Use Appropriate Transactions: If you need detailed line item data, ensure you are using the correct transaction codes or reports that are designed to access the line item database.
  Consult Documentation: Review SAP documentation or help files related to the specific module you are working with to understand how to properly access investment data.
  Data Consistency Check: Run consistency checks on your investment data to ensure that there are no discrepancies between the totals and line item databases.
  Contact SAP Support: If the issue persists, consider reaching out to SAP support or your internal SAP team for further assistance, especially if it involves configuration changes.
  
  Related Information:
  
  SAP Modules: This error is commonly associated with SAP modules like SAP Investment Management (IM) or SAP Project System (PS).
  Database Structure: Understanding the difference between the totals database and line item database in SAP can help in troubleshooting similar issues.
  Transaction Codes: Familiarize yourself with relevant transaction codes (e.g., S_ALR_87013558 for investment reports) that may help in retrieving the required data.
  User Authorization: Ensure that you have the necessary authorizations to access the data in both the totals and line item databases.
  
  By following these steps, you should be able to address the UCF6655 error and access the investment data you need.