Skip to Content

1. OVERVIEW

          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.


2. FUNCTIONALITY


     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:

  • Lists out Workbooks and Web Templates for a given Query or a set of Queries as input.
  • Provision to choose and display Menu Role having either Workbook or Web Template based on a given Query or a set of queries as input.
  • Displays only those workbooks and Web Templates which are present in a Menu Role/Roles.
  • The tool is designed as a report program in SAP
  • The tool is designed to display output in ALV based on the concept of Docking Container and data to be displayed are considered from different tables related to Workbooks and Web Templates.
  • The tool designed to display the output dynamically based on the user input.
  • Normally security team manually checks text descriptions of workbooks which may induce manual errors and also it takes more time in identifying menu roles.
  • This tool helps Security Team in identifying the Menu Roles accurately under which Workbooks needs to be republished incase of any changes done to the existing BW queries (Especially when the changes done to a huge list of queries and when it needs workbooks to be republished)
  • Also reduces the manual effort and increases the efficiency.
  • This tool can be used by Basis team to identify and assign suitable menu Role access to an user coming up with a request to assign suitable menu role under which he can access a particular query
  • This tool can also be used by BW developers to analyze the impact of a query modification
  • The tool provides option of displaying menu roles of Queries or Web templates
  • User should enter the Query names or Web templates and choose the appropriate option from the selection given below

            Workbook  

            Web template

  • The tool dynamically displays the data according to the option chosen
  • The tool displays Query Name, Query Description, Menu Roles, Menu Role Description, Workbook Description in case of Workbook and Query Name, Query Description, Menu Roles, Menu Role Description, Web Template ID, Web Template Description in case of Web template

3. DESIGN

          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:

Image 1.png

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:

Image 2.png

4. USAGE

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

Image 3.png

Click on Execute button.


Output:

Image 4.png

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

Image 5.png

Click on Execute button.


Output:

image 6.png

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:

image 7.pngimage 8.png

Query Technical Name:  XXXXXXXXXXXXX_Q0001_X “Utilization XXXX”


Option 1: Workbooks related to above query under Menu Roles

Input Parameter:

image 9.png

Output:

Image 10.png

Option 2: Web Templates related to above query under Menu Roles


Output:

image 11c.png

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 http://scn.sap.com/people/vindhya.kumari/prof

To report this post you need to login first.

12 Comments

You must be Logged on to comment or reply to a post.

  1. Kumar S

    Thank you jeethendra, A quick one to find out workbooks, web templates etc.

    Good to knew ABAP Program ZBW_WB_MENUROLE_IDENTIFIER now.

    (0) 

Leave a Reply