External SAP HANA Views

Introduction

When activating BW objects like HANA-optimized InfoCubes, you can generate SAP HANA views with the same structures (see provider setting 'External SAP HANA view'). This enables you to create scenarios where data, which is modeled in the BW system, is merged with data modeled in SAP HANA with SAP HANA tools. You can thus access BW data via SQL front ends. All applications that can read SAP HANA views can process the data, more details can be found in the SAP online documentation: Generating SAP HANA Views from the BW System.

From a technical point of view it is important to stress the fact that a query which is executed on the SAP HANA view retrieves the data directly from SAP HANA, without accessing the BW system at all.

The following objects are supported:

• SAP HANA-optimized InfoCubes
• DataStore objects
• InfoObjects
• Queries
• CompositeProviders
• local CompositeProviders in the BW Workspace and queries.

Transaction RS2HANA_ADMIN enables you to manage SAP HANA views from BW objects. SAP Hana Views are stored by default in the SAP Hana Content Package 'system-local.bw.bw2hana'.

SAP Online Documentation

• BW75: Generating SAP HANA Views from the BW System
• BW/4HANA: Generating SAP Hana Views from the BW System

Transactions and Reports

• RS2HANA_CHECK: Checks all of the required prerequisites for a successful replication of the BW authorizations
• RS2HANA_ADMIN: Displays an overview of all of the BW objects with an external SAP HANA view. Allows you to manage the views from BW Objects. Check and repair the HANA views themselves in transaction RS2HANA_ADMIN.
• RS2HANA_GEN (same as SE38 report RS2HANA_AUTH_RUN) Replicate BW Analysis Authorizations to Hana. Complete clean-up and re-build of generated HANA privileges.
• RS2HANA_VIEW: Make central settings in relation to the external SAP HANA view.SAP HANA authorizations are assigned to one user. You can define how this user is generated here.  

Examples

• Simple Example / delivers also some technical background information
• Example where ABAP View(DDIC) is based on HMOD
• HCPR
  • External Hana View and Time-Dependent Master Data
• Pruning
  • External Hana View is based on HCPR with Semantic Partitions

  • BW external HANA View and NLS

• ADSO
  • External Hana View based on ADSO with Non-Cumulative Key Figures
• Queries
  
  • Simple query with variable, RKF and CKF: Example I
  • External Hana view delivers key figure value in external format: Example II
  • Query with unit conversion: Example III
  • Queries containing non-cumulative key figures: Example IV
  • Query with Hierarchy
• InfoObjects

SAP Components

• BW-WHM-MTD-HMOD
• BW-WHM-MTD-HMOD-AUT(Generating SAP Hana Analysis Authorizations)
• BW4-ME-HMOD
• BW4-ME-HMOD-AUT(Generating SAP Hana Analysis Authorizations)

Topics

• Generating SAP Hana Analysis Authorizations (BW2HANA Authorization Generation)
• Transport of External SAP HANA Views
• External Hana View: Language Dependent Texts for Fields

Documentation

SAP Online Documentation

• BW75: Generating SAP HANA Views from the BW System
• BW/4HANA: Generating SAP Hana Views from the BW System
• Authorizations for Generating SAP HANA Views

SDN Article

SAP First Guidance – SAP BW 7.4 on SAP HANA - SAP HANA View Generation

WIKI Page

BW External HANA View

SAP Consulting Notes

• 2317197 -External SAP HANA View: Frequently asked questions, feature availability

• 2080686 -External SAP HANA view based on Query: Differences between BW query and External View

• 2138518 -External SAP HANA view for Query: Division by zero

• 2723506 -External SAP HANA SQL View with SAP BW/4HANA 2.0
• 2756480 -HANA Privilege Generation- General Solutions and Facts
• 2252122 -Technical Customizing of HANA View Generation (RS2HANA_VIEW_SET)
• 2211315 - External SAP HANA view: navigation attribute returns no values
• 2192270 - External SAP HANA view and ambiguous join (RSQBW143)
• 2203131 -BW Near-Line Storage with HANA Smart Data Access: Turn off read access using the "HANA-API" with HANA column views
• 2226839 - External SAP HANA view for CompositeProvider: Performance
• 2190204 - External SAP HANA view and Pruning
• 2177718 - External SAP HANA view, performance: enforce SQL engine execution
• 2032830 - External SAP HANA view: Inventory key figures (non-cumulative key figures)
• 2032797 - External SAP HANA view: Include NLS data with HANA Smart Data Access and SAP IQ