How To Fix SDDL_PARSER_MSG024 - Column &1 is not contained in the GROUP BY list

SAP Error Message - Details

• Message type: E = Error

• Message class: SDDL_PARSER_MSG - Message Class for DDL Parser

• Message number: 024

• Message text: Column &1 is not contained in the GROUP BY list

What causes this issue?

An aggregate function is used in the selection list. All the fields from
the selection list that are not used in the aggregate function must be
included in the GROUP BY list.

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?

Include the field &V1& in the GROUP BY list.
Note that only field names must be used in the GROUP BY list. Alias
names are not permitted.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.