DMCIND01 SAP ABAP Report - MWB: Create Index in Database
DMCIND01 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 DMCIND01 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 DMCIND01. "Basic submit
SUBMIT DMCIND01 AND RETURN. "Return to original report after report execution complete
SUBMIT DMCIND01 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_TSP = Table Name
Selection Text: P_TAB = Tablespace
Selection Text: P_SIM = Simulation (Display Only)
Selection Text: P_NEXT = Parameter NEXT
Selection Text: P_MIN = Parameter MINEXTENTS
Selection Text: P_MAX = Parameter MAXEXTENTS
Selection Text: P_INIT = Parameter INIT
Selection Text: P_IND = Index Name
Selection Text: P_FLD3 = Name of Index Field #3
Selection Text: P_FLD2 = Name of Index Field #2
Selection Text: P_FLD1 = Name of Index Field #1
Title: MWB: Create Index in Database
Text Symbol: T03 = Table Fields (Only for Table Cluster)
Text Symbol: T02 = Options
Text Symbol: T01 = Storage Parameter (Optional)
Text Symbol: 013 = For cluster: Enter at least one index field
Text Symbol: 012 = No fields for index found
Text Symbol: 011 = Rtrn code =
Text Symbol: 010 = Error While Executing Database Change
Text Symbol: 006 = Index Does Not Exist in Dictionary
Text Symbol: 005 = IndexName
Text Symbol: 004 = Table Name
Text Symbol: 003 = Missing Input Parameter :
Text Symbol: 002 = only for ORACLE. Function was terminated.
Text Symbol: 001 = Function is currently available
INCLUDES used within this REPORT DMCIND01
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:
DD_INDEX_NAME CALL FUNCTION 'DD_INDEX_NAME' EXPORTING INDEXNAME = P_IND TABNAME = P_TAB IMPORTING DBINDEX = G_DBINDEX EXCEPTIONS OTHERS = 1.
DB_EXISTS_INDEX CALL FUNCTION 'DB_EXISTS_INDEX' EXPORTING DBINDEX = G_DBINDEX IMPORTING SUBRC = G_RC EXCEPTIONS OTHERS = 1.
DB_GET_INDEX_PARAMETER CALL FUNCTION 'DB_GET_INDEX_PARAMETER' EXPORTING INDEXNAME = P_IND SOURCE = 'CMP' TABNAME = P_TAB IMPORTING DD12DBS = GS_DD12DBS EXCEPTIONS INDEX_DOES_NOT_EXIST = 1 NOT_SET = 2 UNCOMPLETE_PARAMETER = 3 OTHERS = 4.
WRITE_AND_CALL_DBPROG CALL FUNCTION 'WRITE_AND_CALL_DBPROG' IMPORTING GENPROG = G_GENPROG RC = G_RC TABLES STATEMENTS = GT_STATEMENTS EXCEPTIONS PROGRAM_NOT_WRITTEN = 1 SQL_ERROR_OCCURED = 2 OTHERS = 3.
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 DMCIND01 or its description.