SAP Reports / Programs | SAP Business Information Warehouse | Basis System and Installation | BW Microsoft SQL Server(BW-SYS-DB-MSS) SAP BW
RSDD_MSSQL_CUBEANALYZE_INCL SAP ABAP INCLUDE - Include RSDD_MSSQL_CUBEANALYZE_INCL
RSDD_MSSQL_CUBEANALYZE_INCL is a standard ABAP INCLUDE 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 RSDD_MSSQL_CUBEANALYZE_INCL 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 RSDD_MSSQL_CUBEANALYZE_INCL. "Basic submit
SUBMIT RSDD_MSSQL_CUBEANALYZE_INCL AND RETURN. "Return to original report after report execution complete
SUBMIT RSDD_MSSQL_CUBEANALYZE_INCL VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
INCLUDES used within this REPORT RSDD_MSSQL_CUBEANALYZE_INCL
GT_T_INCLUDE_COLS TYPE TABLE OF G_T_INCLUDE_COLS.
FORM DEFINE_INCLUDE_COLS_AND_CREATE
FORM REMOVE_INCLUDE_COLS_AND_CREATE
FORM FILL_INCLUDE_ALV
FORM HAS_INDEX_INCLUDES
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:
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = text-058.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = text-059.
RSD_IS_CUBE_TABLE call function 'RSD_IS_CUBE_TABLE' exporting i_tablnm = l_tabname importing e_infocube = l_infocube e_is_facttab = l_is_facttab.
RSD_IS_CUBE_TABLE call function 'RSD_IS_CUBE_TABLE' exporting i_tablnm = l_tabname importing e_infocube = l_infocube e_is_facttab = l_is_facttab.
RSD_CUBE_GET call function 'RSD_CUBE_GET' exporting i_infocube = l_infocube importing e_s_cube = l_s_cube exceptions infocube_not_found = 1 illegal_input = 2 others = 3.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = l_text.
DB_EXISTS_TABLE call function 'DB_EXISTS_TABLE' exporting tabname = l_tabname importing subrc = l_subrc.
DD_INDEX_NAME call function 'DD_INDEX_NAME' exporting indexname = '0' tabname = l_tabname importing dbindex = l_dbindex.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting dbindex = l_dbindex tabname = p_tabname importing subrc = l_subrc0 unique = l_unique0 exceptions parameter_error = 1 others = 2.
DD_INDEX_NAME call function 'DD_INDEX_NAME' exporting indexname = 'P' tabname = l_tabname importing dbindex = l_dbindexp.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting dbindex = l_dbindexp tabname = p_tabname importing subrc = l_subrcp unique = l_uniquep exceptions parameter_error = 1 others = 2.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = l_text.
DB_EXISTS_TABLE call function 'DB_EXISTS_TABLE' exporting tabname = l_tablnm importing subrc = l_subrc.
RSD_IS_CUBE_TABLE * call function 'RSD_IS_CUBE_TABLE' * exporting * i_tablnm = l_tablnm * importing * e_infocube = l_infocube * e_is_facttab = l_is_facttab.
RSDU_INFOCUBE_FACTTABLES * call function 'RSDU_INFOCUBE_FACTTABLES' * exporting * i_infocube = l_infocube * importing * e_efacttab = l_efacttab * exceptions * infocube_error = 1 * inherited_error = 2 * others = 3.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = missepk_list_s-tabname indexname = '0' importing realname = l_dbindex subrc = l_subrc unique = l_unique exceptions parameter_error = 1 others = 2.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = missepk_list_s-tabname indexname = 'P' importing realname = l_dbindex subrc = l_subrc unique = l_unique exceptions parameter_error = 1 others = 2.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = l_text.
call function 'DB_EXISTS_TABLE' exporting tabname = missfpk_list_s-tabname importing subrc = l_subrc.
RSD_IS_CUBE_TABLE call function 'RSD_IS_CUBE_TABLE' exporting i_tablnm = l_tablnm importing e_infocube = l_infocube e_is_facttab = l_is_facttab.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = missfpk_list_s-tabname indexname = 'P' importing realname = l_dbindex subrc = l_subrc unique = l_unique exceptions parameter_error = 1 others = 2.
RSDU_PART_MSS_POSSIBLE call function 'RSDU_PART_MSS_POSSIBLE' changing c_part_possible = l_part_possible.
MSS_GET_ALL_PART_OBJS call function 'MSS_GET_ALL_PART_OBJS' tables all_part_tabs = part_tabs_info_tab exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 no_objects_found = 4 others = 5. "#EC FB_RC
MSS_GET_ALL_PART_OBJS call function 'MSS_GET_ALL_PART_OBJS' tables all_part_tabs = part_tabs_info_tab exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 no_objects_found = 4 others = 5. "#EC FB_RC
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = l_text.
RSD_IS_CUBE_TABLE call function 'RSD_IS_CUBE_TABLE' exporting i_tablnm = l_tabname importing e_infocube = l_infocube e_is_facttab = l_is_facttab.
RSDU_INFOCUBE_FACTTABLES call function 'RSDU_INFOCUBE_FACTTABLES' exporting i_infocube = l_infocube importing e_ffacttab = l_ffacttab e_efacttab = l_efacttab exceptions infocube_error = 1 inherited_error = 2 others = 3.
RSDU_PARTITIONS_INFO_GET_MSS call function 'RSDU_PARTITIONS_INFO_GET_MSS' exporting i_tablnm = l_tabname 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.
POPUP_TO_CONFIRM * call function 'POPUP_TO_CONFIRM' * exporting * titlebar = l_title * text_question = * 'Do you want to add the partition to the table?' * text_button_1 = 'Yes'(001) ** ICON_BUTTON_1 = ' ' * text_button_2 = 'No'(002) ** ICON_BUTTON_2 = ' ' ** DEFAULT_BUTTON = '1' * display_cancel_button = ' ' ** USERDEFINED_F1_HELP = ' ' ** START_COLUMN = 25 ** START_ROW = 6 ** POPUP_TYPE = ** IV_QUICKINFO_BUTTON_1 = ' ' ** IV_QUICKINFO_BUTTON_2 = ' ' * importing * answer = l_answer ** TABLES ** PARAMETER = * exceptions * text_not_found = 1 * others = 2.
RSDU_TABLE_ADD_PARTITION_MSS * call function 'RSDU_TABLE_ADD_PARTITION_MSS' * exporting * i_tablnm = l_tabname * i_part_column = l_partkey * i_part_value = l_tmprequest ** IMPORTING ** E_PARTNM = * changing * c_processed = l_processed * exceptions * add_partition_failed = 1 * split_partition_failed = 2 * others = 3.
MSS_GET_ALL_PART_OBJS call function 'MSS_GET_ALL_PART_OBJS' tables all_part_tabs = part_tabs_info_tab exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 no_objects_found = 4 others = 5. "#EC FB_RC
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = l_text.
RSD_IS_CUBE_TABLE call function 'RSD_IS_CUBE_TABLE' exporting i_tablnm = l_tabname importing e_infocube = l_infocube e_is_facttab = l_is_facttab.
RSDU_INFOCUBE_FACTTABLES call function 'RSDU_INFOCUBE_FACTTABLES' exporting i_infocube = l_infocube importing e_ffacttab = l_ffacttab e_efacttab = l_efacttab exceptions infocube_error = 1 inherited_error = 2 others = 3.
RSDU_PARTITIONS_INFO_GET_MSS call function 'RSDU_PARTITIONS_INFO_GET_MSS' exporting i_tablnm = l_tabname 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_CUBE_GET call function 'RSD_CUBE_GET' exporting i_infocube = l_infocube importing e_t_dime = l_t_dime exceptions infocube_not_found = 1 illegal_input = 2 others = 3.
RSD_SIDNM_GET_FROM_IOBJNM call function 'RSD_SIDNM_GET_FROM_IOBJNM' exporting i_iobjnm = rsd_c_dpanm-requid importing e_sidfieldnm = l_sidnm exceptions name_error = 1 others = 2.
RSD_FIELDNM_GET_FOR_DIME call function 'RSD_FIELDNM_GET_FOR_DIME' exporting i_dimension = l_s_dime-dimension importing e_fieldnm = l_pdime_fieldnm exceptions name_error = 1 others = 2.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = l_text.
RSDU_PARTITIONS_INFO_GET call function 'RSDU_PARTITIONS_INFO_GET' exporting i_tablnm = l_tablnm importing e_partype = l_partype e_partkey = l_partkey e_ts_part_info = lt_ts_part_info exceptions table_not_exists = 1 table_not_partitioned = 2 inherited_error = 3 others = 4.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = l_text.
RSDU_PARTITIONS_INFO_GET call function 'RSDU_PARTITIONS_INFO_GET' exporting i_tablnm = l_tablnm importing e_partype = l_partype e_partkey = l_partkey e_ts_part_info = lt_ts_part_info exceptions table_not_exists = 1 table_not_partitioned = 2 inherited_error = 3 others = 4.
RSD_CUBE_MULTI_GET_ONLY_DB call function 'RSD_CUBE_MULTI_GET_ONLY_DB' exporting i_read_all = rs_c_true importing e_t_cube = lt_cubelist exceptions illegal_input = 1 others = 2.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = l_text.
RSDU_GET_INFOCUBE_TABLES call function 'RSDU_GET_INFOCUBE_TABLES' exporting i_infocube = l_cube-infocube importing e_th_tablnm = lt_cubetabs exceptions infocube_error = 1 inherited_error = 2 others = 3.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = l_text.
MSS_GET_DB_SIZE_INFO call function 'MSS_GET_DB_SIZE_INFO' exporting con_name = 'DEFAULT' schema = ' ' db_name = 'tempdb' importing db_sizeinfo = l_tempdbsize exceptions others = 1.
MSS_GET_TOP_N_TABLES call function 'MSS_GET_TOP_N_TABLES' exporting number = 50 order = 'L' tables large_tables = l_topntab exceptions others = 1.
DB_EXISTS_TABLE call function 'DB_EXISTS_TABLE' exporting tabname = p_tabname importing subrc = l_subrc.
MSS_GET_INDEXES call function 'MSS_GET_INDEXES' exporting table_name = p_tabname_mss tables all_indexes = p_index_tab exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 db_not_found = 4 no_db_access = 5 schema_not_found = 6 invalid_input = 7 no_indexes_found = 8 others = 9.
MSS_GET_INDEX_TYPE call function 'MSS_GET_INDEX_TYPE' exporting index_name = p_index_tab-indname table_name = p_tabname_mss * SCHEMA_NAME = * DB_NAME = importing index_type = index_type exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 db_not_found = 4 no_db_access = 5 schema_not_found = 6 invalid_input = 7 index_not_found multiple_indexes_found = 9 others = 10.
POPUP_TO_GET_ONE_VALUE ** call function 'POPUP_TO_GET_ONE_VALUE' ** exporting ** textline1 = 'F Fact table to fix' *** TEXTLINE2 = ' ' *** TEXTLINE3 = ' ' ** titel = 'F Fact table to fix' ** valuelength = 20 ** importing ** answer = answer ** value1 = value ** exceptions ** titel_too_long = 1 ** others = 2.
MSS_GET_INDEXES * call function 'MSS_GET_INDEXES' * exporting * table_name = l_tabname_mss * tables * all_indexes = l_t_all_indexes * exceptions * not_running_on_mssql = 1 * db_error = 2 * internal_error = 3 * db_not_found = 4 * no_db_access = 5 * schema_not_found = 6 * invalid_input = 7 * no_indexes_found = 8 * others = 9.
DD_INDEX_NAME call function 'DD_INDEX_NAME' exporting indexname = l_ddindex tabname = p_tabname importing dbindex = l_dbindex.
DB_DROP_INDEX * call function 'DB_DROP_INDEX' * exporting * dbindex = l_dbindex * tabname = p_tabname * exceptions * index_not_dropped = 1 * program_not_generated = 2 * program_not_written = 3 * others = 4.
DB_STORAGE_PUT * call function 'DB_STORAGE_PUT' * exporting * tabname = l_tabname * indexname = '010' * useflag = 'X' * tables * storpar = lt_storpar * exceptions * db_error = 1 * other_error = 2 * others = 3.
DD_CREATE_INDEX_S * call function 'DD_CREATE_INDEX_S' * exporting * no_exec = l_noexec * indexname = '010' * tabname = l_tabname * tables * statements = l_stmttab * exceptions * basetab_error = 1 * db_error = 2 * dd_error = 3 * index_exists = 4 * others = 5.
DD_CREATE_INDEX * call function 'DD_CREATE_INDEX' * exporting * indexname = lt_dd12l-indexname * tabname = lt_dd12l-sqltab * exceptions * basetab_error = 1 * db_error = 2 * dd_error = 3 * index_exists = 4 * others = 5.
DD_CREATE_INDEX * call function 'DD_CREATE_INDEX' * exporting * indexname = dd12l_tab-indexname * tabname = dd12l_tab-sqltab * exceptions * basetab_error = 1 * db_error = 2 * dd_error = 3 * index_exists = 4 * others = 5.
DD_TABNAME_OF_INDEX call function 'DD_TABNAME_OF_INDEX' exporting dbindex = l_dbindex importing index = l_indname exceptions index_not_in_dd = 1 others = 2.
DD_INDEX_NAME call function 'DD_INDEX_NAME' exporting indexname = '0' tabname = p_tabname importing dbindex = l_dbindex.
DD_DROP_INDEX call function 'DD_DROP_INDEX' exporting tabname = p_tabname indexname = '0' importing subrc = l_subrc exceptions index_not_dropped = 1 program_not_generated = 2 program_not_written = 3 others = 4.
DDIF_TABL_GET call function 'DDIF_TABL_GET' exporting name = p_tabname state = 'M' importing dd02v_wa = l_s_dd02v dd09l_wa = l_s_dd09l tables dd03p_tab = l_t_dd03p exceptions illegal_input = 1 others = 2.
DD_INDEX_NAME call function 'DD_INDEX_NAME' exporting indexname = '010' tabname = p_tabname importing dbindex = l_dbindex.
RSD_IS_CUBE_TABLE call function 'RSD_IS_CUBE_TABLE' exporting i_tablnm = l_tablnm importing e_infocube = l_infocube e_is_facttab = l_is_facttab.
DD_DROP_INDEX call function 'DD_DROP_INDEX' exporting tabname = p_tabname indexname = '0' importing subrc = l_subrc exceptions index_not_dropped = 1 program_not_generated = 2 program_not_written = 3 others = 4.
DD_DROP_INDEX call function 'DD_DROP_INDEX' exporting tabname = p_tabname indexname = 'P' importing subrc = l_subrc exceptions index_not_dropped = 1 program_not_generated = 2 program_not_written = 3 others = 4.
DD_CREATE_INDEX call function 'DD_CREATE_INDEX' exporting indexname = 'P' tabname = p_tabname exceptions basetab_error = 1 db_error = 2 dd_error = 3 index_exists = 4 others = 5.
DD_DROP_INDEX * call function 'DD_DROP_INDEX' * exporting * tabname = p_tabname * indexname = 'P' * importing * subrc = l_subrc * exceptions * index_not_dropped = 1 * program_not_generated = 2 * program_not_written = 3 * others = 4.
DD_CREATE_INDEX call function 'DD_CREATE_INDEX' exporting indexname = '0' tabname = p_tabname exceptions basetab_error = 1 db_error = 2 dd_error = 3 index_exists = 4 others = 5.
RSD_IS_CUBE_TABLE call function 'RSD_IS_CUBE_TABLE' exporting i_tablnm = l_tablnm importing e_infocube = l_infocube e_is_facttab = l_is_facttab.
DD_CREATE_INDEX call function 'DD_CREATE_INDEX' exporting indexname = 'P' tabname = p_tabname exceptions basetab_error = 1 db_error = 2 dd_error = 3 index_exists = 4 others = 5.
RSDU_PARTITIONS_INFO_GET call function 'RSDU_PARTITIONS_INFO_GET' exporting i_tablnm = p_tabname importing * E_PARTYPE = * E_PARTKEY = e_ts_part_info = l_ts_p_info exceptions table_not_exists = 1 table_not_partitioned = 2 inherited_error = 3 others = 4.
RSDU_TABLE_ADD_PARTITION_MSS call function 'RSDU_TABLE_ADD_PARTITION_MSS' exporting i_tablnm = p_tabname i_part_column = l_partcol i_part_value = p_boundary changing c_processed = l_processed exceptions add_partition_failed = 1 split_partition_failed = 2 others = 3.
RSDU_PARTITIONS_INFO_GET call function 'RSDU_PARTITIONS_INFO_GET' exporting i_tablnm = p_tabname importing * E_PARTYPE = * E_PARTKEY = e_ts_part_info = l_ts_p_info exceptions table_not_exists = 1 table_not_partitioned = 2 inherited_error = 3 others = 4.
RSDU_TABLE_DROP_PARTITION_MSS call function 'RSDU_TABLE_DROP_PARTITION_MSS' exporting i_tablnm = p_tabname i_partnm = l_partnm changing c_processed = l_processed exceptions drop_partition_failed = 1 others = 2.
DB_DROP_TABLE call function 'DB_DROP_TABLE' exporting tabname = p_tabname exceptions program_not_generated = 1 program_not_written = 2 table_not_dropped = 3 others = 4.
DD_DROP_INDEX call function 'DD_DROP_INDEX' exporting tabname = p_tabname indexname = '900' exceptions index_not_dropped = 1 program_not_generated = 2 program_not_written = 3 others = 4.
MSS_EXEC_UPDATESTATS call function 'MSS_EXEC_UPDATESTATS' "destination currcon-rfcdest exporting "con_name = currcon-con_name "schema = currcon-dbschema table_name = l_tabname "index_name = upd_idx "schema_name = obj_schema "db_name = obj_db fullscan = 'X' sampleper = 0 tables info_msgs = lt_dbcclist exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 db_not_found = 4 no_db_access = 5 schema_not_found = 6 invalid_input = 7 table_not_found = 8 index_not_found = 9 others = 10.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = text-082.
DDIF_TABL_GET call function 'DDIF_TABL_GET' exporting name = p_tabname state = 'M' importing dd02v_wa = l_s_dd02v dd09l_wa = l_s_dd09l tables dd03p_tab = l_t_dd03p exceptions illegal_input = 1 others = 2.
DD_GET_NAMETAB call function 'DD_GET_NAMETAB' exporting tabname = p_tabname importing * F_STATUS = * R_MODEFLAG = * R_STATUS = x030l_wa = x030l_wa tables x031l_tab = lt_x031l exceptions not_found = 1 no_fields = 2 others = 3.
DD_GET_NAMETAB call function 'DD_GET_NAMETAB' exporting tabname = p_tabname importing x030l_wa = x030l_wa tables x031l_tab = lt_x031l exceptions not_found = 1 no_fields = 2 others = 3.
DD_PUT_NAMETAB call function 'DD_PUT_NAMETAB' exporting * MODEFLAG = ' ' status = 'A' x030l_wa = x030l_wa tables x031l_tab = lt_x031l exceptions write_error = 1 others = 2.
DD_GET_NAMETAB call function 'DD_GET_NAMETAB' exporting tabname = p_tabname importing x030l_wa = x030l_wa tables x031l_tab = lt_x031l exceptions not_found = 1 no_fields = 2 others = 3.
DD_INDEX_NAME call function 'DD_INDEX_NAME' exporting indexname = 'P' tabname = p_tabname importing dbindex = l_dbindex.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting dbindex = l_dbindex tabname = p_tabname importing subrc = l_subrc unique = l_unique exceptions parameter_error = 1 others = 2.
DB_GET_INDEX_FIELDS call function 'DB_GET_INDEX_FIELDS' exporting dbindex = l_dbindex importing subrc = l_subrc tables dbfldnames = lt_dbfldnames.
DDIF_TABL_GET call function 'DDIF_TABL_GET' exporting name = p_tabname state = 'M' importing dd02v_wa = l_s_dd02v dd09l_wa = l_s_dd09l tables dd03p_tab = l_t_dd03p exceptions illegal_input = 1 others = 2.
RSD_FIX_DIME_GET_FOR_CUBE call function 'RSD_FIX_DIME_GET_FOR_CUBE' exporting i_infocube = i_infocube importing e_pdime = l_pdime.
RSD_FIELDNM_GET_FOR_DIME call function 'RSD_FIELDNM_GET_FOR_DIME' exporting i_dimension = l_pdime importing e_fieldnm = e_column.
MSS_GET_INDEXES call function 'MSS_GET_INDEXES' exporting table_name = l_tabname_mss tables all_indexes = l_t_all_indexes exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 db_not_found = 4 no_db_access = 5 schema_not_found = 6 invalid_input = 7 no_indexes_found = 8 others = 9.
MSS_GET_INDEX_TYPE call function 'MSS_GET_INDEX_TYPE' exporting index_name = l_indname_mss importing index_type = l_indtype exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 db_not_found = 4 no_db_access = 5 schema_not_found = 6 invalid_input = 7 index_not_found = 8 multiple_indexes_found = 9 others = 10.
DD_INDEX_NAME call function 'DD_INDEX_NAME' exporting indexname = '0' tabname = p_tabname importing dbindex = lt_dd12l-dbindex.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = lt_dd12l-sqltab indexname = lt_dd12l-indexname importing subrc = l_subrc exceptions parameter_error = 1 others = 2.
DD_INDEX_NAME call function 'DD_INDEX_NAME' exporting indexname = lt_dd12l-indexname tabname = lt_dd12l-sqltab importing dbindex = lt_dd12l-dbindex.
RSD_IS_CUBE_TABLE call function 'RSD_IS_CUBE_TABLE' exporting i_tablnm = p_tabname importing e_infocube = l_infocube e_is_facttab = l_is_facttab.
RSDU_INFOCUBE_FACTTABLES call function 'RSDU_INFOCUBE_FACTTABLES' exporting i_infocube = l_infocube importing e_ffacttab = l_ffacttab e_efacttab = l_efacttab exceptions infocube_error = 1 inherited_error = 2 others = 3.
DB_DROP_INDEX * call function 'DB_DROP_INDEX' * exporting * dbindex = l_dbindex * tabname = p_tabname * importing * subrc = l_subrc * exceptions * index_not_dropped = 1 * program_not_generated = 2 * program_not_written = 3 * others = 4.
DD_TABNAME_OF_INDEX * call function 'DD_TABNAME_OF_INDEX' * exporting * dbindex = l_dbindex * importing * index = l_indname ** TABNAME = * exceptions * index_not_in_dd = 1 * others = 2.
DB_STORAGE_PUT * call function 'DB_STORAGE_PUT' * exporting * tabname = p_tabname * indexname = l_indname * useflag = 'X' * tables * storpar = lt_storpar * exceptions * db_error = 1 * other_error = 2 * others = 3.
DD_CREATE_INDEX * call function 'DD_CREATE_INDEX' * exporting * indexname = l_indname * tabname = p_tabname * exceptions * basetab_error = 1 * db_error = 2 * dd_error = 3 * index_exists = 4 * others = 5.
DB_DROP_INDEX call function 'DB_DROP_INDEX' exporting dbindex = l_dbindex tabname = p_tabname exceptions index_not_dropped = 1 program_not_generated = 2 program_not_written = 3 others = 4.
DD_TABNAME_OF_INDEX call function 'DD_TABNAME_OF_INDEX' exporting dbindex = p_dbindexname importing index = l_ddindex exceptions index_not_in_dd = 1 others = 2.
DB_STORAGE_PUT call function 'DB_STORAGE_PUT' exporting tabname = l_tabname indexname = l_ddindex useflag = 'X' tables storpar = lt_storpar exceptions db_error = 1 other_error = 2 others = 3.
DD_CREATE_INDEX call function 'DD_CREATE_INDEX' exporting indexname = l_ddindex tabname = l_tabname exceptions basetab_error = 1 db_error = 2 dd_error = 3 index_exists = 4 others = 5.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = p_tabname indexname = '0' importing subrc = l_subrc exceptions parameter_error = 1 others = 2.
DB_STORAGE_PUT call function 'DB_STORAGE_PUT' exporting tabname = p_tabname indexname = '0' useflag = 'X' tables storpar = lt_storpar exceptions db_error = 1 other_error = 2 others = 3.
DD_CREATE_INDEX call function 'DD_CREATE_INDEX' exporting indexname = '0' tabname = p_tabname exceptions basetab_error = 1 db_error = 2 dd_error = 3 index_exists = 4 others = 5.
DD_CREATE_INDEX call function 'DD_CREATE_INDEX' exporting indexname = lt_dd12l-indexname tabname = lt_dd12l-sqltab exceptions basetab_error = 1 db_error = 2 dd_error = 3 index_exists = 4 others = 5.
DB_DROP_INDEX call function 'DB_DROP_INDEX' exporting dbindex = l_dbindex tabname = p_tabname exceptions index_not_dropped = 1 program_not_generated = 2 program_not_written = 3 others = 4.
DD_TABNAME_OF_INDEX call function 'DD_TABNAME_OF_INDEX' exporting dbindex = l_dbindex importing index = l_indname * TABNAME = exceptions index_not_in_dd = 1 others = 2.
DB_STORAGE_PUT call function 'DB_STORAGE_PUT' exporting tabname = p_tabname indexname = l_indname useflag = 'X' tables storpar = lt_storpar exceptions db_error = 1 other_error = 2 others = 3.
DD_CREATE_INDEX call function 'DD_CREATE_INDEX' exporting indexname = l_indname tabname = p_tabname exceptions basetab_error = 1 db_error = 2 dd_error = 3 index_exists = 4 others = 5.
MSS_GET_INDEX_STORPARS call function 'MSS_GET_INDEX_STORPARS' exporting index_name = l_dbindex_mss table_name = l_tabname_mss importing index_storpars = l_index_storpars exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 db_not_found = 4 no_db_access = 5 schema_not_found = 6 invalid_input = 7 index_not_found = 8 multiple_indexes_found = 9 others = 10.
MSS_GET_INDEXES call function 'MSS_GET_INDEXES' exporting table_name = l_tabname_mss tables all_indexes = l_t_all_indexes exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 db_not_found = 4 no_db_access = 5 schema_not_found = 6 invalid_input = 7 no_indexes_found = 8 others = 9.
DB_EXISTS_TABLE call function 'DB_EXISTS_TABLE' exporting tabname = p_tabname importing subrc = l_subrc.
DB_EXISTS_TABLE call function 'DB_EXISTS_TABLE' exporting tabname = p_tabname importing subrc = l_subrc.
MSS_GET_INDEXES call function 'MSS_GET_INDEXES' exporting table_name = l_tabname_mss * SCHEMA_NAME = * DB_NAME = * ONLY_UNIQUE_INDS = * ALSO_AUTOCRE_STATS = * ALSO_MANCRE_STATS = tables all_indexes = lt_index_tab exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 db_not_found = 4 no_db_access = 5 schema_not_found = 6 invalid_input = 7 no_indexes_found = 8 others = 9.
DB_EXISTS_TABLE call function 'DB_EXISTS_TABLE' exporting tabname = p_tabname importing subrc = l_subrc.
DB_EXISTS_TABLE call function 'DB_EXISTS_TABLE' exporting tabname = p_tabname importing subrc = l_subrc.
MSS_GET_INDEXES call function 'MSS_GET_INDEXES' exporting table_name = l_tabname_mss * SCHEMA_NAME = * DB_NAME = * ONLY_UNIQUE_INDS = * ALSO_AUTOCRE_STATS = * ALSO_MANCRE_STATS = tables all_indexes = lt_index_tab exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 db_not_found = 4 no_db_access = 5 schema_not_found = 6 invalid_input = 7 no_indexes_found = 8 others = 9.
RSDU_PARTITIONS_INFO_GET call function 'RSDU_PARTITIONS_INFO_GET' exporting i_tablnm = p_tabname exceptions table_not_exists = 1 table_not_partitioned = 2 inherited_error = 3 others = 4.
DB_STORAGE_CLEAR call function 'DB_STORAGE_CLEAR' exporting tabname = p_tabname dbindex = p_indname exceptions not_found = 1 db_error = 2 other_error = 3 others = 4. "#EC FB_RC
DB_STORAGE_PUT call function 'DB_STORAGE_PUT' exporting tabname = p_tabname indexname = p_indnamedd useflag = 'X' tables storpar = lt_storpar exceptions db_error = 1 other_error = 2 others = 3.
DD_DATABASE_UTILITY * call function 'DD_DATABASE_UTILITY' * exporting * fct = 'MDF' * id_name = p_indnamedd * obj_name = p_tabname * obj_type = 'INDX' * exec_modus = 'S' * popup_flag = 'X' * call_from_dbut = ' ' * importing * subrc = l_subrc * exceptions * unexpected_error = 01 * unsupported_function = 02 * unsupported_obj_type = 03 * table_is_locked_by_tcnv = 04 * authority_check_failed = 05 * abort_function = 06 * conversion_error = 07.
DB_DROP_INDEX call function 'DB_DROP_INDEX' exporting dbindex = p_indname tabname = p_tabname importing subrc = l_subrc exceptions index_not_dropped = 1 program_not_generated = 2 program_not_written = 3 others = 4.
DB_STORAGE_PUT call function 'DB_STORAGE_PUT' exporting tabname = p_tabname indexname = p_indnamedd useflag = 'X' tables storpar = lt_storpar exceptions db_error = 1 other_error = 2 others = 3.
RSDU_PARTITIONS_INFO_GET call function 'RSDU_PARTITIONS_INFO_GET' exporting i_tablnm = p_tabname exceptions table_not_exists = 1 table_not_partitioned = 2 inherited_error = 3 others = 4.
DB_STORAGE_CLEAR call function 'DB_STORAGE_CLEAR' exporting tabname = p_tabname dbindex = p_indname * WHERE_USEFLAG = '*' * WHERE_SOURCE = '*' exceptions not_found = 1 db_error = 2 other_error = 3 others = 4.
DB_STORAGE_GET call function 'DB_STORAGE_GET' exporting tabname = p_tabname * INDEXNAME = ' ' dbindex = p_indname source_hierarchy = l_srchier tables storpar = lt_storpar exceptions mapping_error = 1 db_error = 2 uncomplete_parameter = 3 others = 4.
DB_STORAGE_PUT call function 'DB_STORAGE_PUT' exporting tabname = p_tabname indexname = p_indnamedd useflag = 'X' tables storpar = lt_storpar exceptions db_error = 1 other_error = 2 others = 3.
DD_DATABASE_UTILITY * call function 'DD_DATABASE_UTILITY' * exporting * fct = 'MDF' * id_name = p_indnamedd * obj_name = p_tabname * obj_type = 'INDX' * exec_modus = 'S' * popup_flag = 'X' * call_from_dbut = ' ' * importing * subrc = l_subrc * exceptions * unexpected_error = 01 * unsupported_function = 02 * unsupported_obj_type = 03 * table_is_locked_by_tcnv = 04 * authority_check_failed = 05 * abort_function = 06 * conversion_error = 07.
DB_DROP_INDEX call function 'DB_DROP_INDEX' exporting dbindex = p_indname tabname = p_tabname importing subrc = l_subrc exceptions index_not_dropped = 1 program_not_generated = 2 program_not_written = 3 others = 4.
DB_STORAGE_PUT call function 'DB_STORAGE_PUT' exporting tabname = p_tabname indexname = p_indnamedd useflag = 'X' tables storpar = lt_storpar exceptions db_error = 1 other_error = 2 others = 3.
DB_STORAGE_GET * call function 'DB_STORAGE_GET' * exporting * tabname = p_tabname ** INDEXNAME = ' ' * dbindex = p_indname * source_hierarchy = l_srchier * tables * storpar = lt_storpar * exceptions * mapping_error = 1 * db_error = 2 * uncomplete_parameter = 3 * others = 4.
DB_STORAGE_GET * call function 'DB_STORAGE_GET' * exporting * tabname = p_tabname ** INDEXNAME = ' ' * dbindex = p_indname * source_hierarchy = l_srchier * tables * storpar = lt_storpar * exceptions * mapping_error = 1 * db_error = 2 * uncomplete_parameter = 3 * others = 4.
DB_GET_RELEASE * call function 'DB_GET_RELEASE' * importing * release = l_dbrel.
MSS_DB_AND_SCHEMA call function 'MSS_DB_AND_SCHEMA' changing db_name = dname schema_name = sname exceptions others = 1.
POPUP_TO_CONFIRM call function 'POPUP_TO_CONFIRM' exporting text_question = l_text importing answer = l_answer exceptions text_not_found = 1 others = 2.
MSS_GET_INDEXES call function 'MSS_GET_INDEXES' exporting table_name = l_tabname_mss tables all_indexes = l_t_all_indxs exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 db_not_found = 4 no_db_access = 5 schema_not_found = 6 invalid_input = 7 no_indexes_found = 8 others = 9.
DD_TABNAME_OF_INDEX call function 'DD_TABNAME_OF_INDEX' exporting dbindex = l_dbindex importing index = l_ddindex exceptions index_not_in_dd = 1 others = 2.
DB_STORAGE_SAVE call function 'DB_STORAGE_SAVE' exporting tabname = p_tabname indexname = l_ddindex dbindex = l_dbindex * SOURCE = 'DBS' useflag = 'X' * 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_DROP_INDEX call function 'DB_DROP_INDEX' exporting dbindex = l_dbindex tabname = p_tabname exceptions index_not_dropped = 1 program_not_generated = 2 program_not_written = 3 others = 4.
SAPGUI_PROGRESS_INDICATOR call function 'SAPGUI_PROGRESS_INDICATOR' exporting text = text-077.
BP_FIND_JOBS_WITH_PROGRAM call function 'BP_FIND_JOBS_WITH_PROGRAM' exporting abap_program_name = 'RSDD_MSSQL_CUBEANALYZE_BATCH' dialog = 'N' tables joblist = lt_joblist exceptions no_jobs_found = 01 program_specification_missing = 02 invalid_dialog_type = 03 job_find_canceled = 04.
POPUP_TO_CONFIRM call function 'POPUP_TO_CONFIRM' exporting text_question = text-113 text_button_1 = text-114 "'Sofort starten' text_button_2 = text-115 "'Einplanen' default_button = ' ' display_cancel_button = 'X' importing answer = l_answer exceptions text_not_found = 1 others = 2.
BP_START_DATE_EDITOR call function 'BP_START_DATE_EDITOR' exporting stdt_dialog = 'Y' stdt_input = p_startcond stdt_opcode = 14 importing stdt_modify_type = l_modiftype stdt_output = p_startcond exceptions others = 1.
JOB_OPEN call function 'JOB_OPEN' exporting jobname = glob_jobname importing jobcount = p_jobnumber exceptions cant_create_job = 1 invalid_job_data = 2 jobname_missing = 3 others = 4.
JOB_CLOSE call function 'JOB_CLOSE' exporting jobcount = p_jobnumber jobname = glob_jobname calendar_id = p_startcond-calendarid event_id = p_startcond-eventid event_param = p_startcond-eventparm event_periodic = p_startcond-periodic laststrtdt = p_startcond-laststrtdt laststrttm = p_startcond-laststrttm prddays = p_startcond-prddays prdhours = p_startcond-prdhours prdmins = p_startcond-prdmins prdmonths = p_startcond-prdmonths prdweeks = p_startcond-prdweeks predjob_checkstat = p_startcond-checkstat pred_jobcount = p_startcond-predjobcnt pred_jobname = p_startcond-predjob sdlstrtdt = p_startcond-sdlstrtdt sdlstrttm = p_startcond-sdlstrttm start_on_workday_not_before = p_startcond-notbefore start_on_workday_nr = p_startcond-wdayno workday_count_direction = p_startcond-wdaycdir strtimmed = l_immediate exceptions cant_start_immediate = 1 invalid_startdate = 2 jobname_missing = 3 job_close_failed = 4 job_nosteps = 5 job_notex = 6 lock_failed = 7 others = 8.
BP_FIND_JOBS_WITH_PROGRAM call function 'BP_FIND_JOBS_WITH_PROGRAM' exporting abap_program_name = 'RSDD_MSSQL_CUBEANALYZE_BATCH' dialog = 'N' tables joblist = lt_joblist exceptions no_jobs_found = 01 program_specification_missing = 02 invalid_dialog_type = 03 job_find_canceled = 04.
DB_GET_RELEASE call function 'DB_GET_RELEASE' importing release = database_release.
call function append ' call function ''DB6_CALL_COCKPIT'' ' "#EC NOTEXT to l_tab. "#EC NOTEXT
DD_TABNAME_OF_INDEX call function 'DD_TABNAME_OF_INDEX' exporting dbindex = p_dbind importing index = l_ddind exceptions index_not_in_dd = 1 others = 2.
DD_CREATE_INDEX_S call function 'DD_CREATE_INDEX_S' exporting indexname = l_ddind tabname = p_tabname no_exec = 'X' tables statements = lt_stmt exceptions basetab_error = 1 db_error = 2 dd_error = 3 index_exists = 4 others = 5.
WRITE_AND_CALL_DBPROG call function 'WRITE_AND_CALL_DBPROG' tables statements = lt_stmt exceptions program_not_written = 01 sql_error_occured = 02.
DB_STORAGE_CLEAR call function 'DB_STORAGE_CLEAR' exporting tabname = p_tabname indexname = l_ddind exceptions not_found = 1 db_error = 2 other_error = 3 others = 4.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting dbindex = indx_list_s-indname tabname = p_tabname importing subrc = l_subrc exceptions parameter_error = 1 others = 2.
MSS_GET_TOP_N_TABLES * call function 'MSS_GET_TOP_N_TABLES' * exporting * number = 5000 * order = 'L' * tables * large_tables = l_topntab * exceptions ** not_running_on_mssql = 1 ** db_error = 2 ** internal_error = 3 ** db_not_found = 4 ** no_db_access = 5 ** schema_not_found = 6 ** invalid_input = 7 ** connect_error = 8 * others = 1.
MSS_GET_DB_SIZE_INFO * call function 'MSS_GET_DB_SIZE_INFO' ** exporting ** con_name = 'DEFAULT' ** schema = ' ' ** db_name = 'tempdb' * importing * db_sizeinfo = l_dbsizestruc * exceptions ** not_running_on_mssql = 1 ** db_error = 2 ** internal_error = 3 ** db_not_found = 4 ** no_db_access = 5 ** connect_error = 6 * others = 1.
MSS_DB_AND_SCHEMA * call function 'MSS_DB_AND_SCHEMA' * changing * db_name = l_dbname * schema_name = l_schema * exceptions * not_running_on_mssql = 1 * db_error = 2 * internal_error = 3 * db_not_found = 4 * no_db_access = 5 * schema_not_found = 6 * others = 7.
MSS_GET_TOP_N_TABLES * call function 'MSS_GET_TOP_N_TABLES' * exporting * schema = l_schema * db_name = l_dbname * number =
* order = 'L' * tables * large_tables = l_topntab * exceptions ** not_running_on_mssql = 1 ** db_error = 2 ** internal_error = 3 ** db_not_found = 4 ** no_db_access = 5 ** schema_not_found = 6 ** invalid_input = 7 * connect_error = 1 * others = 2.
MSS_GET_DB_SIZE_INFO * call function 'MSS_GET_DB_SIZE_INFO' * exporting ** con_name = 'DEFAULT' * schema = l_schema * db_name = l_dbname * importing * db_sizeinfo = l_dbsizestruc * exceptions ** not_running_on_mssql = 1 ** db_error = 2 ** internal_error = 3 ** db_not_found = 4 ** no_db_access = 5 ** connect_error = 6 * others = 1.
BP_FIND_JOBS_WITH_PROGRAM * call function 'BP_FIND_JOBS_WITH_PROGRAM' * exporting * abap_program_name = 'RSCOMP1' * dialog = 'N' * tables * joblist = lt_joblist * exceptions * no_jobs_found = 01 * program_specification_missing = 02 * invalid_dialog_type = 03 * job_find_canceled = 04.
RS_VARIANT_CONTENTS ** call function 'RS_VARIANT_CONTENTS' ** exporting ** report = 'RSCOMP1' ** variant = tbtcp-variant ** tables ** valutab = lt_values ** exceptions ** variant_non_existent = 1 ** variant_obsolete = 2 ** others = 3.
RS_VARIANT_CONTENTS ** call function 'RS_VARIANT_CONTENTS' ** exporting ** report = 'RSCOMP1' ** variant = tbtcp-variant ** tables ** valutab = lt_values ** exceptions ** variant_non_existent = 1 ** variant_obsolete = 2 ** others = 3.
RS_VARIANT_CONTENTS call function 'RS_VARIANT_CONTENTS' exporting report = 'RSCOMP1' variant = tbtcp-variant tables valutab = lt_values exceptions variant_non_existent = 1 variant_obsolete = 2 others = 3.
BP_JOBLOG_READ call function 'BP_JOBLOG_READ' exporting * CLIENT = SY-MANDT jobcount = tbtcp-jobcount * JOBLOG = ' ' jobname = tbtcp-jobname tables joblogtbl = lt_joblog exceptions cant_read_joblog = 1 jobcount_missing = 2 joblog_does_not_exist = 3 joblog_is_empty = 4 joblog_name_missing = 5 jobname_missing = 6 job_does_not_exist = 7 others = 8.
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 RSDD_MSSQL_CUBEANALYZE_INCL or its description.
RSDD_MSSQL_CUBEANALYZE_INCL - Include RSDD_MSSQL_CUBEANALYZE_INCL RSDD_MSSQL_CUBEANALYZE_BATCH - RSDD_MSSQL_CUBEANALYZE_BATCH RSDD_MSSQL_CUBEANALYZE_BATCH - RSDD_MSSQL_CUBEANALYZE_BATCH RSDD_MSSQL_CUBEANALYZE - Analysis of MS SQL Server Fact Tables RSDD_MSSQL_CUBEANALYZE - Analysis of MS SQL Server Fact Tables RSDD_LTIP_SHOW_INDEX - Display Content of a Physical Index