How To Fix CFD_REGISTRY_CHECK220 - Description fields not supported for CDS view &1 (due to group by clause)

CFD_REGISTRY_CHECK220 - Overview

• Message type: E = Error

• Message class: CFD_REGISTRY_CHECK - Custom Fields: Messages for Registry Check

• Message number: 220

• Message text: Description fields not supported for CDS view &1 (due to group by clause)

What causes this issue?

Description fields are not supported in consumption view <(>&<)>1
(Annotation @VDM.viewType: #CONSUMPTION), which is used for oData
exposure (Annotation @OData.publish: true) due to the contained group by
clause.

System Response

All code like custom fields will have no additional description fields
within the resulting oData service.

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 CFD_REGISTRY_CHECK220 - Description fields not supported for CDS view &1 (due to group by clause) ?

  The SAP error message CFD_REGISTRY_CHECK220 indicates that there is an issue with the use of description fields in a Core Data Services (CDS) view when a GROUP BY clause is present. This error typically arises when you attempt to include fields in the SELECT list that are not part of the aggregation or grouping, which is not allowed in SQL.
  
  Cause:
  The error occurs because:
  
  Description Fields: You are trying to select description fields (e.g., text fields) that are not included in the GROUP BY clause or are not aggregated.
  SQL Aggregation Rules: SQL requires that all selected fields in a grouped query must either be included in the GROUP BY clause or be aggregated using functions like SUM(), COUNT(), etc.
  
  
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Modify the CDS View:
  
  Ensure that all fields in the SELECT list are either included in the GROUP BY clause or are aggregated.
  If you need to