How To Fix G00123 - Data type &1: Cons chart &2: Hierarchy information not found

SAP Error Message - Details

• Message type: E = Error

• Message class: G00 - SAP Consolidation

• Message number: 123

• Message text: Data type &1: Cons chart &2: Hierarchy information not found

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 G00123 - Data type &1: Cons chart &2: Hierarchy information not found ?

  The SAP error message G00123 indicates that there is an issue with the consistency of the data in the system, specifically related to a characteristic or hierarchy that is not found. This error typically arises in the context of reporting or data analysis, particularly when working with characteristics and hierarchies in SAP BW (Business Warehouse) or SAP BI (Business Intelligence).
  Cause:
  
  Missing Hierarchy: The hierarchy associated with the characteristic is not defined or has been deleted.
  Incorrect Configuration: The characteristic or the hierarchy might not be properly configured in the system.
  Data Inconsistency: There may be inconsistencies in the data model, such as missing entries in the master data tables.
  Transport Issues: If the system has recently undergone a transport of changes, the hierarchy might not have been transported correctly.
  
  Solution:
  
  
  Check Hierarchy Definition:
  
  Go to the relevant transaction (e.g., RSH1 for Hierarchy Maintenance) and verify if the hierarchy for the characteristic exists.
  If it does not exist, you may need to create it or restore it from a backup.
  
  
  
  Validate Characteristic Configuration:
  
  Use transaction RSD1 to check the configuration of the characteristic in the InfoObject.
  Ensure that the hierarchy is correctly assigned to the characteristic.
  
  
  
  Check Master Data:
  
  Use transaction RSRV to run consistency checks on the master data for the characteristic.
  If inconsistencies are found, you may need to correct them.
  
  
  
  Transport Check:
  
  If the issue arose after a transport, check the transport logs to ensure that all necessary objects were transported correctly.
  If something is missing, you may need to re-transport the hierarchy or characteristic.
  
  
  
  Rebuild Hierarchy:
  
  If the hierarchy is corrupted or missing, you may need to rebuild it from scratch based on the business requirements.
  
  
  
  Consult Documentation:
  
  Review SAP documentation or notes related to the specific version of SAP you are using for any known issues or additional troubleshooting steps.
  
  
  
  Related Information:
  
  Transaction Codes:
  
  RSH1: Hierarchy Maintenance
  RSD1: InfoObject Maintenance
  RSRV: Consistency Check
  
  
  SAP Notes: Check SAP Notes for any specific fixes or patches related to this error message.
  Support: If the issue persists, consider reaching out to SAP support for further assistance.
  
  By following these steps, you should be able to identify and resolve the cause of the G00123 error message in your SAP system.