Skip to Content

Introduction

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…

Audience

SAP BW Administrators / Developers.

Table of Contents

Introduction
Audience 
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>.

/wp-content/uploads/2012/09/1_141271.jpg

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

/wp-content/uploads/2012/09/2_141281.jpg

Step 4: Click the ‘Contents’ button.

/wp-content/uploads/2012/09/3_141282.jpg

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

/wp-content/uploads/2012/09/4_141283.jpg

Step 6: Note down the SID (8361).

/wp-content/uploads/2012/09/5_141284.jpg

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).

/wp-content/uploads/2012/09/6_141286.jpg

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

/wp-content/uploads/2012/09/7_141285.jpg

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.

/wp-content/uploads/2012/09/8_141287.jpg

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

/wp-content/uploads/2012/09/9_141288.jpg

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)

/wp-content/uploads/2012/09/10_141289.jpg

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply