SAP ABAP Class CL_RSDRS_ADABASD_SQL_STMT (Generate a MaxDB SQL Statement)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-SYS-DB-SDB (Application Component) BW MaxDB
     ⤷ RSADA (Package) BW Porting MaxDB

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_RSDRS_SQL_STMT	Data Manager SQL Statement	20031120

Properties

Class	CL_RSDRS_ADABASD_SQL_STMT
Short Description	Generate a MaxDB SQL Statement
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	RSADA	BW Porting MaxDB
Created	20031120	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	RS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	RSD	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
3	RSDRS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_RSDRS_SQL_STMT	☐	☐	Data Manager SQL Statement	20031120

Friends

#	Friend	Modeled only	Created on	Description
1	CL_RSDRS_ADABASD_EXITS	☐	20040323	Database dependent exits for MaxDB

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	P_DSTYPE	Instance attribute	Private	☐	Type reference (TYPE)	SDB_DSTYPE		Data Source	20091020
2	P_F4_OPT	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL	rs_c_false	Flag for F4 Optimization	20091020
3	P_FACTVIEW	Instance attribute	Private	☐	Type reference (TYPE)	RSD_TABLNM		View of union all Table	20031120
4	P_HIER_FACTOR	Instance attribute	Private	☐	Type reference (TYPE)	STRING		correction factor for unambiguous hierarchies	20031120
5	P_INNER_GROUPBY	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Group by in inner SQL statement (if factview used)	20060120
6	P_R_EXIT_OBJ	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_RSDRS_ADABASD_EXITS		Reference to Database specific exits	20031120
7	P_SRV_OBJ	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_RSDRS_STMT_SRVS		Service Object for Statement Creation	20031120
8	P_SUPPRESS_AGGR	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL	rs_c_false	No aggregation	20070619
9	P_SX_QUERY	Instance attribute	Private	☐	Type reference (TYPE)	RSDRS_SX_QUERY		query definition	20031120
10	P_TH_COB_PRO	Instance attribute	Private	☐	Type reference (TYPE)	RSDRS_TH_COB_PRO		COB PRO information of sx_query	20031120
11	P_TOPN_DB	Instance attribute	Private	☐	Type reference (TYPE)	RS_BOOL	RS_C_FALSE	Top N Functions in DB	20091020
12	P_T_CODE	Instance attribute	Private	☐	Type reference (TYPE)	RSDRS_T_ABAPSOURCE		Generated Code	20031120

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	BUILD_CHA_SELECT	Instance method	Private	Method	Build an entry of char. and nav. attr. part of select list	20031120
2	BUILD_DELETE_HEADER	Instance method	Private	Method	For db_delete build delete header	20050512
3	BUILD_FACTVIEW_HAVING	Instance method	Private	Method	Build starting select list for factview	20060120
4	BUILD_FACTVIEW_ORDERBY	Instance method	Private	Method	Build the final orderby clause for the factview	20060120
5	BUILD_FACTVIEW_SELECT	Instance method	Private	Method	Build starting select list for factview	20060120
6	BUILD_FORMULA	Instance method	Private	Method	Build Select List Entry for a Key Figure	20071123
7	BUILD_FROM_JOINS	Instance method	Private	Method	Build the from list with join conditions (ANSI Notation)	20031120
8	BUILD_GROUPBY_LIST	Instance method	Private	Method	Build group by part of statement	20031120
9	BUILD_HAVING_LIST	Instance method	Private	Method	Build the have list (not used currently)	20031120
10	BUILD_HINT	Instance method	Protected	Method	build hint for SQL stmt	20031120
11	BUILD_INSERT_HEADER	Instance method	Private	Method	For db_insert or db_create build insert list, drop indexes	20031120
12	BUILD_KYF_SELECT	Instance method	Private	Method	Build Select List Entry for a Key Figure	20031120
13	BUILD_ORDERBY	Instance method	Private	Method	build order by list	20031120
14	BUILD_OUTER	Instance method	Private	Method	build a single outer join condition	20031120
15	BUILD_SUBQUERY	Instance method	Private	Method	build a subquery. Subqueries may occur within where cond.	20031120
16	BUILD_SUBQUERY_FOR_DELETE	Instance method	Private	Method	subquery for delete	20050809
17	BUILD_TOP_SELECT	Instance method	Private	Method	Create Select list for top N query	20090821
18	BUILD_TOP_WHERE	Instance method	Private	Method	Creates WHERE clause for top N query	20090821
19	BUILD_WHERE_LIST	Instance method	Private	Method	Build the where list (without the join part)	20031120
20	CONSTRUCTOR	Instance method	Public	Constructor	Class constructor	20031120
21	DET_DATAMART_AGGR	Instance method	Private	Method	Determine if aggregation is possible for DataMart queries	20090212
22	DET_HIER_FACTOR	Instance method	Private	Method	Determine the correction factor for unambiguous hierarchies	20031120
23	FIND_FACTVIEW	Instance method	Private	Method	Changes the factview into two union all connected star joins	20031120
24	GET_STARTTAB	Instance method	Private	Method	Get starting table for join conditions	20031120
25	PROCESS_FACTVIEW	Instance method	Private	Method	Changes the factview into two union all connected star joins	20031120
26	PROCESS_TOPQUERY	Instance method	Private	Method	Processes Top/Bottom Query	20060516
27	PROCESS_TOPQUERY_ABAP	Instance method	Private	Method	ABAP Processing of Top n Query	20090820
28	PROCESS_TOPQUERY_DB	Instance method	Private	Method	DB Processing of Top n Query	20090820
29	REMOVE_REDUNDANT_CONDITIONS	Instance method	Private	Method	Delete Redundant Conditions	20111229
30	SET_F4_OPTIMIZATION	Instance method	Private	Method	Verify and Set F4 Optimization	20090821
31	SPLIT_HEADER	Instance method	Private	Method	Splits statement into header and select stmt	20060120
32	WRITE_JOIN	Instance method	Private	Method	recurse over from list and join tables together	20031120
33	WRITE_TABLE	Instance method	Private	Method	write a table entry of the from list	20031120

