SAP ABAP Class CL_GRFN_HANA_UTIL (Hana utility)

Hierarchy

☛ GRCFND_A (Software Component) GRC Foundation ABAP
   ⤷ GRC-RM (Application Component) GRC Risk Management
     ⤷ GRFN_IE_LEGACY (Package) GRC Integration Engine: 3.0 Legacy Objects

Properties

Class	CL_GRFN_HANA_UTIL
Short Description	Hana utility
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	GRFN_IE_LEGACY	GRC Integration Engine: 3.0 Legacy Objects
Created	20121011	SAP
Last change	20141106
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)
2	CL_GRFN_CCI_AM_HANA	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)

Interfaces

Class CL_GRFN_HANA_UTIL has no interface implemented.

Friends

Class CL_GRFN_HANA_UTIL has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	GV_TABLE_TYPE_VIEW	Constant	Public	☐	Type reference (TYPE)	STRING	'V'		20121011
2	MO_CONNECTION	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Database Connection	20121011
3	MO_METADATA	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_METADATA_HDB		Implements CL_SQL_METADATA for SAPDB	20121011
4	MT_VIEW_COLUMN	Instance attribute	Private	☐	Type reference (TYPE)	T_COLUMNS			20121011
5	MV_CONNECTOR	Instance attribute	Private	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20121011
6	MV_SCHEMA	Instance attribute	Private	☐	Type reference (TYPE)	ADBC_NAME			20121011

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	BUILD_PARAMETER_CLAUSE	Instance method	Public	Method	Build parameter clause	20121011
2	BUILD_QUERY_BY_FIELD_LIST	Instance method	Public	Method	Build query by field list	20121011
3	BUILD_QUERY_BY_OUTPUT	Instance method	Public	Method	Build query by output structure	20121011
4	BUILD_SQL_STATEMENT	Instance method	Public	Method	Build the sql statement for execution	20121011
5	BUILD_WHERE_CLAUSE	Instance method	Public	Method	Build where clause	20121011
6	CLOSE_CONNECTION	Instance method	Public	Method	Close connection	20121106
7	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20121011
8	EXECUTE_QUERY	Instance method	Public	Method	Execute query	20121011
9	EXECUTE_SQL_STATEMENT	Instance method	Public	Method	Execute the sql statement	20121011
10	GET_ALL_VIEWS	Instance method	Public	Method	Get all views	20121011
11	GET_CALC_VIEWS	Instance method	Public	Method	Get calculation views	20121011
12	GET_CONNECTION	Instance method	Public	Method	Get connection object	20121106
13	GET_METADATA	Instance method	Public	Method	Get Metadata object	20121106
14	GET_VIEW_COLUMNS	Instance method	Public	Method	Get view columns	20121011
15	INIT_SCHEMA	Instance method	Private	Method	Init schema	20121011

Events

Class CL_GRFN_HANA_UTIL has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	S_COLUMNS	Public	See coding			20121107	BEGIN OF s_columns, view_name TYPE text100, columns TYPE t_column_descr, END OF s_columns
2	S_COLUMN_DESCR	Public	See coding			20121107	BEGIN OF s_column_descr, column_name TYPE dbobject_d, position TYPE int4, data_type TYPE string, data_length TYPE int4, data_precesision TYPE int4, data_scale TYPE int4, data_nullable TYPE char10, description TYPE string, unique_column_name TYPE string, custom_flag TYPE int4, property_caption TYPE string, END OF s_column_descr
3	T_COLUMNS	Public	See coding			20121107	t_columns TYPE STANDARD TABLE OF s_columns WITH KEY primary_key COMPONENTS view_name
4	T_COLUMN_DESCR	Public	See coding			20121107	t_column_descr TYPE STANDARD TABLE OF s_column_descr WITH KEY column_name

Method Signatures

Method BUILD_PARAMETER_CLAUSE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SELECTION_PARAMETER	Call by reference	☐	Type reference (TYPE)	GRFN_T_QUERY_SELECTION		Query selection	20121011
2	Returning	RV_PARAMETER_CLAUSE	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20121011

Method BUILD_PARAMETER_CLAUSE on class CL_GRFN_HANA_UTIL has no exception.

Method BUILD_QUERY_BY_FIELD_LIST Signature

Method BUILD_QUERY_BY_FIELD_LIST on class CL_GRFN_HANA_UTIL has no parameter.
Method BUILD_QUERY_BY_FIELD_LIST on class CL_GRFN_HANA_UTIL has no exception.

Method BUILD_QUERY_BY_OUTPUT Signature

Method BUILD_QUERY_BY_OUTPUT on class CL_GRFN_HANA_UTIL has no parameter.
Method BUILD_QUERY_BY_OUTPUT on class CL_GRFN_HANA_UTIL has no exception.

