cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

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

0 Likes
View Entire Topic
Former Member
0 Likes

Okay..Let me check.

Thanks,

Angavai Elangovan