SAP Function Modules
DB_CREATE_INDEX_S SAP Function module
DB_CREATE_INDEX_S is a standard SAP function module available within R/3 SAP systems depending on your version and release level. Below is the pattern details for this FM showing its interface including any import and export parameters, exceptions etc as well as any documentation contributions (Comments) specific to the object.
See here to view full function module documentation and code listing, simply by entering the name DB_CREATE_INDEX_S into the relevant SAP transaction such as SE37 or SE80.
Associated Function Group:
SDB2
Released Date:
Not Released
Processing type: Normal fucntion module
Pattern for FM DB_CREATE_INDEX_S - DB CREATE INDEX S
CALL FUNCTION 'DB_CREATE_INDEX_S' "
EXPORTING
* dbindex = SPACE " dd12l-dbindex
* dbindex = SPACE " dd12l-dbindex Name of the index to be created on the DB
* indexname = SPACE " dd12v-indexname Unique Index ID in a Table
* dbsys = SY-DBSYS " sy-dbsys
* dbsys = SY-DBSYS " sy-dbsys DBS for which program is generated
* no_exec = SPACE "
* no_exec = SPACE " X: Do not execute generated program
* prid = 0 " sy-tabix Log ID
* progname = SPACE " trdir-name Name of gen. program
tabname = " dd02l-tabname Name of table
tabname = " dd02l-tabname
* unique = SPACE " dd12l-uniqueflag
* unique = SPACE " dd12l-uniqueflag X: create unique index
* max_severity = 'E' " sy-msgty
* db_check_flag = SPACE "
* dbspec_info = " ddindx_dbspec
IMPORTING
genprog = " trdir-name
genprog = " trdir-name Actual name of the generated program
TABLES
ddfldnames = " ddfldnam Names of the index fields
statements = " Table of the generated statements
EXCEPTIONS
INDEX_EXISTS = 1 " Index already exists
INDEX_NOT_CREATED = 2 " Error when creating the index
PROGRAM_NOT_GENERATED = 3 " Program could not be generated
PROGRAM_NOT_WRITTEN = 4 " Program could not be written
TABLE_DOES_NOT_EXIST = 5 " Table does not exist
STORAGE_NOT_DETERMINATED = 6 "
. " DB_CREATE_INDEX_S
ABAP code example for Function Module DB_CREATE_INDEX_S
The ABAP code below is a full code listing to execute function module DB_CREATE_INDEX_S including all data declarations. The code uses the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the original method of declaring data variables up front. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8).
| ld_genprog | TYPE TRDIR-NAME , |
| ld_genprog | TYPE TRDIR-NAME , |
| it_ddfldnames | TYPE STANDARD TABLE OF DDFLDNAM,"TABLES PARAM |
| wa_ddfldnames | LIKE LINE OF it_ddfldnames , |
| it_statements | TYPE STANDARD TABLE OF STRING,"TABLES PARAM |
| wa_statements | LIKE LINE OF it_statements . |
SELECT single DBINDEX
FROM DD12L
INTO @DATA(ld_dbindex).
SELECT single DBINDEX
FROM DD12L
INTO @DATA(ld_dbindex).
SELECT single INDEXNAME
FROM DD12V
INTO @DATA(ld_indexname).
DATA(ld_dbsys) = 'some text here'.
DATA(ld_dbsys) = 'some text here'.
DATA(ld_no_exec) = 'some text here'.
DATA(ld_no_exec) = 'some text here'.
DATA(ld_prid) = '123 '.
SELECT single NAME
FROM TRDIR
INTO @DATA(ld_progname).
SELECT single TABNAME
FROM DD02L
INTO @DATA(ld_tabname).
SELECT single TABNAME
FROM DD02L
INTO @DATA(ld_tabname).
SELECT single UNIQUEFLAG
FROM DD12L
INTO @DATA(ld_unique).
SELECT single UNIQUEFLAG
FROM DD12L
INTO @DATA(ld_unique).
DATA(ld_max_severity) = 'some text here'.
DATA(ld_db_check_flag) = 'some text here'.
DATA(ld_dbspec_info) = 'some text here'.
"populate fields of struture and append to itab
append wa_ddfldnames to it_ddfldnames.
"populate fields of struture and append to itab
append wa_statements to it_statements. . CALL FUNCTION 'DB_CREATE_INDEX_S' EXPORTING * dbindex = ld_dbindex * dbindex = ld_dbindex * indexname = ld_indexname * dbsys = ld_dbsys * dbsys = ld_dbsys * no_exec = ld_no_exec * no_exec = ld_no_exec * prid = ld_prid * progname = ld_progname tabname = ld_tabname tabname = ld_tabname * unique = ld_unique * unique = ld_unique * max_severity = ld_max_severity * db_check_flag = ld_db_check_flag * dbspec_info = ld_dbspec_info IMPORTING genprog = ld_genprog genprog = ld_genprog TABLES ddfldnames = it_ddfldnames statements = it_statements EXCEPTIONS INDEX_EXISTS = 1 INDEX_NOT_CREATED = 2 PROGRAM_NOT_GENERATED = 3 PROGRAM_NOT_WRITTEN = 4 TABLE_DOES_NOT_EXIST = 5 STORAGE_NOT_DETERMINATED = 6 . " DB_CREATE_INDEX_S
IF SY-SUBRC EQ 0. "All OK ELSEIF SY-SUBRC EQ 1. "Exception "Add code for exception here ELSEIF SY-SUBRC EQ 2. "Exception "Add code for exception here ELSEIF SY-SUBRC EQ 3. "Exception "Add code for exception here ELSEIF SY-SUBRC EQ 4. "Exception "Add code for exception here ELSEIF SY-SUBRC EQ 5. "Exception "Add code for exception here ELSEIF SY-SUBRC EQ 6. "Exception "Add code for exception here ENDIF.
ABAP code to compare 7.40 inline data declaration with original syntax
The below ABAP code uses the older none in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. It may also be useful if you are using an older version of SAP as some of the newer syntax above, such as the @DATA is not available until 4.70 EHP 8.
DATA:
| ld_genprog | TYPE TRDIR-NAME , |
| ld_genprog | TYPE TRDIR-NAME , |
| ld_dbindex | TYPE DD12L-DBINDEX , |
| ld_dbindex | TYPE DD12L-DBINDEX , |
| it_ddfldnames | TYPE STANDARD TABLE OF DDFLDNAM , |
| wa_ddfldnames | LIKE LINE OF it_ddfldnames, |
| ld_indexname | TYPE DD12V-INDEXNAME , |
| it_statements | TYPE STANDARD TABLE OF STRING , |
| wa_statements | LIKE LINE OF it_statements, |
| ld_dbsys | TYPE SY-DBSYS , |
| ld_dbsys | TYPE SY-DBSYS , |
| ld_no_exec | TYPE STRING , |
| ld_no_exec | TYPE STRING , |
| ld_prid | TYPE SY-TABIX , |
| ld_progname | TYPE TRDIR-NAME , |
| ld_tabname | TYPE DD02L-TABNAME , |
| ld_tabname | TYPE DD02L-TABNAME , |
| ld_unique | TYPE DD12L-UNIQUEFLAG , |
| ld_unique | TYPE DD12L-UNIQUEFLAG , |
| ld_max_severity | TYPE SY-MSGTY , |
| ld_db_check_flag | TYPE STRING , |
| ld_dbspec_info | TYPE DDINDX_DBSPEC . |
SELECT single DBINDEX
FROM DD12L
INTO ld_dbindex.
SELECT single DBINDEX
FROM DD12L
INTO ld_dbindex.
"populate fields of struture and append to itab
append wa_ddfldnames to it_ddfldnames.
SELECT single INDEXNAME
FROM DD12V
INTO ld_indexname.
"populate fields of struture and append to itab
append wa_statements to it_statements.
ld_dbsys = 'some text here'.
ld_dbsys = 'some text here'.
ld_no_exec = 'some text here'.
ld_no_exec = 'some text here'.
ld_prid = '123 '.
SELECT single NAME
FROM TRDIR
INTO ld_progname.
SELECT single TABNAME
FROM DD02L
INTO ld_tabname.
SELECT single TABNAME
FROM DD02L
INTO ld_tabname.
SELECT single UNIQUEFLAG
FROM DD12L
INTO ld_unique.
SELECT single UNIQUEFLAG
FROM DD12L
INTO ld_unique.
ld_max_severity = 'some text here'.
ld_db_check_flag = 'some text here'.
ld_dbspec_info = 'some text here'.
Contribute (Add Comments)
Please help keep this info upto date and use the comments section below to add useful hints, tips and information specific to this SAP function. This will then be available for you and other users to easily find by simply searching on the object name DB_CREATE_INDEX_S or its description.