SAP ABAP Class CL_RSDR_AT_QUERY_HANDLER (Query Handler for Atomic Queries)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-OT (Application Component) OLAP Technology
     ⤷ RSDRP (Package) Data Manager Query Handler

Properties

Class	CL_RSDR_AT_QUERY_HANDLER
Short Description	Query Handler for Atomic Queries
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	RSDRP	Data Manager Query Handler
Created	20020829	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	CL_RSDR_AT_QUERY	Forward declaration class (CLASS c DEFINITION DEFERRED)	Forward declaration class (CLASS c DEFINITION DEFERRED)
2	RS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
3	RSD	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
4	RSDRH	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
5	RSDRP	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_RSDR_AT_QUERY_HANDLER has no interface implemented.

Friends

Class CL_RSDR_AT_QUERY_HANDLER has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	N_C_EXEC_MODE	Constant	Public	☐	See coding				20030926
2	N_C_MAX_DEGREE	Constant	Public	☐	Type reference (TYPE)	I	6	Maximum Degree of Parallelism	20040319
3	N_EXEC_MODE	Instance attribute	Public	☑	Type reference (TYPE)	TN_EXEC_MODE		serial/parallel execution	20030319
4	N_EXPLAIN_DM	Instance attribute	Public	☑	Type reference (TYPE)	RS_BOOL		Explain Data Manager	20060717
5	N_STATUS	Instance attribute	Public	☐	Type reference (TYPE)	CL_RSDR_AT_OBJ=>TN_QUERY_STATUS		Status of query handler	20020910
6	N_T_QUERY	Instance attribute	Public	☑	Type reference (TYPE)	CL_RSDR_AT_OBJ=>TN_T_OBJ		List of Queries AND postprocessing objects	20040319
7	P_ACT_UID	Instance attribute	Private	☐	Type reference (TYPE)	RSDRP_UID		UID of actually running query if executed serially	20020910
8	P_COMMIT_ALLOWED	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL		Commit on default connection allowed	20060825
9	P_C_TASKNAME_PREFIX	Constant	Private	☐	Type reference (TYPE)	RSDR0_TASKNAME_LONG	'BI_RSDR_'	BW Data Manager: Task Name - 32 Characters	20091026
10	P_ERROR_UID	Instance attribute	Private	☐	Type reference (TYPE)	RSDRP_UID		UID of failing query	20081201
11	P_FINISHED	Instance attribute	Private	☐	Type reference (TYPE)	I		queries already finished	20081201
12	P_MAX_DEGREE	Instance attribute	Private	☐	Type reference (TYPE)	I	N_C_MAX_DEGREE	Maximum Used Degree of Parallelism	20040319
13	P_MAX_DEGREE_RSADMIN	Instance attribute	Private	☐	Type reference (TYPE)	I		Final max degree of parallelism	20051107
14	P_MESSAGE	Instance attribute	Private	☐	Type reference (TYPE)	CHAR50		Error Message	20081201
15	P_NO_RESULT	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL		Are there any queries with no result flag set ?	20020911
16	P_OTHER_ERRORS	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL		Other queries also have errors.	20081201
17	P_PARALLEL_IN_BATCH	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL		Allow Parallel mode in batch process	20041207
18	P_RC	Instance attribute	Private	☐	Type reference (TYPE)	RSDRP_RC		error code of failing query	20081201
19	P_RECENT_FINISH	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL			20081201
20	P_RESULT_FETCH	Instance attribute	Private	☐	Type reference (TYPE)	CL_RSDR_AT_OBJ=>TN_QUERY_STATUS	CL_RSDR_AT_OBJ=>N_C_QUERY_STATUS-NEW	Has result been fetched already ?	20030314
21	P_RFC_RC	Instance attribute	Private	☐	Type reference (TYPE)	RSDRP_RC		code if rfc mechanism errors occur	20081201
22	P_RUNNING	Instance attribute	Private	☐	Type reference (TYPE)	I		queries currently running	20081201
23	P_R_EQSID_TABL_CACHE	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_RSDRC_EQSID_TABL_CACHE		Eqsid Tabl Cache Object	20040707
24	P_SLOTS	Instance attribute	Private	☐	Type reference (TYPE)	CHAR50		max. parallelity queryprocessing	20081201
25	P_TH_TMPOBJ	Instance attribute	Private	☐	Type reference (TYPE)	RSDRH_TH_TABLNM			20020906
26	P_T_NCUM_REPNM	Instance attribute	Private	☐	Type reference (TYPE)	TP_T_REPNM		NCUM Report Names to be cleaned up	20050825
27	P_T_POSTPROC	Instance attribute	Private	☐	Type reference (TYPE)	CL_RSDR_AT_POSTPROC=>TN_T_POSTPROC		List of postprocessing objects	20020906
28	P_T_QUERY	Instance attribute	Private	☐	Type reference (TYPE)	CL_RSDR_AT_QUERY=>TN_T_QUERY			20081201
29	P_WAITING	Instance attribute	Private	☐	Type reference (TYPE)	I		queries waiting to run	20081201

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_EQSID_CACHE_OBJ	Instance method	Public	Method	Add EQSID Cache Object for cleaning up the tmpobjs	20040707
2	ADD_NCUM_REPNM	Instance method	Public	Method	Register an ncum report name to be dropped afterwards	20050825
3	ADD_QUERY	Instance method	Public	Method	Add a query to the handler's query list	20020829
4	ADD_TMPOBJ	Instance method	Public	Method	Add a temporary object to the handler's list of tmp objects	20020829
5	ADD_TMPOBJS	Instance method	Public	Method	Add a table with temporary object to the handler	20030923
6	ALLOW_PARALLEL_IN_BATCH	Instance method	Public	Method	Allow parallel mode in batch process	20041207
7	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20020910
8	DISPATCH	Instance method	Private	Method	dispatch parallel accesses	20081201
9	DISPATCHER_RECEIVE	Instance method	Public	Method	receive method for dispatcher	20081201
10	DROP_TMPOBJS	Instance method	Public	Method	Drop all temporary objects	20020829
11	EXECUTE	Instance method	Public	Method	Execute all queries with parallelism	20020829
12	EXECUTE_SERIALLY	Instance method	Public	Method	Execute all queries one by one in packaged mode	20020829
13	GET_PARALLEL_DEGREE	Instance method	Private	Method	Determines the parallel degree used for execution	20020829
14	GET_RESULT	Instance method	Public	Method	return result if parallel execution	20020911
15	GET_RESULT_PACKAGED	Instance method	Public	Method	Retrieve result after parallel run in pkg mode	20030314
16	GET_RESULT_SIZE	Instance method	Public	Method	parl. exec: get result size to decide on packaged get_result	20030317
17	RECORD_ESTIMATES	Instance method	Private	Method	Records the execution estimates for the queries ...	20040511
18	RUN_POSTPROC	Instance method	Private	Method	Run the ncum post-processing	20020910
19	SET_ENH_DB_OPT	Instance method	Public	Method	Set Usage of Enhanced db optimizer features (before execute)	20050127
20	SET_MAX_DEGREE	Instance method	Private	Method	Set the maximum degree of parallelism to be used	20040319
21	WRITE_MESSAGES_TO_HANDLER	Instance method	Private	Method	Execute all queries with parallelism	20050221

