ARTICLE
ABAP and SAP HANA
SAP HANA is an appliance, independent from AS
ABAP , used for high-performance analysis of large volumes of data.
SAP HANA works with the SAP HANA database
, which is based on in-memory technology .
AS ABAP can access the SAP HANA database of a standalone SAP HANA
appliance using a secondary database
connection and, for example, ADBC .
Various tools and accelerators are available for replicating data from
the database of an AS ABAP to the SAP HANA database, to enable
high-performance analyses.
Furthermore, an SAP HANA database can
be implemented as the central database of an AS ABAP . In this
case, the AS ABAP database tables managed by ABAP Dictionary are
saved in the database schema SAPsid . sid stands for the
system ID (name of the AS ABAP ). As usual, database tables of
this type can be accessed using Open SQL or Native SQL (
ADBC ). With respect to ABAP programs, SAP HANA databases behave
in this case in the same way as a regular relational database. All HANA-
specific functions are wrapped by the
database interface and access is
optimized to the greatest extent possible.
To exploit the in-memory properties of the SAP HANA database in
an optimum way, however, application logic must be transferred in a
suitable form from the application server to the SAP HANA database. This
can be done, for example, using suitably programmed
joins , but these Open SQL -methods
are often not enough. Instead, parts of the application logic must
itself be programmed on the SAP HANA database in SAP HANA Studio. The
following methods are available, with the most complex listed first:
Modeling of SAP HANA views transformed
internally to SQL or SQLScript
.
Attribute views - Selected columns of joins between tables.
Attribute views are created in a graphical tool and transformed
internally to SQL .
Analytic views - A combination of table data and aggregated data
from one or more tables. Analytic views are created in a
graphical tool and transformed internally to SQL .
Calculation views - A combination of table data or data from
other views in which complex conditions and calculations are possible.
Calculation views are either created in a graphical tool and
transformed internally to SQLScript or can be programmed using
SQLScript .
Programming of dedicated database
procedures in SQLScript . This
can be done in HANA Studio or dynamically using
Native SQL (
ADBC ) methods.
The following sections demonstrate how the entities of the SAP HANA
database created in HANA Studio (or in Native SQL ) can be
accessed from ABAP programs:
Access to HANA Views Using External
Views
Calling SQL Script
Note
SAP HANA views cannot be created using Native SQL , since
the description language is XML -based, not SQL -based.
Documentation extract taken from SAP system, � Copyright SAP AG. All rights reserved