SAP DB_TABL_CNV Function Module for Execute an action of the DB utility









DB_TABL_CNV is a standard db tabl cnv SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for Execute an action of the DB utility processing and below is the pattern details for this FM, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.


See here to view full function module documentation and code listing for db tabl cnv FM, simply by entering the name DB_TABL_CNV into the relevant SAP transaction such as SE37 or SE38.

Function Group: SDB6
Program Name: SAPLSDB6
Main Program: SAPLSDB6
Appliation area: S
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:



Function DB_TABL_CNV pattern details

In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.
CALL FUNCTION 'DB_TABL_CNV'"Execute an action of the DB utility
EXPORTING
TABNAME = "
* PRID = 0 "Row Index of Internal Tables
* TARGET = "
* FCT = "
* EXECMODE = "
* MUTUALEX = 'X' "
* STEPPER = 'X' "
* DEBUG = ' ' "

IMPORTING
SUBRC = "Return Code

CHANGING
* TICNV_WA = "

EXCEPTIONS
OP_FAILURE = 1 NO_OF_POOLS_EXCEEDED = 2 ILLEGAL_FUNCTION = 3 ILLEGAL_EXECMODE = 4 CONVERSION_REJECTED = 5 ILLEGAL_TRANSITION = 6
.



IMPORTING Parameters details for DB_TABL_CNV

TABNAME -

Data type: DD02L-TABNAME
Optional: No
Call by Reference: No ( called with pass by value option)

PRID - Row Index of Internal Tables

Data type: SY-TABIX
Optional: Yes
Call by Reference: No ( called with pass by value option)

TARGET -

Data type: TICNV-POSTSTATE
Optional: Yes
Call by Reference: No ( called with pass by value option)

FCT -

Data type: TBATG-FCT
Optional: Yes
Call by Reference: No ( called with pass by value option)

EXECMODE -

Data type: TBATG-EXECMODE
Optional: Yes
Call by Reference: No ( called with pass by value option)

MUTUALEX -

Data type: DDREFSTRUC-BOOL
Default: 'X'
Optional: Yes
Call by Reference: No ( called with pass by value option)

STEPPER -

Data type: DDREFSTRUC-BOOL
Default: 'X'
Optional: Yes
Call by Reference: No ( called with pass by value option)

DEBUG -

Data type: DDREFSTRUC-BOOL
Default: ' '
Optional: Yes
Call by Reference: No ( called with pass by value option)

EXPORTING Parameters details for DB_TABL_CNV

SUBRC - Return Code

Data type: SY-SUBRC
Optional: No
Call by Reference: No ( called with pass by value option)

CHANGING Parameters details for DB_TABL_CNV

TICNV_WA -

Data type: TICNV
Optional: Yes
Call by Reference: No ( called with pass by value option)

EXCEPTIONS details

OP_FAILURE -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

NO_OF_POOLS_EXCEEDED -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

ILLEGAL_FUNCTION -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

ILLEGAL_EXECMODE -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

CONVERSION_REJECTED -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

ILLEGAL_TRANSITION -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

Copy and paste ABAP code example for DB_TABL_CNV Function Module

The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than 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 newer method of declaring data variables on the fly. 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), which i why i have stuck to the origianl for this example.

DATA:
lv_subrc  TYPE SY-SUBRC, "   
lv_tabname  TYPE DD02L-TABNAME, "   
lv_ticnv_wa  TYPE TICNV, "   
lv_op_failure  TYPE TICNV, "   
lv_prid  TYPE SY-TABIX, "   0
lv_no_of_pools_exceeded  TYPE SY, "   
lv_target  TYPE TICNV-POSTSTATE, "   
lv_illegal_function  TYPE TICNV, "   
lv_fct  TYPE TBATG-FCT, "   
lv_illegal_execmode  TYPE TBATG, "   
lv_execmode  TYPE TBATG-EXECMODE, "   
lv_conversion_rejected  TYPE TBATG, "   
lv_mutualex  TYPE DDREFSTRUC-BOOL, "   'X'
lv_illegal_transition  TYPE DDREFSTRUC, "   
lv_stepper  TYPE DDREFSTRUC-BOOL, "   'X'
lv_debug  TYPE DDREFSTRUC-BOOL. "   ' '

  CALL FUNCTION 'DB_TABL_CNV'  "Execute an action of the DB utility
    EXPORTING
         TABNAME = lv_tabname
         PRID = lv_prid
         TARGET = lv_target
         FCT = lv_fct
         EXECMODE = lv_execmode
         MUTUALEX = lv_mutualex
         STEPPER = lv_stepper
         DEBUG = lv_debug
    IMPORTING
         SUBRC = lv_subrc
    CHANGING
         TICNV_WA = lv_ticnv_wa
    EXCEPTIONS
        OP_FAILURE = 1
        NO_OF_POOLS_EXCEEDED = 2
        ILLEGAL_FUNCTION = 3
        ILLEGAL_EXECMODE = 4
        CONVERSION_REJECTED = 5
        ILLEGAL_TRANSITION = 6
. " DB_TABL_CNV




ABAP code using 7.40 inline data declarations to call FM DB_TABL_CNV

The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.

"SELECT single SUBRC FROM SY INTO @DATA(ld_subrc).
 
"SELECT single TABNAME FROM DD02L INTO @DATA(ld_tabname).
 
 
 
"SELECT single TABIX FROM SY INTO @DATA(ld_prid).
 
 
"SELECT single POSTSTATE FROM TICNV INTO @DATA(ld_target).
 
 
"SELECT single FCT FROM TBATG INTO @DATA(ld_fct).
 
 
"SELECT single EXECMODE FROM TBATG INTO @DATA(ld_execmode).
 
 
"SELECT single BOOL FROM DDREFSTRUC INTO @DATA(ld_mutualex).
DATA(ld_mutualex) = 'X'.
 
 
"SELECT single BOOL FROM DDREFSTRUC INTO @DATA(ld_stepper).
DATA(ld_stepper) = 'X'.
 
"SELECT single BOOL FROM DDREFSTRUC INTO @DATA(ld_debug).
DATA(ld_debug) = ' '.
 


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!