SAP ABAP Class CL_OIUP_SQL_PARSER_WHERE_TREE (PDM - Where Clause Tree/Node)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
     ⤷ OIU_P (Package) Partitioned Data Management

Properties

Class	CL_OIUP_SQL_PARSER_WHERE_TREE
Short Description	PDM - Where Clause Tree/Node
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class	OIUP
Program status
Category	0
Package	OIU_P	Partitioned Data Management
Created	20040414	SAP
Last change	20050224	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_OIUP_SQL_PARSER_WHERE_TREE has no forward declaration.

Interfaces

Class CL_OIUP_SQL_PARSER_WHERE_TREE has no interface implemented.

Friends

#	Friend	Modeled only	Created on	Description
1	CL_OIUP_SQL_PARSER	☐	20040520	PDM - SQL Parser
2	CL_OIUP_SQL_PARSER_EXPRESSION	☐	20040426	PDM - Where Expression
3	CL_OIUP_SQL_PARSER_WHERE	☐	20040427	PDM - Parse SQL With WHERE Clause

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	AND_NODE	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_WHERE_TREE		AND Node	20040414
2	AND_OR	Instance attribute	Private	☐	Type reference (TYPE)	TY_AND_OR		AND, OR	20040414
3	CLOSE_PARENTHESIS_COUNTER	Instance attribute	Private	☐	Type reference (TYPE)	I		Number Of Close Parenthesis	20040420
4	C_ALL	Constant	Private	☐	Type reference (TYPE)	CHAR3	'ALL'	Constant - ALL	20040608
5	C_AND	Constant	Private	☐	Type reference (TYPE)	TY_AND_OR	'AND'	Constant - AND	20040414
6	C_ANY	Constant	Private	☐	Type reference (TYPE)	CHAR3	'ANY'	Constant - ANY	20040608
7	C_BETWEEN	Constant	Private	☐	Type reference (TYPE)	CHAR7	'BETWEEN'	Constant - BETWEEN	20040415
8	C_DASH	Constant	Private	☐	Type reference (TYPE)	CHAR1	'-'	Constant - Dash	20040628
9	C_ESCAPE	Constant	Private	☐	Type reference (TYPE)	CHAR6	'ESCAPE'	Constant - ESCAPE	20040602
10	C_EXISTS	Constant	Private	☐	Type reference (TYPE)	CHAR6	'EXISTS'	Constant - EXISTS	20040415
11	C_FALSE	Constant	Private	☐	Type reference (TYPE)	CHAR1	SPACE	Constant - False	20040414
12	C_HAVING	Constant	Private	☐	Type reference (TYPE)	CHAR6	'HAVING'	Constant - HAVING	20040609
13	C_IN	Constant	Private	☐	Type reference (TYPE)	CHAR2	'IN'	Constant - IN	20040415
14	C_IS	Constant	Private	☐	Type reference (TYPE)	CHAR2	'IS'	Constant - IS	20040415
15	C_LIKE	Constant	Private	☐	Type reference (TYPE)	CHAR4	'LIKE'	Constant - LIKE	20040415
16	C_NOT	Constant	Private	☐	Type reference (TYPE)	CHAR3	'NOT'	Constant - NOT	20040415
17	C_NULL	Constant	Private	☐	Type reference (TYPE)	CHAR4	'NULL'	Constant - NULL	20040415
18	C_OR	Constant	Private	☐	Type reference (TYPE)	TY_AND_OR	'OR'	Constant - OR	20040414
19	C_ROOT	Constant	Private	☐	Type reference (TYPE)	CHAR8	'%%ROOT%%'	Constant - %%ROOT%%	20040414
20	C_SOME	Constant	Private	☐	Type reference (TYPE)	CHAR4	'SOME'	Constant - SOME	20040608
21	C_TRUE	Constant	Private	☐	Type reference (TYPE)	CHAR1	'X'	Constant - True	20040414
22	C_WHERE	Constant	Private	☐	Type reference (TYPE)	CHAR5	'WHERE'	Constant - WHERE	20040415
23	EXPRESSION	Instance attribute	Private	☐	Type reference (TYPE)	STRING		Expression (Between AND/OR)	20040414
24	FIELD	Instance attribute	Private	☐	Type reference (TYPE)	FIELDNAME		Operand Field Name	20040420
25	LEFT_OR_NODE	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_WHERE_TREE		"Left" OR Node	20040414
26	OPEN_PARENTHESIS_COUNTER	Instance attribute	Private	☐	Type reference (TYPE)	I		Number Of Open Parenthesis	20040420
27	OR_NODES	Instance attribute	Private	☐	Type reference (TYPE)	TY_OR_NODES		Table Of OR Nodes	20040414
28	PARENTHESIS_COUNTER	Instance attribute	Private	☐	Type reference (TYPE)	I		Working Parenthesis Counter	20040414
29	PARENT_NODE	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_WHERE_TREE		Parent Node	20040414
30	PARSER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_WHERE		Parser Object	20040421
31	ROOT_NODE	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_WHERE_TREE		Root Node	20040422
32	TABLE	Instance attribute	Private	☐	Type reference (TYPE)	TABNAME		Operand Table Name	20040420
33	WHERE_EXPRESSION	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_EXPRESSION		Where Expression	20040426
34	WHERE_INFO	Instance attribute	Private	☐	Type reference (TYPE)	TY_WHERE_INFO_ITAB		Where Clause Info For Each Table	20040422

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	AND	Instance method	Private	Method	Add AND Clause	20040414
2	CLEAN_TRAVERSAL_RESULT	Static method	Private	Method	Clean Traversal Result (Recursive Call)	20040423
3	CLEAN_WHERE_CLAUSE	Static method	Public	Method	Clean Where Clause From Traversal	20040423
4	CLOSE_PARENTHESIS	Instance method	Private	Method	Handle Close Parenthesis	20040414
5	CREATE	Static method	Public	Method	Create Parse Tree Root Node For Where Clause	20040414
6	GET_DATA_LOCATION	Instance method	Private	Method	Data In PRA and/or Nearline (Which Instances)	20040422
7	GET_EXPRESSION	Instance method	Private	Method	Return Expression	20040414
8	GET_PARENT_NODE	Instance method	Private	Method	Get Parent Node	20040414
9	GET_STRING	Static method	Private	Method	Build String From Several Rows Of String Internal Table	20040414
10	OR	Instance method	Private	Method	Add OR Clause	20040414
11	PARSE_EXPRESSION	Instance method	Private	Method	Parse Where Expression	20040415
12	PARSE_WHERE	Instance method	Private	Method	Create Parse Tree Nodes For Where Clause (Recursive)	20040414
13	TRAVERSE	Instance method	Public	Method	Traverse Parse Tree	20040414

