Skip to Content

How to identify the BW Workbooks created on the BW BEx Queries only in two steps

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/

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