Master data deletion not working

[#1]

Hi All,

In production environment, I need to delete some unwanted old records from master data, since it getting on report prompt by default. For this deletion, I have followed the below steps (Step 1 to Step 8), but it doesn't works. Still the records showing on P-Table (Master data table)& X-Table (SID table). Kindly share your idea/ Input for this deletion.

1) RSA1 --> find Info object --> right click --> maintain master data

2) Select rows we want to delete and click 'Delete' icon. Then SAVE.

3) If system prompt message "some master data cannot be deleted" ... continue with this message.

4) Then goto tcode SLG1 --> enter Object: RSDMD and Subobject: MD_DEL and User: your userID and press F8.

5) In the next screen Expand node and double click 'Problem class additional information'

6) This will give which ever objects using SIDs of this master data.

7) We should delete this SID according to that list (For this deletion I have used this program RSDMDD_DELETE_BATCH ).

😎 Then we should delete particular data from DSO/Cubes.

9) Once data deleted from cube, then Use Tcode RSRV -> Tests in Transaction RSRV -> All Elementary Tests -> Transaction Data -> Entries Not Used in the dimension of an InfoCube (Double Click)

10) From the right side window, expand “Entries Not Used in the Dimension of an InfoCube” Node & Enter InfoCube click “Transfer”

11) Now, click “Execute” (Toolbar)… and the results displayed in the right side window..

12) Now, click “Correct error” (Toolbar)

Thanks,

Angavai Elangovan

[Former Member · Accepted solution]

Hi All,

I have deleted the entry in DSO (Which infoprovider having the entry) and then deleted the entry in master data. Still it showing in the masterdata table.

Thanks,

Angavai Elangovan

[yasemin_kilinc · Accepted solution]

Were you successfull in deleting the entry in master data? Again take a look at SLG1 transcation if the entry exists in any other infoprovider.

[Former Member]

Is there any program available for master data selective deletion, since I need to delete more entries.

Thanks,

Angavai Elangovan

[yasemin_kilinc]

In maintenance of master data screen select multiple choices option for the characteristic, view all the master data you want to delete, select all and try deleting. Then you will see the infoprovider one by one in SLG1.

Regards

[Former Member]

Now it got deleted

But for single entry deletion takes long time.

Thanks,

Angavai Elangovan

[Former Member]

Okay..Let me check.

Thanks,

Angavai Elangovan

[Former Member]

Hi Angavai,

This is just for information: Is this Master Data Loading Daily into your system. If so is it a Full Load.

Have you deleted from all the places as where used.

Check and try to delete the master data in the places, in which it is still being used:

1. In the InfoCube( all Targets)

2. As an attribute

3. In a hierarchy

Then try deleting again.

Thanks and Regards,

Dinesh

[yasemin_kilinc]

Hi Angavai,

As far as I know SLG1 shows the first infoprovider where the data exist. It stops after finding a usage of the sid. There may be many infoproviders where this master data is used. So you need to do those steps as long as all master data sids are deleted from tables. By the way I didn't know that there was a program RSDMDD_DELETE_BATCH to clean the sids from the dimension tables. But I think you first need to delete data from the infoprovider and then the dimensions.

Regards

Yasemin...

[Former Member]

Hi,

Plese do the following:

Right click on Master Data Infoobject and go to Delete Master Data.

It will prompt you a pop up, Check delete SID checkbox as well along wiht the pre-defined selection and proceed.

Now check your master data might get deleted.

Regards,

Vikrant

[Former Member]

Hi Ram,

I have followed the steps which are in my prior post. By the way I have deleted the entry in transaction data and then deleted the master data entry by using the program 'RSDMDD_DELETE_BATCH' and after running the report it shows message like data deleted successfully.

But still the deleted entry showing on P-Table & X-Table.

Thanks,

Angavai Elangovan

[RamanKorrapati]

Then do the RSRV test on master data P and X tables.

later activate your master data info object.

After that you can cross check, whether deleted entries exist P and X table or not.

[RamanKorrapati]

You totally did in opposite way.

if need to delete master data record then first you need to delete the same record form all targets(cube/dso)where its been used.

Once you delete from targets then it will allow you to delete from master data tables other wise it won't.

While deleting master data itself it may shows the logs as its been used targets. so first try to delete particular record from dso/cube by using selective deletion.

later you can delete from master data tables.