Events

Class CL_OIUP_SQL_PARSER_WHERE_TREE has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TY_AND_OR	Private	Type reference (TYPE)	CHAR3	AND, OR	20040414

Method Signatures

Method AND Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	AND_NODE	Value transfer	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_WHERE_TREE		AND Node	20040414
2	Importing	CLOSE_PARENTHESIS	Value transfer	☐	Type reference (TYPE)	I		Number Of Close Parenthesis	20040414
3	Importing	EXPRESSION	Value transfer	☐	Type reference (TYPE)	STRING		AND Expression	20040414
4	Importing	FIELD	Value transfer	☐	Type reference (TYPE)	FIELDNAME		Operand Field Name	20040420
5	Importing	OPEN_PARENTHESIS	Value transfer	☐	Type reference (TYPE)	I		Number Of Open Parenthesis	20040414
6	Importing	TABLE	Value transfer	☐	Type reference (TYPE)	TABNAME		Operand Table Name	20040420
7	Importing	WHERE_EXPRESSION	Value transfer	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_EXPRESSION		Where Expression	20040426

Method AND on class CL_OIUP_SQL_PARSER_WHERE_TREE has no exception.

Method CLEAN_TRAVERSAL_RESULT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CLEAN_EXPRESSION	Value transfer	☐	Type reference (TYPE)	OIUP_STRING_ITAB		Cleaned Traversal Result Expression	20040423
2	Importing	EXPRESSION	Value transfer	☐	Type reference (TYPE)	OIUP_STRING_ITAB		Traversal Result Expression	20040423

