SAP ABAP Class /IWHDB/CL_HAI_RT_MD_READER (Retrieves data from HANA database)

Hierarchy

☛ SAP_GWFND (Software Component) SAP Gateway Foundation
   ⤷ OPU-BSE-SDE (Application Component) Gateway SAP Data Enablement
     ⤷ /IWHDB/HAI_RT (Package) Gateway - HANA Analytics Integration - Runtime

Properties

Class	/IWHDB/CL_HAI_RT_MD_READER
Short Description	Retrieves data from HANA database
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	/IWHDB/HAI_RT	Gateway - HANA Analytics Integration - Runtime
Created	20120223	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	ADBC	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class /IWHDB/CL_HAI_RT_MD_READER has no interface implemented.

Friends

Class /IWHDB/CL_HAI_RT_MD_READER has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	MO_SQL_WRAPPER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	/IWHDB/CL_HAI_RT_SQL_WRAPPER		Wrapper for HANA (ADBC) SQL Statements	20120223
2	MT_VIEWS	Instance attribute	Private	☐	Type reference (TYPE)	/IWHDB/T_HAI_RT_VIEW		View Infomation	20120228
3	MT_VIEW_PROPS	Instance attribute	Private	☐	Type reference (TYPE)	/IWHDB/T_HAI_RT_VCOL_TYPES		HANA View Properties	20120228

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_VIEW_PROPERTY	Instance method	Private	Method	adds a view column to property maps	20120223
2	CLOSE_DB_CONNECTION	Instance method	Public	Method	Close Database Connection	20120430
3	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20120223
4	GET_SQL_STMNT_READ_CUBES	Instance method	Private	Method	Get SQL statement to read cubes metadata	20120321
5	GET_SQL_STMNT_READ_DB_TBL_TY	Instance method	Private	Method	Get SQL statement to read db table types	20120321
6	GET_SQL_STMNT_READ_DB_VIEW_TY	Instance method	Private	Method	Get SQL statement to read db view types	20120321
7	GET_SQL_STMNT_READ_DIMENSIONS	Instance method	Private	Method	Get SQL statement to read dimensions metadata	20120321
8	GET_SQL_STMNT_READ_VIEW_PROP	Instance method	Private	Method	Get SQL statement to read view properties	20120321
9	GET_VIEW	Instance method	Public	Method	Gets the actual table where view data is persisted on HANA	20120223
10	GET_VIEWS	Instance method	Public	Method	Gets views	20120223
11	GET_VIEW_PROPERTIES	Instance method	Public	Method	Reads properties related to HANA infomation models (views)	20120223
12	HANDLE_SQL_EXCEPTION	Instance method	Private	Method	Log and ... SQL Exception	20120223
13	LOAD_METADATA_FROM_HDB	Instance method	Public	Method	Loads view-related metadata from HANA	20120223
14	READ_CUBES	Instance method	Private	Method	Read cube information	20120320
15	READ_DB_TYPES_FOR_TABLE	Instance method	Private	Method	Reads the db-types of table columns from HANA	20120223
16	READ_DB_TYPES_FOR_VIEW	Instance method	Private	Method	Reads the db-types of view columns from HANA	20120223
17	READ_DIMENSIONS	Instance method	Private	Method	Read dimension information	20120321
18	READ_VIEW_PROPERTIES	Instance method	Private	Method	Reads properties related to HANA infomation models (views)	20120223
19	SET_COLUMN_ABAP_TYPE	Instance method	Private	Method		20120620

Events

Class /IWHDB/CL_HAI_RT_MD_READER has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TS_ATTR	Public	See coding			20120223	BEGIN OF ts_attr, name TYPE string, value TYPE string, END OF ts_attr
2	TS_ELEM	Public	See coding			20120223	BEGIN OF ts_elem, name TYPE string, value TYPE string, level TYPE i, t_attr TYPE tt_attr, END OF ts_elem
3	TT_ATTR	Public	See coding			20120223	tt_attr TYPE STANDARD TABLE OF ts_attr WITH DEFAULT KEY
4	TT_ELEM	Public	See coding			20120223	tt_elem TYPE STANDARD TABLE OF ts_elem WITH DEFAULT KEY

