SAP Reports / Programs | Basis Components | Database Interface, Database Platforms | SAP HANA database(BC-DB-HDB) SAP BC
SHDB_INDEX_ANALYZE SAP ABAP Report - Analyze Indexing for HANA
SHDB_INDEX_ANALYZE 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 SHDB_INDEX_ANALYZE 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 SHDB_INDEX_ANALYZE. "Basic submit
SUBMIT SHDB_INDEX_ANALYZE AND RETURN. "Return to original report after report execution complete
SUBMIT SHDB_INDEX_ANALYZE VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Selection Text: DBGMODE = Detailed Log
Selection Text: TABNAME = Tables
Title: Analyze Indexing for HANA
Text Symbol: 001 = not a HANA system
Text Symbol: 002 = time/quantity field:
Text Symbol: 003 = not enough selectivity:
Text Symbol: 004 = field not in m_cs_columns:
Text Symbol: 005 = Propose Index on
Text Symbol: 006 = no matching Index for:
Text Symbol: 007 = replacing:
Text Symbol: 008 = Index already exists on
Text Symbol: 009 = is keyfield. No Index required for:
Text Symbol: 010 = to be created to replace:
Text Symbol: 014 = No large table found
Text Symbol: 015 = All Indexes already created
Text Symbol: 016 = Count table entries
Text Symbol: 017 = Distinct entries
Text Symbol: 018 = Index creation Input
Text Symbol: 019 = New Indexes found
INCLUDES used within this REPORT SHDB_INDEX_ANALYZE
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:
REUSE_ALV_FIELDCATALOG_MERGE CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING I_PROGRAM_NAME = 'SHDB_INDEX_ANALYZE' I_INTERNAL_TABNAME = 'L_STR_NEW_INDEXES' * I_STRUCTURE_NAME = * I_CLIENT_NEVER_DISPLAY = 'X' I_INCLNAME = 'SHDB_INDEX_INCL' I_BYPASSING_BUFFER = 'X' * I_BUFFER_ACTIVE = CHANGING CT_FIELDCAT = lt_fieldcat * EXCEPTIONS * INCONSISTENT_INTERFACE = 1 * PROGRAM_ERROR = 2 * OTHERS = 3 .
REUSE_ALV_LIST_DISPLAY CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' EXPORTING * I_INTERFACE_CHECK = ' ' * I_BYPASSING_BUFFER = ' ' * I_BUFFER_ACTIVE = ' ' * I_CALLBACK_PROGRAM = ' ' * I_CALLBACK_PF_STATUS_SET = ' ' * I_CALLBACK_USER_COMMAND = ' ' * I_CALLBACK_TOP_OF_PAGE = ' ' * I_CALLBACK_HTML_TOP_OF_PAGE = ' ' * I_CALLBACK_HTML_END_OF_LIST = ' ' * I_STRUCTURE_NAME = * I_BACKGROUND_ID = ' ' * I_GRID_TITLE = * I_GRID_SETTINGS = * IS_LAYOUT = IT_FIELDCAT = lt_fieldcat * IT_EXCLUDING = * IT_SPECIAL_GROUPS = * IT_SORT = * IT_FILTER = * IS_SEL_HIDE = * I_DEFAULT = 'X' * I_SAVE = ' ' * IS_VARIANT = * IT_EVENTS = * IT_EVENT_EXIT = * IS_PRINT = * IS_REPREP_ID = * I_SCREEN_START_COLUMN = 0 * I_SCREEN_START_LINE = 0 * I_SCREEN_END_COLUMN = 0 * I_SCREEN_END_LINE = 0 * I_HTML_HEIGHT_TOP = 0 * I_HTML_HEIGHT_END = 0 * IT_ALV_GRAPHICS = * IT_HYPERLINK = * IT_ADD_FIELDCAT = * IT_EXCEPT_QINFO = * IR_SALV_FULLSCREEN_ADAPTER = * IMPORTING * E_EXIT_CAUSED_BY_CALLER = * ES_EXIT_CAUSED_BY_USER = TABLES T_OUTTAB = ut_new_indexes * EXCEPTIONS * PROGRAM_ERROR = 1 * OTHERS = 2 .
BAL_LOG_CREATE call function 'BAL_LOG_CREATE' exporting i_s_log = l_s_log importing e_log_handle = g_log_handle.
BAL_DSP_LOG_DISPLAY call function 'BAL_DSP_LOG_DISPLAY' * EXPORTING * i_t_log_handle = l_t_log_handle exceptions profile_inconsistent = 1 internal_error = 2 no_data_available = 3 no_authority = 4 others = 5.
BAL_DB_SAVE_PREPARE call function 'BAL_DB_SAVE_PREPARE' exporting i_t_replace_in_these_logs = l_t_log_handle.
BAL_DB_SAVE call function 'BAL_DB_SAVE' exporting i_t_log_handle = l_t_log_handle i_in_update_task = ' ' exceptions log_not_found = 0 save_not_allowed = 0 numbering_error = 0.
BAL_LOG_MSG_ADD call function 'BAL_LOG_MSG_ADD' exporting i_log_handle = g_log_handle i_s_msg = l_s_msg exceptions log_not_found = 0 others = 1.
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 SHDB_INDEX_ANALYZE or its description.
SHDB_INDEX_ANALYZE - Analyze Indexing for HANA SHDB_INDEX_ANALYZE - Analyze Indexing for HANA SHDB_GROUP_TABLES_LOAD_BASED - SHDB_GROUP_TABLES_LOAD_BASED SHDB_GROUP_TABLES_LOAD_BASED - SHDB_GROUP_TABLES_LOAD_BASED SHDB_DISTRIBUTE_TABLES - Report SHDB_DISTRIBUTE_TABLES SHDB_DISTRIBUTE_TABLES - Report SHDB_DISTRIBUTE_TABLES