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 where some tables are not properly connected.
  
  
  Changes in Data Model: If there have been recent changes to the data model (like adding or removing tables), the join conditions may not have been updated accordingly.
  
  
  Solution:
  To resolve the MC736 error, you can take the following steps:
  
  
  Check Join Conditions:
  
  Open the data model or query definition in the SAP BW or HANA modeling environment.
  Ensure that all tables involved in the query have appropriate join conditions defined. Each table should be linked to at least one other table.
  
  
  
  Review Join Types:
  
  Verify that the join types are correctly set according to your data requirements. Ensure that the joins make sense for the data being queried.
  
  
  
  Update Data Model:
  
  If there have been changes to the data model, review and update the join conditions to reflect those changes. Make sure that all necessary relationships are established.
  
  
  
  Test the Query:
  
  After making the necessary adjustments, test the query or data model again to see if the error persists.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or help resources for guidance on how to properly set up joins in your specific version of SAP BW or HANA.
  
  
  
  Seek Help from SAP Support:
  
  If you are unable to resolve the issue, consider reaching out to SAP support or consulting with a colleague who has experience with SAP data modeling.
  
  
  
  Related Information:
  
  SAP BW Documentation: Check the official SAP BW documentation for best practices on data modeling and query design.
  SAP Community: Engage with the SAP Community forums where other users may have encountered similar issues and can provide insights or solutions.
  Training Resources: Consider taking training courses on SAP BW or HANA modeling to better understand how to design effective data models and queries.
  
  By following these steps, you should be able to identify and resolve the cause of the MC736 error in your SAP environment.