CDS view &1 refers to too many tables

Message type: E = Error

Message class: DD_CHK_COMPLEXITY - Messages of CDS complexity check

Message number: 101

Message text: CDS view &1 refers to too many tables



What causes this issue?

The number of joined tables in the CDS view exceeds the limit of the
most restrictive database supported by SAP. As a result, this view
cannot be activated on all databases supported by SAP.


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?

Reduce the number of joined tables in the CDS view.



Error message extract from SAP system. Copyright SAP SE.