This component is done in SAP BW system. The purpose of the component is to list out all the Workbooks, Web templates present for a query/queries under User Menu Role. The component can be used by any user.
The idea to create this component came up when the Security team was finding it difficult to identify huge list of workbooks to be refreshed, manual errors were encountered at the same time there was time constraint. The approach in which Security team was following was tedious and time consuming. The same tables which security team refers to perform the task is used here in the component but by making the lookup being used in ABAP program thereby by completely removing manual lookup and making room to zero errors in identification of Menu Roles.
This tool is helpful for BW developers and End users too. Users can check whether the particular query has been assigned to any Menu Role as a Web Template or as a Workbook, and if assigned then whether that Menu Role is assigned to intended user of that report or not just by executing a program providing and the technical name of the query.
This component has the following functionality; it has two different options for listing out Menu roles:
Option 1: Workbook
If we need to list out Menu Roles under which Workbook/workbooks exists for a given query or a set of queries, then choose the Workbook radio button. This component when executed provides the list of workbooks if present else it will return no results.
Option 2: Web Template
If we need to list out Menu Roles under which Web Template/Web Templates exists for a given query or a set of queries, then choose the Web Template radio button. This component when executed provides the list of Web Templates if present else it will return no results.
For a given query the tool displays:
For Workbook:
Query Name, Query Description, Menu Role, Menu Role Description and Workbook Description.
For Web Template:
Query Name, Query Description, Menu Role, Menu Role Description, Web Template ID and Web Template description.
This component needs a small modification when it needs to be used in different project's BW system. But this modification will not change the functionality of the component. This change is related to the nomenclature of Menu Role used in the program to avoid unnecessary overheard of searching all the Menu Roles.
Functionality:
Workbook
Web template
Below standard SAP tables are utilized and by using lookups with various tables the desired result is obtained. There is no impact on existing SAP system's functionality. This tool can be implemented without any modification to existing tables, programs etc.
Modification based on Security Role Technical naming convention followed:
The tool is designed to extract Menu Roles having pattern 'X%' (Menu roles starting with alphabet X). If the convention followed in your project is different, the tool can be modified to accommodate the same by just changing the value at a single place.
To make the changes, follow the below steps:
Step 1. Once you are done creating all the objects related in your system, go to the data declarations include.
Step 2. Search for the keyword c_pattern
Step 3. Replace the value of X% (% indicates followed by anything) with the convention followed in your project.
In case there in no specific convention followed, do a 'Where used list' of the constant c_pattern and delete/comment the conditions that use this constant and also remove/comment the constant declaration.
Step 4. Activate the include.
The below screenshot shows the place of declaration of the pattern:
List of table used to build the tool:
RSRREPDIR
RSRWORKBOOK
AGR_HIER
AGR_HIERT
RSRWBINDEXT
RSZELTXT
AGR_TEXTS
RSZWOBJXREF
Below is the design Flow chart:
Step 1: Create an ABAP Program ZBW_WB_MENUROLE_IDENTIFIER using the codes provided in the attachment:
Step 2: Execute the program.
Step 3: Provide the Technical name of the Query for which Workbook/Web Template has to be searched and click on the Radio button if you need to find Menu Roles under which workbooks are published as shown below:
Query Technical Name: XXXXXXXXXX_Q9 and its Description "XXXXXXXXX"
Option 1: Workbooks related to above query under Menu Roles
Click on Execute button.
Output:
Column "Menu Role Description" gives the Role Menus under which Workbooks corresponding to Query XXXXXXXXX_Q9 have been published.
Option 2: Web Templates related to above query under Menu Roles
Click on Execute button.
Output:
The additional column Web Template ID gives the technical name of Web Template that is built using the query XXXXXXXXX_Q9.
Query for which there are no Workbooks or Web Templates the tool displays "No data found".
For example Query “Utilization XXXX” has a Web Template but no Workbook under Role Menu as shown below:
Query Technical Name: XXXXXXXXXXXXX_Q0001_X "Utilization XXXX"
Option 1: Workbooks related to above query under Menu Roles
Input Parameter:
Output:
Option 2: Web Templates related to above query under Menu Roles
Output:
Attachments includes the codes for the tool as below:
1. DATA DECLARATIONS INCLUDE
2. MAIN REPORT PROGRAM
3. SUBROUTINES DEFINITIONS INCLUDE
Credits:
ABAP Coding: Vindhya Kumari vindhya.kumari
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
10 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |