How To Fix SDDL_PARSER_MSG171 - Client field must be specified manually to avoid duplicates

SAP Error Message - Details

• Message type: E = Error

• Message class: SDDL_PARSER_MSG - Message Class for DDL Parser

• Message number: 171

• Message text: Client field must be specified manually to avoid duplicates

What causes this issue?

In cases where the data source is client-specific and the annotations
@ClientHandling.type: #CLIENT_INDEPENDENT and @ClientHandling.algorithm:
#NONE are set, the CDS view is a cross-client view. The client field
must be produced regardless of this to avoid duplicates in the resulting
data records.

How to fix this error?

Add the client field to the select list.

Error message extract from SAP system. Copyright SAP SE.