How To Fix DD_CDS_ANALYSIS101 - L'utilisation de l'association &3 est redondante - utilisée ds &1 et &2.

DD_CDS_ANALYSIS101 - Overview

• Message type: E = Error

• Message class: DD_CDS_ANALYSIS - CDS code inspector messages

• Message number: 101

• Message text: L'utilisation de l'association &3 est redondante - utilisée ds &1 et &2.

Quelle est la cause de ce problème?

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.

Le système émet un message d'erreur et ne vous permettra pas de poursuivre cette transaction tant que l'erreur n'est pas résolue.

Comment corriger cette erreur?

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.

Extrait du message d'erreur du système SAP. Copyright SAP SE.