How To Fix DD_CDS_ANALYSIS101 - Verwendung von Assoziation &3 ist redundant - wird in &1 und &2 verwendet

SAP Error Message - Details

• Message type: E = Error

• Message class: DD_CDS_ANALYSIS - CDS code inspector messages

• Message number: 101

• Message text: Verwendung von Assoziation &3 ist redundant - wird in &1 und &2 verwendet

Was verursacht dieses Problem?

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.

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

Wie behebe ich diesen Fehler?

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.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE