Hello Friends,
In this post I would like to provide the steps required to delete the master data which is being used in transaction data (Info Cubes and DSO’s).
The Major steps are
1) RSA1 –> find your Info object –> right click –> maintain master data
2) Select rows you want to delete and click ‘Delete’ icon. Then SAVE.
3) If system prompt you message “some master data cannot be deleted” … continue with this message.
4) Then go to t-code SLG1 –> enter Object: RSDMD and Sub Object: MD_DEL and User: your user ID and press F8.
5) In the next screen Expand node and double click ‘Problem class additional information’
6) This will give you which ever objects using SIDs of this master data.
7) You should delete this SID according to that list.
8) Then U should delete particular data from DSO/Cubes.
Once data deleted from cube, then
9) Use T-code RSRV -> Tests in Transaction RSRV -> All Elementary Tests -> Transaction Data -> Entries Not Used in the dimension of an Info Cube (Double Click)
10) From the right side window, expand “Entries Not Used in the Dimension of an Info Cube” Node & Enter Info Cube (like 0SD_C01), click “Transfer”
11) Now, click “Execute” (Toolbar)… and the results displayed in the right side window..
12) Now, click “Correct error” (Toolbar)
Hope It helps
Happy Learning