Events

Class CL_RSDRS_ADABASD_SQL_STMT has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	RSADA_T_DDFIELD	Private	See coding			20031121	RSADA_T_DDFIELD TYPE TABLE OF ddfield

Method Signatures

Method BUILD_CHA_SELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SEPARATOR	Call by reference	☐	Type reference (TYPE)	RSDRS_SEP		Separator between list elements	20031120
2	Importing	I_S_CHA	Call by reference	☐	Type reference (TYPE)	RSDRS_S_CHA		actual characteristic to build entry for	20031120

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031120

Method BUILD_DELETE_HEADER Signature

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

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20050512

Method BUILD_FACTVIEW_HAVING Signature

Method BUILD_FACTVIEW_HAVING on class CL_RSDRS_ADABASD_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20060120

Method BUILD_FACTVIEW_ORDERBY Signature

Method BUILD_FACTVIEW_ORDERBY on class CL_RSDRS_ADABASD_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20060120

Method BUILD_FACTVIEW_SELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_GROUPBY	Value transfer	☐	Type reference (TYPE)	RS_BOOL		Boolean	20060120

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20060120

Method BUILD_FORMULA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FORMULA	Call by reference	☐	Type reference (TYPE)	RSDRS_S_KYF-FORMULA		formula	20071123
2	Importing	I_T_FORM_FLD	Call by reference	☐	Type reference (TYPE)	RSDRS_T_FORM_FLD		factor for unambigous hierarchies	20071123
3	Returning	R_FORMULA	Value transfer	☐	Type reference (TYPE)	STRING		Resolved Formula	20071123

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20071123

