SAP Function Modules
DB_DROP_TABLE_S SAP Function module
DB_DROP_TABLE_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_DROP_TABLE_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_DROP_TABLE_S - DB DROP TABLE S
CALL FUNCTION 'DB_DROP_TABLE_S' "
EXPORTING
* 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
* progname = SPACE " trdir-name Name of the generated program ($LISTE: screen display)
tabname = " dd02l-tabname
tabname = " dd02l-tabname Name of the table
* ddhead = " ddheader
* db_check_flag = SPACE "
* storsave_under_tabname = SPACE " dd02l-tabname
IMPORTING
genprog = " trdir-name
genprog = " trdir-name Actual name of the generated program
subrc = " sy-subrc
subrc = " sy-subrc 0: deleted; 4: table does not exist
TABLES
statements = " Table of the generated statements
EXCEPTIONS
PROGRAM_NOT_GENERATED = 1 " Program could not be generated
PROGRAM_NOT_WRITTEN = 2 " Program could not be written
TABLE_NOT_DROPPED = 3 " Error when deleting the table
STORAGE_NOT_DETERMINATED = 4 "
. " DB_DROP_TABLE_S
ABAP code example for Function Module DB_DROP_TABLE_S
The ABAP code below is a full code listing to execute function module DB_DROP_TABLE_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 , |
| ld_subrc | TYPE SY-SUBRC , |
| ld_subrc | TYPE SY-SUBRC , |
| it_statements | TYPE STANDARD TABLE OF STRING,"TABLES PARAM |
| wa_statements | LIKE LINE OF it_statements . |
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).
DATA(ld_ddhead) = '123 '.
DATA(ld_db_check_flag) = 'some text here'.
SELECT single TABNAME
FROM DD02L
INTO @DATA(ld_storsave_under_tabname).
"populate fields of struture and append to itab
append wa_statements to it_statements. . CALL FUNCTION 'DB_DROP_TABLE_S' EXPORTING * 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 * ddhead = ld_ddhead * db_check_flag = ld_db_check_flag * storsave_under_tabname = ld_storsave_under_tabname IMPORTING genprog = ld_genprog genprog = ld_genprog subrc = ld_subrc subrc = ld_subrc TABLES statements = it_statements EXCEPTIONS PROGRAM_NOT_GENERATED = 1 PROGRAM_NOT_WRITTEN = 2 TABLE_NOT_DROPPED = 3 STORAGE_NOT_DETERMINATED = 4 . " DB_DROP_TABLE_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 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_dbsys | TYPE SY-DBSYS , |
| ld_dbsys | TYPE SY-DBSYS , |
| it_statements | TYPE STANDARD TABLE OF STRING , |
| wa_statements | LIKE LINE OF it_statements, |
| ld_subrc | TYPE SY-SUBRC , |
| ld_subrc | TYPE SY-SUBRC , |
| 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_ddhead | TYPE DDHEADER , |
| ld_db_check_flag | TYPE STRING , |
| ld_storsave_under_tabname | TYPE DD02L-TABNAME . |
ld_dbsys = 'some text here'.
ld_dbsys = 'some text here'.
"populate fields of struture and append to itab
append wa_statements to it_statements.
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.
ld_ddhead = '123 '.
ld_db_check_flag = 'some text here'.
SELECT single TABNAME
FROM DD02L
INTO ld_storsave_under_tabname.
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_DROP_TABLE_S or its description.