Skip to Content
Author's profile photo Former Member

Deleting Partially Active Requests from DSO

Warning. The instructions in this blog are not recommend by SAP. The actions taken do appear in various security audit logs, and may be forbidden in your company. Furthermore, if they are done incorrectly, they could cause parts of your BW system to become inoperable, without support from SAP to fix.


Use at your own risk.


Deleting Partially Active Requests from DSO

Sometimes while several requests are being activated at a time in a DSO, we get partially active requests. Generally we use “Do not condense requests into one request when activation takes place” option to avoid this situation. There might be other scenarios like restarting the activation for other requests, not deleting all the cancelled requests causing inconsistencies in the DSO. The requirement is to delete such requests from DSO but we are not able to delete them in the regular way.

In such cases, we need to delete the requests from 4 tables which contain all the requests in DSO to maintain consistency. These tables are:

1)      1) RSICCONT

2)      2) RSMONICDP

3)      3) RSODSACTUPDTYPE

         4) RSODSACTREQ

To perform this activity please follow the below steps:

1)     1) Go to SE16/SE11 and open the table.

2)      2) Provide the request number which needs to be deleted.

                                        /wp-content/uploads/2013/10/selection_293564.png

3)       3) Select the request and double click on it to access Display screen.

4)      4)  Write /h in the command prompt field and press enter. We get a Debugger switched on message at the left bottom corner of the screen.

                                        /wp-content/uploads/2013/10/command_293566.jpg

5)      5)  Press enter again to go into the debug mode and select the variable with id “code” and modify its value to “DELE”. For this double click on code first and then double click on the pen, both of these fields are highlighted in yellow. Change the value from SHOW to DELE and press enter.

                                        /wp-content/uploads/2013/10/abap1_293570.jpg

                                        /wp-content/uploads/2013/10/abap2_293571.jpg

6)      6) Press F8 to complete the execution and proceed to delete the entry we selected.

7)      7)Click on Delete entry to delete this entry.

                                        Delete.jpg

The selected entry has been deleted from the custom table.

Repeat the same procedure for all the other 3 tables to maintain consistency.

We can select multiple entries on the Data Browser screen and delete them with only one execution of the debugger tool to modify the value of “code” variable.

Select the entries you want to delete.

                               /wp-content/uploads/2013/10/mulp_sel_293573.jpg

Perform the steps 4-7 mentioned above. Now click on “Delete Entry” and then “Next entry”.

    

                              /wp-content/uploads/2013/10/multiple_293574.jpg

Thanks !!

Assigned Tags

      17 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Phani KV
      Phani KV

      Good one.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks ..:)

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      Thanks for the tip Patik. But, will be able to do this in prod too?

      Benedict

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Yes benedict. I too tried it in Production. We just need the Debug access for it and then you can move ahead.

      Author's profile photo Former Member
      Former Member

      Pratik...just a small info needed while creating this document how you are pasting the screen shots of BW system in the document, while I try to create any blog or document I am not able to copy paste the screen shots in the document ....kindly let me know

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Antony we need to attach the snapshots. We can't copy paste them. We need to upload them from our local computer and then you can use them.

      Author's profile photo Former Member
      Former Member

      Thanks pratik

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      First save the screen shots as JPEG or Bitmap in your local folder. In the blog editor, use the camera icon to insert the screen shots:)

      Benedict

      Author's profile photo Former Member
      Former Member

      thanks

      Author's profile photo Former Member
      Former Member

      great trick to delete unwanted request.

      Kind Regards

      Manna

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Manna.. 🙂

      Author's profile photo Former Member
      Former Member

      thanks for sharing.. its a nice trick.

      Author's profile photo Former Member
      Former Member

      Im waiting for this doc since long. At last i got it here. Thanks for sharing.

      Best Regards,

      Venu Gopal

      Author's profile photo Matthew Billingham
      Matthew Billingham
      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Matthew for editing it. True, this should be practiced only if there are no other options available.

      Thanks once again. 🙂

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice document. 🙂

      Author's profile photo sandeep seloj
      sandeep seloj

      very useful...thank you!!!