Method BUILD_SQL_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_MAXROWS	Value transfer	☐	Type reference (TYPE)	GRFN_MAXROWS		Job step max rows	20121011
2	Importing	IV_PARAMETER_CLAUSE	Value transfer	☑	Type reference (TYPE)	GRFN_STRING		Parameter clause	20121011
3	Importing	IV_RESULT_SET	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		Result set	20121011
4	Importing	IV_SCHEMANAME	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		Schema name	20121106
5	Importing	IV_VIEW_NAME	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		view name	20121011
6	Importing	IV_WHERE_CLAUSE	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		Where clause	20121011
7	Returning	RV_SQL	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		SQL String	20121011

Method BUILD_SQL_STATEMENT on class CL_GRFN_HANA_UTIL has no exception.

Method BUILD_WHERE_CLAUSE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SELECTION	Call by reference	☐	Type reference (TYPE)	GRFN_T_QUERY_SELECTION		Query selection	20121011
2	Returning	RV_WHERE_CLAUSE	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20121011

Method BUILD_WHERE_CLAUSE on class CL_GRFN_HANA_UTIL has no exception.

Method CLOSE_CONNECTION Signature

Method CLOSE_CONNECTION on class CL_GRFN_HANA_UTIL has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20121106

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CONNECTOR	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20121011
2	Importing	IV_SCHEMA	Call by reference	☑	Type reference (TYPE)	ADBC_NAME			20121011

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20121011

Method EXECUTE_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_RESULT	Call by reference	☐	Type reference (TYPE)	TABLE			20121011
2	Exporting	EV_ROW_COUNT	Call by reference	☐	Type reference (TYPE)	I			20121011
3	Importing	IV_QUERY_STRING	Call by reference	☐	Type reference (TYPE)	STRING			20121011

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20121011

Method EXECUTE_SQL_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EO_DATA_TYPE	Call by reference	☐	Object reference (TYPE REF TO)	CL_ABAP_TABLEDESCR		Runtime Type Services	20121011
2	Exporting	ER_DATA	Call by reference	☐	Object reference (TYPE REF TO)	DATA			20121011
3	Exporting	ET_METADATA	Call by reference	☐	Type reference (TYPE)	ADBC_RS_METADATA_DESCR_TAB			20121011
4	Exporting	ET_QUERYPARAM_OUT	Call by reference	☐	Type reference (TYPE)	GRFN_T_QUERYPARAM_OUT		Query Output Parameter	20121011
5	Exporting	EV_TOTAL_ROWS	Call by reference	☐	Type reference (TYPE)	INT4		Natural number	20121011
6	Importing	IV_CONNECTOR	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		Connector	20121011
7	Importing	IV_SCHEMANAME	Value transfer	☑	Type reference (TYPE)	GRFN_STRING		Schema name	20121106
8	Importing	IV_SQL	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		SQL string	20121011
9	Importing	IV_VIEW_NAME	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		View name	20121011

#	Exception	Resumable	Description	Created on
1	CX_GRFN_EXCEPTION	☐	Generic GRC API exception	20121011
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20121011

Method GET_ALL_VIEWS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RT_VIEW	Value transfer	☐	Type reference (TYPE)	ADBC_TABLE_DESCR_TAB			20121011

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20121011

Method GET_CALC_VIEWS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_QUERYLIST	Call by reference	☐	Type reference (TYPE)	GRFN_T_QUERYLIST		Query List	20121011
2	Exporting	EV_ROW_COUNT	Call by reference	☐	Type reference (TYPE)	I			20121011
3	Importing	IT_QRY_PARAS	Call by reference	☐	Type reference (TYPE)	GRFN_T_EO_QRY_PARA		EO Query Paramaters	20121011

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20121011

Method GET_CONNECTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RO_CONNECTION	Value transfer	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Database Connection	20121106

Method GET_CONNECTION on class CL_GRFN_HANA_UTIL has no exception.

Method GET_METADATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RO_METADATA	Value transfer	☐	Object reference (TYPE REF TO)	CL_SQL_METADATA_HDB		Implements CL_SQL_METADATA for SAPDB	20121106

Method GET_METADATA on class CL_GRFN_HANA_UTIL has no exception.

Method GET_VIEW_COLUMNS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_COLUMN	Call by reference	☐	Type reference (TYPE)	T_COLUMN_DESCR			20121011
2	Importing	IV_SCHEMANAME	Value transfer	☑	Type reference (TYPE)	GRFN_STRING		Schema name	20121106
3	Importing	IV_VIEW_NAME	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		View name	20121011

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20121011

Method INIT_SCHEMA Signature

Method INIT_SCHEMA on class CL_GRFN_HANA_UTIL has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20121011

History

Last changed by/on	SAP	20141106
SAP Release Created in	V1100