How To Fix RSR_EXCEL_RUNTIME_DE008 - New rows are not permitted since columns contain two structures

SAP Error Message - Details

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME_DE - Messages for BEx Analyzer with Original Language German

• Message number: 008

• Message text: New rows are not permitted since columns contain two structures

What causes this issue?

New rows can only be entered in the current query view when values are u
pdated or there is no longer a structure drilled down in the columns.

System Response

New rows <ZH>cannot</> be entered.

How to fix this error?

To enter new rows, change the drilldown so that there is only one struct
ure in the columns.

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 RSR_EXCEL_RUNTIME_DE008 - New rows are not permitted since columns contain two structures ?

  The SAP error message RSR_EXCEL_RUNTIME_DE008 typically occurs when you are trying to export data to Excel from an SAP BW query, and the data structure of the query results is not compatible with the Excel format. Specifically, this error indicates that the query results contain two different structures in the columns, which prevents the addition of new rows in the Excel output.
  Cause:
  The error is caused by the following scenarios:
  
  Mixed Structures: The query results may contain columns that are based on different structures or characteristics. For example, if some columns are based on key figures and others on characteristics, this can lead to inconsistencies.
  Hierarchical Data: If the query includes hierarchical data (like a hierarchy of characteristics), it may also lead to this error if the structure is not uniform across the columns.
  Inconsistent Data Types: If the data types of the columns are inconsistent, it can also trigger this error.
  
  Solution:
  To resolve the RSR_EXCEL_RUNTIME_DE008 error, you can try the following solutions:
  
  
  Check Query Design:
  
  Review the query design in the SAP BW Query Designer. Ensure that all columns in the query are based on the same structure or are compatible with each other.
  Avoid mixing key figures and characteristics in a way that leads to structural inconsistencies.
  
  
  
  Modify the Query:
  
  If you have hierarchical characteristics, consider flattening the hierarchy or ensuring that all columns are compatible.
  You may need to create separate queries for different structures if they cannot be combined.
  
  
  
  Export Options:
  
  Instead of exporting directly to Excel, try exporting the data to a CSV format first, and then open it in Excel. This can sometimes bypass the structural limitations.
  Use the "Export" function in the SAP GUI instead of the Excel button, as it may handle the data differently.
  
  
  
  Check for Updates:
  
  Ensure that your SAP system is up to date with the latest patches and updates, as there may be fixes related to this issue in newer versions.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or support notes related to the specific version of SAP BW you are using for any known issues or additional troubleshooting steps.
  
  
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any specific fixes or workarounds related to this error message.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered and resolved similar issues.
  SAP BW Query Designer: Familiarize yourself with the capabilities and limitations of the Query Designer to avoid structural issues in your queries.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to successfully export your data to Excel.