Skip to Content

Moderator message: Directly modifying the contents of standard SAP tables is not best practice. Therefore following the advice in this document is at your own risk.


Dear Friends this Document will give you a brief information about the data deletion from info cube and DSO.

Some time we come across this situation if we wants to delete all request from DSO or cube then we have some standard option like this.

1. Delete Data – Right click on data target and select delete data.

2. Delete request by request – I think is a big task and takes more time.

3. Selective Deletion.

Perhaps it will not work.

Delete Data – Some time we trying this option but still we can see the request in our Request tab.

Selective Deletion – if we wants to delete some records thus this option is OK.

But if we wants to delete all request from DSO or Info cube then we can use this standard table to delete all data from cube or DSO.

1. Table – RSREQICODS – Monitor: Saving of the updated IC and ODS per request

give the Table name or target name to delete data.


Press Execute or F8.

select all then go to table entry menu and select delete or delete all.


2. Table RSICCONT – Monitor: Saving of the updated IC and ODS per request


Give your target name (Info Cube or DSO) in below screen

Select request

Go to table entry menu option and select delete or delete all.

3. RSREQDONE – Monitor: Saving of the QM entries

   This table will give you all request information and QM status also with date, this means when it was loaded.

Give the DTP technical name for relevant data target and here our data target is 0SD_O06.

Give the DTP technical name.. and execute.

Now we can see all the request which is loaded by this DTP

select table entries and delete from the table after all three table deletion check the data target.


Thanks for reading this document…..

Note : If any request is not activated for DSO it will not delete.

Thanks and Regards,

Satendra Mishra

To report this post you need to login first.

34 Comments

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

  1. Raman Korrapati

    really good info. But screens are not visible. Pls try to fix them from your end.

    One more thing deleting entries from standard table risky/danger. need to be careful.

    (0) 
    1. Satendra Mishra Post author

      Hi Raman,

      Thanks for appreciation and suggestion regarding screenshot. 🙂

      really its risky to delete entries from standard table but some time it required. 🙂

      Regards,

      SM

      (0) 
  2. Phani KV

    i got same issue how to delete DSO request.(it is partially activated)

    it is preferable table level deletion request in PRD. if we delete any issue?

    Thanks,

    Phani.

    (0) 
    1. Satendra Mishra Post author

      Hi Pani,

      I also faced same issue long back in PRD and I used all 3 tables in PRD. But before deleting data confirm that for which data target you wants to delete data so while delete data select correct DSO, DTP request and Info cube. Be careful while selection data target bcz 1 mistake can delete all data from other data target if you selected wrong data target or DTP technical name data source name.

      🙂

      Regards,

      SM

      (0) 
  3. Prashanth Konduru

    Nice tip and usefull informations, but not suggested for deletion of entries from the system tables in Production environment.

    More over “Delete Data” will delete the entire data requests from the DSO or IC and also the table entries as well.

    Thanks for sharing 🙂

    Regards

    KP

    (0) 
      1. Prashanth Konduru

        Its Ok fine … the Blog is informative and usefull

        I was just giving heads up that “delete data” its self will delete the entire DSO or IC data and requests and also from the tables as well.

        If you check the link its clear that Suman is facing the issue with one request not with the entire data requests in the DSO or IC. Check my replies in that post…

        Regards

        KP

        (0) 
  4. Matthew Billingham

    Moderator message: Directly modifying the contents of standard SAP tables is not best practice. Therefore following the advice in this document is at your own risk.


    I have added this warning to the document.

    (0) 
  5. Abhijit Gaikwad

    Hi Satendra,

    I thank you for all the efforts you’ve taken.

    Let me ask you to briefly brief us on the unrealistic situation where you needed to delete All information from a DSO / Infocube?

    I can understand ‘Deleting a request from an Infocube’, but not ‘All information’.

    Lastly, by cautiously following each and every step of yours, maybe all consistency between all internal SAP application/status tables could be guaranteed but one – the data/tuples would still survive inside the Infocubes’ F/E tables without she (SAP BW application) even knowing they are there or does she. Please correct me, if I am wrong here.


    Kind regards,

    Abhijit 

    (0) 
    1. Suhas Karnik

      Hi Satendra,

      This solution introduces very serious inconsistencies in the system because the RS-tables contradict the actual DSO/Cube content as Abhijit points out.

      Some additional follow-ups to his questions: given the fact that the data itself continues to exist in the Cube, what happens to the reports that are executed on the Cube? Would they show the data from the requests you deleted from RS-tables?

      If we’re talking about DSOs, what happens to the future deltas that are sent out from the affected DSO? What happens to the deltas that are sent into the DSO?

      And It is indeed very curious why we need to manipulate RS-table entries, as SAP has give a single click option in RSA1 to delete all DSO/Cube content in a perfectly safe manner?

      Regards,

      Suhas

      (0) 
      1. Satendra Mishra Post author

        Dear Suhas,

        I want to clear that time when you loading data from PSA to cube or DSO then due to some reasons particular request got corrupted then you can delete by selection a single request in manage and delete but some time it wont works then we go for this option not all the time bcz we have some standard option which i mentioned in my document. and about deltas which is already there in pSA so you can reload again if you not deleted from there. 🙂

        Regards,

        SM

        (0) 
        1. Suhas Karnik

          Hi Satendra,

          Sorry, I didn’t get that meaning from the blog above – to me it appeared that this approach was being presented as a substitute to the standard procedure for deleting (any/all) requests from a DSO. 
          But one thing is still not clear: how do you address the problem that the data still physically exists in the A table of the DSO or the F/E tables of the cube? There aren’t any steps here to handle that. Can you point out which of the above steps takes care of deleting the data present in the DSO/Cube tables?
          Regards,
          Suhas
          (0) 
    2. Satendra Mishra Post author

      Dear Abhijeet,

      I wrote here in top of my document some time we are not able to directly delete request from the DSO or Cube. I also mentioned there we have standard option to delete data from cube and dso but some times it wont works then we can go for this options.

      Note : i want to clear that this for particular request not for all request some this not able to delete some request then we can go for this solution. And there will be no inconsistency between any table and data

      http://scn.sap.com/message/14636424#14636424

      Regards,

      SM

      (0) 
  6. David Horner

    Hi Guys,

    we have just applied this technique to our QA system, however, the data remains within the DSOs and Cubes.  It is only the request info on the management tab that has been deleted.

    Regards

    David Horner

    (0) 

Leave a Reply