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

SDDL_PARSER_MSG024 - Overview

• 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.

Smart SAP Assistant

• What is the cause and solution for SAP error message SDDL_PARSER_MSG024 - Column &1 is not contained in the GROUP BY list ?

  The SAP error message SDDL_PARSER_MSG024 indicates that there is an issue with a SQL query, specifically related to the GROUP BY clause. This error occurs when a column that is being selected in the query is not included in the GROUP BY list, which is a requirement in SQL when using aggregate functions.
  
  Cause:
  In SQL, when you use aggregate functions (like SUM, COUNT, AVG, etc.) along with non-aggregated columns in a SELECT statement, all non-aggregated columns must be included in the GROUP BY clause. If a column is selected but not included in the GROUP BY list, the SQL engine cannot determine how to group the results, leading to this error.
  Example:
  Consider the following SQL query:
  SELECT department, COUNT(employee_id)
  FROM employees
  GROUP BY department;
  If you try to add another column, such as employee_name, without including it in the GROUP BY clause, you will encounter the error:
  SELECT department, employee_name, COUNT(employee_id)
  FROM employees
  GROUP BY department;
  In this case, employee_name