How To Fix AQQIS_CNTRL036 - No left outer join can be defined here

AQQIS_CNTRL036 - Overview

• Message type: E = Error

• Message class: AQQIS_CNTRL - Join-Control InfoSet

• Message number: 036

• Message text: No left outer join can be defined here

What causes this issue?

You have tried to add a join.
The tables and links defined do not allow a join to be added here
Note that ABAP SQL does not support the following situations:
The right-hand table of a left-outer join is also the right-hand table
of another joins, that means:
a right table of a left-outer joins can only be linked with a left-hand
table.
A right-hand table of a left-outer joins is the left-hand table of
another left-outer join.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

System Response

The desired changes have been cancelled.

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

AQQIS_CNTRL036 - Details

• The SAP error message AQQIS_CNTRL036, which states "No left outer join can be defined here," typically occurs in the context of SAP Query or SAP ABAP when you are trying to create a query that involves a left outer join between tables, but the system does not allow it due to certain constraints.
  
  Cause:
  
  
  Table Relationships: The tables you are trying to join may not have a valid relationship that allows for a left outer join. In SAP, certain tables are designed to be joined in specific ways, and attempting to create a left outer join where it is not supported will trigger this error.
  
  
  Query Design: The design of the query may not support left outer joins due to the way the data is structured or the specific fields being used in the join condition.
  
  
  Data Dictionary Constraints: The data dictionary (DDIC) may have constraints that prevent the use of left outer joins