SAP Reports / Programs | Basis Components | Database Interface, Database Platforms | Microsoft SQL Server(BC-DB-MSS) SAP BC
MSSCOMPRESS SAP ABAP Report - MSSCOMPRESS
MSSCOMPRESS is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The report
If you would like to execute this report or see the full code listing simply enter MSSCOMPRESS 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 MSSCOMPRESS. "Basic submit
SUBMIT MSSCOMPRESS AND RETURN. "Return to original report after report execution complete
SUBMIT MSSCOMPRESS VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: MSSCOMPRESS
Text Symbol: 104 = Column-store
Text Symbol: 110 = Compress all tables
Text Symbol: 111 = Compress filtered tables
Text Symbol: 112 = Compress selected tables
Text Symbol: 114 = No table selected
Text Symbol: 115 = Compression dialog canceled
Text Symbol: 116 = Open Job failed
Text Symbol: 117 = Close Job failed
Text Symbol: 120 = Start in DIALOG
Text Symbol: 121 = Start IMMEDIATE as batch
Text Symbol: 122 = Schedule BATCH job
Text Symbol: 123 = Start compression
Text Symbol: 200 = No compression log found between
Text Symbol: 201 = and
Text Symbol: 202 = Logs of SQL Server compression runs
Text Symbol: 206 = Expert mode
Text Symbol: 207 = Only for SAP internal use! Turn on expert mode anyway?
Text Symbol: 208 = Random mode
Text Symbol: 209 = DO NOT USE! Turn on random mode anyway?
Text Symbol: 210 = Running for
Text Symbol: 211 = Started at
Text Symbol: 212 = Finished at
Text Symbol: 213 = Aborted at
Text Symbol: 214 = Ended at
Text Symbol: 215 = No job running
Text Symbol: 216 = Compressing table
Text Symbol: 001 = No authorization for this report
Text Symbol: 002 = This report requires Microsoft SQL Server
Text Symbol: 003 = This report requires Microsoft SQL Server 2008 or newer
Text Symbol: 005 = Table Name
Text Symbol: 006 = Name of the table
Text Symbol: 007 = Size [KB]
Text Symbol: 008 = Size of the table in kilobyte
Text Symbol: 009 = Data [KB]
Text Symbol: 010 = Size of data pages in kilobyte
Text Symbol: 011 = Index [KB]
Text Symbol: 012 = Size of index pages in kilobyte
Text Symbol: 013 = Data
Text Symbol: 014 = Compression type of data pages
Text Symbol: 015 = Index
Text Symbol: 016 = Compression type of index pages
Text Symbol: 017 = #Ind
Text Symbol: 018 = Number of secondary indexes
Text Symbol: 019 = Row count
Text Symbol: 020 = Number of rows
Text Symbol: 021 = Part
Text Symbol: 022 = Number of partitions
Text Symbol: 030 = Read table status from database...
Text Symbol: 100 = Row-compressed
Text Symbol: 101 = Page-compressed
Text Symbol: 102 = Not compressed
Text Symbol: 103 = mixed (per partition)
INCLUDES used within this REPORT MSSCOMPRESS
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:
F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING retfield = 'TEXT' dynpprog = g_dynpprog dynpnr = g_dynpnr dynprofield = 'DYN_COMPR_DISPLAY_DATA' value_org = 'S' TABLES value_tab = gt_f4tab_comp_data EXCEPTIONS OTHERS = 1.
F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING retfield = 'TEXT' dynpprog = g_dynpprog dynpnr = g_dynpnr dynprofield = 'DYN_COMPR_DISPLAY_INDEX' value_org = 'S' TABLES value_tab = gt_f4tab_comp_index EXCEPTIONS OTHERS = 1.
F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING retfield = 'TEXT' dynpprog = g_dynpprog dynpnr = g_dynpnr dynprofield = 'DYN_COMPR_DISPLAY_TOPN' value_org = 'S' TABLES value_tab = gt_f4tab_top_n EXCEPTIONS OTHERS = 1.
MSS_DB_AND_SCHEMA CALL FUNCTION 'MSS_DB_AND_SCHEMA' CHANGING db_name = g_db_name schema_name = g_schema_abap EXCEPTIONS OTHERS = 1.
POPUP_TO_DECIDE_LIST CALL FUNCTION 'POPUP_TO_DECIDE_LIST' EXPORTING titel = 'Start compression'(123) textline1 = l_textline start_row = 7 start_col = 14 IMPORTING answer = c_mode TABLES t_spopli = lt_spopli.
SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING text = l_string percentage = g_done_percent.
BP_START_DATE_EDITOR CALL FUNCTION 'BP_START_DATE_EDITOR' EXPORTING stdt_dialog = 'Y' stdt_input = g_job_cond stdt_opcode = 14 IMPORTING stdt_modify_type = l_modiftype stdt_output = g_job_cond EXCEPTIONS OTHERS = 1.
JOB_OPEN CALL FUNCTION 'JOB_OPEN' EXPORTING jobname = gc_job_name IMPORTING jobcount = g_job_number EXCEPTIONS cant_create_job = 1 invalid_job_data = 2 jobname_missing = 3 OTHERS = 4.
JOB_CLOSE CALL FUNCTION 'JOB_CLOSE' EXPORTING jobcount = g_job_number jobname = gc_job_name calendar_id = g_job_cond-calendarid event_id = g_job_cond-eventid event_param = g_job_cond-eventparm event_periodic = g_job_cond-periodic laststrtdt = g_job_cond-laststrtdt laststrttm = g_job_cond-laststrttm prddays = g_job_cond-prddays prdhours = g_job_cond-prdhours prdmins = g_job_cond-prdmins prdmonths = g_job_cond-prdmonths prdweeks = g_job_cond-prdweeks predjob_checkstat = g_job_cond-checkstat pred_jobcount = g_job_cond-predjobcnt pred_jobname = g_job_cond-predjob sdlstrtdt = g_job_cond-sdlstrtdt sdlstrttm = g_job_cond-sdlstrttm start_on_workday_not_before = g_job_cond-notbefore start_on_workday_nr = g_job_cond-wdayno workday_count_direction = g_job_cond-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.
BAL_DB_SAVE CALL FUNCTION 'BAL_DB_SAVE' EXPORTING i_t_log_handle = gt_app_logs EXCEPTIONS log_not_found = 1 save_not_allowed = 2 numbering_error = 3 OTHERS = 4.
CALL FUNCTION 'DB_COMMIT'.
BAL_LOG_MSG_ADD_FREE_TEXT CALL FUNCTION 'BAL_LOG_MSG_ADD_FREE_TEXT' EXPORTING i_log_handle = g_app_logh i_msgty = i_type i_probclass = i_class i_text = l_text EXCEPTIONS OTHERS = 1.
APPL_LOG_DISPLAY CALL FUNCTION 'APPL_LOG_DISPLAY' EXPORTING object = '*' subobject = '*' external_number = gc_app_log_extern * OBJECT_ATTRIBUTE = 0 * SUBOBJECT_ATTRIBUTE = 0 * EXTERNAL_NUMBER_ATTRIBUTE = 0 date_from = g_log_from time_from = '000000' "#EC NOTEXT date_to = g_log_to time_to = '235959' "#EC NOTEXT * TITLE_SELECTION_SCREEN = ' ' title_list_screen = 'Logs of SQL Server compression runs'(202) column_selection = l_baldisp suppress_selection_dialog = 'X' "#EC NOTEXT * COLUMN_SELECTION_MSG_JUMP = '1' external_number_display_length = 30 IMPORTING number_of_protocols = l_rowcount EXCEPTIONS no_authority = 1 OTHERS = 2.
BAL_LOG_CREATE CALL FUNCTION 'BAL_LOG_CREATE' EXPORTING i_s_log = g_app_log IMPORTING e_log_handle = g_app_logh EXCEPTIONS log_header_inconsistent = 1 OTHERS = 2.
BAL_DB_SAVE CALL FUNCTION 'BAL_DB_SAVE' EXPORTING i_t_log_handle = gt_app_logs EXCEPTIONS log_not_found = 1 save_not_allowed = 2 numbering_error = 3 OTHERS = 4.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
BAL_LOG_REFRESH CALL FUNCTION 'BAL_LOG_REFRESH' EXPORTING i_log_handle = g_app_logh EXCEPTIONS log_not_found = 1 OTHERS = 2.
SAPGUI_SET_FUNCTIONCODE CALL FUNCTION 'SAPGUI_SET_FUNCTIONCODE' EXPORTING functioncode = 'REFRESH'.
SAPGUI_SET_FUNCTIONCODE CALL FUNCTION 'SAPGUI_SET_FUNCTIONCODE' EXPORTING functioncode = new_ok.
SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING text = 'Read table status from database...'(030)
POPUP_TO_CONFIRM CALL FUNCTION 'POPUP_TO_CONFIRM' EXPORTING titlebar = 'Random mode'(208) text_question = 'DO NOT USE! Turn on random mode anyway?'(209) icon_button_1 = 'ICON_YES' icon_button_2 = 'ICON_NO' display_cancel_button = ' ' default_button = '2' popup_type = 'ICON_MESSAGE_WARNING' IMPORTING answer = l_answer.
POPUP_TO_CONFIRM CALL FUNCTION 'POPUP_TO_CONFIRM' EXPORTING titlebar = 'Expert mode'(206) text_question = 'Only for SAP internal use! Turn on expert mode anyway?'(207) icon_button_1 = 'ICON_YES' icon_button_2 = 'ICON_NO' display_cancel_button = ' ' default_button = '2' popup_type = 'ICON_MESSAGE_WARNING' IMPORTING answer = l_answer.
BP_JOB_SELECT CALL FUNCTION 'BP_JOB_SELECT' EXPORTING jobselect_dialog = 'N' jobsel_param_in = e_params IMPORTING jobsel_param_out = i_params TABLES jobselect_joblist = lt_joblist jobname_ext_sel = lt_jobname username_ext_sel = lt_username CHANGING error_code = l_subrc EXCEPTIONS invalid_dialog_type = 1 jobname_missing = 2 no_jobs_found = 3 selection_canceled = 4 username_missing = 5 OTHERS = 6.
BP_JOB_MAINTENANCE_SM37B CALL FUNCTION 'BP_JOB_MAINTENANCE_SM37B' EXPORTING o_jobsel_params = e_params EXCEPTIONS OTHERS = 0.
HELP_START CALL FUNCTION 'HELP_START' EXPORTING help_infos = help_infos TABLES dynpselect = dynpselect dynpvaluetab = dynpvaluetab.
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 MSSCOMPRESS or its description.