How To Fix RSDMD112 - Not all master data can be deleted

RSDMD112 - Overview

• Message type: E = Error

• Message class: RSDMD - Messages for master data

• Message number: 112

• Message text: Not all master data can be deleted

What causes this issue?

The system was unable to delete all of the master data, because some of
the master data is still being used.

System Response

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

How to fix this error?

First, delete the master data from the places where it is still being
used (for example, in InfoCubes, as an attribute, in a hierarchy).
Refer to the application log: Transaction slg1, object RSDMD,
sub-object MD_DEL. The application log contains a list showing you
whether the master data has been deleted or if it is still in use, and
if so where it is being used. The list is complete only when you
confirm that you want to delete all the master data that is in use.
When you have checked each case where master data is in use, try the
deletion process again.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

RSDMD112 - Details

• The SAP error message RSDMD112, which states "Not all master data can be deleted," typically occurs when you attempt to delete master data in SAP BW (Business Warehouse) or SAP BI (Business Intelligence) and there are dependencies or references that prevent the deletion of certain master data records.
  Causes:
  
  
  Active Data Dependencies: The master data you are trying to delete may be actively used in InfoObjects, queries, or other data models. If there are active references to the master data in the system, it cannot be deleted.
  
  
  Data in InfoProviders: The master data might be linked to InfoProviders (like InfoCubes or DataStore Objects) that contain data. If the master data is being used in any of these InfoProviders, it cannot be deleted.
  
  
  Hierarchy Dependencies: If the master data is part of a hierarchy, you may not be able to delete it until the hierarchy is adjusted or the master data is removed from the