SAP NetWeaver AS ABAP Release 751, ©Copyright 2017 SAP AG. All rights reserved.  

ABAP - Keyword Documentation →  ABAP - Reference →  Processing External Data →  ABAP Database Accesses →  ABAP and SAP HANA → 

External Views for SAP HANA Views

Open SQL provides access to all database tables and views whose structures are defined as repository objects in ABAP Dictionary. An SAP HANA View (Attribute View, Analytic View, Calculation View), on the other hand, is an entity of the SAP HANA database and is defined here using SAP HANA Studio. This uses HANA-specific data types and different naming conventions to ABAP Dictionary also apply. This means that direct access to an SAP HANA view using Open SQL is not possible.

To access an SAP HANA view directly from ABAP programs, views called external views are available in ABAP Dictionary. An external view is a special view in ABAP Dictionary that functions as a proxy for an SAP HANA view and which can be accessed using SAP HANA and Open SQL.

Notes

• The following restrictions currently apply to the use of external views in ABAP programs:

• The structure of analytic views do not allow them to be read using SELECT *. The same basic rules apply to the statement SELECT in Open SQL as when using the HANA-SQL statement SELECT, with individual columns and the addition GROUP BY needing to be specified. If SELECT * is used, a runtime error occurs.

• Calculation views with parameters can be access only if a default value is defined for each parameter. If not, reads are canceled and produce a runtime error.

• External views should only be used in those cases that are not covered by ABAP CDS or AMDP.

This translation does not reflect the current version of the documentation.