How To Fix SDDL_PARSER_MSG030 - UNION must not contain any LOB columns in the selection list

SDDL_PARSER_MSG030 - Overview

• Message type: E = Error

• Message class: SDDL_PARSER_MSG - Message Class for DDL Parser

• Message number: 030

• Message text: UNION must not contain any LOB columns in the selection list

What causes this issue?

The selection list of a UNION cannot have columns with the type STRING,
RAWSTRING, LCHR, or LRAW.
Elements with these ABAP Dictionary data types are known as LOBs (Large
Objects).

Error message extract from SAP system. Copyright SAP SE.

SDDL_PARSER_MSG030 - Details

• The SAP error message SDDL_PARSER_MSG030 indicates that there is an issue with a SQL query that is attempting to use a UNION operation, which includes LOB (Large Object) columns in the selection list. In SAP HANA and other SQL databases, LOB columns (such as BLOBs for binary data or CLOBs for character data) cannot be included in a UNION operation due to the way these data types are handled.
  
  Cause:
  The error occurs when a SQL statement attempts to combine results from multiple SELECT statements using a UNION, and at least one of those SELECT statements includes a LOB column. The SQL standard and many database systems, including SAP HANA, restrict the use of LOB columns in UNION operations because they can lead to complications in data handling and performance.
  
  Solution:
  To resolve this error, you need to modify your SQL query to ensure that LOB columns are not included in the selection lists