The Function Module DB_DROP_VIEW (Deletes a view in the database) is a standard Function Module in SAP ERP and is part of the function group SDB2 within the package SDIC.
| Function Module | DB_DROP_VIEW |
| Short Text | Deletes a view in the database |
| 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 |
|---|---|---|---|---|
| DBSYS | LIKE | SY-DBSYS | SY-DBSYS | DBS for which program is generated |
| DB_CHECK_FLAG | LIKE | SPACE | ||
| IGNORE_SQL_ERROR | LIKE | SPACE | ||
| NO_EXEC | LIKE | SPACE | X: Do not execute generated program | |
| PRID | LIKE | SY-TABIX | 0 | |
| PROGNAME | LIKE | TRDIR-NAME | SPACE | Name of generated program |
| VIEWNAME | LIKE | DD25V-VIEWNAME | View name |
These are the EXPORTING parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| GENPROG | LIKE | TRDIR-NAME | Real name of the generated program | |
| SUBRC | LIKE | SY-SUBRC | 0: deleted, 4: view does not exist |
This function module does not define any CHANGING parameters.
This function module does not define any TABLE parameters.
These are the Exceptions of this function module.
| Exception Name | Short Text |
|---|---|
| PROGRAM_NOT_GENERATED | Program could not be generated |
| PROGRAM_NOT_WRITTEN | Program could not be written |
| VIEW_NOT_DROPPED | Error when deleting the view |