How To Fix RSQBW397 - InfoObject &1 cannot be linked with InfoObject &2

RSQBW397 - Overview

• Message type: E = Error

• Message class: RSQBW -

• Message number: 397

• Message text: InfoObject &1 cannot be linked with InfoObject &2

What causes this issue?

You cannot make the required join because the InfoObjects to be linked
do not agree.
Two InfoObjects or attributes can only be linked if they reference the
same basic characteristic or have the same technical properties (data
type, internal length, and number of decimal places).
When you edit an append for an InfoSet, additional restrictions apply.
Only the following objects can be linked with each other:
Objects that belong to the same append
Objects of the append with the main object
Objects of the append with objects from a hierarchically higher level

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

It is also not possible to link dimensions of InfoCubes to each other.
Furthermore, you cannot link key figures.

System Response

The link was not created.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSQBW397 - InfoObject &1 cannot be linked with InfoObject &2 ?

  The SAP error message RSQBW397 indicates that there is an issue with linking two InfoObjects in a query or data model. This error typically arises in the context of SAP BW (Business Warehouse) when you are trying to create or modify a query that involves InfoObjects that cannot be directly linked due to certain constraints or incompatibilities.
  
  Cause:
  
  Incompatible Data Types: The InfoObjects you are trying to link may have incompatible data types. For example, one InfoObject might be a characteristic while the other is a key figure.
  Different Attributes: The InfoObjects may have different attributes or characteristics that prevent them from being linked.
  Hierarchy Issues: If one of the InfoObjects is part of a hierarchy and the other is not, this can lead to linking issues.
  Missing Relationships: There may not be a defined relationship between the two InfoObjects in the data model.
  Aggregation Levels: If the InfoObjects are at different aggregation levels, they may