How To Fix SDDL_PARSER_MSG029 - GROUP BY must not contain any LOB columns

SDDL_PARSER_MSG029 - Overview

• Message type: E = Error

• Message class: SDDL_PARSER_MSG - Message Class for DDL Parser

• Message number: 029

• Message text: GROUP BY must not contain any LOB columns

What causes this issue?

The columns specified after GROUP BY cannot have the type STRING,
RAWSTRING, LCHR, or LRAW.
Elements with these ABAP Dictionary data types are known as LOBs (Large
Objects).

How to fix this error?

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

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 SDDL_PARSER_MSG029 - GROUP BY must not contain any LOB columns ?

  The SAP error message SDDL_PARSER_MSG029 indicates that there is an issue with a SQL query that is attempting to use a GROUP BY clause that includes LOB (Large Object) columns. In SAP HANA and other SQL databases, LOB columns (such as BLOBs for binary data or CLOBs for character data) cannot be used in GROUP BY clauses because they are not suitable for aggregation or grouping operations.
  Cause
  The error occurs when:
  
  A SQL query is written that includes LOB columns in the GROUP BY clause.
  LOB columns are typically used for storing large amounts of data, and SQL databases do not support grouping by these types of columns.
  
  Solution
  To resolve this error, you should:
  
  
  Remove LOB Columns from the GROUP BY Clause: Modify your SQL query to exclude any LOB columns from the GROUP BY clause. Only include columns that are suitable for grouping, such as integers, strings, or dates.
  For example, if your original query