SAP Reports / Programs
RSDRD_ORACLE_ROUTINES SAP ABAP Report - ORACLE: DB-dependent routines for deleting from the fact table
RSDRD_ORACLE_ROUTINES is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.
If you would like to execute this report or see the full code listing simply enter RSDRD_ORACLE_ROUTINES into the relevant SAP transactions such as SE38 or SE80
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT RSDRD_ORACLE_ROUTINES. "Basic submit
SUBMIT RSDRD_ORACLE_ROUTINES AND RETURN. "Return to original report after report execution complete
SUBMIT RSDRD_ORACLE_ROUTINES VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: ORACLE: DB-dependent routines for deleting from the fact table
INCLUDES used within this REPORT RSDRD_ORACLE_ROUTINES
No INCLUDES are used within this REPORT code!
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
RSD_FACTTAB_GET_FOR_CUBE call function 'RSD_FACTTAB_GET_FOR_CUBE' exporting i_infocube = l_icube importing e_comptab = l_etablnm exceptions OTHERS = 0.
RSDU_PARTITIONS_INFO_GET call function 'RSDU_PARTITIONS_INFO_GET' exporting i_tablnm = i_tablnm importing e_partype = l_parttype e_partkey = l_partkey e_ts_part_info = l_ts_part_info exceptions table_not_exists = 1 table_not_partitioned = 2 others = 3.
DB_COMMIT call function 'DB_COMMIT'.
RSDU_ANALYZE_TABLE * CALL FUNCTION 'RSDU_ANALYZE_TABLE' * EXPORTING * i_tablnm = i_tablnm * i_percentage = 10 * EXCEPTIONS * OTHERS = 8.
RSDDK_STA_ADD_DELETOR call function 'RSDDK_STA_ADD_DELETOR' exporting i_event = rssta_c_event-ic_del_end_analyze i_infocube = i_datatarget i_delmode = l_mode i_n_rec_all = l_all_cnt i_n_rec_del = l_cnt.
RSDU_CREATE_TABLE_AS_SELECT call function 'RSDU_CREATE_TABLE_AS_SELECT' exporting i_newtablnm =
-itab i_t_select = l_t_select i_reftablnm = -dbtab i_permanent = rs_c_false i_parallel_degree = i_parallel_degree changing c_t_msg = c_t_msg exceptions others = 8.
DB_EXISTS_TABLE call function 'DB_EXISTS_TABLE' exporting tabname =
-itab importing subrc = l_subrc.
RSDU_EXEC_SQL call function 'RSDU_EXEC_SQL' exporting i_t_stmt = l_t_insert importing e_sqlerr = l_sqlerr e_sqlerrtxt = l_errtxt exceptions sql_error = 1 others = 2.
RSDDK_STA_ADD_DELETOR call function 'RSDDK_STA_ADD_DELETOR' exporting i_event = rssta_c_event-ic_del_end_prep_count i_infocube = i_datatarget.
RSDU_TABLE_TRUNCATE call function 'RSDU_TABLE_TRUNCATE' exporting i_tablnm = i_tablnm exceptions inherited_error = 1 ddic_error = 2 others = 3.
RSDPW_INFOCUBE_DELETE_ALL_DATA * call function 'RSDPW_INFOCUBE_DELETE_ALL_DATA' * exporting * i_infocube = i_datatarget * changing * c_t_message = l_t_message * exceptions * illegal_input = 0 * dso_error = 0 * batch_error = 0 * inherited_error = 0 * others = 0.
RSDPW_INFOCUBE_DELETE_DATA * call function 'RSDPW_INFOCUBE_DELETE_DATA' * exporting * i_infocube = i_datatarget * changing * c_t_message = l_t_message * exceptions * illegal_input = 0 * dso_error = 0 * batch_error = 0 * inherited_error = 0 * others = 0.
RSDDK_STA_ADD_DELETOR call function 'RSDDK_STA_ADD_DELETOR' exporting i_event = rssta_c_event-ic_del_end_delete i_infocube = i_datatarget.
DB_EXISTS_TABLE CALL FUNCTION 'DB_EXISTS_TABLE' EXPORTING tabname = l_tablnm_new IMPORTING subrc = l_subrc.
RSDU_CREATE_TABLE_AS_SELECT call function 'RSDU_CREATE_TABLE_AS_SELECT' exporting i_newtablnm = l_tablnm_new i_t_select = l_t_select i_reftablnm = i_tablnm i_permanent = rs_c_true i_parallel_degree = i_parallel_degree exceptions others = 8.
DB_EXISTS_TABLE call function 'DB_EXISTS_TABLE' exporting tabname = l_tablnm_new importing subrc = l_subrc.
DB_STORAGE_SAVE CALL FUNCTION 'DB_STORAGE_SAVE' EXPORTING dbsys = sy-dbsys for_table_and_indexes = rs_c_true tabname = i_tablnm.
RSDDK_STA_ADD_DELETOR call function 'RSDDK_STA_ADD_DELETOR' exporting i_event = rssta_c_event-ic_del_end_build_tmptab i_infocube = i_datatarget.
call function 'DB_DROP_TABLE' exporting tabname = i_tablnm exceptions others = 8.
DB_RENAME_TABLE call function 'DB_RENAME_TABLE' exporting tabname_new = i_tablnm tabname_old = l_tablnm_new exceptions others = 8.
RSD_OBJECT_IS_GENERATED call function 'RSD_OBJECT_IS_GENERATED' exporting i_objnm = i_tablnm importing e_identifier = l_identifier exceptions nspacegen_invalid = 1 others = 2.
RSDGDB_AFTER_DB_MODIFICATION call function 'RSDGDB_AFTER_DB_MODIFICATION' exporting i_infocube = i_datatarget i_proc_index_for_e = l_proc_index_for_e i_proc_index_for_f = l_proc_index_for_f importing e_t_msg = c_t_msg exceptions others = 8.
RSDU_INFOCUBE_INDEXES_CREATE call function 'RSDU_INFOCUBE_INDEXES_CREATE' exporting i_infocube = i_datatarget i_facttab = i_tablnm exceptions others = 8.
DB_CREATE_PRIMARY_INDEX call function 'DB_CREATE_PRIMARY_INDEX' exporting tabname = i_tablnm importing subrc = l_subrc.
DD_CREATE_INDEX call function 'DD_CREATE_INDEX' exporting tabname = l_s_dd12l-sqltab indexname = l_s_dd12l-indexname exceptions basetab_error = 1 db_error = 2 dd_error = 3 index_exists = 4 others = 5.
DB_STORAGE_CLEAR CALL FUNCTION 'DB_STORAGE_CLEAR' EXPORTING dbsys = sy-dbsys for_table_and_indexes = rs_c_true tabname = i_tablnm.
RSDDK_STA_ADD_DELETOR call function 'RSDDK_STA_ADD_DELETOR' exporting i_event = rssta_c_event-ic_del_end_build_indexes i_infocube = i_datatarget.
RSDDTMPTAB_RELEASE_NAME * CALL FUNCTION 'RSDDTMPTAB_RELEASE_NAME' * EXPORTING * i_tmpnm = l_tablnm_new * EXCEPTIONS * delete_error = 1 * wrong_nametype = 2 * OTHERS = 3.
DB_DBUSER call function 'DB_DBUSER' importing dbuser = l_username.
RSDU_EXEC_SQL call function 'RSDU_EXEC_SQL' exporting i_stmt = l_sqlstmt importing e_sqlerr = l_sqlerr e_sqlerrtxt = l_errtxt exceptions sql_error = 1 others = 2.
RSDU_EXEC_SQL call function 'RSDU_EXEC_SQL' exporting i_stmt = l_sqlstmt importing e_sqlerr = l_sqlerr e_sqlerrtxt = l_errtxt exceptions sql_error = 1 others = 2.
RSDU_EXEC_SQL ** CALL FUNCTION 'RSDU_EXEC_SQL' ** EXPORTING ** i_t_stmt = l_t_stmt *** I_STMT = *** I_LOWER_TRANS = RS_C_FALSE *** I_ERROR_DOWNLOAD = RS_C_TRUE *** IMPORTING *** e_sqlerr = *** e_sqlerrtxt = *** e_stmtsize = ** EXCEPTIONS ** sql_error = 1 ** statement_too_complex = 2 ** no_statement = 3 ** inherited_error = 4 ** obj_not_found_or_dupl_record = 5 ** OTHERS = 6 ** .
RSDU_PARTITIONS_INFO_GET_ORA call function 'RSDU_PARTITIONS_INFO_GET_ORA' exporting i_tablnm = i_tablnm importing e_partype = l_partype e_partkey = l_partkey e_ts_part_info = l_ts_part_info changing c_processed = l_processed exceptions table_not_exists = 1 table_not_partitioned = 2 others = 3.
RSD_FIX_DIME_GET_FOR_CUBE call function 'RSD_FIX_DIME_GET_FOR_CUBE' exporting i_infocube = i_datatarget importing e_pdime = l_pdime e_ptablnm = l_dimtab e_t_dpa = l_t_dpa exceptions name_error = 1 others = 2.
RSD_DIME_GET call function 'RSD_DIME_GET' exporting i_infocube = i_datatarget i_dimension = l_pdime importing e_s_dime = l_s_dime e_s_tbhd = l_s_tbhd e_t_dimet = l_t_dimet e_tbhd_not_found = l_tbhd_not_fnd e_t_dime_iobj = l_t_dime_iobj exceptions dimension_not_found = 1 illegal_input = 2 others = 3.
RSD_SIDTAB_GET_FOR_CHA_BAS call function 'RSD_SIDTAB_GET_FOR_CHA_BAS' exporting i_chabasnm = l_sel_iobj importing e_sidtab = l_sidtab.
RRSI_VAL_SID_SINGLE_CONVERT call function 'RRSI_VAL_SID_SINGLE_CONVERT' exporting i_iobjnm = l_sel_iobj i_chavl =
-low importing e_sid = l_sid exceptions no_sid = 1 chavl_not_allowed = 2 chavl_not_figure = 3 chavl_not_plausible = 4 x_message = 5 others = 6.
RRSI_SID_VAL_SINGLE_CONVERT call function 'RRSI_SID_VAL_SINGLE_CONVERT' exporting i_iobjnm = l_sel_iobj i_sid = l_sid importing e_chavl = l_chavl exceptions no_value_for_sid = 1 x_message = 2 others = 3.
RSD_IOBJ_GET call function 'RSD_IOBJ_GET' exporting i_iobjnm = l_sel_iobj importing e_s_cob_pro = l_s_cob_pro exceptions iobj_not_found = 1 illegal_input = 2 bct_comp_invalid = 3 others = 4.
RSD_SIDNM_GET_FROM_IOBJNM call function 'RSD_SIDNM_GET_FROM_IOBJNM' exporting i_iobjnm = l_sel_iobj importing e_sidfieldnm = l_sidfld exceptions name_error = 1 others = 2.
RSD_SIDTAB_GET_FOR_CHA_BAS call function 'RSD_SIDTAB_GET_FOR_CHA_BAS' exporting i_chabasnm = l_s_cob_pro-chabasnm importing e_sidtab = l_sidtab exceptions name_error = 1 others = 2.
RSDPW_INFOCUBE_DELETE_REQUEST * call function 'RSDPW_INFOCUBE_DELETE_REQUEST' * exporting * i_infocube = i_datatarget * i_ts_sid = l_ts_sid * changing * c_t_message = l_t_message * exceptions * dso_error = 0 * inherited_error = 0 * others = 0.
RSDU_EXEC_SQL call function 'RSDU_EXEC_SQL' exporting i_stmt = l_sqlstmt importing e_sqlerr = l_sqlerr e_sqlerrtxt = l_errtxt exceptions sql_error = 1 others = 2.
RSDU_EXEC_SQL call function 'RSDU_EXEC_SQL' exporting i_stmt = l_sqlstmt importing e_sqlerr = l_sqlerr e_sqlerrtxt = l_errtxt exceptions sql_error = 1 others = 2.
RSDU_EXEC_SQL call function 'RSDU_EXEC_SQL' exporting i_t_stmt = l_t_stmt importing e_sqlerr = l_sqlerr exceptions sql_error = 1 statement_too_complex = 2 no_statement = 3 inherited_error = 4 duprec = 5 obj_exists = 6 obj_not_found = 7 others = 8.
RSDDTMPTAB_GET_NEW_TABLE call function 'RSDDTMPTAB_GET_NEW_TABLE' exporting i_nametype = rsd_c_id_tmp_tabl_sel i_drop = rs_c_true importing e_tmpnm = e_tmptablnm.
DDIF_TABL_GET call function 'DDIF_TABL_GET' exporting name = 'QUERY_TABL_MODEL' state = rsd_c_ddsta-active langu = sy-langu importing gotstate = l_got_state dd02v_wa = l_s_dd02v dd09l_wa = l_s_dd09l exceptions illegal_input = 1.
DDIF_TABL_PUT call function 'DDIF_TABL_PUT' exporting name = e_tmptablnm dd02v_wa = l_s_dd02v dd09l_wa = l_s_dd09l tables dd03p_tab = l_t_dd03p exceptions tabl_not_found = 1 name_inconsistent = 2 tabl_inconsistent = 3 put_failure = 4 put_refused = 5 others = 6.
DD_TABL_ACT call function 'DD_TABL_ACT' exporting * DEVICE = 'F' * PATH = ' ' * PROTNAME = ' ' tabname = e_tmptablnm * TIMER_ON = ' ' * PRID = 0 * ACT_MODE = 1 * AUTH_CHK = 'X' * EXCOMMIT = 'X' importing act_result = l_subrc tables act_res_tab = l_t_act_res exceptions actok_failure = 1 dbchange_failure = 2 lockact_failure = 3 ntab_gen_failure = 4 put_failure = 5 read_failure = 6 unlockact_failure = 7 access_failure = 8 others = 9.
RSDU_TABLE_TRUNCATE call function 'RSDU_TABLE_TRUNCATE' exporting i_tablnm = i_tmptablnm.
DD_TABL_DEL call function 'DD_TABL_DEL' exporting tabname = i_tmptablnm del_state = 'M'.
RSDDTMPTAB_RELEASE_NAME call function 'RSDDTMPTAB_RELEASE_NAME' exporting i_tmpnm = i_tmptablnm exceptions delete_error = 1 wrong_nametype = 2 others = 3.
RSDU_EXEC_SQL call function 'RSDU_EXEC_SQL' exporting i_t_stmt = l_t_storadel importing e_sqlerr = l_sqlerr exceptions sql_error = 1 statement_too_complex = 2 no_statement = 3 inherited_error = 4 duprec = 5 obj_exists = 6 obj_not_found = 7 others = 8.
DB_STORAGE_SAVE call function 'DB_STORAGE_SAVE' exporting * DBSYS = SY-DBSYS * PRID = 0 * FOR_TABLE_AND_INDEXES = ' ' tabname = i_tabname * INDEXNAME = ' ' * DBINDEX = ' ' * SOURCE = 'DBS' * USEFLAG = ' ' * SAVE_UNDER_TABNAME = ' ' * CORRECTION = 'X' exceptions import_error = 1 mapping_error = 2 db_error = 3 uncomplete_parameter = 4 put_error = 5 other_error = 6 others = 7.
DB_CREATE_TABLE_S call function 'DB_CREATE_TABLE_S' exporting no_exec = 'X' tabname = i_tabname tables ddfields = l_t_ddfield statements = l_t_statement exceptions program_not_generated = 1 program_not_written = 2 tparam_source_not_determinated = 3 table_exists = 4 table_not_created = 5 others = 6.
RSDU_EXEC_SQL call function 'RSDU_EXEC_SQL' exporting i_t_stmt = l_t_storadel importing e_sqlerr = l_sqlerr exceptions sql_error = 1 statement_too_complex = 2 no_statement = 3 inherited_error = 4 duprec = 5 obj_exists = 6 obj_not_found = 7 others = 8.
RSDU_CREATE_TABLE_AS_SELECT CALL FUNCTION 'RSDU_CREATE_TABLE_AS_SELECT' EXPORTING i_newtablnm =
-itab i_t_select = l_t_select i_reftablnm = -dbtab i_permanent = rs_c_false i_parallel_degree = i_parallel_degree CHANGING c_t_msg = c_t_msg EXCEPTIONS OTHERS = 8.
DB_EXISTS_TABLE CALL FUNCTION 'DB_EXISTS_TABLE' EXPORTING tabname =
-itab IMPORTING subrc = l_subrc.
RSDU_EXEC_SQL CALL FUNCTION 'RSDU_EXEC_SQL' EXPORTING i_t_stmt = l_t_insert IMPORTING e_sqlerr = l_sqlerr e_sqlerrtxt = l_errtxt EXCEPTIONS sql_error = 1 OTHERS = 2.
RSDU_EXEC_SQL CALL FUNCTION 'RSDU_EXEC_SQL' EXPORTING i_t_stmt = l_t_insert IMPORTING e_sqlerr = l_sqlerr e_sqlerrtxt = l_errtxt EXCEPTIONS sql_error = 1 OTHERS = 2.
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name RSDRD_ORACLE_ROUTINES or its description.
RSDRD_ORACLE_ROUTINES - ORACLE: DB-dependent routines for deleting from the fact table RSDRD_ORACLE_ROUTINES - ORACLE: DB-dependent routines for deleting from the fact table RSDRD_MSSQL_TMPL - MSSQL: DB-abhängige Routinen für das Löschen aus der Faktentabelle RSDRD_MSSQL_ROUTINES - MSSQL: DB-dependent routines for deleting from the fact table RSDRD_MSSQL_ROUTINES - MSSQL: DB-dependent routines for deleting from the fact table RSDRD_IMO_ROUTINES - Report RSDRD_IMO_ROUTINES