How To Fix R7700 - Compoundings cannot be deleted if high cardinality is activated

R7700 - Overview

• Message type: E = Error

• Message class: R7 - BW: Data basis

• Message number: 700

• Message text: Compoundings cannot be deleted if high cardinality is activated

What causes this issue?

You are trying to remove compounded InfoObjects from InfoObject &V1&.
Since InfoObject &V1& does not contain any data, but is flagged as a
high cardinality InfoObject, removing a compound InfoObject is not
possible.

System Response

The check returned an error. The InfoObject cannot be activated.

How to fix this error?

Change the high cardinality setting of the InfoObject to off. Then
remove the compounded InfoObject. Change the high cardinality setting of
the InfoObject to on again.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message R7700 - Compoundings cannot be deleted if high cardinality is activated ?

  The SAP error message R7700, which states "Compoundings cannot be deleted if high cardinality is activated," typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when you are trying to delete compoundings (which are used in the context of InfoObjects) while high cardinality is enabled.
  
  Cause:
  
  High Cardinality Activation: High cardinality refers to a situation where an InfoObject can have a large number of unique values. When high cardinality is activated for an InfoObject, it imposes certain restrictions on how data can be managed, including the deletion of compoundings.
  Data Integrity: The system prevents the deletion of compoundings to maintain data integrity and consistency, as compoundings are often used to define relationships between different characteristics in the data model.
  
  
  Solution:
  
  Check High Cardinality Settings: If you need to delete the compoundings, you may need to first check if high cardinality is indeed activated for the InfoObject in question. You can do