SAP ABAP Class CL_RSR_SQL_COMMAND (Execution of SQL (XML/A))
Hierarchy
☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-OT (Application Component) OLAP Technology
     ⤷ RSR_SQL (Package) SQL Execution in XML for Analysis
Properties
Class CL_RSR_SQL_COMMAND  
Short Description Execution of SQL (XML/A)    
Super Class    
Instantiability of a Class 0  Private 
Final    
General Data
Message Class    
Program status     
Category 0   
Package RSR_SQL   SQL Execution in XML for Analysis 
Created 20060321   SAP 
Last change 20130531   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
# Type group / Object type Type Type Description
1 RRT1 Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
2 RRTDP Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
3 RS 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)
Interfaces
Class CL_RSR_SQL_COMMAND has no interface implemented.
Friends
# Friend Modeled only Created on Description
1 CL_RSR_SQL_CONDITION 20060328 SQL Condition (WHERE / HAVING)
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 N_C_ITEM_TP Constant Public See coding 20060328
2 N_PARSER_DEST Static Attribute Public Type reference (TYPE) RFCDEST 'MDX PARSER' Logical destination (specified when calling function) 20060322
3 N_R_META Instance attribute Public Object reference (TYPE REF TO) CL_RSR_SQL_META_DATA Metadata for SQL (XML/A) 20060321
4 N_SQL Instance attribute Public Type reference (TYPE) STRING 20060321
5 N_STATE Instance attribute Public Type reference (TYPE) CHAR1 Single-Character Indicator 20060321
6 P_CAT_NAM Instance attribute Private Type reference (TYPE) BAPI6115TAB-CAT_NAM CATALOG to which the CUBE belongs 20060321
7 P_ERROR Static Attribute Private Type reference (TYPE) STRING 20060328
8 P_ID Instance attribute Private Type reference (TYPE) BAPI6111GEN-OBJ_HANDLE BW: General Reference Field for Internal IDs 20060321
9 P_MAX_ID Static Attribute Private Type reference (TYPE) BAPI6111GEN-OBJ_HANDLE BW: General Reference Field for Internal IDs 20060321
10 P_PARAM_INDEX Instance attribute Private Type reference (TYPE) I 20060321
11 P_R_DTA Instance attribute Private Object reference (TYPE REF TO) CL_RSR_SQL_META_DATA_DTA 20060404
12 P_R_HAVING Instance attribute Private Object reference (TYPE REF TO) CL_RSR_SQL_CONDITION SQL Condition (WHERE / HAVING) 20060328
13 P_R_WHERE Instance attribute Private Object reference (TYPE REF TO) CL_RSR_SQL_CONDITION SQL Condition (WHERE / HAVING) 20060328
14 P_TH_REF Static Attribute Private See coding 20060321
15 P_T_CMD Instance attribute Private Type reference (TYPE) RRT1_T_CMD 20060321
16 P_T_COND Instance attribute Private See coding 20060328
17 P_T_GROUP_BY Instance attribute Private Type reference (TYPE) TN_T_ITEM 20060328
18 P_T_ITEM Instance attribute Private Type reference (TYPE) TN_T_ITEM 20060328
19 P_T_ORDER_BY Instance attribute Private Type reference (TYPE) TN_T_ITEM 20060328
20 P_T_PARAM Instance attribute Private Type reference (TYPE) RRT1_T_CMD_PARAMS 20060321
21 P_T_SELECT Instance attribute Private Type reference (TYPE) TN_T_ITEM 20060328
Methods
# Method Level Visibility Method type Description Created on
1 CLASS_CONSTRUCTOR Static method Public Constructor 20070403
2 CONSTRUCTOR Instance method Public Constructor CONSTRUCTOR 20060321
3 CREATE Static method Public Method 20060321
4 FETCH Instance method Public Method 20060404
5 FREE Instance method Public Method 20060321
6 GET Static method Public Method 20060321
7 GET_ID Instance method Public Method 20060321
8 OPEN_CURSOR Instance method Public Method 20060328
9 PARSE Instance method Public Method 20060321
10 POP_COND Instance method Private Method 20060328
11 POP_ITEM Instance method Private Method 20060328
12 POP_PARAM Instance method Private Method 20060327
13 PUSH_COND Instance method Private Method 20060328
14 PUSH_ITEM Instance method Private Method 20060328
15 REMOVE_DELIMITERS Static method Public Method 20060327
16 SET_SQL Instance method Public Method 20060404
17 TRANSFORM Instance method Private Method 20060328
Events
Class CL_RSR_SQL_COMMAND has no event.
Types
# Type Visibility Typing Associated Type Description Created on Type Source
1 TN_S_ITEM Public See coding 20060328 BEGIN OF tn_s_item, tp TYPE char1, val TYPE rrt1_s_cmd_params-cmd_param1, aggr TYPE rrtcmdid, dsc TYPE rs_bool, alias TYPE rsalias, END OF tn_s_item
2 TN_S_SELECT Public See coding 20060328 BEGIN OF tn_s_select, iobjnm TYPE rsiobjnm, position TYPE i, END OF tn_s_select
3 TN_TH_SELECT Public See coding 20060404 tn_th_select TYPE HASHED TABLE OF tn_s_item-val WITH UNIQUE KEY table_line INITIAL SIZE 0
4 TN_T_ITEM Public See coding 20060328 tn_t_item TYPE STANDARD TABLE OF tn_s_item WITH NON-UNIQUE KEY table_line INITIAL SIZE 0
Method Signatures

Method CLASS_CONSTRUCTOR Signature

