SAP Function Module DB_DROP_VIEW
Deletes a view in the database
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
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.
Technical Information
| Function Module | DB_DROP_VIEW |
| Short Text | Deletes a view in the database |
| Function Group | SDB2 |
| Package | SDIC |
| Module Type | Normal Module |
Importing Parameters
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 |
Exporting Parameters
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 |
Changing Parameters
This function module does not define any CHANGING parameters.
Table Parameters
This function module does not define any TABLE parameters.
Exceptions
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 |