How To Fix SD_CDS_PROJECTION016 - Usage of field &1 in on-condition of association &2 is not allowed

SD_CDS_PROJECTION016 - Overview

• Message type: E = Error

• Message class: SD_CDS_PROJECTION - Message for Projection Entities

• Message number: 016

• Message text: Usage of field &1 in on-condition of association &2 is not allowed

What causes this issue?

In the definition of local association on-conditions in CDS Projection
Views, only fields from the underlying CDS View are supported.
Functions, virtual elements or path fields are not supported as operand
in the on-condition of association &V2&.

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?

Please use only fields from your underlying CDS View.

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 SD_CDS_PROJECTION016 - Usage of field &1 in on-condition of association &2 is not allowed ?

  The SAP error message SD_CDS_PROJECTION016 indicates that there is an issue with the usage of a field in the on-condition of an association within a Core Data Services (CDS) view. This error typically arises when a field is used in a way that is not permitted according to the rules governing associations in CDS views.
  
  Cause:
  The error occurs when:
  
  A field is used in the ON condition of an association that is not allowed. This can happen if the field is not part of the associated entity or if it violates the rules of the association.
  The field being referenced does not have a direct relationship with the associated entity, or it is not part of the key fields that define the association.
  
  
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Review the Association Definition: Check the definition of the association in your CDS view. Ensure that the fields used in the ON