SAP ABAP Class CL_GRFN_CCI_AM_HANA (AM CCI Proxy to HANA)

Hierarchy

☛ GRCFND_A (Software Component) GRC Foundation ABAP
   ⤷ GRC (Application Component) Governance, Risk and Compliance
     ⤷ GRFN_INTEGRATION_ENGINE (Package) GRC Integration Engine

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_GRFN_CCI_AM	AM - Generic CCI	20120629

Properties

Class	CL_GRFN_CCI_AM_HANA
Short Description	AM CCI Proxy to HANA
Super Class	CL_GRFN_CCI_AM	AM - Generic CCI
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	GRFN_INTEGRATION_ENGINE	GRC Integration Engine
Created	20120629	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_CCI_AM_HANA has no interface implemented.

Friends

Class CL_GRFN_CCI_AM_HANA has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	HDBC_VIEWTYPE	Constant	Public	☐	See coding				20120702
2	MT_QUERYPARAM_IN	Instance attribute	Private	☐	Type reference (TYPE)	GRFN_T_QUERYPARAM_IN		Query Input Parameter	20120912
3	MT_QUERYPARAM_OUT	Instance attribute	Private	☐	Type reference (TYPE)	GRFN_T_QUERYPARAM_OUT		Query Output Parameter	20120912
4	MT_SELECTPARAM_IN	Instance attribute	Private	☐	Type reference (TYPE)	GRFN_T_SELECTPARAM_IN		Selection Input Parameter	20120912
5	MT_VARIABLE_IN	Instance attribute	Private	☐	Type reference (TYPE)	GRFN_T_VARIABLE_IN		Variable for Input	20120912
6	MT_VIEW_COLUMN	Instance attribute	Private	☐	Type reference (TYPE)	T_COLUMN			20120710

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	BUILD_OUTPUT_FIELDS	Instance method	Private	Method	Build output fields	20120705
2	BUILD_PARAMETER_CLAUSE	Instance method	Private	Method	Build parameter clause	20120815
3	BUILD_RESULT_SET	Instance method	Private	Method	Build result set string	20120704
4	BUILD_SQL_STATEMENT	Instance method	Private	Method	Build the sql statement for execution	20120705
5	BUILD_WHERE_CLAUSE	Instance method	Private	Method	Build where clause	20120704
6	EXECUTE_SQL_STATEMENT	Instance method	Private	Method	Execute the sql statement	20120705
7	GET_ALL_VIEWS	Instance method	Private	Method	Get all views	20120702
8	GET_CALC_VIEWS	Instance method	Private	Method	Get all calculated views	20120702
9	GET_PARAMETER_VALUE_SET	Static method	Public	Method	Get parameter value set	20120912
10	GET_STRUCT_REF	Instance method	Private	Method	Get Structure of SQL Result	20130218
11	GET_VIEW_COLUMNS	Instance method	Private	Method	Get view columns	20120710
12	GET_VIEW_NAME	Instance method	Private	Method	Get the schema and view name	20120705
13	GET_VIEW_PARAMETERS	Instance method	Private	Method	Get view parameters	20120801
14	GET_VIEW_VARIABLES	Instance method	Private	Method	Get view variables	20120905

Events

