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.
Incoming search terms:
- does workbook have any description in sap bi
- SAP table that stores the query and workbook name
- how to check the version of a workbook in sap bw
- sap bw workbook table
- how is bex queries used for reporting in sap
- how to find last 1 year used workbook in SAP BW
- how can i get the technical id for a sap analysis workbook
- workbook query in sap bw
- BW workbook
- how to check query used in which workbooks in sap bw