SAP ABAP Class CL_RSDRS_SYBASE_SQL_STMT (Generate an Sybase ASE SQL Statements)
Hierarchy
SAP_BW (Software Component) SAP Business Warehouse
   BW-SYS-DB-SYB (Application Component) BW on Sybase ASE Database Platform
     RSSYB (Package) SAP BW on Sybase ASE
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 20101110
Properties
Class CL_RSDRS_SYBASE_SQL_STMT  
Short Description Generate an Sybase ASE SQL Statements    
Super Class    
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package RSSYB   SAP BW on Sybase ASE 
Created 20101110   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 RSDRH Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
4 RSDRS Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
5 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 20101110
Friends
# Friend Modeled only Created on Description
1 CL_RSDRS_SYBASE_EXITS 20101221 Database dependent exits for Sybase ASE
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 N_C_ROWID_TO_ROWNUM Constant Public Type reference (TYPE) RSD_FIELDNM '#rowid2rownum' rowid to row number function (only where) 20101110
2 P_F4_SUBSELECTS Instance attribute Private Type reference (TYPE) RS_BOOL RS_C_FALSE Special treatment for subselects for F4-Help 20101110
3 P_FACTALIAS Instance attribute Private Type reference (TYPE) RSDRS_ALIAS Alias of fact table 20101110
4 P_FACTVIEW Instance attribute Private Type reference (TYPE) RSD_TABLNM View of union all Table 20101110
5 P_HIER_FACTOR Instance attribute Private Type reference (TYPE) STRING correction factor for unambiguous hierarchies 20101110
6 P_INNER_GROUPBY Instance attribute Private Type reference (TYPE) RS_BOOL RS_C_TRUE Group by in inner SQL statement (if factview used) 20101110
7 P_INS_BY_BULK Instance attribute Private Type reference (TYPE) RS_BOOL rs_c_unknown ins_by_bulk is supported 20130228
8 P_R_EXIT_OBJ Instance attribute Private Object reference (TYPE REF TO) CL_RSDRS_SYBASE_EXITS Reference to Database specific exits 20101110
9 P_SRV_OBJ Instance attribute Private Object reference (TYPE REF TO) CL_RSDRS_STMT_SRVS Service Object for Statement Creation 20101110
10 P_SX_QUERY Instance attribute Private Type reference (TYPE) RSDRS_SX_QUERY query definition 20101110
11 P_TH_PARTQUERY Instance attribute Private Type reference (TYPE) TP_TH_PARTQUERY Part query description for F4 subselects 20101110
12 P_T_CODE Instance attribute Private Type reference (TYPE) RSDRS_T_ABAPSOURCE Generated Code 20101110
13 P_T_FACTVIEW_HEADER Instance attribute Private Type reference (TYPE) RSDRS_T_ABAPSOURCE Header in Case of Fact View 20101110
14 P_USE_DBOPT Instance attribute Private Type reference (TYPE) RS_BOOL Use DB optimizer features 20101110
15 P_USE_FACTVIEW Instance attribute Private Type reference (TYPE) RS_BOOL rs_c_unknown Use fact view in queries 20110325
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 20101110
2 BUILD_DELETE_HEADER Instance method Private Method For db_delete build delete header 20101110
3 BUILD_F4_SELECT Instance method Private Method Build starting select list for factview 20101110
4 BUILD_FACTVIEW_HAVING Instance method Private Method Build starting select list for factview 20101110
5 BUILD_FACTVIEW_ORDERBY Instance method Private Method Build the final orderby clause for the factview 20101110
6 BUILD_FACTVIEW_SELECT Instance method Private Method Build starting select list for factview 20101110
7 BUILD_FORMULA Instance method Private Method Build Select List Entry for a Key Figure 20101110
8 BUILD_FROM_JOINS Instance method Private Method Build the from list with join conditions (ANSI Notation) 20101110
9 BUILD_GROUPBY_LIST Instance method Private Method Build group by part of statement 20101110
10 BUILD_HAVING_LIST Instance method Private Method Build the have list (not used currently) 20101110
11 BUILD_HINT Instance method Public Method build hint for SQL stmt 20101110
12 BUILD_INSERT_HEADER Instance method Private Method For db_insert or db_create build insert list, drop indexes 20101110
13 BUILD_KYF_SELECT Instance method Private Method Build Select List Entry for a Key Figure 20101110
14 BUILD_ORDERBY Instance method Private Method build order by list 20101110
15 BUILD_OUTER Instance method Private Method build a single outer join condition 20101110
16 BUILD_SUBQUERY Instance method Private Method build a subquery. Subqueries may occur within where cond. 20101110
17 BUILD_TOP_SELECT Instance method Private Method Build starting select list for factview 20101110
18 BUILD_TOP_WHERE Instance method Private Method Build starting select list for factview 20101110
19 BUILD_WHERE_LIST Instance method Private Method Build the where list (without the join part) 20101110
20 CHECK_F4_SUBSELECTS Instance method Private Method Changes the factview into two union all connected star joins 20101110
21 CONSTRUCTOR Instance method Public Constructor Class constructor 20101110
22 DET_HIER_FACTOR Instance method Private Method Determine the correction factor for unambiguous hierarchies 20101110
23 FIND_FACTVIEW Instance method Private Method Changes the factview into two union all connected star joins 20101110
24 GET_SELDIM Instance method Private Method Get number of dimensions with select options 20101110
25 GET_STARTTAB Instance method Private Method Get starting table for join conditions 20101110
26 PROCESS_F4_SUBSELECTS Instance method Private Method Changes or-ed subselects with in into union selects 20101110
27 PROCESS_F4_WHERE Instance method Private Method Changes or-ed subselects with in into union selects 20101110
28 PROCESS_FACTVIEW Instance method Private Method Changes the factview into two union all connected star joins 20101110
29 PROCESS_RECORDTP_RESTRICTION Instance method Private Method Add partitioning condition for recordtp restriction 20101110
30 PROCESS_STANDARD_SELECT Instance method Private Method Generate the standard SQL Statement 20101110
31 PROCESS_TOPQUERY Instance method Private Method Processes the top/bottom sum/percent query 20101110
32 SPLIT_HEADER Instance method Private Method Splits statement into header and select stmt 20101110
33 SPLIT_INLIST Instance method Private Method Build the where list (without the join part) 20101110
34 WRITE_JOIN Instance method Private Method recurse over from list and join tables together 20101110
35 WRITE_TABLE Instance method Private Method write a table entry of the from list 20101110
Events
Class CL_RSDRS_SYBASE_SQL_STMT has no event.
Types
# Type Visibility Typing Associated Type Description Created on Type Source
1 TP_S_PARTQUERY Private See coding 20101110
2 TP_TH_PARTQUERY Private See coding 20101110
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 20101110
2 Importing I_S_CHA Call by reference Type reference (TYPE) RSDRS_S_CHA actual characteristic to build entry for 20101110
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL statement is too large 20101110

