How To Fix SDDL_PARSER_MSG061 - The association & cannot be used locally in the view (see long text)

SDDL_PARSER_MSG061 - Overview

• Message type: E = Error

• Message class: SDDL_PARSER_MSG - Message Class for DDL Parser

• Message number: 061

• Message text: The association & cannot be used locally in the view (see long text)

What causes this issue?

If a locally defined association is used in the selection list of the
CDS view (for example a field of the association target is accessed),
this association is translated directly to a local join. Here, the ON
condition of the association is applied directly to the join ON
condition, which means that the join ON condition may contain invalid
clauses.
This includes situations where the ON condition of the association
contains the following clauses (using $PROJECTION):
Path expression of the selection list
Calculated field
Expressions such as CAST, CASE, or function calls
In these cases, this association cannot be used locally, since clauses
of this type cannot be used in ON conditions of joins.

Error message extract from SAP system. Copyright SAP SE.

SDDL_PARSER_MSG061 - Details

• The SAP error message SDDL_PARSER_MSG061 indicates that there is an issue with the association in a CDS (Core Data Services) view. Specifically, it means that the association you are trying to use cannot be utilized locally within the view. This typically occurs when the association is defined in a way that is not compatible with the local context of the view.
  
  Cause:
  
  Association Scope: The association might be defined in a way that it is not accessible in the context of the view where you are trying to use it. This can happen if the association is defined in a different CDS view or if it is not properly linked to the current view.
  Incorrect Join Type: The association might be defined with a join type that is not compatible with the local context.
  Semantic Errors: There could be semantic errors in the way the association is defined or used, such as incorrect cardinality