SAP Reports / Programs | SAP Business Information Warehouse | Basis System and Installation | BW Microsoft SQL Server(BW-SYS-DB-MSS) SAP BW

RSMSS_ANALYZERCLI4 SAP ABAP INCLUDE - Implementation of LCL_ANALYZER_REPAIRS







RSMSS_ANALYZERCLI4 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 RSMSS_ANALYZERCLI4 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 RSMSS_ANALYZERCLI4. "Basic submit
SUBMIT RSMSS_ANALYZERCLI4 AND RETURN. "Return to original report after report execution complete
SUBMIT RSMSS_ANALYZERCLI4 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Title: Implementation of LCL_ANALYZER_REPAIRS


INCLUDES used within this REPORT RSMSS_ANALYZERCLI4

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:

BP_JOB_DELETE call function 'BP_JOB_DELETE' exporting jobcount = l_jobcount jobname = l_jobname forcedmode = 'X' exceptions job_does_not_exist = 0 error_message = 0.

BP_JOB_READ call function 'BP_JOB_READ' exporting job_read_jobcount = -jobcount job_read_jobname = -jobname job_read_opcode = 20 tables job_read_steplist = l_t_jobstep exceptions others = 0.

RS_VARIANT_CONTENTS call function 'RS_VARIANT_CONTENTS' exporting report = sy-repid variant = l_variant tables valutab = l_t_valuetab.

BAL_DB_ENQUEUE call function 'BAL_DB_ENQUEUE' exporting i_log_handle = l_s_check_result-balmsghndl-log_handle.

BAL_DB_DEQUEUE call function 'BAL_DB_DEQUEUE' exporting i_log_handle = l_s_check_result-balmsghndl-log_handle.

DB_DROP_TABLE_S call function 'DB_DROP_TABLE_S' exporting no_exec = ' ' tabname = l_tabname db_check_flag = 'X' importing subrc = l_subrc tables statements = l_t_statements exceptions others = 1.

DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = i_s_check_result-objname indexname = '0' importing realname = l_db_primary_key subrc = l_rc unique = l_unique exceptions parameter_error = 1 others = 2. "#EC FB_RC

RSCDS_LOCK_GET call function 'RSCDS_LOCK_GET' exporting i_facttab = l3_facttab i_infocube = l_infocube exceptions x_message = 1 others = 2.

RSCDS_LOCK_CHECK call function 'RSCDS_LOCK_CHECK' exporting i_facttab = l3_facttab i_infocube = l_infocube exceptions blocking = 1 others = 3.

DB_DROP_INDEX call function 'DB_DROP_INDEX' exporting dbindex = l_db_primary_key no_exec = ' ' tabname = i_s_check_result-objname db_check_flag = 'X' importing subrc = l_rc exceptions index_not_dropped = 1 others = 4.

DD_INDX_DEL call function 'DD_INDX_DEL' exporting sqltab = -sqltab indexname = -indexname del_state = -as4local importing rc = l_rc.

DD_INDEX_NAME call function 'DD_INDEX_NAME' exporting indexname = -indexname tabname = -sqltab * DBSYS = SY-DBSYS importing dbindex = -dbindex.

DB_DROP_INDEX call function 'DB_DROP_INDEX' exporting dbindex = -dbindex * NO_EXEC = ' ' tabname = -sqltab db_check_flag = 'X' importing * GENPROG = subrc = l_rc exceptions index_not_dropped = 1 program_not_generated = 2 program_not_written = 3 others = 4. "#EC FB_RC

DDIF_INDX_PUT call function 'DDIF_INDX_PUT' exporting name = l_dd_tab id = l_ddindexid dd12v_wa = tables dd17v_tab = l_t_single_index_fields_dd17v exceptions indx_not_found = 1 name_inconsistent = 2 indx_inconsistent = 3 put_failure = 4 put_refused = 5 others = 6.

RSCDS_LOCK_RELEASE call function 'RSCDS_LOCK_RELEASE' exporting i_facttab = l3_facttab i_infocube = l_infocube.

RSCDS_LOCK_RELEASE call function 'RSCDS_LOCK_RELEASE' exporting i_facttab = l3_facttab i_infocube = l_infocube.

DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = i_s_check_result-objname indexname = '0' importing subrc = l_rc exceptions parameter_error = 1 others = 2. "#EC FB_RC

RSCDS_LOCK_GET call function 'RSCDS_LOCK_GET' exporting i_facttab = l3_facttab i_infocube = l_infocube exceptions x_message = 1 others = 2.

RSCDS_LOCK_CHECK





call function 'RSCDS_LOCK_CHECK' exporting i_facttab = l3_facttab i_infocube = l_infocube exceptions blocking = 1.

DB_CREATE_PRIMARY_INDEX call function 'DB_CREATE_PRIMARY_INDEX' exporting tabname = i_s_check_result-objname importing subrc = l_rc.

RSCDS_LOCK_RELEASE call function 'RSCDS_LOCK_RELEASE' exporting i_facttab = l3_facttab i_infocube = l_infocube.

DD_INDX_DEL call function 'DD_INDX_DEL' exporting sqltab = -sqltab indexname = -indexname del_state = -as4local importing rc = l_rc.

DD_INDEX_NAME call function 'DD_INDEX_NAME' exporting indexname = -indexname tabname = -sqltab * DBSYS = SY-DBSYS importing dbindex = -dbindex.

DB_DROP_INDEX call function 'DB_DROP_INDEX' exporting dbindex = -dbindex * NO_EXEC = ' ' tabname = -sqltab db_check_flag = 'X' importing * GENPROG = subrc = l_rc exceptions index_not_dropped = 1 program_not_generated = 2 program_not_written = 3 others = 4. "#EC FB_RC