Method BUILD_FROM_JOINS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_TH_JOIN	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_JOIN		List of inner join conditions	20031120
2	Importing	I_TH_TABLE	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_TABLE		Table List	20031120
3	Importing	I_TX_LEFTOUTER	Call by reference	☐	Type reference (TYPE)	RSDRS_TX_LEFTOUTER		list of left outer joins	20031120

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031120

Method BUILD_GROUPBY_LIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_T_GROUPBY	Call by reference	☐	Type reference (TYPE)	RSDRS_T_GROUPBY		Groupby	20031120

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031120

Method BUILD_HAVING_LIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_T_HAVING	Call by reference	☐	Type reference (TYPE)	RSDRS_T_HAVING		Having list	20031120

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031120

Method BUILD_HINT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_HINT	Call by reference	☐	Type reference (TYPE)	RS_CHAR255		Final hints ...	20031120
2	Importing	I_OPEN_SQL	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Boolean	20031120
3	Importing	I_T_HINT	Call by reference	☐	Type reference (TYPE)	RSDRS_T_ABAPSOURCE		Hints from Statement (if set ...)	20031120

Method BUILD_HINT on class CL_RSDRS_ADABASD_SQL_STMT has no exception.

Method BUILD_INSERT_HEADER Signature

Method BUILD_INSERT_HEADER on class CL_RSDRS_ADABASD_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031120

Method BUILD_KYF_SELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_HIER_FACTOR	Call by reference	☐	Type reference (TYPE)	STRING		factor for unambigous hierarchies	20031120
2	Importing	I_SEPARATOR	Call by reference	☐	Type reference (TYPE)	RSDRS_SEP		Separator for select list	20031120
3	Importing	I_S_KYF	Call by reference	☐	Type reference (TYPE)	RSDRS_S_KYF		key figure description	20031120

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031120

Method BUILD_ORDERBY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_T_ORDERBY	Call by reference	☐	Type reference (TYPE)	RSDRS_T_ORDERBY		orderby list	20031120

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031120

Method BUILD_OUTER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TH_TBLS_JOINED	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_TABLE		Tables already joined	20031120
2	Importing	I_SX_LEFTOUTER	Call by reference	☐	Type reference (TYPE)	RSDRS_SX_LEFTOUTER		left outer condition to build	20031120

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031120

Method BUILD_SUBQUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SUBQUERY_ID	Call by reference	☐	Type reference (TYPE)	RSDRS_SUBQUERY_ID		Subquery ID of actual subquery	20031120
2	Importing	I_SX_SUBQUERY	Call by reference	☐	Type reference (TYPE)	RSDRS_SX_SUBQUERY		Subquery description	20031120
3	Importing	I_S_WHERE	Call by reference	☐	Type reference (TYPE)	RSDRS_S_WHERE		Surrounding where statement	20031120

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031120

Method BUILD_SUBQUERY_FOR_DELETE Signature

Method BUILD_SUBQUERY_FOR_DELETE on class CL_RSDRS_ADABASD_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20050809

Method BUILD_TOP_SELECT Signature

Method BUILD_TOP_SELECT on class CL_RSDRS_ADABASD_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20090821

Method BUILD_TOP_WHERE Signature

Method BUILD_TOP_WHERE on class CL_RSDRS_ADABASD_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20090821

Method BUILD_WHERE_LIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SUBQUERY_ID	Call by reference	☐	Type reference (TYPE)	RSDRS_SUBQUERY_ID		ID of actual subquery	20031120
2	Importing	I_TRANS_DEL	Call by reference	☐	Type reference (TYPE)	RS_BOOL	RS_C_TRUE	Boolean	20050809
3	Importing	I_T_WHERE	Call by reference	☐	Type reference (TYPE)	RSDRS_T_WHERE		Where List	20031120

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031120

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SX_QUERY	Call by reference	☐	Type reference (TYPE)	RSDRS_SX_QUERY		Quey description	20031120

Method CONSTRUCTOR on class CL_RSDRS_ADABASD_SQL_STMT has no exception.