Class CL_GRFN_CCI_AM_HANA has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	HDB_S_COLUM_DESCR	Public	See coding			20120704	BEGIN OF hdb_s_colum_descr, column_name TYPE dbobject_d, hdb_position TYPE int4, grc_position TYPE int4, hdb_type TYPE datatype_d, hdb_length TYPE int4, hdb_decimals TYPE int4, grc_type TYPE datatype_d, grc_length TYPE int4, grc_decimals TYPE int4, END OF hdb_s_colum_descr
2	HDB_T_COLUM_DESCR	Public	See coding			20120704	hdb_t_colum_descr TYPE STANDARD TABLE OF hdb_s_colum_descr
3	S_COLUMN	Public	See coding			20120710	BEGIN OF s_column, view_name TYPE string, columns TYPE adbc_tabcol_descr_tab, END OF s_column
4	S_COLUMN_DESCR	Public	See coding			20121025	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, * ddic_type TYPE datatype_d, * ddic_length TYPE int4, * ddic_decimals TYPE int4, description TYPE string, unique_column_name TYPE string, custom_flag type int4, END OF s_column_descr
5	S_PARAMETER	Public	See coding			20120801	BEGIN OF s_parameter, procedure_name TYPE string, parameter_name TYPE string, parameter_type TYPE string, position TYPE i, data_type TYPE adbc_name, data_length TYPE i, data_scale TYPE i, nullable TYPE char10, has_default_value TYPE char10, view_name TYPE string, mandatory TYPE i, default_value TYPE string, description TYPE string, END OF s_parameter
6	S_PARAMETER_VALUE_SET	Public	See coding			20120912	BEGIN OF s_parameter_value_set, parameter_name TYPE string, position TYPE i, value TYPE string, description TYPE string, END OF s_parameter_value_set
7	S_VARIABLE	Public	See coding			20120905	BEGIN OF s_variable, view_name TYPE string, variable_name TYPE string, data_type TYPE adbc_name, data_length TYPE i, data_scale TYPE i, value_attribute TYPE char10, selection_type TYPE char10, multiline TYPE char10, nullable TYPE char10, default_value TYPE string, description TYPE string, END OF s_variable
8	S_VIEW	Public	See coding			20120702	BEGIN OF s_view, schema_name TYPE string, view_name TYPE string, view_type TYPE string, comments TYPE string, END OF s_view
9	T_COLUMN	Public	See coding			20120710	t_column TYPE STANDARD TABLE OF s_column WITH KEY primary_key COMPONENTS view_name
10	T_COLUMN_DESCR	Public	See coding			20121025	t_column_descr TYPE STANDARD TABLE OF s_column_descr
11	T_PARAMETER	Public	See coding			20120801	t_parameter TYPE STANDARD TABLE OF s_parameter WITH KEY parameter_name
12	T_PARAMETER_VALUE_SET	Public	See coding			20120912	t_parameter_value_set TYPE STANDARD TABLE OF s_parameter_value_set WITH KEY parameter_name position
13	T_VARIABLE	Public	See coding			20120905	t_variable TYPE STANDARD TABLE OF s_variable WITH KEY variable_name
14	T_VIEW	Public	See coding			20120702	t_view TYPE STANDARD TABLE OF s_view

Method Signatures

Method BUILD_OUTPUT_FIELDS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_FIELD	Call by reference	☐	Type reference (TYPE)	GRFN_T_EXPLIST_FIELD		Exception List Output Field	20120705
2	Importing	IS_BR	Call by reference	☐	Type reference (TYPE)	GRFN_S_API_BR		Business rule	20120705
3	Importing	IS_EO	Call by reference	☐	Type reference (TYPE)	GRFN_S_API_EO		Enterprise Object	20120705

Method BUILD_OUTPUT_FIELDS on class CL_GRFN_CCI_AM_HANA has no exception.

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			20120815
2	Returning	RV_PARAMETER_CLAUSE	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120815

Method BUILD_PARAMETER_CLAUSE on class CL_GRFN_CCI_AM_HANA has no exception.

Method BUILD_RESULT_SET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_FIELD	Call by reference	☐	Type reference (TYPE)	GRFN_T_EXPLIST_FIELD		Exception List Output Field	20120704
2	Returning	RV_RESULT_SET	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120704

Method BUILD_RESULT_SET on class CL_GRFN_CCI_AM_HANA 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	Call by reference	☑	Type reference (TYPE)	GRFN_MAXROWS		Natural number	20120705
2	Importing	IV_PARAMETER_CLAUSE	Call by reference	☑	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120815
3	Importing	IV_RESULT_SET	Call by reference	☑	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120705
4	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120705
5	Importing	IV_WHERE_CLAUSE	Call by reference	☑	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120705
6	Returning	RV_SQL	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120705

Method BUILD_SQL_STATEMENT on class CL_GRFN_CCI_AM_HANA 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_QRY_PARAS	Call by reference	☑	Type reference (TYPE)	GRFN_T_EO_QRY_PARA		EO Query Paramaters	20120926
2	Importing	IT_SELECTION	Call by reference	☐	Type reference (TYPE)	GRFN_T_QUERY_SELECTION			20120704
3	Importing	IV_CONNECTOR	Call by reference	☑	Type reference (TYPE)	STRING			20120926
4	Returning	RV_WHERE_CLAUSE	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120704

