Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Former Member


Every once in a while you need to delete master data for which transactional data still exists. Most likely result: the master data cannot be deleted. To delete the master data, there must be no transactional data which is being by referenced by this master data. It must be no longer be used as attribute value, used in hierarchies and it must not be used in a query. Using the where used list in transaction <RSD1> for an Info-object provides you with a list of Info-providers like Info-cubes, Datastore objects etc. but it does not provide the details of a particular master data in that Info-object which is being used in these Info-providers This document describes the steps that have to be performed to find out where a particular master data value is being used. It is based on OSS note 1305595 which deserves much more appreciation. Hence this document...


SAP BW Administrators / Developers.

Table of Contents

Table of Contents

1. Find the SID of the master-data value

2. Find the related info-providers

1. Find the SID of the master-data value

This chapter describes the steps to find the SID of the master-data value that will be used in the next chapter.
As an example I will take a random material number of info-object 0MATERIAL: 41458 - Milkshake Strawberry

Step 1: Log on to the BW system.

Step 2: Execute transaction <RSD1>, fill out the info-object 0MATERIAL and click <Display>.

Step 3: Double-click the entry for the field ‘SID table’ to switch to the table view for this table.

Step 4: Click the ‘Contents’ button.

Step 5: Enter the material number and press the ‘Execute’ button.

Step 6: Note down the SID (8361).

2. Find the related info-providers

Step 7: Execute transaction <SE37>, fill out the function module <RSDDCVER_USAGE_MDATA_BY_SID> and click the ‘Test/Execute’ button (F8).

Step 8: Fill out the parameter I_IOBJNM with the info-object ‘0MATERIAL’.

Step 9: Click on the table picture for parameter I_T_SID_CHECK and fill out the SID that was retrieved in step 6. You can enter multiple values using the ‘New Line’ button.

Step 10: Go back to the previous screen and execute the function module (F8).

The entries consist of information on where the specific material number is being used. For example the below value E_T_ULIST_ATR_NAV shows that this material number is also being used as an attribute value for the info-object ‘CRM Product’ (0CRM_PROD)

Labels in this area