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

[former_member222937]

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.

Then you will get the "GENUNIID" for respective BEx Query.

 

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".

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

Total 111 BW Workbook entries found.

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

Related content:

https://scn.sap.com/

https://help.sap.com/