Method BUILD_DELETE_HEADER Signature

Method BUILD_DELETE_HEADER on class CL_RSDRS_SYBASE_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20101110

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

Method BUILD_FACTVIEW_HAVING Signature

Method BUILD_FACTVIEW_HAVING on class CL_RSDRS_SYBASE_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20101110

Method BUILD_FACTVIEW_ORDERBY Signature

Method BUILD_FACTVIEW_ORDERBY on class CL_RSDRS_SYBASE_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20101110

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

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 20101110
2 Importing I_T_FORM_FLD Call by reference Type reference (TYPE) RSDRS_T_FORM_FLD Factor for Unambiguous Hierarchies 20101110
3 Returning R_FORMULA Value transfer Type reference (TYPE) STRING Resolved Formula 20101110
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL statement is too large 20101110

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 ID of actual subquery 20101110
2 Importing I_TH_JOIN Call by reference Type reference (TYPE) RSDRS_TH_JOIN List of inner join conditions 20101110
3 Importing I_TH_TABLE Call by reference Type reference (TYPE) RSDRS_TH_TABLE Table List 20101110
4 Importing I_TX_LEFTOUTER Call by reference Type reference (TYPE) RSDRS_TX_LEFTOUTER list of left outer joins 20101110
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL statement is too large 20101110

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 Group by 20101110
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL statement is too large 20101110

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 20101110
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL statement is too large 20101110

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 ... 20101110
2 Importing I_T_HINT Call by reference Type reference (TYPE) RSDRS_T_ABAPSOURCE Hints from Statement (if set ...) 20101110

Method BUILD_HINT on class CL_RSDRS_SYBASE_SQL_STMT has no exception.

Method BUILD_INSERT_HEADER Signature

Method BUILD_INSERT_HEADER on class CL_RSDRS_SYBASE_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL statement is too large 20101110

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 Unambiguous Hierarchies 20101110
2 Importing I_SEPARATOR Call by reference Type reference (TYPE) RSDRS_SEP Separator for select list 20101110
3 Importing I_S_KYF Call by reference Type reference (TYPE) RSDRS_S_KYF key figure description 20101110
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL statement is too large 20101110

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 order by list 20101110
2 Importing I_USE_RETALIAS Value transfer Type reference (TYPE) RS_BOOL RS_C_TRUE Use return alias if possible 20101110
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL statement is too large 20101110

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 20101110
2 Importing I_SX_LEFTOUTER Call by reference Type reference (TYPE) RSDRS_SX_LEFTOUTER left outer condition to build 20101110
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL statement is too large 20101110

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

