Skip to Content
Technical Articles
Author's profile photo Anikesh Jyotishi

External HANA view configuration in BW4HANA


SAP Introduced new functionality from BW 7.4 on HANA where we can generate HANA view directly from B4HANA and BW on HANA application during BW object activation, The external HANA view enables to create scenarios where data, which is modeled in the BW system, are merged with data modeled in SAP HANA with SAP HANA tools.

This document will provide you an overview of the external HANA view configuration from the SAP BASIS point of view.



The content of this blog post is provided “AS IS”. This information could contain technical inaccuracies, typographical errors, and out-of-date information. This document may be updated or changed without notice at any time. Use of the information is therefore at your own risk. In no event shall SAP be liable for special, indirect, incidental, or consequential damages resulting from or related to the use of this document.


This document tried to include all Basis steps for BW4HANA external HANA view configuration.

From BW 7.50 it is possible to generate Calculation Views for all objects if you execute the steps available (SAP note 2236064)

SAP encouraging to use inbuild FIORI URL for external Hana view configuration in BW4HANA.

External HANA View setup in BW4HANA Steps: –

  • Take all system backup
  • User sync and setup HANA user creation along with ABAP user
  • External HANA view related TRANSACTION / FIORI URL
  • Global Role for HANA external HANA view and Multi-Role
  • Parameter setup for external HANA view setup
  • Generate external HANA view with ADSO
  • Sync new HANA user role from BW4HANA application
  • Check external HANA view from Application and DB level

Take all system backup: –

As per preventive measures take full DB backup, We are only adding new configuration and no impact on system core functionality.


User sync and setup HANA user creation along with ABAP user :-

Same as


Global Role for HANA external HANA view

If you are using assignment type as D (Direct assignment), Need to create a global role. (More explanation under next setup)

bw2hana/<ABAP_Schema>_SAP_BW_MODEL_GENERATION is a master role and needs to create in every environment, Without this role, one can be able to generate an external HANA view from the BW system, This role should be assigned to the HANA level.

To be able to access SAP HANA views that have been generated from the BW system, you need the following authorizations:

  • Object privilege: SELECT on _SYS_BI
  • Object privilege: EXECUTE on REPOSITORY_REST(SYS)
  • Package privilege: REPO.READ on the content package where generated SAP HANA views are stored.


External HANA view related TRANSACTION / FIORI URL:-


All transaction details added in previous blog, It’s a same as BW on HANA.

https://<hostname:https port>/sap/bc/ui2/flp?sap-client=<Client number>&sap-language=EN#Shell-home


Assign FIORI roles, SAP_BW4_MODELER, and SAP BW4 REPORTING USER roles to the user so that the user can access FIORI tails.


Under data Management Select external Hana view tail

Go to general settings

Based on SAP default setting need to give HANA package name as

It will allow the Application layer to create all external Hana views under package.

Check the entry in the RS2HANA_VIEW_SET table.

Changing an existing package is only possible if the HANA package is empty.

The below option can be checked based on functional requirements.


Assignment Type:-  SAP provides 2 assignment types on BW4hana and based on your selection external Hana view roles will be created at the HANA DB level.

 I preferred D direct assignment as it required only one global role and additional analytical privileges will generate based on infoprovider external Hana view.

If you will use Assignment M it will generate par BW4HANA DB user role, for example, if you have 2000 users it will generate 2000 roles as below format.

bw2hana/<ABAP_Schema>_SAP_BW_MODEL_GENERATION_username :- if assignment type is ‘M’


We have 2 options in BW4hana for AP generation, S and U.


Multiple BW4HANA

If multiple BW4HANA systems share on HANA instance, it is mandatory to set a different package in each system.

Generate external HANA view with ADSO

For NW 7.5 SP7 all development supported by eclipse.

This step purely for the functional team, they can follow the below link and enable external HANA view from eclipse.

Sync new HANA user role from BW4HANA application


Click on analytic privileges to remove and add HANA DB roles analytical privileges for specific BW4HANA objects.

The detailed analysis we can enable below expert mode settings: –

Check external HANA view from Application and DB level:-

Click on object name and click on check view consistency,

DB level check views on below location, All BW4HANA external HANA views will be created under the system-local package as we placed the parameter under RS2hana_admin.


Reference SAP Notes:-


2695442 – External Hana View: Activation of BW Object fails with error ‘Replication failed RS2HANA_AUTH234’



  1. Allows access to BW4HANA data via SQL front ends.
  2. All applications that can read SAP HANA views can process the data easily for External views
  3. The advantage of running the query which is executed on the SAP HANA view retrieves the data directly from SAP HANA, without accessing the BW4HANA system at all.
  4. Data can be viewed by Excel and other tools via DB


I hope this document will help you with the external HANA view setup.



Anikesh Jyotishi


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Anders Kortbæk
      Anders Kortbæk

      Hi Anikesh,

      If we use the external HANA view to export data from a BW4HANA system. Would that not require some kind of license or are we free to do that?

      Even if we build our own HANA Calculation Views on top of BW4 objects and export data via them?

      BR, Anders

      Author's profile photo Anikesh Jyotishi
      Anikesh Jyotishi
      Blog Post Author

      Hello Anders,


      Yes if you are developing HANA view development, you need an additional license, it will not come under run time license, please check with SAP for more details.


      The options marked with * have some restrictions regarding data processing.

      SAP HANA Runtime Edition is considered an integral part of the application itself, so that any kind of data processing (modeling, administration, creation of data structures and use of advanced analytics) must be done by this application, via the application layer (where the interface can be either from SAP or a 3rd party provider). With SAP HANA Runtime Edition, the data from the application can only be displayed or graphically processed at the front-end application and any direct connection to the database bypassing the application is a license violation.

      In general, though, you can only use HANA for the application and it’s approved interfaces. Any access to hana outside the application and any data not brought in via the app is generally is a violation.

      Creating call views is usually not allowed unless the app is doing it.

      Runtime and full use can coexist but there AE strict rules around that too.

      The picture below shows not only the available SAP HANA capabilities, but also the restricted (Δ) and not included (X) ones when SAP HANA Runtime Edition is licensed.