#	Exception	Resumable	Description	Created on
1	CX_GRFN_EXCEPTION	☐	Generic GRC API exception	20120926

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	20120705
2	Exporting	ER_DATA	Call by reference	☐	Object reference (TYPE REF TO)	DATA			20120705
3	Exporting	ET_QUERYPARAM_OUT	Call by reference	☐	Type reference (TYPE)	GRFN_T_QUERYPARAM_OUT		Query Output Parameter	20120705
4	Exporting	EV_TOTAL_ROWS	Call by reference	☐	Type reference (TYPE)	INT4		Natural number	20120705
5	Importing	IT_QRY_PARAS	Call by reference	☐	Type reference (TYPE)	GRFN_T_EO_QRY_PARA		EO Query Paramaters	20121018
6	Importing	IV_CONNECTOR	Call by reference	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120705
7	Importing	IV_SQL	Call by reference	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120705
8	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120710

#	Exception	Resumable	Description	Created on
1	CX_GRFN_EXCEPTION	☐	Generic GRC API exception	20120705

Method GET_ALL_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	20120702
2	Importing	IT_QRY_PARAS	Call by reference	☐	Type reference (TYPE)	GRFN_T_EO_QRY_PARA		EO Query Paramaters	20120702
3	Importing	IV_CONNECTOR	Call by reference	☐	Type reference (TYPE)	STRING			20120702

#	Exception	Resumable	Description	Created on
1	CX_GRFN_EXCEPTION	☐	Generic GRC API exception	20120702

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	20120702
2	Importing	IT_QRY_PARAS	Call by reference	☐	Type reference (TYPE)	GRFN_T_EO_QRY_PARA		EO Query Paramaters	20120702
3	Importing	IV_CONNECTOR	Call by reference	☐	Type reference (TYPE)	STRING			20120702

#	Exception	Resumable	Description	Created on
1	CX_GRFN_EXCEPTION	☐	Generic GRC API exception	20120702

Method GET_PARAMETER_VALUE_SET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_VALUE_SET	Call by reference	☐	Type reference (TYPE)	GRFN_T_VALUE_LIST		Selection Input Variable	20120912
2	Importing	IV_CONNECTOR	Call by reference	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120912
3	Importing	IV_PARAMETER_NAME	Call by reference	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120912
4	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120912

#	Exception	Resumable	Description	Created on
1	CX_GRFN_EXCEPTION	☐	Generic GRC API exception	20120912

Method GET_STRUCT_REF Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_METADATA	Call by reference	☐	Type reference (TYPE)	ADBC_RS_METADATA_DESCR_TAB			20130218
2	Importing	P_STRICT	Call by reference	☑	Type reference (TYPE)	ABAP_BOOL			20130218
3	Importing	STRING_ONLY	Call by reference	☑	Type reference (TYPE)	ABAP_BOOL		Boolean Variable (X=True, -=False, Space=Unknown)	20130218
4	Returning	STRUCT_REF	Value transfer	☐	Object reference (TYPE REF TO)	DATA			20130218

Method GET_STRUCT_REF on class CL_GRFN_CCI_AM_HANA 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)	CL_GRFN_CCI_AM_HANA=>T_COLUMN_DESCR			20120710
2	Importing	IV_CONNECTOR	Call by reference	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120710
3	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120710

#	Exception	Resumable	Description	Created on
1	CX_GRFN_EXCEPTION	☐	Generic GRC API exception	20120710

Method GET_VIEW_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_QRY_PARAS	Call by reference	☐	Type reference (TYPE)	GRFN_T_EO_QRY_PARA		EO Query Paramaters	20120705
2	Returning	RV_NAME	Value transfer	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120705

Method GET_VIEW_NAME on class CL_GRFN_CCI_AM_HANA has no exception.

Method GET_VIEW_PARAMETERS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_PARAMETER	Call by reference	☐	Type reference (TYPE)	CL_GRFN_CCI_AM_HANA=>T_PARAMETER		Selection Input Parameter	20120801
2	Importing	IV_CONNECTOR	Call by reference	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120801
3	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120801

#	Exception	Resumable	Description	Created on
1	CX_GRFN_EXCEPTION	☐	Generic GRC API exception	20120801

Method GET_VIEW_VARIABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_VARIABLE	Call by reference	☐	Type reference (TYPE)	CL_GRFN_CCI_AM_HANA=>T_VARIABLE		Selection Input Variable	20120905
2	Importing	IV_CONNECTOR	Call by reference	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120905
3	Importing	IV_VIEW_NAME	Call by reference	☐	Type reference (TYPE)	GRFN_STRING		Long text for DataMart	20120905

#	Exception	Resumable	Description	Created on
1	CX_GRFN_EXCEPTION	☐	Generic GRC API exception	20120905

History

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