Method Signatures

Method ADD_VIEW_PROPERTY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_BIMC_PROPERTY	Call by reference	☐	Type reference (TYPE)	/IWHDB/S_HAI_RT_BIMC_PROPERTY		BIMC Property from HANA	20120228
2	Importing	IV_COLTYPE	Call by reference	☐	Type reference (TYPE)	/IWHDB/S_HAI_RT_VCOL_TYPES		Column DB types of HANA views	20120228

Method ADD_VIEW_PROPERTY on class /IWHDB/CL_HAI_RT_MD_READER has no exception.

Method CLOSE_DB_CONNECTION Signature

Method CLOSE_DB_CONNECTION on class /IWHDB/CL_HAI_RT_MD_READER has no parameter.

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120430

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CON_NAME	Call by reference	☐	Type reference (TYPE)	/IWHDB/DEFI_HANA_DB_CON		Database connection name - Points to HANA system	20120228

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120228

Method GET_SQL_STMNT_READ_CUBES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_ADBC_STMNT_PARAM	Call by reference	☐	Type reference (TYPE)	/IWHDB/CL_HAI_RT_SQL_WRAPPER=>TT_ADBC_STMNT_PARAM			20131107
2	Exporting	EV_ADBC_STMNT	Call by reference	☐	Type reference (TYPE)	STRING			20131107
3	Importing	IV_CATALOG_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120321
4	Importing	IV_CUBE_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120321

Method GET_SQL_STMNT_READ_CUBES on class /IWHDB/CL_HAI_RT_MD_READER has no exception.

Method GET_SQL_STMNT_READ_DB_TBL_TY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_ADBC_STMNT_PARAM	Call by reference	☐	Type reference (TYPE)	/IWHDB/CL_HAI_RT_SQL_WRAPPER=>TT_ADBC_STMNT_PARAM			20131107
2	Exporting	EV_ADBC_STMNT	Call by reference	☐	Type reference (TYPE)	STRING			20131107
3	Importing	IV_SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120321
4	Importing	IV_TABLE_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120321

Method GET_SQL_STMNT_READ_DB_TBL_TY on class /IWHDB/CL_HAI_RT_MD_READER has no exception.

Method GET_SQL_STMNT_READ_DB_VIEW_TY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_ADBC_STMNT_PARAM	Call by reference	☐	Type reference (TYPE)	/IWHDB/CL_HAI_RT_SQL_WRAPPER=>TT_ADBC_STMNT_PARAM			20131107
2	Exporting	EV_ADBC_STMNT	Call by reference	☐	Type reference (TYPE)	STRING			20131107
3	Importing	IV_CATALOG_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120321
4	Importing	IV_VIEW_NAME	Call by reference	☑	Type reference (TYPE)	STRING			20120321

Method GET_SQL_STMNT_READ_DB_VIEW_TY on class /IWHDB/CL_HAI_RT_MD_READER has no exception.

Method GET_SQL_STMNT_READ_DIMENSIONS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_ADBC_STMNT_PARAM	Call by reference	☐	Type reference (TYPE)	/IWHDB/CL_HAI_RT_SQL_WRAPPER=>TT_ADBC_STMNT_PARAM			20131107
2	Exporting	EV_ADBC_STMNT	Call by reference	☐	Type reference (TYPE)	STRING			20131107
3	Importing	IV_CATALOG_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120321
4	Importing	IV_CUBE_NAME	Call by reference	☑	Type reference (TYPE)	STRING			20120321
5	Importing	IV_VIEW_NAME	Call by reference	☑	Type reference (TYPE)	STRING			20120321

Method GET_SQL_STMNT_READ_DIMENSIONS on class /IWHDB/CL_HAI_RT_MD_READER has no exception.

