SAP Reports / Programs
DMC_CREATE_INDEX SAP ABAP Report - MWB: Maintenance of Database Index (local/remote)
DMC_CREATE_INDEX is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Program for checking and organizing secondary indexes (also in remote systems)...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.
If you would like to execute this report or see the full code listing simply enter DMC_CREATE_INDEX 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 DMC_CREATE_INDEX. "Basic submit
SUBMIT DMC_CREATE_INDEX AND RETURN. "Return to original report after report execution complete
SUBMIT DMC_CREATE_INDEX 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: P_TAB = D Table Name
Selection Text: P_LST = Display indexes for table
Selection Text: P_IND = D Index ID
Selection Text: P_FLD8 = Field Name 8th Index Field
Selection Text: P_FLD7 = Field Name 7th Index Field
Selection Text: P_FLD6 = Field Name 6th Index Field
Selection Text: P_FLD5 = Field Name 5th Index Field
Selection Text: P_FLD4 = Field Name 4th Index Field
Selection Text: P_FLD3 = Field Name 3rd Index Field
Selection Text: P_FLD2 = Field Name 2nd Index Field
Selection Text: P_FLD1 = Field Name 1st Index Field
Selection Text: P_DEST = D RFC Destination
Selection Text: P_DEL = Delete Index
Selection Text: P_CRE = Create index
Selection Text: P_CHK = Check table
Title: MWB: Maintenance of Database Index (local/remote)
Text Symbol: T04 = Function
Text Symbol: T03 = RFC Destination
Text Symbol: T02 = Index fields
Text Symbol: T01 = Table/ Index
Text Symbol: 204 = Field name
Text Symbol: 202 = Pos
Text Symbol: 201 = Index
Text Symbol: 200 = Physical table
Text Symbol: 106 = Index was deleted
Text Symbol: 105 = Index was created
Text Symbol: 101 = Table does not exist:
Text Symbol: 100 = No secondary index found for table:
Text Symbol: 002 = Check was successful - table exists in the specified system
Text Symbol: 001 = Table not found in the specified system
INCLUDES used within this REPORT DMC_CREATE_INDEX
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:
RFC_SYSTEM_INFO CALL FUNCTION 'RFC_SYSTEM_INFO' DESTINATION p_dest IMPORTING rfcsi_export = wa_rfcsi EXCEPTIONS communication_failure = 1 MESSAGE rfc_msg system_failure = 2 MESSAGE rfc_msg OTHERS = 3.
DD_INDEX_INTERFACE CALL FUNCTION 'DD_INDEX_INTERFACE' DESTINATION p_dest EXPORTING table_name = p_tab index_name = p_ind action = 'I' activate = 'X' shorttext = 'MWB' no_transp_request = 'X' IMPORTING actfailed = l_actfailed TABLES index_fields = gt_fields EXCEPTIONS cancelled = 1 already_exist = 2 permission_error = 3 name_not_allowed = 4 db_access_error = 5 basetab_error = 6 not_exist = 7 communication_failure = 8 MESSAGE rfc_msg system_failure = 9 MESSAGE rfc_msg OTHERS = 10.
DD_INDEX_INTERFACE CALL FUNCTION 'DD_INDEX_INTERFACE' DESTINATION p_dest EXPORTING table_name = p_tab index_name = p_ind action = 'U' activate = 'X' shorttext = 'MWB' no_transp_request = 'X' IMPORTING actfailed = l_actfailed TABLES index_fields = gt_fields EXCEPTIONS cancelled = 1 already_exist = 2 permission_error = 3 name_not_allowed = 4 db_access_error = 5 basetab_error = 6 not_exist = 7 communication_failure = 8 MESSAGE rfc_msg system_failure = 9 MESSAGE rfc_msg OTHERS = 10.
DD_INDEX_INTERFACE CALL FUNCTION 'DD_INDEX_INTERFACE' DESTINATION p_dest EXPORTING table_name = p_tab index_name = p_ind action = 'D' no_transp_request = 'X' IMPORTING actfailed = l_actfailed TABLES index_fields = gt_fields EXCEPTIONS cancelled = 1 already_exist = 2 permission_error = 3 name_not_allowed = 4 db_access_error = 5 basetab_error = 6 not_exist = 7 communication_failure = 8 MESSAGE rfc_msg system_failure = 9 MESSAGE rfc_msg OTHERS = 10.
DD_TABL_GET CALL FUNCTION 'DD_TABL_GET' DESTINATION p_dest EXPORTING tabl_name = p_tab IMPORTING dd02v_wa_a = wa_dd02v_30 TABLES dd12v_tab_a = gt_dd12v_30_a dd12v_tab_n = gt_dd12v_30_n dd17v_tab_a = gt_dd17v_30_a dd17v_tab_n = gt_dd17v_30_n EXCEPTIONS access_failure = 1 communication_failure = 2 MESSAGE rfc_msg system_failure = 3 MESSAGE rfc_msg OTHERS = 4.
DD_TABL_GET CALL FUNCTION 'DD_TABL_GET' DESTINATION p_dest EXPORTING tabl_name = p_tab IMPORTING dd02v_wa_a = wa_dd02v TABLES dd12v_tab_a = gt_dd12v_a dd12v_tab_n = gt_dd12v_n dd17v_tab_a = gt_dd17v_a dd17v_tab_n = gt_dd17v_n EXCEPTIONS access_failure = 1 communication_failure = 2 MESSAGE rfc_msg system_failure = 3 MESSAGE rfc_msg OTHERS = 4.
DD_TABL_GET CALL FUNCTION 'DD_TABL_GET' DESTINATION p_dest EXPORTING tabl_name = p_tab IMPORTING dd02v_wa_a = wa_dd02v_30 TABLES dd12v_tab_a = gt_dd12v_30_a dd12v_tab_n = gt_dd12v_30_n dd17v_tab_a = gt_dd17v_30_a dd17v_tab_n = gt_dd17v_30_n EXCEPTIONS access_failure = 1 communication_failure = 2 MESSAGE rfc_msg system_failure = 3 MESSAGE rfc_msg OTHERS = 4.
DD_TABL_GET CALL FUNCTION 'DD_TABL_GET' DESTINATION p_dest EXPORTING tabl_name = p_tab IMPORTING dd02v_wa_a = wa_dd02v TABLES dd12v_tab_a = gt_dd12v_a dd12v_tab_n = gt_dd12v_n dd17v_tab_a = gt_dd17v_a dd17v_tab_n = gt_dd17v_n EXCEPTIONS access_failure = 1 communication_failure = 2 MESSAGE rfc_msg system_failure = 3 MESSAGE rfc_msg OTHERS = 4.
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 DMC_CREATE_INDEX or its description.
DMC_CREATE_INDEX - MWB: Maintenance of Database Index (local/remote) DMC_CREATE_INDEX - MWB: Maintenance of Database Index (local/remote) DMC_CREATE_EMPTY_PRECALC_ACPL - Create precalculation with predefined number of access plans for calc. DMC_CREATE_EMPTY_PRECALC_ACPL - Create precalculation with predefined number of access plans for calc. DMC_CREATE_CLUSTER - Conversion: Create cluster for temporary data storage DMC_CREATE_CLUSTER - Conversion: Create cluster for temporary data storage