Method BUILD_TOP_SELECT Signature

Method BUILD_TOP_SELECT on class CL_RSDRS_SYBASE_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG 20101110

Method BUILD_TOP_WHERE Signature

Method BUILD_TOP_WHERE on class CL_RSDRS_SYBASE_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG 20101110

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 20101110
2 Importing I_T_WHERE Call by reference Type reference (TYPE) RSDRS_T_WHERE Where List 20101110
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL statement is too large 20101110

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

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 Query description 20101110

Method CONSTRUCTOR on class CL_RSDRS_SYBASE_SQL_STMT has no exception.

Method DET_HIER_FACTOR Signature

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

Method FIND_FACTVIEW Signature

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

Method GET_SELDIM Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_THRESHOLD Call by reference Type reference (TYPE) I Min. number of selective dimensions needed 20101110
2 Returning R_SEL_DIM Value transfer Type reference (TYPE) I Number of selective dimensions 20101110

Method GET_SELDIM on class CL_RSDRS_SYBASE_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 20101110
2 Importing I_TH_TABLE Call by reference Type reference (TYPE) RSDRS_TH_TABLE Table list to find starttab in 20101110

Method GET_STARTTAB on class CL_RSDRS_SYBASE_SQL_STMT has no exception.

Method PROCESS_F4_SUBSELECTS Signature

Method PROCESS_F4_SUBSELECTS on class CL_RSDRS_SYBASE_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20101110

Method PROCESS_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 20101110
2 Returning R_T_CODE Value transfer Type reference (TYPE) RSDRS_T_ABAPSOURCE Complete f4 inner statement 20101110
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG Generated Stmt is too long ... 20101110

Method PROCESS_FACTVIEW Signature

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

Method PROCESS_RECORDTP_RESTRICTION Signature

Method PROCESS_RECORDTP_RESTRICTION on class CL_RSDRS_SYBASE_SQL_STMT has no parameter.
Method PROCESS_RECORDTP_RESTRICTION on class CL_RSDRS_SYBASE_SQL_STMT has no exception.

Method PROCESS_STANDARD_SELECT Signature

Method PROCESS_STANDARD_SELECT on class CL_RSDRS_SYBASE_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL statement is too large 20101110

Method PROCESS_TOPQUERY Signature

Method PROCESS_TOPQUERY on class CL_RSDRS_SYBASE_SQL_STMT has no parameter.
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG 20101110

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 20101110
2 Exporting E_T_HEADER Call by reference Type reference (TYPE) RSDRS_T_ABAPSOURCE 20101110
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG 20101110

Method SPLIT_INLIST Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_CODE Call by reference Type reference (TYPE) RSDRS_ABAPLINE left side of in statement 20101110
2 Importing I_CONNECTOR Call by reference Type reference (TYPE) RSDRS_ABAPLINE connector between the partial inlists 20101110
3 Importing I_S_WHERE Call by reference Type reference (TYPE) RSDRS_S_WHERE Where List 20101110
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL statement is too large 20101110

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 20101110
2 Changing C_TS_JOIN Call by reference Type reference (TYPE) RSDRS_TS_JOIN Join list to work on 20101110
3 Importing I_STARTTAB Call by reference Type reference (TYPE) RSDRS_ALIAS Table to start with 20101110
4 Importing I_SUBQUERY_ID Call by reference Type reference (TYPE) RSDRS_SUBQUERY_ID ID of Subquery 20101110
5 Importing I_TH_TABLE Call by reference Type reference (TYPE) RSDRS_TH_TABLE List of Tables 20101110
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL statement is too large 20101110

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 20101110
2 Importing I_SUBQUERY_ID Call by reference Type reference (TYPE) RSDRS_SUBQUERY_ID ID of Subquery 20101110
3 Importing I_TABALIAS Call by reference Type reference (TYPE) RSDRS_ALIAS alias of table to write 20101110
4 Importing I_TH_TABLE Call by reference Type reference (TYPE) RSDRS_TH_TABLE list of tables 20101110
# Exception Resumable Description Created on
1 CX_RSDRS_STMT_TOO_LONG SQL statement is too large 20101110
History
Last changed by/on SAP  20130531 
SAP Release Created in 731