SAP ABAP Class CL_OIUP_SQL_ANALYZER (PDM - SQL Analyzer)

Hierarchy

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

Meta Relationship - Used By

#	Relationship type	Used by	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_OIUP_SQL_ANALYZER_CPIC	PDM - SQL Analyzer Via CPIC	20041117
2	Inheritance (c INHERITING FROM c_ref)	CL_OIUP_SQL_ANALYZER_DBCON	PDM - SQL Analyzer Via DBCON	20041116

Properties

Class	CL_OIUP_SQL_ANALYZER
Short Description	PDM - SQL Analyzer
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	20041116	SAP
Last change	20050520	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_OIUP_SQL_ANALYZER has no forward declaration.

Interfaces

Class CL_OIUP_SQL_ANALYZER has no interface implemented.

Friends

Class CL_OIUP_SQL_ANALYZER has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	C_AND	Constant	Protected	☐	Type reference (TYPE)	CHAR3	'AND'	Constant - AND	20041116
2	C_EQUAL	Constant	Protected	☐	Type reference (TYPE)	CHAR1	'='	Constant - Equal	20041116
3	C_FALSE	Constant	Protected	☐	Type reference (TYPE)	CHAR1	SPACE	Constant - False	20041116
4	C_PRA	Constant	Protected	☐	Type reference (TYPE)	DBCON_NAME	'DEFAULT'	Constant - DEFAULT	20041117
5	C_QUOTE	Constant	Protected	☐	Type reference (TYPE)	CHAR1	''''	Constant - Single Quote	20041116
6	C_TRUE	Constant	Protected	☐	Type reference (TYPE)	CHAR1	'X'	Constant - True	20041116
7	I_BADI	Static Attribute	Protected	☐	Object reference (TYPE REF TO)	IF_EX_OIUP_PDM_ENGINE		Business add-in interface IF_EX_OIUP_PDM_ENGINE	20050119

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ANALYZE_DELETE_STATEMENT	Instance method	Public	Method	Analyze DELETE Statement	20041116
2	ANALYZE_INSERT_STATEMENT	Instance method	Public	Method	Analyze INSERT Statement	20041116
3	ANALYZE_MODIFY_STATEMENT	Instance method	Public	Method	Analyze MODIFY Statement	20041116
4	ANALYZE_SELECT_STATEMENT	Instance method	Public	Method	Analyze SELECT Statement	20041116
5	ANALYZE_UPDATE_STATEMENT	Instance method	Public	Method	Analyze UPDATE Statement	20041116
6	SELECT_SHADOW	Instance method	Protected	Method	SELECT Via Shadow Table Technique	20041116
7	SELECT_SHADOW_PACKAGE_SIZE	Instance method	Protected	Method	SELECT / PACKAGE SIZE Via Shadow Table Technique	20041116
8	SELECT_SINGLE_ENDSELECT	Instance method	Protected	Method	SELECT Single Table / ENDSELECT	20041116
9	SELECT_SINGLE_PACKAGE_SIZE	Instance method	Protected	Method	SELECT Single Table / PACKAGE SIZE	20041116
10	SELECT_SINGLE_TABLE	Instance method	Protected	Method	SELECT Single Table	20041116
11	SELECT_SINGLE_WA	Instance method	Protected	Method	SELECT Single Work Area	20041116
12	SHADOW_DELETE	Instance method	Public	Method	Delete Shadow Table	20041117
13	SHADOW_POPULATE	Instance method	Protected	Method	Populate Shadow Table	20041117

Events

Class CL_OIUP_SQL_ANALYZER has no event.

Types

Class CL_OIUP_SQL_ANALYZER has no local type.

Method Signatures

Method ANALYZE_DELETE_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_DATA_LOCATION_ITAB	Value transfer	☐	Type reference (TYPE)	OIUP_DATA_LOCATIONS_ITAB		PDM - Data Locations	20041116
2	Importing	P_PARSER	Value transfer	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER		PDM - SQL Parser Interface	20041116
3	Returning	RC	Value transfer	☐	Type reference (TYPE)	SY-SUBRC		Return Value, Return Value After ABAP Statements	20050506

Method ANALYZE_DELETE_STATEMENT on class CL_OIUP_SQL_ANALYZER has no exception.

Method ANALYZE_INSERT_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_DATA_LOCATION_ITAB	Value transfer	☐	Type reference (TYPE)	OIUP_DATA_LOCATIONS_ITAB		PDM - Data Locations	20041116
2	Importing	P_PARSER	Value transfer	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER		PDM - SQL Parser Interface	20041116
3	Returning	RC	Value transfer	☐	Type reference (TYPE)	SY-SUBRC		Return Value, Return Value After ABAP Statements	20050506

Method ANALYZE_INSERT_STATEMENT on class CL_OIUP_SQL_ANALYZER has no exception.

Method ANALYZE_MODIFY_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_DATA_LOCATION_ITAB	Value transfer	☐	Type reference (TYPE)	OIUP_DATA_LOCATIONS_ITAB		PDM - Data Locations	20041116
2	Importing	P_PARSER	Value transfer	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER		PDM - SQL Parser Interface	20041116
3	Returning	RC	Value transfer	☐	Type reference (TYPE)	SY-SUBRC		Return Value, Return Value After ABAP Statements	20050506

Method ANALYZE_MODIFY_STATEMENT on class CL_OIUP_SQL_ANALYZER has no exception.

Method ANALYZE_SELECT_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	DBCNT	Value transfer	☐	Type reference (TYPE)	SY-DBCNT		DB operations, number of table lines processed	20050506
2	Changing	GT_ENDSELECT	Call by reference	☐	Type reference (TYPE)	OIUP_ENDSELECTS_ITAB		PDM - ENDSELECTs	20041116
3	Importing	P_DATA_LOCATION_ITAB	Value transfer	☐	Type reference (TYPE)	OIUP_DATA_LOCATIONS_ITAB		PDM - Data Locations	20041116
4	Importing	P_INCLUDE	Value transfer	☐	Type reference (TYPE)	INCLUDE		INCLUDE used	20041116
5	Importing	P_PARSER	Value transfer	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER		PDM - SQL Parser Interface	20041116
6	Importing	P_PROGRAM	Value transfer	☐	Type reference (TYPE)	PROGRAM		Program/transaction in SQL trace analysis	20041116
7	Exporting	RC	Value transfer	☐	Type reference (TYPE)	SY-SUBRC		Return Value, Return Value After ABAP Statements	20050506

#	Exception	Resumable	Description	Created on
1	ENDSELECT	☐	ENDSELECT Encountered	20041116
2	PACKAGE_SIZE	☐	PACKAGE SIZE Encountered	20041116

Method ANALYZE_UPDATE_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_DATA_LOCATION_ITAB	Value transfer	☐	Type reference (TYPE)	OIUP_DATA_LOCATIONS_ITAB		PDM - Data Locations	20041116
2	Importing	P_PARSER	Value transfer	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER		PDM - SQL Parser Interface	20041116
3	Returning	RC	Value transfer	☐	Type reference (TYPE)	SY-SUBRC		Return Value, Return Value After ABAP Statements	20050506

Method ANALYZE_UPDATE_STATEMENT on class CL_OIUP_SQL_ANALYZER has no exception.

Method SELECT_SHADOW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	DBCNT	Value transfer	☐	Type reference (TYPE)	SY-DBCNT		DB operations, number of table lines processed	20050506
2	Changing	GT_ENDSELECT	Call by reference	☐	Type reference (TYPE)	OIUP_ENDSELECTS_ITAB		PDM - ENDSELECTs	20041116
3	Importing	P_DATA_LOCATION_ITAB	Value transfer	☐	Type reference (TYPE)	OIUP_DATA_LOCATIONS_ITAB		PDM - Data Locations	20041116
4	Importing	P_INCLUDE	Value transfer	☐	Type reference (TYPE)	INCLUDE		INCLUDE used	20041116
5	Importing	P_PARSER	Value transfer	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER		PDM - SQL Parser Interface	20041116
6	Importing	P_PROGRAM	Value transfer	☐	Type reference (TYPE)	PROGRAM		Program/transaction in SQL trace analysis	20041116
7	Exporting	RC	Value transfer	☐	Type reference (TYPE)	SY-SUBRC		Return Value, Return Value After ABAP Statements	20050506

Method SELECT_SHADOW on class CL_OIUP_SQL_ANALYZER has no exception.

Method SELECT_SHADOW_PACKAGE_SIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	GT_ENDSELECT	Call by reference	☐	Type reference (TYPE)	OIUP_ENDSELECTS_ITAB		PDM - ENDSELECTs	20041116
2	Importing	P_DATA_LOCATION_ITAB	Value transfer	☐	Type reference (TYPE)	OIUP_DATA_LOCATIONS_ITAB		PDM - Data Locations	20041116
3	Importing	P_INCLUDE	Value transfer	☐	Type reference (TYPE)	INCLUDE		INCLUDE used	20041116
4	Importing	P_PARSER	Value transfer	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER		PDM - SQL Parser Interface	20041116
5	Importing	P_PROGRAM	Value transfer	☐	Type reference (TYPE)	PROGRAM		Program/transaction in SQL trace analysis	20041116

Method SELECT_SHADOW_PACKAGE_SIZE on class CL_OIUP_SQL_ANALYZER has no exception.

Method SELECT_SINGLE_ENDSELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	GT_ENDSELECT	Call by reference	☐	Type reference (TYPE)	OIUP_ENDSELECTS_ITAB		PDM - ENDSELECTs	20041117
2	Importing	P_DATA_LOCATION_ITAB	Value transfer	☐	Type reference (TYPE)	OIUP_DATA_LOCATIONS_ITAB		PDM - Data Locations	20041116
3	Importing	P_INCLUDE	Value transfer	☐	Type reference (TYPE)	INCLUDE		INCLUDE used	20041116
4	Importing	P_PARSER	Value transfer	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER		PDM - SQL Parser Interface	20041116
5	Importing	P_PROGRAM	Value transfer	☐	Type reference (TYPE)	PROGRAM		Program/transaction in SQL trace analysis	20041116

Method SELECT_SINGLE_ENDSELECT on class CL_OIUP_SQL_ANALYZER has no exception.

Method SELECT_SINGLE_PACKAGE_SIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	GT_ENDSELECT	Call by reference	☐	Type reference (TYPE)	OIUP_ENDSELECTS_ITAB		PDM - ENDSELECTs	20041117
2	Importing	P_DATA_LOCATION_ITAB	Value transfer	☐	Type reference (TYPE)	OIUP_DATA_LOCATIONS_ITAB		PDM - Data Locations	20041116
3	Importing	P_INCLUDE	Value transfer	☐	Type reference (TYPE)	INCLUDE		INCLUDE used	20041116
4	Importing	P_PARSER	Value transfer	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER		PDM - SQL Parser Interface	20041116
5	Importing	P_PROGRAM	Value transfer	☐	Type reference (TYPE)	PROGRAM		Program/transaction in SQL trace analysis	20041116

Method SELECT_SINGLE_PACKAGE_SIZE on class CL_OIUP_SQL_ANALYZER has no exception.

Method SELECT_SINGLE_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_DATA_LOCATION_ITAB	Value transfer	☐	Type reference (TYPE)	OIUP_DATA_LOCATIONS_ITAB		PDM - Data Locations	20041116
2	Importing	P_PARSER	Value transfer	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER		PDM - SQL Parser Interface	20041116
3	Returning	RC	Value transfer	☐	Type reference (TYPE)	SY-SUBRC		Return Value, Return Value After ABAP Statements	20050506

Method SELECT_SINGLE_TABLE on class CL_OIUP_SQL_ANALYZER has no exception.

Method SELECT_SINGLE_WA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_DATA_LOCATION_ITAB	Value transfer	☐	Type reference (TYPE)	OIUP_DATA_LOCATIONS_ITAB		PDM - Data Locations	20041116
2	Importing	P_PARSER	Value transfer	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER		PDM - SQL Parser Interface	20041116
3	Returning	RC	Value transfer	☐	Type reference (TYPE)	SY-SUBRC		Return Value, Return Value After ABAP Statements	20050506

Method SELECT_SINGLE_WA on class CL_OIUP_SQL_ANALYZER has no exception.

Method SHADOW_DELETE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_DATA_LOCATION_ITAB	Value transfer	☐	Type reference (TYPE)	OIUP_DATA_LOCATIONS_ITAB		PDM - Data Locations	20041117
2	Importing	P_GUID	Value transfer	☐	Type reference (TYPE)	GUID_32		GUID in 'CHAR' Format in Uppercase	20041117

Method SHADOW_DELETE on class CL_OIUP_SQL_ANALYZER has no exception.

Method SHADOW_POPULATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_DATA_LOCATION_ITAB	Value transfer	☐	Type reference (TYPE)	OIUP_DATA_LOCATIONS_ITAB		PDM - Data Locations	20041117
2	Importing	P_GUID	Value transfer	☐	Type reference (TYPE)	GUID_32		GUID in 'CHAR' Format in Uppercase	20041117
3	Importing	P_PARSER	Value transfer	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER		PDM - SQL Parser Interface	20041117

Method SHADOW_POPULATE on class CL_OIUP_SQL_ANALYZER has no exception.

History

Last changed by/on	SAP	20050520
SAP Release Created in	600