SAP ABAP Class CL_RODPS_ODP_SQL (SQL Services for Operational Data Provider)

Hierarchy

☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ BC-EIM-ODP (Application Component) Operational Data Provisioning (ODP) in Search&Analytics
     ⤷ RODPS (Package) Operational Data Provider Services

Properties

Class	CL_RODPS_ODP_SQL
Short Description	SQL Services for Operational Data Provider
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class	RODPS
Program status
Category	0
Package	RODPS	Operational Data Provider Services
Created	20100730	SAP
Last change	20131127	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	CL_RODPS_ODP_SQL	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)
3	IF_RODPS_CONTEXT	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
4	IF_RODPS_ODP_DIRECT_ACCESS	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...

Interfaces

Class CL_RODPS_ODP_SQL has no interface implemented.

Friends

Class CL_RODPS_ODP_SQL has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	C_ASTERISK	Constant	Public	☐	See coding		'*'		20100730
2	C_KEYWORD	Constant	Public	☐	See coding				20100730
3	C_LEFT_PARENTHESIS	Constant	Public	☐	Attribute reference (LIKE)	CL_RSMDS_SET=>C_LEFT_PARENTHESIS	CL_RSMDS_SET=>C_LEFT_PARENTHESIS		20100730
4	C_NEWLINE	Constant	Public	☐	Attribute reference (LIKE)	CL_ABAP_CHAR_UTILITIES=>CR_LF	CL_ABAP_CHAR_UTILITIES=>CR_LF		20100730
5	C_PROGNAME	Constant	Public	☐	See coding				20100730
6	C_REGEX_FUNCTION_TOKEN	Constant	Public	☐	See coding				20100806
7	C_RIGHT_PARENTHESIS	Constant	Public	☐	Attribute reference (LIKE)	CL_RSMDS_SET=>C_RIGHT_PARENTHESIS	CL_RSMDS_SET=>C_RIGHT_PARENTHESIS		20100730
8	C_TAB	Constant	Public	☐	Attribute reference (LIKE)	CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB	CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB		20100730
9	C_TOKEN_TYPE	Constant	Public	☐	See coding			Token type (identifier, literal, list, comment)	20100805

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	API_TO_SQL	Static method	Public	Method		20100730
2	API_TO_SQL_TABLE	Static method	Public	Method		20101217
3	PARSE_FROM	Static method	Private	Method		20100806
4	PARSE_GROUP_BY	Static method	Private	Method		20100806
5	PARSE_IDENTIFIER	Static method	Private	Method		20100809
6	PARSE_INTEGER	Static method	Private	Method		20100809
7	PARSE_KEYWORD	Static method	Private	Method		20100809
8	PARSE_ORDER_BY	Static method	Private	Method		20100806
9	PARSE_SELECT	Static method	Private	Method		20100806
10	PARSE_SYMBOL	Static method	Private	Method		20100809
11	PARSE_WHERE	Static method	Private	Method		20100806
12	REMOVE_LINEBREAKS	Static method	Private	Method	Remove Line Breaks	20100805
13	SQL_TO_API	Static method	Public	Method		20100803
14	SUBMIT_SQL	Static method	Public	Method		20100802
15	SYNTAX_ERROR	Static method	Private	Method		20100805
16	UNEXPECTED_END_OF_STATEMENT	Static method	Private	Method		20100809

Events

Class CL_RODPS_ODP_SQL has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TT_LINES	Public	See coding			20101217	tt_lines TYPE STANDARD TABLE OF string WITH KEY table_line
2	TT_OFFSETS	Private	See coding			20100805	tt_offsets TYPE SORTED TABLE OF int2 WITH UNIQUE KEY table_line
3	TT_TOKENS	Private	See coding			20100806	tt_tokens TYPE STANDARD TABLE OF stokes WITH DEFAULT KEY

Method Signatures

