SAP ABAP Class CL_RSDRS_ORACLE_SQL_STMT (Generate an Oracle SQL Statement)
Hierarchy
☛
SAP_BW (Software Component) SAP Business Warehouse
⤷
BW-BEX-OT (Application Component) OLAP Technology
⤷
RSORA (Package) BW: Oracle Porting
SAP_BW (Software Component) SAP Business Warehouse⤷
BW-BEX-OT (Application Component) OLAP Technology⤷
RSORA (Package) BW: Oracle PortingMeta 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 | 20030403 |
Properties
| Class | CL_RSDRS_ORACLE_SQL_STMT | |
| Short Description | Generate an Oracle SQL Statement | |
| Super Class | ||
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | RSORA | BW: Oracle Porting |
| Created | 20030224 | 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 | 20030403 |
Friends
| # | Friend | Modeled only | Created on | Description |
|---|---|---|---|---|
| 1 | CL_RSDRS_ORACLE_EXITS | 20030228 | Database dependent exits for Oracle |
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) | 20050125 | |
| 2 | P_F4_SUBSELECTS |
Instance attribute | Private | Type reference (TYPE) | RS_BOOL | RS_C_FALSE | Special treatment for subselects for F4-Help | 20060420 | |
| 3 | P_FACTALIAS |
Instance attribute | Private | Type reference (TYPE) | RSDRS_ALIAS | Alias of fact table | 20060420 | ||
| 4 | P_FACTVIEW |
Instance attribute | Private | Type reference (TYPE) | RSD_TABLNM | View of union all Table | 20031030 | ||
| 5 | P_HIER_FACTOR |
Instance attribute | Private | Type reference (TYPE) | STRING | correction factor for unambiguous hierarchies | 20030224 | ||
| 6 | P_INNER_GROUPBY |
Instance attribute | Private | Type reference (TYPE) | RS_BOOL | RS_C_TRUE | Group by in inner SQL statement (if factview used) | 20050413 | |
| 7 | P_R_EXIT_OBJ |
Instance attribute | Private | Object reference (TYPE REF TO) | CL_RSDRS_ORACLE_EXITS | Reference to Database specific exits | 20030228 | ||
| 8 | P_SRV_OBJ |
Instance attribute | Private | Object reference (TYPE REF TO) | CL_RSDRS_STMT_SRVS | Service Object for Statement Creation | 20030224 | ||
| 9 | P_SX_QUERY |
Instance attribute | Private | Type reference (TYPE) | RSDRS_SX_QUERY | query definition | 20030403 | ||
| 10 | P_TH_PARTQUERY |
Instance attribute | Private | Type reference (TYPE) | TP_TH_PARTQUERY | Part query description for F4 subselects | 20060420 | ||
| 11 | P_T_CODE |
Instance attribute | Private | Type reference (TYPE) | RSDRS_T_ABAPSOURCE | Generated Code | 20030403 | ||
| 12 | P_T_FACTVIEW_HEADER |
Instance attribute | Private | Type reference (TYPE) | RSDRS_T_ABAPSOURCE | Header in Case of Fact View | 20070313 | ||
| 13 | P_USE_DBOPT |
Instance attribute | Private | Type reference (TYPE) | RS_BOOL | Use DB optimizer features | 20050113 |
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 | 20030224 |
| 2 | BUILD_DELETE_HEADER |
Instance method | Private | Method | For db_delete build delete header | 20050421 |
| 3 | BUILD_F4_SELECT |
Instance method | Private | Method | Build starting select list for factview | 20060420 |
| 4 | BUILD_FACTVIEW_HAVING |
Instance method | Private | Method | Build starting select list for factview | 20041029 |
| 5 | BUILD_FACTVIEW_ORDERBY |
Instance method | Private | Method | Build the final orderby clause for the factview | 20041027 |
| 6 | BUILD_FACTVIEW_SELECT |
Instance method | Private | Method | Build starting select list for factview | 20041027 |
| 7 | BUILD_FORMULA |
Instance method | Private | Method | Build Select List Entry for a Key Figure | 20071115 |
| 8 | BUILD_FROM_JOINS |
Instance method | Private | Method | Build the from list with join conditions (ANSI Notation) | 20030224 |
| 9 | BUILD_GROUPBY_LIST |
Instance method | Private | Method | Build group by part of statement | 20030224 |
| 10 | BUILD_HAVING_LIST |
Instance method | Private | Method | Build the have list (not used currently) | 20030224 |
| 11 | BUILD_HINT |
Instance method | Protected | Method | build hint for SQL stmt | 20030228 |
| 12 | BUILD_INSERT_HEADER |
Instance method | Private | Method | For db_insert or db_create build insert list, drop indexes | 20030224 |
| 13 | BUILD_KYF_SELECT |
Instance method | Private | Method | Build Select List Entry for a Key Figure | 20030224 |
| 14 | BUILD_ORDERBY |
Instance method | Private | Method | build order by list | 20030224 |
| 15 | BUILD_OUTER |
Instance method | Private | Method | build a single outer join condition | 20030224 |
| 16 | BUILD_SUBQUERY |
Instance method | Private | Method | build a subquery. Subqueries may occur within where cond. | 20030224 |
| 17 | BUILD_TOP_SELECT |
Instance method | Private | Method | Build starting select list for factview | 20051006 |
| 18 | BUILD_TOP_WHERE |
Instance method | Private | Method | Build starting select list for factview | 20051006 |
| 19 | BUILD_WHERE_LIST |
Instance method | Private | Method | Build the where list (without the join part) | 20030224 |
| 20 | CHECK_F4_SUBSELECTS |
Instance method | Private | Method | Changes the factview into two union all connected star joins | 20060420 |
| 21 | CONSTRUCTOR |
Instance method | Public | Constructor | Class constructor | 20030228 |
| 22 | DET_HIER_FACTOR |
Instance method | Private | Method | Determine the correction factor for unambiguous hierarchies | 20030224 |
| 23 | FIND_FACTVIEW |
Instance method | Private | Method | Changes the factview into two union all connected star joins | 20031031 |
| 24 | |