Method GET_SQL_STMNT_READ_VIEW_PROP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_ADBC_STMNT_PARAM	Call by reference	☐	Type reference (TYPE)	/IWHDB/CL_HAI_RT_SQL_WRAPPER=>TT_ADBC_STMNT_PARAM			20131107
2	Exporting	EV_ADBC_STMNT	Call by reference	☐	Type reference (TYPE)	STRING			20131107
3	Importing	IV_CATALOG_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120321
4	Importing	IV_VIEW_NAME	Call by reference	☑	Type reference (TYPE)	STRING			20120321

Method GET_SQL_STMNT_READ_VIEW_PROP on class /IWHDB/CL_HAI_RT_MD_READER has no exception.

Method GET_VIEW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CATALOG_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120228
2	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120228
3	Returning	RS_VIEW	Value transfer	☐	Type reference (TYPE)	/IWHDB/S_HAI_RT_VIEW		HANA View	20120228

Method GET_VIEW on class /IWHDB/CL_HAI_RT_MD_READER has no exception.

Method GET_VIEWS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RT_VIEWS	Value transfer	☐	Type reference (TYPE)	/IWHDB/T_HAI_RT_VIEW		View Infomation	20120228

Method GET_VIEWS on class /IWHDB/CL_HAI_RT_MD_READER has no exception.

Method GET_VIEW_PROPERTIES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CATALOG_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120228
2	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120228
3	Returning	RT_PROPERTIES	Value transfer	☐	Type reference (TYPE)	/IWHDB/T_HAI_RT_VCOL_TYPES		HANA View Column Types	20120228

Method GET_VIEW_PROPERTIES on class /IWHDB/CL_HAI_RT_MD_READER has no exception.

Method HANDLE_SQL_EXCEPTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_SQL_EXCEPTION	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20120321

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120228

Method LOAD_METADATA_FROM_HDB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CATALOG_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120223
2	Importing	IV_VIEW_NAME	Call by reference	☑	Type reference (TYPE)	STRING			20120223

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120228

Method READ_CUBES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CATALOG_NAME	Call by reference	☑	Type reference (TYPE)	STRING			20120320
2	Importing	IV_CUBE_NAME	Call by reference	☑	Type reference (TYPE)	STRING			20120320
3	Returning	RT_CUBES	Value transfer	☐	Type reference (TYPE)	/IWHDB/T_HAI_RT_VIEW		View Infomation	20120320

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120320

Method READ_DB_TYPES_FOR_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120228
2	Importing	IV_TABLE_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120228
3	Returning	RT_COL_TYPES	Value transfer	☐	Type reference (TYPE)	/IWHDB/T_HAI_RT_TCOL_TYPES		HANA table column types	20120228

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120228

Method READ_DB_TYPES_FOR_VIEW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CATALOG_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120228
2	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120228
3	Returning	RT_COL_TYPES	Value transfer	☐	Type reference (TYPE)	/IWHDB/T_HAI_RT_VCOL_TYPES		HANA View Column Types	20120228

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120228

Method READ_DIMENSIONS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CATALOG_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120321
2	Importing	IV_CUBE_NAME	Call by reference	☑	Type reference (TYPE)	STRING			20120321
3	Importing	IV_VIEW_NAME	Call by reference	☑	Type reference (TYPE)	STRING			20120321
4	Returning	RT_DIMENSIONS	Value transfer	☐	Type reference (TYPE)	/IWHDB/T_HAI_RT_VIEW		View Infomation	20120321

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120321

Method READ_VIEW_PROPERTIES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CATALOG_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120228
2	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	STRING			20120228

#	Exception	Resumable	Description	Created on
1	/IWBEP/CX_MGW_TECH_EXCEPTION	☐	Technical Exception	20120228

Method SET_COLUMN_ABAP_TYPE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CS_COLUMN_DESCR	Call by reference	☐	Type reference (TYPE)	/IWHDB/S_HAI_RT_VCOL_TYPES		Column DB types of HANA views	20120620

Method SET_COLUMN_ABAP_TYPE on class /IWHDB/CL_HAI_RT_MD_READER has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	100