To build a list of BEx Workbooks and BEx Queries in a role use table AGR_HIER
keys = AGR_NAME + OBJECT_ID
- AGR_NAME = role
- OBJECT_ID = ID fo the object in the role (1 is the root folder)
- PARENT_ID = ID of the parent folder (1 for objects that are in the root folder)
- FOLDER = X if it is a folder
- TEXT = Either Role menu descripiption or report description
- REPORT = RRMX for WBK / SAP_BW_QUERY for query
- SAP_GUID = WBK ID or Query TECH NAME
The following program lists the Role / Workbook ID / Workbook name and all the queries that are in the workbook. Additionally it will list any replacement path variable that uses the result of another query as input.
Download – ZBW_WB_PROPERTIES – 17.4 KB – 605 downloads