How to identify the BW Workbooks created on the BW BEx Queries


Background/Scope of Document:


In this document explaining a scenario, where we need to identify the total numbers of BW Workbooks are created on the BW BEx Queries.


Test Scenario:


Below are steps to identify the BW Workbooks.


Go to T-Code SE11/SE16: Select the Table “RSRREPDIR” (Directory of all reports) and provide the BW BEx Query name.

Capture.JPG

Then you will get the “GENUNIID” for respective BEx Query.

 
Capture1.JPG

With the help of “GENUNIID”, we will get the “WORKBOOKID” easily.


Now again, Go to SE11 and select the Table: “RSRWORKBOOK” (‘Where-used list’ for reports in workbooks) and put the “GENUNIID”.


Then we will get the list of “WORKBOOKID“.

Capture2.JPG

Below are the Workbooks are exists on the BW BEx Query.

Capture3.JPG

Total 111 BW Workbook entries found.

Capture4.JPG

Above steps concludes, how to identify the existing BW Workbooks.

Related content:

https://scn.sap.com/

https://help.sap.com/

To report this post you need to login first.

4 Comments

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

  1. Aparajit Banik

    Nice one Kshitij

    Just one more addition would have been really nice if  you would have explained in the document a little bit more about the relation between the RSZ tables ; like you have used two tables RSREPDIR  report directory and RSRWORKBOOK  using the GENUINID(Query) value from one table into another..
    Thanks. 🙂

    (0) 

Leave a Reply