DDIF_INDX_PUT call function 'DDIF_INDX_PUT' exporting name = l_dd_tab id = l_ddindexid dd12v_wa = tables dd17v_tab = l_t_single_index_fields_dd17v exceptions indx_not_found = 1 name_inconsistent = 2 indx_inconsistent = 3 put_failure = 4 put_refused = 5 others = 6.

DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = i_s_check_result-objname indexname = '0' importing realname = l_db_primary_key subrc = l_rc unique = l_unique exceptions parameter_error = 1 others = 2. "#EC FB_RC

RSCDS_LOCK_GET call function 'RSCDS_LOCK_GET' exporting i_facttab = l3_facttab i_infocube = l_infocube exceptions x_message = 1 others = 2.

RSCDS_LOCK_CHECK call function 'RSCDS_LOCK_CHECK' exporting i_facttab = l3_facttab i_infocube = l_infocube exceptions blocking = 1 others = 3.

DB_DROP_INDEX call function 'DB_DROP_INDEX' exporting dbindex = l_db_primary_key no_exec = ' ' tabname = i_s_check_result-objname db_check_flag = 'X' importing subrc = l_rc exceptions others = 0.

DD_INDX_DEL call function 'DD_INDX_DEL' exporting sqltab = -sqltab indexname = -indexname del_state = -as4local importing rc = l_rc.

DD_INDEX_NAME call function 'DD_INDEX_NAME' exporting indexname = -indexname tabname = -sqltab * DBSYS = SY-DBSYS importing dbindex = -dbindex.

DB_DROP_INDEX call function 'DB_DROP_INDEX' exporting dbindex = -dbindex * NO_EXEC = ' ' tabname = -sqltab db_check_flag = 'X' importing * GENPROG = subrc = l_rc exceptions index_not_dropped = 1 program_not_generated = 2 program_not_written = 3 others = 4. "#EC FB_RC

DDIF_INDX_PUT call function 'DDIF_INDX_PUT' exporting name = l_dd_tab id = l_ddindexid dd12v_wa = tables dd17v_tab = l_t_single_index_fields_dd17v exceptions indx_not_found = 1 name_inconsistent = 2 indx_inconsistent = 3 put_failure = 4 put_refused = 5 others = 6.

RSCDS_LOCK_RELEASE call function 'RSCDS_LOCK_RELEASE' exporting i_facttab = l3_facttab i_infocube = l_infocube.

RSCDS_LOCK_RELEASE call function 'RSCDS_LOCK_RELEASE' exporting i_facttab = l3_facttab i_infocube = l_infocube.

RSDU_PARTITIONS_INFO_GET call function 'RSDU_PARTITIONS_INFO_GET' exporting i_tablnm = l_ffacttab importing * E_PARTYPE = e_partkey = l_partkey e_ts_part_info = l_t_current_partitons exceptions table_not_exists = 1 table_not_partitioned = 2 inherited_error = 3 others = 4.

RSDU_TABLE_ADD_PARTITION call function 'RSDU_TABLE_ADD_PARTITION' exporting i_tablenm = l_ffacttab i_part_column = l_partkey i_part_value = l_numc_request exceptions table_not_exists = 1 table_not_partitioned = 2 invalid_partition_column = 3 partition_already_exists = 4 add_partition_failed = 5 split_partition_failed = 6 invalid_partition_argument = 7 tabart_inconsitency = 8 others = 9.

RSDU_TABLE_DROP_PARTITION call function 'RSDU_TABLE_DROP_PARTITION' exporting i_tablenm = l_ffacttab i_part_column = l_partkey i_part_value = l_request exceptions drop_partition_failed = 1 partition_not_exists = 2 table_not_partitioned = 3 invalid_partition_column = 4 invalid_partition_argument = 5 others = 6.




RSDU_ANALYZE_TABLE call function 'RSDU_ANALYZE_TABLE' exporting i_tablnm = l_tabname i_force_statistics = rs_c_true exceptions analyze_failed = 1 dbms_not_supported = 2 inherited_error = 3 others = 4.

DD_TABL_DEL call function 'DD_TABL_DEL' exporting tabname = l_tabname del_state = 'A' exceptions error_message = 1 others = 2.

RSD_OBJECT_IS_GENERATED call function 'RSD_OBJECT_IS_GENERATED' exporting i_objnm = l_tabname importing e_infocube = l_infocube exceptions nspacegen_invalid = 1 others = 2. "#EC FB_RC

RSENQ_ENQUEUE call function 'RSENQ_ENQUEUE' exporting i_action = rsenq_c_create_index i_t_object = l_t_object importing e_lockid = l_lockid changing c_t_msg = l_t_msg exceptions locked = 1 others = 2.

RSDU_INFOCUBE_INDEXES_REPAIR call function 'RSDU_INFOCUBE_INDEXES_REPAIR' exporting i_infocube = l_rsd_infocube i_facttab = l_rsdtabname i_with_aggregates = rs_c_false i_double_facttab = rs_c_false i_degenerated = rs_c_false exceptions dropping_error = 1 index_error = 2 check_error = 3 inherited_error = 4 others = 5. "#EC FB_RC

RSENQ_DEQUEUE call function 'RSENQ_DEQUEUE' exporting i_lockid = l_lockid changing c_t_msg = l_t_msg exceptions no_lock_found = 1 others = 2. "#EC FB_RC



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 RSMSS_ANALYZERCLI4 or its description.