The Function Module DB_DROP_INDEX_S (As DB_DROP_INDEX, basically returns the generated statements) is a standard Function Module in SAP ERP and is part of the function group SDB2 within the package SDIC.
| Function Module | DB_DROP_INDEX_S |
| Short Text | As DB_DROP_INDEX, basically returns the generated statements |
| Function Group | SDB2 |
| Package | SDIC |
| Module Type | Normal Module |
These are the IMPORTING parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| DBINDEX | LIKE | DD12L-DBINDEX | Name of the index on the DB | |
| DBSYS | LIKE | SY-DBSYS | SY-DBSYS | DBS for which program is generated |
| DB_CHECK_FLAG | LIKE | 'X' | ||
| INDEXNAME | TYPE | DD12V-INDEXNAME | Unique Index ID in a Table | |
| NO_EXEC | LIKE | SPACE | X: Do not execute generated program | |
| PRID | LIKE | SY-TABIX | 0 | |
| PROGNAME | LIKE | TRDIR-NAME | SPACE | Name of generated program |
| STORSAVE_UNDER_TABNAME | TYPE | DD02L-TABNAME | SPACE | |
| TABNAME | LIKE | DD02L-TABNAME |
These are the EXPORTING parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| GENPROG | LIKE | TRDIR-NAME | Actual name of the generated program | |
| SUBRC | LIKE | SY-SUBRC | 0: deleted, 4: index does not exist |
This function module does not define any CHANGING parameters.
These are the TABLE parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| STATEMENTS | LIKE | Table of the generated SQL statements |
These are the Exceptions of this function module.
| Exception Name | Short Text |
|---|---|
| INDEX_NOT_DROPPED | Error deleting the index |
| PROGRAM_NOT_GENERATED | Program could not be generated |
| PROGRAM_NOT_WRITTEN | Program could not be written |
| STORAGE_NOT_DETERMINATED |