SAP ABAP Class CL_ADT_DP_OPEN_SQL_HANDLER (Handler class for Open SQL)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-AIE (Application Component) Installation and Infrastructure for ABAP Tools in Eclipse
     ⤷ SDP_ADT (Package) Development package

Properties

Class	CL_ADT_DP_OPEN_SQL_HANDLER
Short Description	Handler class for Open SQL
Super Class
Instantiability of a Class	0	Private
Final	☑

General Data

Message Class
Program status
Category	0
Package	SDP_ADT	Development package
Created	20130723	SAP
Last change	20140121	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	ABAP	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	SANA	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_ADT_DP_OPEN_SQL_HANDLER has no interface implemented.

Friends

Class CL_ADT_DP_OPEN_SQL_HANDLER has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	C_GEN_CODE_VARIABLES	Constant	Private	☐	See coding				20130726
2	C_SELECT_KEYWORD	Constant	Private	☐	See coding				20130724
3	MT_QUERY_TOKENS	Instance attribute	Private	☐	Type reference (TYPE)	SANA_STOKESX_TAB		Sequence of qualified tokens	20130725
4	MT_SELECT_FIELDS	Instance attribute	Private	☐	Type reference (TYPE)	TT_SELECT_FIELDS			20130726
5	MT_TABLE_DETAILS	Instance attribute	Private	☐	Type reference (TYPE)	TT_TABLE_DET			20130726
6	MT_TYPE_DATA_DECLARATION	Instance attribute	Private	☐	Type reference (TYPE)	STRINGTAB		Table with Strings	20130726
7	MV_FROM_CLAUSE	Instance attribute	Private	☐	Type reference (TYPE)	STRING			20130725
8	MV_FROM_OFFSET	Instance attribute	Private	☐	Type reference (TYPE)	I	0		20130725
9	MV_GROUP_BY_OFFSET	Instance attribute	Private	☐	Type reference (TYPE)	I	0		20130725
10	MV_HAVING_OFFSET	Instance attribute	Private	☐	Type reference (TYPE)	I	0		20130725
11	MV_INTO_CLAUSE	Instance attribute	Private	☐	Type reference (TYPE)	STRING			20130725
12	MV_INTO_LENGTH	Instance attribute	Private	☐	Type reference (TYPE)	I	0		20130725
13	MV_INTO_OFFSET	Instance attribute	Private	☐	Type reference (TYPE)	I	0		20130725
14	MV_NEW_FORMAT_FLAG	Instance attribute	Private	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20131003
15	MV_ORDER_BY_OFFSET	Instance attribute	Private	☐	Type reference (TYPE)	I	0		20130725
16	MV_QUERY_STRING	Instance attribute	Private	☐	Type reference (TYPE)	STRING			20130723
17	MV_SELECT_CLAUSE	Instance attribute	Private	☐	Type reference (TYPE)	STRING			20130725
18	MV_SELECT_OFFSET	Instance attribute	Private	☐	Type reference (TYPE)	I	0		20130725
19	MV_SELECT_SINGLE_ROW	Instance attribute	Private	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20130801
20	MV_UP_TO_CLAUSE	Instance attribute	Private	☐	Type reference (TYPE)	STRING			20130725
21	MV_UP_TO_LENGTH	Instance attribute	Private	☐	Type reference (TYPE)	I	0		20130725
22	MV_UP_TO_OFFSET	Instance attribute	Private	☐	Type reference (TYPE)	I	0		20130725
23	MV_WHERE_OFFSET	Instance attribute	Private	☐	Type reference (TYPE)	I	0		20130725

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Private	Constructor		20130725
2	GENERATE_DATA_TYPE_DECLARAION	Instance method	Private	Method		20130726
3	GET_CLAUSE_FOR_TOKEN	Instance method	Private	Method		20130725
4	GET_FORBIDDEN_TABLES	Instance method	Private	Method	lList all tables where user doe not have access	20130726
5	GET_INSTANCE	Static method	Public	Method		20130725
6	GET_QUERY_RESULT	Instance method	Public	Method	Gets the result of query	20130723
7	PARSE_COMMA_SEP_SELECT_CLAUSE	Instance method	Private	Method	Parses comma separated select list	20131003
8	PARSE_FROM_CLAUSE	Instance method	Private	Method		20130726
9	PARSE_QUERY	Instance method	Private	Method		20130723
10	PARSE_SELECT_CLAUSE	Instance method	Private	Method		20130726
11	REPLACE_INTO_UPTO_CLAUSE	Instance method	Private	Method		20130726
12	SPLIT_QUERY_STRING	Instance method	Private	Method	spilts query string to multiple lines less than 255 chars	20130729
13	TOKENISE_QUERY	Instance method	Private	Method		20130731

Events

