How To Fix DD_CDS_ANALYSIS101 - Association &3 is used redundant, it is used in &1 and &2.

SAP Error Message - Details

• Message type: E = Error

• Message class: DD_CDS_ANALYSIS - CDS code inspector messages

• Message number: 101

• Message text: Association &3 is used redundant, it is used in &1 and &2.

What causes this issue?

The usage of associations in CDS path expressions is equivalent to
technical join operations in the native database view. If the same
association is in views which are stacked on top of each other,
duplicate joins are created which are potentially unnecessary. In order
to improve the performance of CDS Views duplicate joins should be
avoided.

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 the same association multiple times in stacked CDS
Views it is more efficient to include all the columns required into the
CDS View at the bottom of the stack.
This warning can be suppressed by putting the pseudo comment
/*+[hideWarning] { "IDS" : [ "DOUBLE_JOIN" ] }*/
in front of one of the path expressions using the association at hand or
at the view itself.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DD_CDS_ANALYSIS101 - Association &3 is used redundant, it is used in &1 and &2. ?

  The SAP error message DD_CDS_ANALYSIS101 indicates that there is a redundancy in the use of an association in a Core Data Services (CDS) view. Specifically, the error message states that an association (denoted as &3) is being used redundantly in two different places (denoted as &1 and &2) within the same CDS view or between different CDS views.
  Cause:
  This error typically arises when:
  
  An association is defined in a CDS view and is being referenced multiple times in a way that is not allowed.
  The same association is being used in a manner that creates ambiguity or redundancy, which can lead to confusion in the data model.
  
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Review the CDS View Definition: Check the definition of the CDS view where the error is occurring. Look for the association that is mentioned in the error message.
  
  
  Identify Redundant Usage: Determine where the association is being used redundantly. This could be in the SELECT statement or in the JOIN conditions.
  
  
  Refactor the CDS View:
  
  If the association is being used in multiple places, consider whether you can consolidate its usage.
  You may need to remove one of the redundant references or refactor the view to avoid the redundancy.
  
  
  
  Check for Inheritance: If the CDS view is inheriting from another view, ensure that the association is not being inherited and then redefined in a way that causes redundancy.
  
  
  Test the Changes: After making the necessary adjustments, activate the CDS view and test it to ensure that the error is resolved and that the view behaves as expected.
  
  
  Related Information:
  
  CDS Views: Core Data Services (CDS) are a way to define semantic data models in SAP. They allow for the definition of complex data models that can be consumed by various applications.
  Associations: In CDS, associations are used to define relationships between different entities. They are similar to foreign keys in traditional database design.
  SAP Documentation: For more detailed information, refer to the official SAP documentation on CDS views and associations, which provides guidelines on best practices and common pitfalls.
  
  If the issue persists after following these steps, consider reaching out to your SAP support team or consulting the SAP Community for further assistance.