In SAP BW you able to create a workbook with one or more queries, After you’ve created or sometime during maintenance your workbook, you might need to get a list of queries that were used to build that workbook. You can use transaction RRMX_WORKBOOK_QUERIES_GET to find out which queries are used in workbook.

How to use RRMX_WORKBOOK_QUERIES_GET

1.Get technical name of workbook you can use table RSRWBINDEXT via transaction code SE16/ SE11 . And filter OBJVERS as ‘A’ this is Active Version and lookup the workbook by the title and get the workbook ID.

2.Call transaction code  RRMX_WORKBOOK_QUERIES_GET and input workbook ID with Workbook ID from step 1. Then execute the list queries are in parameter E_T_QUERY_INFO.

rrmx_workbook_queries_get

Incoming search terms:

About The Author

Leave a Reply

Your email address will not be published. Required fields are marked *