Method API_TO_SQL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IR_SELECTION_SET	Call by reference	☑	Object reference (TYPE REF TO)	CL_RSMDS_SET		Selektion als Mengenobjekt (FEMS = 0)	20100730
2	Importing	ITR_SELECTION_SETS	Call by reference	☑	Type reference (TYPE)	RSMDS_TR_SETS		Weitere Selektionen als Mengenobjekt (FEMS > 0)	20100730
3	Importing	IT_FIELD_AGGREGATIONS	Call by reference	☑	Type reference (TYPE)	IF_RODPS_ODP_DIRECT_ACCESS=>TT_FIELD_AGGREGATIONS		Projektion, Umbenennung und Aggregation	20100730
4	Importing	IT_SORT_DESCRIPTIONS	Call by reference	☑	Type reference (TYPE)	IF_RODPS_ODP_DIRECT_ACCESS=>TT_SORT_DESCRIPTIONS		Sortierung	20100730
5	Importing	I_MAXIMUM_ROWS	Call by reference	☐	Type reference (TYPE)	I	0	Maximale Größe der Ergebnismenge in Datensätzen	20100730
6	Importing	I_NO_AGGREGATION	Call by reference	☑	Type reference (TYPE)	ABAP_BOOL		Keine Aggregation (Aggregatfunktion ignorieren)	20100730
7	Importing	I_ODPNAME	Call by reference	☐	Type reference (TYPE)	RODPS_ODPNAME		ODP-Name	20100730
8	Returning	R_SQL	Value transfer	☐	Type reference (TYPE)	STRING		ODQP SQL	20100730

#	Exception	Resumable	Description	Created on
1	CX_RODPS_INPUT_INVALID	☐	Ungültige Eingabe	20100730

Method API_TO_SQL_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IR_SELECTION_SET	Call by reference	☑	Object reference (TYPE REF TO)	CL_RSMDS_SET		Selektion als Mengenobjekt (FEMS = 0)	20101217
2	Importing	ITR_SELECTION_SETS	Call by reference	☑	Type reference (TYPE)	RSMDS_TR_SETS		Weitere Selektionen als Mengenobjekt (FEMS > 0)	20101217
3	Importing	IT_FIELD_AGGREGATIONS	Call by reference	☑	Type reference (TYPE)	IF_RODPS_ODP_DIRECT_ACCESS=>TT_FIELD_AGGREGATIONS		Projektion, Umbenennung und Aggregation	20101217
4	Importing	IT_SORT_DESCRIPTIONS	Call by reference	☑	Type reference (TYPE)	IF_RODPS_ODP_DIRECT_ACCESS=>TT_SORT_DESCRIPTIONS		Sortierung	20101217
5	Importing	I_MAXIMUM_ROWS	Call by reference	☐	Type reference (TYPE)	I	0	Maximale Größe der Ergebnismenge in Datensätzen	20101217
6	Importing	I_NO_AGGREGATION	Call by reference	☑	Type reference (TYPE)	ABAP_BOOL		Keine Aggregation (Aggregatfunktion ignorieren)	20101217
7	Importing	I_ODPNAME	Call by reference	☐	Type reference (TYPE)	RODPS_ODPNAME		ODP-Name	20101217
8	Returning	RT_LINES	Value transfer	☐	Type reference (TYPE)	CL_RODPS_ODP_SQL=>TT_LINES		ODQP SQL	20101217

#	Exception	Resumable	Description	Created on
1	CX_RODPS_INPUT_INVALID	☐	Ungültige Eingabe	20101217

Method PARSE_FROM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TOKEN_POSITION	Call by reference	☐	Type reference (TYPE)	I			20100806
2	Exporting	E_MAXIMUM_ROWS	Call by reference	☐	Type reference (TYPE)	I			20100806
3	Exporting	E_ODPNAME	Call by reference	☐	Type reference (TYPE)	RODPS_ODPNAME		ODP-Name	20100806
4	Importing	IT_TOKENS	Call by reference	☐	Type reference (TYPE)	TT_TOKENS		String-Beschr. eines Tokens in der ABAP/4-Source-Analyse	20100806
5	Importing	I_CONTEXT	Call by reference	☑	Type reference (TYPE)	IF_RODPS_CONTEXT=>T_CONTEXT		Kontext eines ODP	20130423
6	Importing	I_SQL	Call by reference	☑	Type reference (TYPE)	STRING			20100809

#	Exception	Resumable	Description	Created on
1	CX_RODPS_INPUT_INVALID	☐	Ungültige Eingabe	20100806
2	CX_RODPS_SYNTAX_ERROR	☐	Ungültige Eingabe	20100806

Method PARSE_GROUP_BY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_NO_AGGREGATION	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL		Multi-dimensionale Menge	20100806
2	Changing	C_TOKEN_POSITION	Call by reference	☐	Type reference (TYPE)	I			20100806
3	Importing	IT_FIELD_AGGREGATIONS	Call by reference	☐	Type reference (TYPE)	IF_RODPS_ODP_DIRECT_ACCESS=>TT_FIELD_AGGREGATIONS		ODP-Name	20100806
4	Importing	IT_TOKENS	Call by reference	☐	Type reference (TYPE)	TT_TOKENS		String-Beschr. eines Tokens in der ABAP/4-Source-Analyse	20100806
5	Importing	I_SQL	Call by reference	☐	Type reference (TYPE)	STRING			20100809