Events

Class CL_RSDR_AT_QUERY_HANDLER has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TN_EXEC_MODE	Public	Type reference (TYPE)	CHAR01	Execution mode of Query Handler	20030926
2	TP_T_REPNM	Private	See coding			20050825	tp_t_repnm TYPE STANDARD TABLE OF programm WITH DEFAULT KEY INITIAL SIZE 0

Method Signatures

Method ADD_EQSID_CACHE_OBJ Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_EQSID_TABL_CACHE	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSDRC_EQSID_TABL_CACHE		Stores EQSID table restrictions in case of multiproviders	20040707

Method ADD_EQSID_CACHE_OBJ on class CL_RSDR_AT_QUERY_HANDLER has no exception.

Method ADD_NCUM_REPNM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_PROGRAM	Call by reference	☐	Type reference (TYPE)	PROGRAMM		ABAP-Programmname	20050825

Method ADD_NCUM_REPNM on class CL_RSDR_AT_QUERY_HANDLER has no exception.

Method ADD_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	E_SUBRC	Value transfer	☐	Attribute reference (LIKE)	SY-SUBRC		4 if query already exists	20020829
2	Importing	I_R_AT_QUERY	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSDR_AT_QUERY		Query to be added	20020829

Method ADD_QUERY on class CL_RSDR_AT_QUERY_HANDLER has no exception.

Method ADD_TMPOBJ Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	E_SUBRC	Value transfer	☐	Attribute reference (LIKE)	SY-SUBRC		4 = already exists, 8 = illegal type	20020829
2	Importing	I_NAME	Call by reference	☐	Type reference (TYPE)	RSD_TABLNM		Name of temporary object	20020829
3	Importing	I_SEQ_NR	Call by reference	☑	Type reference (TYPE)	I	0	seq-nr if hierarchy result table	20030923
4	Importing	I_TYPE	Call by reference	☑	Type reference (TYPE)	RSDRH_TABTYP	RSDRH_C_TABTYP-TMP	Type of temporary object	20020829