Method CLEAN_TRAVERSAL_RESULT on class CL_OIUP_SQL_PARSER_WHERE_TREE has no exception.

Method CLEAN_WHERE_CLAUSE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CLEAN_WHERE_CLAUSE	Value transfer	☐	Type reference (TYPE)	STRING		Cleaned WHERE Clause	20040423
2	Importing	WHERE_CLAUSE	Value transfer	☐	Type reference (TYPE)	STRING		WHERE Clause (From Traversal)	20040423

Method CLEAN_WHERE_CLAUSE on class CL_OIUP_SQL_PARSER_WHERE_TREE has no exception.

Method CLOSE_PARENTHESIS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CLOSE_PARENTHESIS	Value transfer	☐	Type reference (TYPE)	I		Number Of Close Parenthesis	20040414

Method CLOSE_PARENTHESIS on class CL_OIUP_SQL_PARSER_WHERE_TREE has no exception.

Method CREATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CLAUSE	Call by reference	☐	Type reference (TYPE)	OIUP_STRING_ITAB		Clause To Parse	20040609
2	Importing	PARSER	Call by reference	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_WHERE		Parser Object	20040421
3	Returning	ROOT_NODE	Value transfer	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_WHERE_TREE		Root Node	20040414

#	Exception	Resumable	Description	Created on
1	SUBQUERY	☐	Subquery Encountered	20040611

Method GET_DATA_LOCATION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	INLINE	Value transfer	☐	Type reference (TYPE)	FLAG		'X' = Inline, SPACE = Not Inline	20041202
2	Exporting	NEARLINE_DBCONS	Value transfer	☐	Type reference (TYPE)	OIUP_DB_CONNECTIONS_ITAB		Neraline DB Connections	20040726
3	Exporting	NEARLINE_RFC_DESTINATIONS	Value transfer	☐	Type reference (TYPE)	OIUP_RFC_DESTINATIONS_ITAB		Nearline RFC Destinations	20040422
4	Importing	TABLE	Value transfer	☐	Type reference (TYPE)	TABNAME		Table Name	20040422

Method GET_DATA_LOCATION on class CL_OIUP_SQL_PARSER_WHERE_TREE has no exception.

Method GET_EXPRESSION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	AND_OR	Value transfer	☐	Type reference (TYPE)	TY_AND_OR		AND, OR	20040414
2	Exporting	CLOSE_PARENTHESIS	Value transfer	☐	Type reference (TYPE)	I		Number Of Close Parenthesis	20040414
3	Exporting	EXPRESSION	Value transfer	☐	Type reference (TYPE)	STRING		Expression	20040414
4	Exporting	OPEN_PARENTHESIS	Value transfer	☐	Type reference (TYPE)	I		Number Of Open Parenthesis	20040414
5	Exporting	REMAINING_WHERE_CLAUSE	Value transfer	☐	Type reference (TYPE)	OIUP_STRING_ITAB		Remaining Where Clause	20040414
6	Importing	WHERE_CLAUSE	Value transfer	☐	Type reference (TYPE)	OIUP_STRING_ITAB		Where Clause	20040414

Method GET_EXPRESSION on class CL_OIUP_SQL_PARSER_WHERE_TREE has no exception.

Method GET_PARENT_NODE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	PARENT_NODE	Value transfer	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_WHERE_TREE		Parent Node	20040414

Method GET_PARENT_NODE on class CL_OIUP_SQL_PARSER_WHERE_TREE has no exception.

