SAP ABAP Class CL_RSDRS_TOP_QUERY_ABAP (ABAP Implementation of TOP/BOTTOM query)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-OT (Application Component) OLAP Technology
     ⤷ RSDRS (Package) Data Manager SQL Interface

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_RSDRS_TOP_QUERY	Abstract TOP/BOTTOM Query	20051010

Meta Relationship - Used By

#	Relationship type	Used by	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_RSDRS_TOP_QUERY_ADABASD	MaxDB ABAP Top N	20060118
2	Inheritance (c INHERITING FROM c_ref)	CL_RSDRS_TOP_QUERY_DB2	DB2 Implementation of TOP/BOTTOM Query	20060201
3	Inheritance (c INHERITING FROM c_ref)	CL_RSDRS_TOP_QUERY_DB400	DB400 ABAP TOP Implementation	20060207
4	Inheritance (c INHERITING FROM c_ref)	CL_RSDRS_TOP_QUERY_HDB	MaxDB ABAP Top N	20100624
5	Inheritance (c INHERITING FROM c_ref)	CL_RSDRS_TOP_QUERY_MSSQL	MSSQL Implementation TOP/BOTTOM Query	20060202
6	Inheritance (c INHERITING FROM c_ref)	CL_RSDRS_TOP_QUERY_ORACL	Oracle ABAP TOP Implementation	20051011
7	Inheritance (c INHERITING FROM c_ref)	CL_RSDRS_TOP_QUERY_SYBASE	Sybase ASE: ABAP TOP Implementation	20110325

Properties

Class	CL_RSDRS_TOP_QUERY_ABAP
Short Description	ABAP Implementation of TOP/BOTTOM query
Super Class	CL_RSDRS_TOP_QUERY	Abstract TOP/BOTTOM Query
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	RSDRS	Data Manager SQL Interface
Created	20051010	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_RSDRS_TOP_QUERY_ABAP has no forward declaration.

Interfaces

Class CL_RSDRS_TOP_QUERY_ABAP has no interface implemented.

Friends

Class CL_RSDRS_TOP_QUERY_ABAP has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	O_KYF_POS	Instance attribute	Protected	☐	Type reference (TYPE)	I		Position of keyfigure in result set	20051011
2	O_RANK_POS	Instance attribute	Protected	☐	Type reference (TYPE)	I		Position of rank column	20051011
3	O_R_SQL_QUERY	Instance attribute	Protected	☐	Object reference (TYPE REF TO)	CL_RSDRS_SQL_QUERY			20051124
4	O_SID_POS	Instance attribute	Protected	☐	Type reference (TYPE)	I			20051125

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20051010
2	PREPARE	Instance method	Protected	Method	execute the query and return the data read	20051011
3	TOP_N	Instance method	Protected	Method	execute the query and return the data read	20051011
4	TOP_PERCENT	Instance method	Protected	Method	execute the query and return the data read	20051011
5	TOP_SUM	Instance method	Protected	Method	execute the query and return the data read	20051011

Events

Class CL_RSDRS_TOP_QUERY_ABAP has no event.

Types

Class CL_RSDRS_TOP_QUERY_ABAP has no local type.

Method Signatures

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_R_STAT	Call by reference	☐	Object reference (TYPE REF TO)	CL_RSDD_STATDM_ACCESS			20051010
2	Importing	I_SX_QUERY	Call by reference	☐	Type reference (TYPE)	RSDRS_SX_QUERY			20051010

Method CONSTRUCTOR on class CL_RSDRS_TOP_QUERY_ABAP has no exception.

Method PREPARE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_S_DATA	Call by reference	☐	Type reference (TYPE)	ANY		sample data line	20051011

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL Statement Is Too Large	20051011
2	CX_RSDR_CUBE_LOCKED	☐	During Statement Execution compression, ... running	20051011
3	CX_SY_SQL_ERROR	☐	SQL error	20051011

Method TOP_N Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_COUNTER	Call by reference	☐	Type reference (TYPE)	I		Compression counter for infocubes	20051011
2	Exporting	E_EOF	Call by reference	☐	Type reference (TYPE)	RS_BOOL		end of data reached	20051011
3	Exporting	E_T_DATA	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE		result data	20051011
4	Importing	I_ALLOW_ADBC	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	allow usage of ADBC	20051011
5	Importing	I_CUBE	Call by reference	☑	Type reference (TYPE)	RSD_INFOCUBE		InfoCube	20051011
6	Importing	I_ENH_DB_OPT	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	allow using enhanced db options	20051011
7	Importing	I_SHOW_REPORT	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	display generated stmt/report	20051011
8	Importing	I_TC_BREAK	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	allow testcase break	20051011

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL Statement Is Too Large	20051011
2	CX_RSDR_CUBE_LOCKED	☐	During Statement Execution compression, ... running	20051011
3	CX_SY_SQL_ERROR	☐	SQL error	20051011

Method TOP_PERCENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_COUNTER	Call by reference	☐	Type reference (TYPE)	I		Compression counter for infocubes	20051011
2	Exporting	E_EOF	Call by reference	☐	Type reference (TYPE)	RS_BOOL		end of data reached	20051011
3	Exporting	E_T_DATA	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE		result data	20051011
4	Importing	I_ALLOW_ADBC	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	allow usage of ADBC	20051011
5	Importing	I_CUBE	Call by reference	☑	Type reference (TYPE)	RSD_INFOCUBE		InfoCube	20051011
6	Importing	I_ENH_DB_OPT	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	allow using enhanced db options	20051011
7	Importing	I_SHOW_REPORT	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	display generated stmt/report	20051011
8	Importing	I_TC_BREAK	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	allow testcase break	20051011

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL Statement Is Too Large	20051011
2	CX_RSDR_CUBE_LOCKED	☐	During Statement Execution compression, ... running	20051011
3	CX_SY_SQL_ERROR	☐	SQL error	20051011

Method TOP_SUM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_COUNTER	Call by reference	☐	Type reference (TYPE)	I		Compression counter for infocubes	20051011
2	Exporting	E_EOF	Call by reference	☐	Type reference (TYPE)	RS_BOOL		end of data reached	20051011
3	Exporting	E_T_DATA	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE		result data	20051011
4	Importing	I_ALLOW_ADBC	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	allow usage of ADBC	20051011
5	Importing	I_CUBE	Call by reference	☑	Type reference (TYPE)	RSD_INFOCUBE		InfoCube	20051011
6	Importing	I_ENH_DB_OPT	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	allow using enhanced db options	20051011
7	Importing	I_SHOW_REPORT	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	display generated stmt/report	20051011
8	Importing	I_TC_BREAK	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	allow testcase break	20051011

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL Statement Is Too Large	20051011
2	CX_RSDR_CUBE_LOCKED	☐	During Statement Execution compression, ... running	20051011
3	CX_SY_SQL_ERROR	☐	SQL error	20051011

History

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