Method ADD_TMPOBJ on class CL_RSDR_AT_QUERY_HANDLER has no exception.

Method ADD_TMPOBJS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	E_SUBRC	Value transfer	☐	Attribute reference (LIKE)	SY-SUBRC		4 = already exists, 8 = illegal type	20030923
2	Importing	I_T_TMPOBJ	Call by reference	☐	Type reference (TYPE)	RSDRH_T_TABLNM		Table with temporary objects	20030923

Method ADD_TMPOBJS on class CL_RSDR_AT_QUERY_HANDLER has no exception.

Method ALLOW_PARALLEL_IN_BATCH Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_ALLOW	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Boolean	20041207

Method ALLOW_PARALLEL_IN_BATCH on class CL_RSDR_AT_QUERY_HANDLER has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_COMMIT_ALLOWED	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Commit Allowed on default connection	20060825
2	Importing	I_EXPLAIN_DM	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Explain DM access	20060717

Method CONSTRUCTOR on class CL_RSDR_AT_QUERY_HANDLER has no exception.

Method DISPATCH Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_PARALLEL	Call by reference	☐	Type reference (TYPE)	I			20081201
2	Importing	I_XCODE	Call by reference	☐	Type reference (TYPE)	XSTRING			20081201

#	Exception	Resumable	Description	Created on
1	CX_RSDRP_RFC_ERROR	☐	Fehler bei Paralleler Query-Ausführung	20081201
2	CX_RS_ACTION_NOT_ALLOWED	☐	Die Aktion ist an dieser Stelle nicht erlaubt	20081201

Method DISPATCHER_RECEIVE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_TASK	Call by reference	☐	Type reference (TYPE)	CLIKE			20081201

Method DISPATCHER_RECEIVE on class CL_RSDR_AT_QUERY_HANDLER has no exception.

Method DROP_TMPOBJS Signature

Method DROP_TMPOBJS on class CL_RSDR_AT_QUERY_HANDLER has no parameter.
Method DROP_TMPOBJS on class CL_RSDR_AT_QUERY_HANDLER has no exception.

Method EXECUTE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_NO_RESULT	Call by reference	☐	Type reference (TYPE)	RS_BOOL		If true, only materialized queries ...	20020923
2	Exporting	E_PARALLEL_EXECUTION	Call by reference	☐	Type reference (TYPE)	RS_BOOL		If false, cannot be executed in parallel	20020910
3	Importing	I_MAX_DEGREE	Value transfer	☑	Type reference (TYPE)	I		Max Degree. Has to be <= n_c_max_degree	20040319
4	Importing	I_RT_SAMPLE_DATA	Call by reference	☑	Object reference (TYPE REF TO)	DATA		Example Target Data Structure	20031021

#	Exception	Resumable	Description	Created on
1	CX_RSDRP_DATA_NOT_ASSIGNED	☐	Access to not yet assigned query result data	20020913
2	CX_RSDRP_RFC_ERROR	☐	Kommunikationsfehler (MDX Parser)	20020913
3	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20030925
4	CX_RSDR_CUBE_LOCKED	☐	Cube is locked (due to condensing, ...)	20030925
5	CX_RS_ACTION_NOT_ALLOWED	☐	Die Aktion ist an dieser Stelle nicht erlaubt	20030319
6	CX_RS_EXISTING	☐	Objekt existiert bereits	20020913
7	CX_RS_NOT_FOUND	☐	Objekt nicht gefunden	20020913
8	CX_RS_VCUBE_READ_ERROR	☐	Fehler beim Lesen aus einem Virtuellen Cube	20020913
9	CX_STATIC_CHECK	☐	Ausnahmen mit statischer und dynamischer Prüfung von RAISING	20020913

Method EXECUTE_SERIALLY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_END_OF_DATA	Call by reference	☐	Type reference (TYPE)	RS_BOOL		End of Data reached ?	20030922
2	Exporting	E_SX_SPLITPACK	Call by reference	☐	Type reference (TYPE)	RSDR0_SX_SPLITPACK		splitpack for result	20020910
3	Exporting	E_T_DATA	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE		Result Table Area	20020910
4	Importing	I_MPROV_MAPPING	Value transfer	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Multiprovider Charet mapping	20040913
5	Importing	I_PKGSIZE	Value transfer	☑	Type reference (TYPE)	I	1000	Size of Result Data Packages	20020906
6	Importing	I_SHOW_REPORT	Value transfer	☑	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Show generated Statement	20020923

