How To Fix SADL_GW_DT_CDS001 - Join &1 is not allowed.

SADL_GW_DT_CDS001 - Overview

• Message type: E = Error

• Message class: SADL_GW_DT_CDS - Messages CDS Checks

• Message number: 001

• Message text: Join &1 is not allowed.

What causes this issue?

A join is used in the SELECT statement in the consumption CDS view. This
is not allowed.

System Response

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?

Remove the join in the consumption CDS view. You can use an association
instead.

Procedure for System Administrators

Contact the corresponding developer of the CDS view to correct the
error.

Error message extract from SAP system. Copyright SAP SE.

SADL_GW_DT_CDS001 - Details

• The SAP error message SADL_GW_DT_CDS001 with the description "Join &1 is not allowed" typically occurs in the context of SAP Gateway and Core Data Services (CDS) views. This error indicates that there is an issue with the way joins are defined in your CDS view or the way the data is being accessed through the SAP Gateway.
  
  Cause:
  
  
  Invalid Join Definition: The join defined in the CDS view may not be valid due to various reasons, such as:
  
  The join is between incompatible data sources.
  The join condition is not properly defined.
  The join type is not supported in the context of the operation being performed.
  
  
  
  Restrictions on Joins: Certain joins may not be allowed due to the nature of the data sources involved. For example, joins between certain types of database tables or views may be restricted.
  
  
  Gateway Service Configuration: The error may also arise from the way the OData service is configured in the SAP