How To Fix SDDL_PARSER_MSG087 - Use of the association & can produce cyclical dependencies

SAP Error Message - Details

• Message type: E = Error

• Message class: SDDL_PARSER_MSG - Message Class for DDL Parser

• Message number: 087

• Message text: Use of the association & can produce cyclical dependencies

What causes this issue?

If associations are used within defining CDS views in path expressions
and are exposed as associations in the selection list, this can cause
cyclical dependencies between views - if these views reference each
other. These cycles cannot be cleared in every case by the Data
Dictionary.

System Response

Error in mass activation of CDS views

How to fix this error?

Associations should either be exposed in the selection list of a CDS
view, or defined locally only and used in path expressions.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.