Method DET_DATAMART_AGGR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	E_SUPP_AGGR	Value transfer	☐	Type reference (TYPE)	RS_BOOL		Boolean	20090212

Method DET_DATAMART_AGGR on class CL_RSDRS_ADABASD_SQL_STMT has no exception.

Method DET_HIER_FACTOR Signature

Method DET_HIER_FACTOR on class CL_RSDRS_ADABASD_SQL_STMT has no parameter.
Method DET_HIER_FACTOR on class CL_RSDRS_ADABASD_SQL_STMT has no exception.

Method FIND_FACTVIEW Signature

Method FIND_FACTVIEW on class CL_RSDRS_ADABASD_SQL_STMT has no parameter.
Method FIND_FACTVIEW on class CL_RSDRS_ADABASD_SQL_STMT has no exception.

Method GET_STARTTAB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	E_STARTTAB	Value transfer	☐	Type reference (TYPE)	RSDRS_ALIAS		Starting table	20031120
2	Importing	I_TH_TABLE	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_TABLE		Table list to find starttab in	20031120

Method GET_STARTTAB on class CL_RSDRS_ADABASD_SQL_STMT has no exception.

Method PROCESS_FACTVIEW Signature

Method PROCESS_FACTVIEW on class CL_RSDRS_ADABASD_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20031120

Method PROCESS_TOPQUERY Signature

Method PROCESS_TOPQUERY on class CL_RSDRS_ADABASD_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20060516

Method PROCESS_TOPQUERY_ABAP Signature

Method PROCESS_TOPQUERY_ABAP on class CL_RSDRS_ADABASD_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20091020

Method PROCESS_TOPQUERY_DB Signature

Method PROCESS_TOPQUERY_DB on class CL_RSDRS_ADABASD_SQL_STMT has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	Generated Stmt is too long ...	20091020

Method REMOVE_REDUNDANT_CONDITIONS Signature

Method REMOVE_REDUNDANT_CONDITIONS on class CL_RSDRS_ADABASD_SQL_STMT has no parameter.
Method REMOVE_REDUNDANT_CONDITIONS on class CL_RSDRS_ADABASD_SQL_STMT has no exception.

Method SET_F4_OPTIMIZATION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	E_F4_OPT_POSSIBLE	Value transfer	☐	Type reference (TYPE)	RS_BOOL		Boolean	20090821

Method SET_F4_OPTIMIZATION on class CL_RSDRS_ADABASD_SQL_STMT has no exception.

Method SPLIT_HEADER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_T_CODE	Call by reference	☐	Type reference (TYPE)	RSDRS_T_ABAPSOURCE			20060120
2	Exporting	E_T_HEADER	Call by reference	☐	Type reference (TYPE)	RSDRS_T_ABAPSOURCE			20060120

Method SPLIT_HEADER on class CL_RSDRS_ADABASD_SQL_STMT has no exception.

Method WRITE_JOIN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TH_TBLS_JOINED	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_TABLE		Tables that have already been joined	20031120
2	Changing	C_TS_JOIN	Call by reference	☐	Type reference (TYPE)	RSDRS_TS_JOIN		Join list to work on	20031120
3	Importing	I_STARTTAB	Call by reference	☐	Type reference (TYPE)	RSDRS_ALIAS		Table to start with	20031120
4	Importing	I_TH_TABLE	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_TABLE		List of Tables	20031120

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031120

Method WRITE_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_TH_TBLS_JOINED	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_TABLE		tables already joined	20031120
2	Importing	I_TABALIAS	Call by reference	☐	Type reference (TYPE)	RSDRS_ALIAS		alias of table to write	20031120
3	Importing	I_TH_TABLE	Call by reference	☐	Type reference (TYPE)	RSDRS_TH_TABLE		list of tables	20031120

#	Exception	Resumable	Description	Created on
1	CX_RSDRS_STMT_TOO_LONG	☐	SQL-Statement ist zu groß	20031120

History

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