#	Exception	Resumable	Description	Created on
1	CX_RODPS_INPUT_INVALID	☐	Ungültige Eingabe	20100806
2	CX_RODPS_SYNTAX_ERROR	☐	Ungültige Eingabe	20100806

Method PARSE_IDENTIFIER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_IDENTIFIER	Call by reference	☐	Type reference (TYPE)	CSEQUENCE			20100809
2	Importing	IS_TOKEN	Call by reference	☐	Type reference (TYPE)	STOKES		String-Beschr. eines Tokens in der ABAP/4-Source-Analyse	20100809
3	Importing	I_SQL	Call by reference	☐	Type reference (TYPE)	STRING			20100809

#	Exception	Resumable	Description	Created on
1	CX_RODPS_SYNTAX_ERROR	☐	(SQL) Syntax-Fehler	20100809

Method PARSE_INTEGER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_INTEGER	Call by reference	☐	Type reference (TYPE)	I			20100809
2	Importing	IS_TOKEN	Call by reference	☐	Type reference (TYPE)	STOKES		String-Beschr. eines Tokens in der ABAP/4-Source-Analyse	20100809
3	Importing	I_NEGATIVE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20100809
4	Importing	I_SQL	Call by reference	☐	Type reference (TYPE)	STRING			20100809

#	Exception	Resumable	Description	Created on
1	CX_RODPS_SYNTAX_ERROR	☐	(SQL) Syntax-Fehler	20100809

Method PARSE_KEYWORD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_TOKEN	Call by reference	☐	Type reference (TYPE)	STOKES		String-Beschr. eines Tokens in der ABAP/4-Source-Analyse	20100809
2	Importing	I_KEYWORD	Call by reference	☐	Type reference (TYPE)	CSEQUENCE			20100809
3	Importing	I_SQL	Call by reference	☐	Type reference (TYPE)	STRING			20100809

#	Exception	Resumable	Description	Created on
1	CX_RODPS_SYNTAX_ERROR	☐	(SQL) Syntax-Fehler	20100809

Method PARSE_ORDER_BY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TOKEN_POSITION	Call by reference	☐	Type reference (TYPE)	I			20100806
2	Exporting	ET_SORT_DESCRIPTIONS	Call by reference	☐	Type reference (TYPE)	IF_RODPS_ODP_DIRECT_ACCESS=>TT_SORT_DESCRIPTIONS			20100806
3	Importing	IT_FIELD_AGGREGATIONS	Call by reference	☐	Type reference (TYPE)	IF_RODPS_ODP_DIRECT_ACCESS=>TT_FIELD_AGGREGATIONS		ODP-Name	20100806
4	Importing	IT_TOKENS	Call by reference	☐	Type reference (TYPE)	TT_TOKENS		String-Beschr. eines Tokens in der ABAP/4-Source-Analyse	20100806
5	Importing	I_SQL	Call by reference	☑	Type reference (TYPE)	STRING			20100809

#	Exception	Resumable	Description	Created on
1	CX_RODPS_INPUT_INVALID	☐	Ungültige Eingabe	20100806
2	CX_RODPS_SYNTAX_ERROR	☐	Ungültige Eingabe	20100806

Method PARSE_SELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TOKEN_POSITION	Call by reference	☐	Type reference (TYPE)	I			20100806
2	Exporting	ET_FIELD_AGGREGATIONS	Call by reference	☐	Type reference (TYPE)	IF_RODPS_ODP_DIRECT_ACCESS=>TT_FIELD_AGGREGATIONS			20100806
3	Exporting	E_NO_AGGREGATION	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20100806
4	Importing	IT_TOKENS	Call by reference	☐	Type reference (TYPE)	TT_TOKENS		String-Beschr. eines Tokens in der ABAP/4-Source-Analyse	20100806
5	Importing	I_SQL	Call by reference	☑	Type reference (TYPE)	STRING			20100809

#	Exception	Resumable	Description	Created on
1	CX_RODPS_INPUT_INVALID	☐	Ungültige Eingabe	20100806
2	CX_RODPS_SYNTAX_ERROR	☐	Ungültige Eingabe	20100806

