How To Fix CFD_REGISTRY_CHECK120 - On clause of Association &1 in CDS View &2 contains cast statement

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 120

• Message text: On clause of Association &1 in CDS View &2 contains cast statement

What causes this issue?

In the on condition of the association you use $projections fields which
have a CAST. This is currently not possible as such associations cannot
be used in view extensions and will lead to syntax errors (General CDS
restriction).

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?

Instead of using $projections fields which have a CAST you have to use
the fields from the underlying data source.

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_CHECK120 - On clause of Association &1 in CDS View &2 contains cast statement ?

  The SAP error message CFD_REGISTRY_CHECK120 indicates that there is an issue with the use of a cast statement in the ON clause of an association within a Core Data Services (CDS) view. This error typically arises when the CDS view is trying to establish a relationship between two entities, but the ON clause includes a cast that is not allowed.
  
  Cause:
  The primary cause of this error is the presence of a cast statement in the ON clause of an association. In CDS views, the ON clause is used to define the join condition between two entities. However, using a cast in this context can lead to ambiguity and is not supported by the CDS framework.
  
  Solution:
  To resolve this error, you should remove the cast statement from the ON clause of the association. Instead, ensure that the fields being compared in the ON clause are of the same data type. Here are the