Class CL_ADT_DP_OPEN_SQL_HANDLER has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TT_SELECT_FIELDS	Private	See coding			20130726	tt_select_fields TYPE TABLE OF ty_select_field WITH DEFAULT KEY
2	TT_TABLE_DET	Private	See coding			20130726	tt_table_det TYPE STANDARD TABLE OF ty_table_det WITH DEFAULT KEY
3	TY_SELECT_FIELD	Private	See coding			20130726	BEGIN OF ty_select_field, qualifier TYPE string, fielname TYPE string, alias TYPE string, aggregate_func TYPE string, END OF ty_select_field
4	TY_TABLE_DET	Private	See coding			20130726	BEGIN OF ty_table_det, table_name TYPE string, alias TYPE string, END OF ty_table_det

Method Signatures

Method CONSTRUCTOR Signature

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

Method CONSTRUCTOR on class CL_ADT_DP_OPEN_SQL_HANDLER has no exception.

Method GENERATE_DATA_TYPE_DECLARAION Signature

Method GENERATE_DATA_TYPE_DECLARAION on class CL_ADT_DP_OPEN_SQL_HANDLER has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_ADT_DATAPREVIEW_COMMON	☐	Common Exception for data preview	20130920

Method GET_CLAUSE_FOR_TOKEN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EV_CLAUSE	Value transfer	☐	Type reference (TYPE)	STRING			20130725
2	Exporting	EV_LENGTH	Call by reference	☐	Type reference (TYPE)	I			20130725
3	Exporting	EV_OFFSET	Call by reference	☐	Type reference (TYPE)	I			20130725
4	Importing	IV_TOKEN	Call by reference	☐	Type reference (TYPE)	STRING			20130725

Method GET_CLAUSE_FOR_TOKEN on class CL_ADT_DP_OPEN_SQL_HANDLER has no exception.

Method GET_FORBIDDEN_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RV_RESULT	Value transfer	☐	Type reference (TYPE)	STRING			20130726

#	Exception	Resumable	Description	Created on
1	CX_ADT_DATAPREVIEW_COMMON	☐	Common Exception for data preview	20130920

Method GET_INSTANCE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_NEW_FORMAT	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20131003
2	Importing	IV_QUERY_STRING	Call by reference	☐	Type reference (TYPE)	STRING			20130725
3	Returning	RO_OPEN_SQL_HANDLER	Value transfer	☐	Object reference (TYPE REF TO)	CL_ADT_DP_OPEN_SQL_HANDLER		Handler class for Open SQL	20130725

#	Exception	Resumable	Description	Created on
1	CX_ADT_DATAPREVIEW_COMMON	☐	Common Exception for data preview	20130725

Method GET_QUERY_RESULT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ER_RESULT	Call by reference	☐	Object reference (TYPE REF TO)	DATA			20130723
2	Exporting	EV_EXECUTION_TIME	Call by reference	☐	Type reference (TYPE)	STRING			20131112
3	Importing	IV_ROW_COUNT	Call by reference	☐	Type reference (TYPE)	I			20130726

#	Exception	Resumable	Description	Created on
1	CX_ADT_DATAPREVIEW_COMMON	☐	Common Exception for data preview	20130726

Method PARSE_COMMA_SEP_SELECT_CLAUSE Signature

Method PARSE_COMMA_SEP_SELECT_CLAUSE on class CL_ADT_DP_OPEN_SQL_HANDLER has no parameter.
Method PARSE_COMMA_SEP_SELECT_CLAUSE on class CL_ADT_DP_OPEN_SQL_HANDLER has no exception.

Method PARSE_FROM_CLAUSE Signature

Method PARSE_FROM_CLAUSE on class CL_ADT_DP_OPEN_SQL_HANDLER has no parameter.
Method PARSE_FROM_CLAUSE on class CL_ADT_DP_OPEN_SQL_HANDLER has no exception.

Method PARSE_QUERY Signature

Method PARSE_QUERY on class CL_ADT_DP_OPEN_SQL_HANDLER has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_ADT_DATAPREVIEW_COMMON	☐	Common Exception for data preview	20130726

Method PARSE_SELECT_CLAUSE Signature

Method PARSE_SELECT_CLAUSE on class CL_ADT_DP_OPEN_SQL_HANDLER has no parameter.
Method PARSE_SELECT_CLAUSE on class CL_ADT_DP_OPEN_SQL_HANDLER has no exception.

Method REPLACE_INTO_UPTO_CLAUSE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_ROW_COUNT	Call by reference	☐	Type reference (TYPE)	I			20130726

Method REPLACE_INTO_UPTO_CLAUSE on class CL_ADT_DP_OPEN_SQL_HANDLER has no exception.

Method SPLIT_QUERY_STRING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RT_QUERY_LINES	Value transfer	☐	Type reference (TYPE)	STRINGTAB		Table with Strings	20130729

#	Exception	Resumable	Description	Created on
1	CX_ADT_DATAPREVIEW_COMMON	☐	Common Exception for data preview	20130807

Method TOKENISE_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_TOKENS	Value transfer	☐	Type reference (TYPE)	SANA_STOKESX_TAB			20130731

#	Exception	Resumable	Description	Created on
1	CX_ADT_DATAPREVIEW_COMMON	☐	Common Exception for data preview	20130805

History

Last changed by/on	SAP	20140121
SAP Release Created in	740