Method CLASS_CONSTRUCTOR on class CL_RSR_SQL_COMMAND has no parameter.
Method CLASS_CONSTRUCTOR on class CL_RSR_SQL_COMMAND has no exception.

Method CONSTRUCTOR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_CAT_NAM Call by reference Type reference (TYPE) BAPI6115TAB-CAT_NAM CATALOG zu dem der CUBE gehört 20060321

Method CONSTRUCTOR on class CL_RSR_SQL_COMMAND has no exception.

Method CREATE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_CAT_NAM Call by reference Type reference (TYPE) BAPI6115TAB-CAT_NAM CATALOG zu dem der CUBE gehört 20060321
2 Importing I_SQL Call by reference Type reference (TYPE) STRING 20060327
3 Importing I_T_SQL Call by reference Type reference (TYPE) RRT1_T_CMD_TXT 20060321
4 Returning R_R_SQL Value transfer Object reference (TYPE REF TO) CL_RSR_SQL_COMMAND Ausführung eines SQLs (XML/A) 20060321
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: Allgemeine Fehlerklasse 20060321
2 CX_SY_CREATE_DATA_ERROR System-Exception bei Datenerzeugung 20060321

Method FETCH Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_T_COLUMNS Call by reference Type reference (TYPE) RRTDP_T_COLUMNS 20060404
2 Exporting E_T_DATA Call by reference Type reference (TYPE) RRTDP_T_DATA 20060404
# Exception Resumable Description Created on
1 CX_RSR_MDX_EMPTY 20060404
2 CX_RS_ERROR BW: Allgemeine Fehlerklasse 20060404

Method FREE Signature

Method FREE on class CL_RSR_SQL_COMMAND has no parameter.
Method FREE on class CL_RSR_SQL_COMMAND has no exception.

Method GET Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_ID Call by reference Type reference (TYPE) BAPI6111GEN-OBJ_HANDLE BW: Allgemeines Bezugsfeld für interne IDs 20060321
2 Returning R_R_SQL Value transfer Object reference (TYPE REF TO) CL_RSR_SQL_COMMAND Ausführung eines SQLs (XML/A) 20060321
# Exception Resumable Description Created on
1 CX_RS_NOT_FOUND Objekt nicht gefunden 20060321

Method GET_ID Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning R_ID Value transfer Type reference (TYPE) BAPI6111GEN-OBJ_HANDLE BW: Allgemeines Bezugsfeld für interne IDs 20060321

Method GET_ID on class CL_RSR_SQL_COMMAND has no exception.

Method OPEN_CURSOR Signature

Method OPEN_CURSOR on class CL_RSR_SQL_COMMAND has no parameter.
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: Allgemeine Fehlerklasse 20060328

Method PARSE Signature

Method PARSE on class CL_RSR_SQL_COMMAND has no parameter.
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: Allgemeine Fehlerklasse 20060321

Method POP_COND Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_TEST_ONLY Value transfer Type reference (TYPE) RS_BOOL RS_C_FALSE Boolean 20060328
2 Returning R_R_COND Value transfer Object reference (TYPE REF TO) CL_RSR_SQL_CONDITION SQL Begindung (WHERE / HAVING) 20060328

Method POP_COND on class CL_RSR_SQL_COMMAND has no exception.

Method POP_ITEM Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_TEST_ONLY Value transfer Type reference (TYPE) RS_BOOL RS_C_FALSE Boolean 20060328
2 Returning R_S_ITEM Value transfer Type reference (TYPE) TN_S_ITEM 20060328
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: Allgemeine Fehlerklasse 20060328

Method POP_PARAM Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_PARAM Call by reference Type reference (TYPE) SIMPLE 20060327
2 Importing I_TEST_ONLY Value transfer Type reference (TYPE) RS_BOOL RS_C_FALSE Boolean 20060327
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: Allgemeine Fehlerklasse 20060327

Method PUSH_COND Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_R_COND Call by reference Object reference (TYPE REF TO) CL_RSR_SQL_CONDITION SQL Begindung (WHERE / HAVING) 20060328

Method PUSH_COND on class CL_RSR_SQL_COMMAND has no exception.

Method PUSH_ITEM Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_AGGR Value transfer Type reference (TYPE) RRTCMDID id of a tensor processor command 20060328
2 Importing I_ALIAS Value transfer Type reference (TYPE) RSALIAS BW-DM Feldalias (darf nicht länger als 18 werden ! ) 20060410
3 Importing I_DSC Value transfer Type reference (TYPE) RS_BOOL Boolean 20060328
4 Importing I_TP Call by reference Type reference (TYPE) CHAR1 Einstelliges Kennzeichen 20060328
5 Importing I_VAL Call by reference Type reference (TYPE) RRT1_S_CMD_PARAMS-CMD_PARAM1 20060328

Method PUSH_ITEM on class CL_RSR_SQL_COMMAND has no exception.

Method REMOVE_DELIMITERS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing C_PARAM Call by reference Type reference (TYPE) C 20060327

Method REMOVE_DELIMITERS on class CL_RSR_SQL_COMMAND has no exception.

Method SET_SQL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_SQL Call by reference Type reference (TYPE) STRING 20060404
2 Importing I_T_SQL Call by reference Type reference (TYPE) RRT1_T_CMD_TXT 20060404

Method SET_SQL on class CL_RSR_SQL_COMMAND has no exception.

Method TRANSFORM Signature

Method TRANSFORM on class CL_RSR_SQL_COMMAND has no parameter.
# Exception Resumable Description Created on
1 CX_RS_ERROR BW: Allgemeine Fehlerklasse 20060328
History
Last changed by/on SAP  20130531 
SAP Release Created in 710