SAP ABAP Class CL_RSDRS_DB6_SQL_STMT (Generate a DB6 SQL Statement)
Hierarchy
SAP_BW (Software Component) SAP Business Warehouse
   BW-SYS-DB-DB6 (Application Component) BW DB2 Universal Database
     RSDB6 (Package) BW: Port DB6
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 20040130
Properties
Class CL_RSDRS_DB6_SQL_STMT  
Short Description Generate a DB6 SQL Statement    
Super Class    
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package RSDB6   BW: Port DB6 
Created 20040130   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 RSDB6 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 RSDRS Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
6 RSDU 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 20040130
Friends
# Friend Modeled only Created on Description
1 CL_RSDRS_DB6_EXITS 20040130 Database dependent exits for DB6
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 P_ACCESSTP Instance attribute Private Type reference (TYPE) RSDRS_ACCESSTP Access type of statement 20110429
2 P_FACTVIEW Instance attribute Private Type reference (TYPE) RSD_TABLNM View of union all Table 20040422
3 P_HIER_FACTOR Instance attribute Private Type reference (TYPE) STRING correction factor for unambiguous hierarchies 20040130
4 P_R_EXIT_OBJ Instance attribute Private Object reference (TYPE REF TO) CL_RSDRS_DB6_EXITS Reference to Database specific exits 20040130
5 P_SRV_OBJ Instance attribute Private Object reference (TYPE REF TO) CL_RSDRS_STMT_SRVS Service Object for Statement Creation 20040130
6 P_SX_QUERY Instance attribute Private Type reference (TYPE) RSDRS_SX_QUERY query definition 20040130
7 P_TH_PARTQUERY Instance attribute Private Type reference (TYPE) TP_TH_PARTQUERY 20110429
8 P_T_CODE Instance attribute Private Type reference (TYPE) RSDRS_T_ABAPSOURCE Generated Code 20040130
9 P_USE_DBOPT Instance attribute Private Type reference (TYPE) RS_BOOL Use DB optimizer features 20050218
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 20040421
2 BUILD_DELETE_HEADER Instance method Private Method For db_delete build delete header 20050510
3 BUILD_F4_SELECT Instance method Private Method Build starting. Select list for fact view 20110429
4 BUILD_F4_UNIONS Instance method Private Method Changes or-ed subselects with in into union selects 20110429
5 BUILD_F4_WHERE Instance method Private Method Changes or-ed subselects with in into union selects 20110429
6 BUILD_FFNRO_CLAUSE Instance method Private Method Add FETCH FIRST N ROWS ONLY (ffnro) Clause to Delete 20050726
7 BUILD_FORMULA Instance method Private Method Build Select List Entry for a Key Figure 20071120
8 BUILD_FROM_JOINS Instance method Private Method Build the from list with join conditions (ANSI Notation) 20040421
9 BUILD_GROUPBY_LIST Instance method Private Method Build group by part of statement 20040421
10 BUILD_HAVING_LIST Instance method Private Method Build the have list (not used currently) 20040421
11 BUILD_HINT Instance method Protected Method build hint for SQL stmt 20040130
12 BUILD_INSERT_HEADER Instance method Private Method For db_insert or db_create build insert list, drop indexes 20040421
13 BUILD_KYF_SELECT Instance method Private Method Build Select List Entry for a Key Figure 20040421
14 BUILD_ORDERBY Instance method Private Method build order by list 20040421
15 BUILD_OUTER Instance method Private Method build a single outer join condition 20040421
16 BUILD_SUBQUERY Instance method Private Method build a subquery. Subqueries may occur within where cond. 20040421
17 BUILD_TOP_SELECT Instance method Private Method Build Starting Select List for Factview 20060318
18 BUILD_TOP_WHERE Instance method Private Method Build Starting Select List for Factview 20060318
19 BUILD_WHERE_LIST Instance method Private Method Build the where list (without the join part) 20040421
20 CHECK_F4_SUBSELECTS Instance method Private Method Changes the factview into two union all connected star joins 20110429
21 CONSTRUCTOR Instance method Public Constructor CONSTRUCTOR 20040130
22 DET_DEL_PACKSIZE Instance method Private Method Determination of Package Size for Deletion 20050726
23 DET_HIER_FACTOR Instance method Private Method Determine the correction factor for unambiguous hierarchies 20040422
24 FIND_FACTVIEW Instance method Private Method Changes the factview into two union all connected star joins 20040422
25 GET_STARTTAB Instance method Private Method Get starting table for join conditions 20040422
26 PROCESS_FACTVIEW Instance method Private Method Changes the factview into two union all connected star joins 20040422
27 PROCESS_ROWNUM_ON_TABLE Instance method Private Method Process row number on table 20090116
28 PROCESS_TOPQUERY Instance method Private Method Processes the Top/Bottom Sum/Percent Query 20060318
29 REMOVE_PACKAGE_DIMENSION Instance method Private Method Remove join with package dimension 20050303
30 REMOVE_REDUNDANT_CONDITIONS Instance method Private Method Deletes Redundant Time and Package Restrictions 20080310
31 REMOVE_TIME_RESTRICTION Instance method Private Method Remove restrictions on dimension time 20050512
32 SET_BW_QUERY_NAME Instance method Private Method Set BW query name in SQL comment and DB application 20090826
33 SPLIT_HEADER Instance method Private Method Splits statement into header and select stmt 20060318
34 WRITE_JOIN Instance method Private Method recurse over from list and join tables together 20040422
35 WRITE_TABLE Instance method Private Method write a table entry of the from list 20040422
Events
Class CL_RSDRS_DB6_SQL_STMT has no event.
Types
# Type Visibility Typing Associated Type Description Created on Type Source
1 TP_S_PARTQUERY Private See coding 20110429 BEGIN OF tp_s_partquery, id TYPE rsdrs_subquery_id, num TYPE i, END OF tp_s_partquery
2 TP_TH_PARTQUERY Private See coding 20110429 tp_th_partquery TYPE HASHED TABLE OF tp_s_partquery WITH UNIQUE KEY id
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 20040421
2 Importing I_S_CHA Call by reference Type reference (TYPE) RSDRS_S_CHA actual characteristic to build entry for 20040421
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20040421

