List of Posts

Get this widget
To get notifications, Please like our Facebook Page >>>>>>

Use Search box to find a topic in this Blog!!!

BW Security (Authorizations)

The following are some of the relevant SAP BW Security transaction codes.

Transaction Code
Transaction RSA1 is the main transaction for administrative functions in SAP BW (Administrator Workbench)
This transaction code can be used to mark objects as relevant for authorization (InfoObject Maintainence)
This transaction code can be used to create and modify authorization objects in SAP BW
This transaction code is used to create or modify the variables for authorization checks. (Variable Maintenance)
Business Explorer is the reporting tool in SAP BW and is used for analyzing data.
Templates for modelling and evaluating data

How to Activate Authorizations In BW:-

The following steps explains how to activate the authorizations in BW.
 1)  Mark InfoObject as relevant for authorization tcode => RSD1
 2)  Create report authorization object tcode => RSSM
3)  Select InfoCubes tcode => RSSM
4)  Manually integrate authorization object in role tcode => PFCG
5) Change / Maintain authorization values => PFCG
6)  Assign role to user tcode => PFCG or via Central User Administration
Hierarchical Authorizations in BW

The following steps describe the steps to control authorizations for hierarchies

1) Transfer and activate InfoObject 0TCTAUTHH tcode => RSD1
2) Mark InfoObject 0TCTAUTHH as relevant for authorization tcode => RSD1
3) Mark Leaf InfoObject as relavant for authorization tcode => RSD1
4)  Create authorization objects with 0TCTAUTHH and Leaf InfoObject => RSSM
5) Define hierarchical authorizations tcode => RSSM
6) Manual intrgration of authorization object in role tcode => PFCG
7)  Maintain authorization values tcode => PFCG
8)  Assign role to user tcode => PFCG or via Central User Administration

For extracting structural authorizations from HR (mySAP ERP HCM)  and to map it in SAP BW to maintian consistency between the two systems the tables of interest are:
1)  T77PR -for Structural Authorization profiles
2)  T77UA -for user assignments
3)  T77UU -for users (in this table you can select the users for extraction. You can either select all or specific users)

Structural Authorizations in SAP BW

The following steps show the way Structural Authorization is enforced in SAP BW.

The following steps to be carried out in the mySAP ERP HCM system.

1) Call program RHBAUS02 for uploading Table T77UU and enter users.
2) Call program RHBAUUS00 for generating an index for structural authorization profile
3)  Activate Data source 0HR_PA_2.
 The following steps to be carried out in the SAP BW system

 1) Replicate Data source 0HR_PA_2
2) Activate ODS InfoProvider 0HR_PA_2
3) Create an InfoPackage to perform an extraction for 0HR_PA_2
4) Load ODS data from mySAP ERP HCM
5) Mark InfoObjects as relevant for authorization (In order to use structural authorizations in SAP BW, all characteristic values like position, employee etc. which are relevant to reporting should be marked as authorization relevant InfoObjects.)
6)  Create reporting authorization objects
7)  Link authorization objects to InfoCubes
8)  Call program RSSB_Generate_Authorizations.


  1. Best blog.Got to learn new things.Thanks for this Blog SAP HR Training in Chennai

  2. Somos una empresa de arrendamiento de mini bodegas y bodegas personales en Bogotá
    Minibodegas bogota/

  3. This comment has been removed by the author.

  4. The Information you provided is very much useful for me and SAP BW Learners. This Information was very Interesting, We also provide SAP BW Interview Questions.

  5. 2015 Home Builder of the Year! Classic Homes of Pensacola LLC would like to welcome you to Pensacola Florida. Pensacola is known as FloridaFirst City and is truly a paradise. Sugar white sand with miles of beautiful beaches, vibrant communities, a growing economy and so much to offer.
    New homes in pensacola

  6. Prime Locations Cayman is the most trusted real estate company for buying and selling Cayman Property. A straightforward approach to fulfill customer’s needs.
    Cayman real estate

  7. 24-7 Courier offers same day parcel and same day courier services in Birmingham, Leeds, Nottingham, Liverpool as well as International Courier Services.
    same day courier delivery Glasgow



This blog is solely for the purpose of getting educated in SAP. This blog does not encourage distribution of SAP hold copyright and any other publication and/or materials bearing SAP mark. If you find any copyright materials, please mail me so I can remove them. This blog is not in association with SAP.

ALL Posts

Get this widget