Method GET_STRING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	CLOSE_PARENTHESIS	Value transfer	☐	Type reference (TYPE)	SY-TABIX		Number Of Close Parenthesis	20040414
2	Importing	END	Value transfer	☐	Type reference (TYPE)	SY-TABIX	0	End Index	20040414
3	Exporting	OPEN_PARENTHESIS	Value transfer	☐	Type reference (TYPE)	SY-TABIX		Number Of Open Parenthesis	20040414
4	Exporting	OUTPUT	Value transfer	☐	Type reference (TYPE)	STRING		Row Value	20040414
5	Importing	START	Value transfer	☐	Type reference (TYPE)	SY-TABIX	0	Start Index	20040414
6	Importing	WHERE_CLAUSE	Value transfer	☐	Type reference (TYPE)	OIUP_STRING_ITAB		Where Clause	20040414

Method GET_STRING on class CL_OIUP_SQL_PARSER_WHERE_TREE has no exception.

Method OR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CLOSE_PARENTHESIS	Value transfer	☐	Type reference (TYPE)	I		Number Of Close Parenthesis	20040414
2	Importing	EXPRESSION	Value transfer	☐	Type reference (TYPE)	STRING		OR Expression	20040414
3	Importing	FIELD	Value transfer	☐	Type reference (TYPE)	FIELDNAME		Operand Field Name	20040420
4	Importing	OPEN_PARENTHESIS	Value transfer	☐	Type reference (TYPE)	I		Number Of Open Parenthesis	20040414
5	Returning	OR_NODE	Value transfer	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_WHERE_TREE		OR Node	20040414
6	Importing	TABLE	Value transfer	☐	Type reference (TYPE)	TABNAME		Operand Table Name	20040420
7	Importing	WHERE_EXPRESSION	Value transfer	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_EXPRESSION		Where Expression	20040426

Method OR on class CL_OIUP_SQL_PARSER_WHERE_TREE has no exception.

Method PARSE_EXPRESSION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	EXPRESSION	Value transfer	☐	Type reference (TYPE)	STRING		Where Clause Expression	20040415
2	Exporting	FIELD	Value transfer	☐	Type reference (TYPE)	FIELDNAME		Operand Field Name	20040420
3	Exporting	TABLE	Value transfer	☐	Type reference (TYPE)	TABNAME		Operand Table Name	20040420
4	Exporting	WHERE_EXPRESSION	Value transfer	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_EXPRESSION		Where Expression	20040426

#	Exception	Resumable	Description	Created on
1	SUBQUERY	☐	Subquery Encountered	20040611

Method PARSE_WHERE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	AND_OR	Value transfer	☐	Type reference (TYPE)	TY_AND_OR		AND, OR	20040414
2	Importing	NODE	Value transfer	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER_WHERE_TREE		Where Clause Node	20040414
3	Importing	WHERE_CLAUSE	Value transfer	☐	Type reference (TYPE)	OIUP_STRING_ITAB		Where Clause	20040414

#	Exception	Resumable	Description	Created on
1	SUBQUERY	☐	Subquery Encountered	20040611

Method TRAVERSE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	EXPRESSION	Value transfer	☐	Type reference (TYPE)	STRING		Where Expression	20040414
2	Importing	FIELD	Value transfer	☐	Type reference (TYPE)	FIELDNAME	SPACE	Specific Field Only?	20040423
3	Importing	FOR_ALL_ENTRIES_VARIABLE	Value transfer	☐	Type reference (TYPE)	STRING	SPACE	Variable to use in case of FOR ALL ENTRIES	20040629
4	Importing	REPLACE_VARIABLE	Value transfer	☐	Type reference (TYPE)	FLAG	'X'	'X' - Return Value, SPACE - Return Variable	20040430
5	Importing	RETURN_VIA_STRING	Value transfer	☐	Type reference (TYPE)	FLAG	SPACE	'X' - Return String, SPACE - Return Technical Where Clause	20040426
6	Importing	TABLE	Value transfer	☐	Type reference (TYPE)	TABNAME	SPACE	Specific Table Only?	20040422
7	Importing	TRANSLATE_SPLIT_FIELD	Value transfer	☐	Type reference (TYPE)	FLAG	SPACE	'X' - Translate Split Field to Common Date Field	20040426

Method TRAVERSE on class CL_OIUP_SQL_PARSER_WHERE_TREE has no exception.

History

Last changed by/on	SAP	20050224
SAP Release Created in	472