Method BUILD_DELETE_HEADER Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_PACKSIZE Call by reference Type reference (TYPE) I Packetgroesse fuer Daten Loeschen 20050726
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20050510

Method BUILD_F4_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 Groupby Needed ? 20110429
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20110429

Method BUILD_F4_UNIONS Signature

Method BUILD_F4_UNIONS on class CL_RSDRS_DB6_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20110429

Method BUILD_F4_WHERE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_T_SEL_CODE Call by reference Type reference (TYPE) RSDRS_T_ABAPSOURCE Common part of f4 inner selects 20110429
2 Returning R_T_CODE Value transfer Type reference (TYPE) RSDRS_T_ABAPSOURCE Complete f4 inner statement 20110429
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20110429

Method BUILD_FFNRO_CLAUSE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_PACKSIZE Call by reference Type reference (TYPE) I Packetgroesse fuer Daten Loeschen 20050726
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20050726

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 20071120
2 Importing I_T_FORM_FLD Call by reference Type reference (TYPE) RSDRS_T_FORM_FLD factor for unambigous hierarchies 20071120
3 Returning R_FORMULA Value transfer Type reference (TYPE) STRING Resolved Formula 20071120
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20071120

Method BUILD_FROM_JOINS 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 20090116
2 Importing I_TH_JOIN Call by reference Type reference (TYPE) RSDRS_TH_JOIN List of inner join conditions 20040421
3 Importing I_TH_TABLE Call by reference Type reference (TYPE) RSDRS_TH_TABLE Table List 20040421
4 Importing I_TX_LEFTOUTER Call by reference Type reference (TYPE) RSDRS_TX_LEFTOUTER list of left outer joins 20040421
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20040421

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 20040421
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20040421

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 20040421
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20040421

Method BUILD_HINT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_RC Call by reference Type reference (TYPE) I Return Code; OK=0 20050223
2 Exporting E_T_HINT Call by reference Type reference (TYPE) RSDB6_T_HINT Final statement hints 20050223

Method BUILD_HINT on class CL_RSDRS_DB6_SQL_STMT has no exception.

Method BUILD_INSERT_HEADER Signature

Method BUILD_INSERT_HEADER on class CL_RSDRS_DB6_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20040421

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 20040421
2 Importing I_SEPARATOR Call by reference Type reference (TYPE) RSDRS_SEP Separator for select list 20040421
3 Importing I_S_KYF Call by reference Type reference (TYPE) RSDRS_S_KYF key figure description 20040421
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20040421

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 20040421
2 Importing I_USE_RETALIAS Call by reference Type reference (TYPE) RS_BOOL RS_C_TRUE Boolean 20090116
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20040421

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 20040421
2 Importing I_PARENTHESIS Call by reference Type reference (TYPE) RS_BOOL paranthesis before left outer 20041129
3 Importing I_SX_LEFTOUTER Call by reference Type reference (TYPE) RSDRS_SX_LEFTOUTER left outer condition to build 20040421
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20040421

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 20040421
2 Importing I_SX_SUBQUERY Call by reference Type reference (TYPE) RSDRS_SX_SUBQUERY Subquery description 20040421
3 Importing I_S_WHERE Call by reference Type reference (TYPE) RSDRS_S_WHERE Surrounding where statement 20040421
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20050224

Method BUILD_TOP_SELECT Signature

Method BUILD_TOP_SELECT on class CL_RSDRS_DB6_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20060318

Method BUILD_TOP_WHERE Signature