#	Exception	Resumable	Description	Created on
1	CX_RS_ACCESS_ERROR	☐	Fehler beim Zugriff	20020910
2	CX_RS_ACTION_NOT_ALLOWED	☐	Die Aktion ist an dieser Stelle nicht erlaubt	20030319
3	CX_RS_VCUBE_READ_ERROR	☐	Fehler beim Lesen aus einem Virtuellen Cube	20020910
4	CX_STATIC_CHECK	☐	Ausnahmen mit statischer und dynamischer Prüfung von RAISING	20020910

Method GET_PARALLEL_DEGREE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	E_PARALLEL_DEGREE	Value transfer	☐	Type reference (TYPE)	I		Degree of parallelism	20020829

Method GET_PARALLEL_DEGREE on class CL_RSDR_AT_QUERY_HANDLER has no exception.

Method GET_RESULT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_TX_DATA	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE		Result data	20020911
2	Exporting	E_TX_SPLITPACK	Call by reference	☐	Type reference (TYPE)	RSDR0_TX_SPLITPACK		Splitpack for Result	20020912
3	Importing	I_MPROV_MAPPING	Value transfer	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Multiprovider Charet Mapping	20040913

#	Exception	Resumable	Description	Created on
1	CX_RS_ACCESS_ERROR	☐	Fehler beim Zugriff	20020912
2	CX_RS_ACTION_NOT_ALLOWED	☐	Die Aktion ist an dieser Stelle nicht erlaubt	20030314
3	CX_RS_ERROR	☐	BW: Allgemeine Fehlerklasse	20050125

Method GET_RESULT_PACKAGED Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_END_OF_DATA	Call by reference	☐	Type reference (TYPE)	RS_BOOL		End of Data reached ?	20030314
2	Exporting	E_SX_SPLITPACK	Call by reference	☐	Type reference (TYPE)	RSDR0_SX_SPLITPACK		splitpack for result	20030314
3	Exporting	E_T_DATA	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE		Result Table Area	20030314
4	Importing	I_MPROV_MAPPING	Value transfer	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Multiprovider Charet Mapping	20040913

#	Exception	Resumable	Description	Created on
1	CX_RS_ACCESS_ERROR	☐	Fehler beim Zugriff	20030314
2	CX_RS_ACTION_NOT_ALLOWED	☐	Die Aktion ist an dieser Stelle nicht erlaubt	20030317
3	CX_RS_VCUBE_READ_ERROR	☐	Fehler beim Lesen aus einem Virtuellen Cube	20030314
4	CX_STATIC_CHECK	☐	Ausnahmen mit statischer und dynamischer Prüfung von RAISING	20030314

Method GET_RESULT_SIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	E_SIZE	Value transfer	☐	Type reference (TYPE)	I		Size of result	20030317

#	Exception	Resumable	Description	Created on
1	CX_RS_ACTION_NOT_ALLOWED	☐	Die Aktion ist an dieser Stelle nicht erlaubt	20030317

Method RECORD_ESTIMATES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_T_QUERY	Call by reference	☐	Type reference (TYPE)	CL_RSDR_AT_QUERY=>TN_T_QUERY		Query object list	20040511

Method RECORD_ESTIMATES on class CL_RSDR_AT_QUERY_HANDLER has no exception.

Method RUN_POSTPROC Signature

Method RUN_POSTPROC on class CL_RSDR_AT_QUERY_HANDLER has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRP_DATA_NOT_ASSIGNED	☐	Access to not yet assigned query result data	20020913
2	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20030925
3	CX_RSDR_CUBE_LOCKED	☐	Cube is locked (due to condensing, ...)	20030925
4	CX_RS_EXISTING	☐	Objekt existiert bereits	20020913
5	CX_RS_NOT_FOUND	☐	Objekt nicht gefunden	20020913
6	CX_RS_VCUBE_READ_ERROR	☐	Fehler beim Lesen aus einem Virtuellen Cube	20020911
7	CX_STATIC_CHECK	☐	Ausnahmen mit statischer und dynamischer Prüfung von RAISING	20020913

Method SET_ENH_DB_OPT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_ENH_DB_OPT	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Use enhanced db optimizer features	20050127

Method SET_ENH_DB_OPT on class CL_RSDR_AT_QUERY_HANDLER has no exception.

Method SET_MAX_DEGREE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_MAX_DEGREE	Value transfer	☐	Type reference (TYPE)	I		Max Degree	20040319

Method SET_MAX_DEGREE on class CL_RSDR_AT_QUERY_HANDLER has no exception.

Method WRITE_MESSAGES_TO_HANDLER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_T_QUERY	Call by reference	☐	Type reference (TYPE)	CL_RSDR_AT_QUERY=>TN_T_QUERY			20050221

Method WRITE_MESSAGES_TO_HANDLER on class CL_RSDR_AT_QUERY_HANDLER has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	400