Method PARSE_SYMBOL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_SYMBOL	Call by reference	☐	Type reference (TYPE)	CSEQUENCE			20100809
2	Importing	IS_TOKEN	Call by reference	☐	Type reference (TYPE)	STOKES		String-Beschr. eines Tokens in der ABAP/4-Source-Analyse	20100809
3	Importing	I_SQL	Call by reference	☐	Type reference (TYPE)	STRING			20100809
4	Importing	I_SYMBOL	Call by reference	☐	Type reference (TYPE)	CSEQUENCE			20100809

#	Exception	Resumable	Description	Created on
1	CX_RODPS_SYNTAX_ERROR	☐	(SQL) Syntax-Fehler	20100809

Method PARSE_WHERE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TOKEN_POSITION	Call by reference	☐	Type reference (TYPE)	I			20100806
2	Exporting	ER_SELECTION_SET	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSMDS_SET		Multi-dimensionale Menge	20100806
3	Importing	IR_UNIVERSE	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSMDS_UNIVERSE		ODP-Name	20100806
4	Importing	IT_TOKENS	Call by reference	☐	Type reference (TYPE)	TT_TOKENS		String-Beschr. eines Tokens in der ABAP/4-Source-Analyse	20100806
5	Importing	I_SQL	Call by reference	☑	Type reference (TYPE)	STRING			20100809

#	Exception	Resumable	Description	Created on
1	CX_RODPS_INPUT_INVALID	☐	Ungültige Eingabe	20100806
2	CX_RODPS_SYNTAX_ERROR	☐	Ungültige Eingabe	20100806

Method REMOVE_LINEBREAKS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_STRING	Call by reference	☐	Type reference (TYPE)	STRING			20100805
2	Exporting	ET_OFFSETS	Call by reference	☐	Type reference (TYPE)	TT_OFFSETS			20100805

Method REMOVE_LINEBREAKS on class CL_RODPS_ODP_SQL has no exception.

Method SQL_TO_API Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ER_SELECTION_SET	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSMDS_SET		Selektion als Mengenobjekt (FEMS = 0)	20100803
2	Exporting	ET_FIELD_AGGREGATIONS	Call by reference	☐	Type reference (TYPE)	IF_RODPS_ODP_DIRECT_ACCESS=>TT_FIELD_AGGREGATIONS		Projektion, Umbenennung und Aggregation	20100803
3	Exporting	ET_SORT_DESCRIPTIONS	Call by reference	☐	Type reference (TYPE)	IF_RODPS_ODP_DIRECT_ACCESS=>TT_SORT_DESCRIPTIONS		Sortierung	20100803
4	Exporting	E_MAXIMUM_ROWS	Call by reference	☐	Type reference (TYPE)	I		Maximale Größe der Ergebnismenge in Datensätzen	20100803
5	Exporting	E_NO_AGGREGATION	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL		Keine Aggregation (Aggregatfunktion ignorieren)	20100803
6	Exporting	E_ODPNAME	Call by reference	☐	Type reference (TYPE)	RODPS_ODPNAME		ODP-Name	20100803
7	Importing	I_CONTEXT	Call by reference	☑	Type reference (TYPE)	RODPS_CONTEXT		Kontext eines ODP	20130423
8	Importing	I_SQL	Value transfer	☐	Type reference (TYPE)	STRING		ODP-SQL	20100803

#	Exception	Resumable	Description	Created on
1	CX_RODPS_INPUT_INVALID	☐	Ungültige Eingabe	20100803

Method SUBMIT_SQL Signature

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

Method SUBMIT_SQL on class CL_RODPS_ODP_SQL has no exception.

Method SYNTAX_ERROR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_TOKEN	Call by reference	☐	Type reference (TYPE)	STOKES		String-Beschr. eines Tokens in der ABAP/4-Source-Analyse	20100805
2	Importing	IT_OFFSETS	Call by reference	☐	Type reference (TYPE)	TT_OFFSETS			20100805
3	Importing	I_STMT	Call by reference	☐	Type reference (TYPE)	STRING			20100805

#	Exception	Resumable	Description	Created on
1	CX_RODPS_INPUT_INVALID	☐	Ungültige Eingabe	20100805

Method UNEXPECTED_END_OF_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_KEYWORD	Call by reference	☑	Type reference (TYPE)	CSEQUENCE			20100809
2	Importing	I_SQL	Call by reference	☐	Type reference (TYPE)	STRING			20100809

#	Exception	Resumable	Description	Created on
1	CX_RODPS_SYNTAX_ERROR	☐	(SQL) Syntax-Fehler	20100809

History

Last changed by/on	SAP	20131127
SAP Release Created in	703