How To Fix MC736 - Not all the base tables are linked with join conditions

SAP Error Message - Details

• Message type: E = Error

• Message class: MC - Aggregate: views, matchcodes, lock objects

• Message number: 736

• Message text: Not all the base tables are linked with join conditions

What causes this issue?

When UNIONs are used, at least one field must be selected from each
basis table.

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

System Response

How to fix this error?

At least one field from each basis table should be added to the
selection list. These fields should not be calculated fields, such as
CAST or CASE, or other expressions.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message MC736 - Not all the base tables are linked with join conditions ?

  The SAP error message MC736, which states "Not all the base tables are linked with join conditions," typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when you are trying to execute a query or a data model that involves multiple tables. This error indicates that there is a problem with the way the tables are joined in your data model or query definition.
  
  Cause:
  The error is usually caused by one or more of the following issues:
  
  
  Missing Join Conditions: Not all tables in the query or data model have defined join conditions. This means that the system cannot determine how to relate the data from different tables.
  
  
  Incorrect Join Types: The join types (inner join, outer join, etc.) may not be correctly defined, leading to ambiguity in how the tables should be linked.
  
  
  Data Model Design Issues: The data model may not be designed correctly, leading to a situation