How To Fix GH116 - Read upon Each Navigation Step indicator not permitted in this case

SAP Error Message - Details

• Message type: E = Error

• Message class: GH - Help functions and tools in FI-SL

• Message number: 116

• Message text: Read upon Each Navigation Step indicator not permitted in this case

What causes this issue?

You are trying to activate the "Read upon Each Navigation Step"
indicator.

System Response

However, for technical reasons, activation of the "Read upon Each
Navigation Step" indicator is not permitted when the key figure "Balance
Sheet Value" (BILWERT) or one of the following characteristics are used:
Fin.Stat.Item (ERGSL)
FS Item/Account (SAK_PLUMI)
FS Item/Acct/FA Long (SAKFB_LONG)

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?

Since you would like to use the key figure or one of the characteristics
mentioned above, the system automatically activates the "Read All Data"
indicator.
To prevent too much data being selected at once when it is read at the
start of processing, we recommend that you include as few cha
racteristics as possible in your report.
In so doing, you ensure that you benefit from improved performance when
using the HANA database.

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 GH116 - Read upon Each Navigation Step indicator not permitted in this case ?

  The SAP error message GH116, which states "Read upon Each Navigation Step indicator not permitted in this case," typically occurs in the context of SAP Business Warehouse (BW) or SAP BusinessObjects when there is an issue with the settings related to data retrieval or navigation in a query.
  Cause:
  The error is generally caused by the following factors:
  
  
  Query Settings: The query may have been configured to use the "Read upon Each Navigation Step" option, which is not allowed in certain scenarios, such as when using certain types of data sources or when specific characteristics are involved.
  
  
  Data Source Limitations: The data source being used may not support the "Read upon Each Navigation Step" feature. This can happen if the data source is not optimized for such operations or if it is a non-BW data source.
  
  
  Performance Considerations: SAP may restrict this option to prevent performance issues, as reading data upon each navigation step can lead to excessive database calls and slow performance.
  
  
  Solution:
  To resolve the GH116 error, you can take the following steps:
  
  
  Check Query Properties: Open the query in the Query Designer and check the properties. Look for the "Read upon Each Navigation Step" option and ensure it is not selected if it is not permitted for your data source.
  
  
  Modify Data Source: If you are using a non-BW data source, consider switching to a BW data source that supports this feature or adjusting your query to avoid using this option.
  
  
  Adjust Query Design: Redesign the query to minimize the need for navigation steps that require reading data. This may involve restructuring the query or using different characteristics that do not trigger this error.
  
  
  Consult Documentation: Refer to SAP documentation or help resources for specific guidance on the limitations of your data source and the implications of using the "Read upon Each Navigation Step" option.
  
  
  Performance Tuning: If performance is a concern, consider optimizing the query or the underlying data model to improve efficiency without relying on this feature.
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional context on the limitations of the "Read upon Each Navigation Step" feature.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they have found.
  Training and Documentation: Review training materials or documentation related to SAP BW query design and performance optimization to better understand how to configure queries effectively.
  
  By following these steps, you should be able to resolve the GH116 error and improve the performance and functionality of your SAP queries.