How To Fix G3690 - Errors occurred while displaying transactional totals data

SAP Error Message - Details

• Message type: E = Error

• Message class: G3 - Messages for SAP Consolidation: Integration

• Message number: 690

• Message text: Errors occurred while displaying transactional totals data

What causes this issue?

To compare the totals data of Consolidation, characteristics of the
transaction totals data are mapped to the characteristics of the
Consolidation system. In this process, an error occurred for one or
more transaction data records. Therefore, a complete reconciliation of
the data is not possible.

System Response

The list shows the messages for the affected data records.

How to fix this error?

Go to the messages in the list and check if the reason for the
erroneous display of the transaction data stems from erroneous
Customizing settings. If so, correct the settings.
If you want to use your own logic for displaying the transaction totals
data, you can use the exits of <DS:TRAN.SMOD>enhancement</> FMC10011.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message G3690 - Errors occurred while displaying transactional totals data ?

  The SAP error message G3690, which states "Errors occurred while displaying transactional totals data," typically indicates that there is an issue with the data being retrieved or displayed in the system, particularly related to transactional totals in financial or controlling modules. Here are some potential causes, solutions, and related information for this error:
  Causes:
  
  Data Inconsistency: There may be inconsistencies in the transactional data, such as missing or corrupted entries in the database.
  Authorization Issues: The user may not have the necessary authorizations to view the transactional totals data.
  Configuration Issues: Incorrect configuration settings in the financial or controlling modules can lead to errors in data retrieval.
  System Performance: If the system is under heavy load or if there are performance issues, it may fail to retrieve the data properly.
  Database Issues: Problems with the underlying database, such as locks or corruption, can prevent data from being displayed correctly.
  
  Solutions:
  
  Check Data Consistency: Use transaction codes like SE11 (Data Dictionary) or SE16 (Data Browser) to check the relevant tables for inconsistencies. You may need to run consistency checks or data correction programs.
  Review Authorizations: Ensure that the user has the appropriate authorizations to access the transactional totals data. This can be checked in transaction SU53 or by reviewing the user's role assignments.
  Configuration Review: Verify the configuration settings in the relevant modules (e.g., FI, CO) to ensure they are set up correctly. This may involve checking settings in transaction SPRO.
  System Performance Monitoring: Monitor system performance using transaction SM37 (Job Monitoring) or ST22 (Dump Analysis) to identify any performance bottlenecks or issues.
  Database Maintenance: If there are database issues, consider running database maintenance tasks or consulting with your database administrator to resolve any locks or corruption.
  
  Related Information:
  
  SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that may address this specific error. You can search for G3690 or related keywords.
  Transaction Codes: Familiarize yourself with relevant transaction codes such as FBL1N, FBL3N, or FBL5N for displaying line items, which may help in troubleshooting.
  User Forums: Consider visiting SAP community forums or user groups where similar issues may have been discussed, and solutions shared.
  
  If the issue persists after trying the above solutions, it may be necessary to escalate the problem to your SAP Basis team or SAP support for further investigation.