Method BUILD_TOP_WHERE on class CL_RSDRS_DB6_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20060318

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 20040421
2 Importing I_T_WHERE Call by reference Type reference (TYPE) RSDRS_T_WHERE Where List 20040421
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20041015

Method CHECK_F4_SUBSELECTS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning R_F4_SUBQUERY Value transfer Type reference (TYPE) RS_BOOL Boolean 20110429
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20110429

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 20040130

Method CONSTRUCTOR on class CL_RSDRS_DB6_SQL_STMT has no exception.

Method DET_DEL_PACKSIZE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing C_T_WHERE Call by reference Type reference (TYPE) RSDRS_T_WHERE 20051129
2 Exporting E_PACKSIZE Call by reference Type reference (TYPE) I Packetgroesse fuer Daten Loeschen 20050726

Method DET_DEL_PACKSIZE on class CL_RSDRS_DB6_SQL_STMT has no exception.

Method DET_HIER_FACTOR Signature

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

Method FIND_FACTVIEW Signature

Method FIND_FACTVIEW on class CL_RSDRS_DB6_SQL_STMT has no parameter.
Method FIND_FACTVIEW on class CL_RSDRS_DB6_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 20040422
2 Importing I_TH_TABLE Call by reference Type reference (TYPE) RSDRS_TH_TABLE Table list to find starttab in 20040422

Method GET_STARTTAB on class CL_RSDRS_DB6_SQL_STMT has no exception.

Method PROCESS_FACTVIEW Signature

Method PROCESS_FACTVIEW on class CL_RSDRS_DB6_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20040422

Method PROCESS_ROWNUM_ON_TABLE 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 20090116
2 Importing I_S_TABLE Call by reference Type reference (TYPE) RSDRS_S_TABLE 20090116
3 Returning R_PROCESSED Value transfer Type reference (TYPE) RS_BOOL Boolean 20090116
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20090116

Method PROCESS_TOPQUERY Signature

Method PROCESS_TOPQUERY on class CL_RSDRS_DB6_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20060318

Method REMOVE_PACKAGE_DIMENSION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing C_TH_JOIN Call by reference Type reference (TYPE) RSDRS_TH_JOIN 20050303
2 Changing C_TH_TABLE Call by reference Type reference (TYPE) RSDRS_TH_TABLE 20050303
3 Changing C_TX_LEFTOUTER Call by reference Type reference (TYPE) RSDRS_TX_LEFTOUTER 20050303
4 Changing C_T_WHERE Call by reference Type reference (TYPE) RSDRS_T_WHERE 20050303

Method REMOVE_PACKAGE_DIMENSION on class CL_RSDRS_DB6_SQL_STMT has no exception.

Method REMOVE_REDUNDANT_CONDITIONS Signature

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

Method REMOVE_TIME_RESTRICTION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing C_TH_JOIN Call by reference Type reference (TYPE) RSDRS_TH_JOIN 20050512
2 Changing C_TH_TABLE Call by reference Type reference (TYPE) RSDRS_TH_TABLE 20050512
3 Changing C_TX_LEFTOUTER Call by reference Type reference (TYPE) RSDRS_TX_LEFTOUTER 20050512
4 Changing C_T_WHERE Call by reference Type reference (TYPE) RSDRS_T_WHERE 20050512

Method REMOVE_TIME_RESTRICTION on class CL_RSDRS_DB6_SQL_STMT has no exception.

Method SET_BW_QUERY_NAME Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing C_HINT Call by reference Type reference (TYPE) RSDB6_HINT 20090826

Method SET_BW_QUERY_NAME on class CL_RSDRS_DB6_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 Statement without header 20060318
2 Exporting E_T_HEADER Call by reference Type reference (TYPE) RSDRS_T_ABAPSOURCE Header 20060318

Method SPLIT_HEADER on class CL_RSDRS_DB6_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 20040422
2 Changing C_TS_JOIN Call by reference Type reference (TYPE) RSDRS_TS_JOIN Join list to work on 20040422
3 Importing I_STARTTAB Call by reference Type reference (TYPE) RSDRS_ALIAS Table to start with 20040422
4 Importing I_SUBQUERY_ID Call by reference Type reference (TYPE) RSDRS_SUBQUERY_ID 20090116
5 Importing I_TH_TABLE Call by reference Type reference (TYPE) RSDRS_TH_TABLE List of Tables 20040422
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL-Statement ist zu groß 20040422

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 20040422
2 Importing I_SUBQUERY_ID Call by reference Type reference (TYPE) RSDRS_SUBQUERY_ID 20090116
3 Importing I_TABALIAS Call by reference Type reference (TYPE) RSDRS_ALIAS alias of table to write 20040422
4 Importing I_TH_TABLE Call by reference Type reference (TYPE) RSDRS_TH_TABLE list of tables 20040422
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20040422
History
Last changed by/on SAP  20130531 
SAP Release Created in 700