Skip to Content

Delete Master data from SID Table

Dear Guru's,

scenario : I loaded some master data to an existing info object for a new comp code( CC01) . I found the master data is not correct . I want to delete it .

1) I tried to delete using se38 --> RSDMDD_DELETE_BATCH  & also from Maintain masterdata

No Master data deleted

2) I went to SLG1 &  found that log like below ;

Master data SNBCB1000135 (SID                                          21554042) is used in /BIC/DYYY_C_032; is not deleted

Also some SID values found in some cube for CC01

3) I checked in SID Table & found an entry with the Comp Code CC01 & SID.

My Question is :

1) Can i delete the data from SID ,if so how to do selective deletion for only CC01 data , i found in some posts that deleting SID data might give problems when i reload the same master data.

2) How to delete the SID from cube .

Thank you for your time.

Regards,

Sudhir.

SLG1 for cube.jpg (85.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 10, 2014 at 06:29 AM

    Hi janardhan,

    ) 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 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 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 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 (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 will help.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 10, 2014 at 11:31 AM

    Try with this Program & Check any Inconsistency in Sid's For that IOBJ.

    RSDMD_CHECKPRG_ALL.

    Add comment
    10|10000 characters needed characters exceeded