How To Fix GR681 - Set variables cannot be used in a column

GR681 - Overview

• Message type: E = Error

• Message class: GR - Report Writer

• Message number: 681

• Message text: Set variables cannot be used in a column

What causes this issue?

You cannot use a set variable in a column set.
This is due to the fact that the column structure must be fixed before
the data is selected (unlike the row structure). However, you can use
column sets that contain value variables.

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?

Change your column set so that it does not contain any set varaibles.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message GR681 - Set variables cannot be used in a column ?

  The SAP error message GR681 ("Set variables cannot be used in a column") typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when you are trying to use a set variable in a context where it is not allowed, such as in a column of a query or report.
  
  Cause:
  
  Set Variables Misuse: Set variables are designed to be used in filters or as part of the query definition but not directly in the columns of a report or query.
  Query Design: The query might be incorrectly designed, where a set variable is being referenced in a way that is not supported by the query engine.
  Incompatibility: The version of SAP BW or HANA you are using may have specific limitations regarding the use of set variables.
  
  
  Solution:
  
  Review Query Design: Check the design of your query. Ensure that set variables are only used in the appropriate sections (like filters or conditions)