To extract data from a HANA view to Foundry, the HANA view needs to be published as an external view. This document describes the steps for doing that.
Note that these tools are available from SAP development tools ↗.
An external view is a special view in the ABAP Dictionary that defines an SAP HANA view in ABAP programs.
External views can only be created using the ABAP Development Tools (ADT) and only if the current database is an SAP HANA database.
When an external view is activated, an alias with the name of the view is created on the SAP HANA database that points to the SAP HANA view. The names of the view fields of the external view can be defined differently from the names of the view fields of the SAP HANA view. This performs a mapping of HANA-specific data types to the predefined types in ABAP Dictionary. The following table lists the currently supported HANA-specific data types and indicates which ABAP Dictionary types they are mapped to by default.
| HANA Type | Meaning | Type in ABAP Dictionary |
|---|---|---|
SMALLINT | 2-byte integer | INT2 |
INTEGER | 4-byte integer | INT4 |
BIGINT | 8-byte integer | INT8 |
DECIMAL | Packed number | DEC |
SMALLDECIMAL | Packed number | DEC |
FLOAT | Binary floating point number | FLTP |
NVARCHAR | Unicode character string | CHAR |
VARBINARY | Byte string | RAW |
BLOB | Byte string | RAWSTRING |
NCLOB | Unicode character string | STRING |
External views can be displayed using the ABAP Dictionary tool in the SAP GUI-based ABAP Workbench, but not edited.
Foundry can ingest the external views that you create via a sync.
HANA views are not yet part of the list of supported SAP Object Types in the sync UI. To configure them, navigate to the Advanced view and define your sync as follows:
Copied!1 2 3type: magritte-sap-source-adapter sapType: hanaview obj: <NAME_OF_VIEW>