SAP SAPDB_DBM_EXECUTE_XL Function Module for
SAPDB_DBM_EXECUTE_XL is a standard sapdb dbm execute xl SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used to perform a specific ABAP function and below is the pattern details, 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 sapdb dbm execute xl FM, simply by entering the name SAPDB_DBM_EXECUTE_XL into the relevant SAP transaction such as SE37 or SE38.
Function Group: SADC
Program Name: SAPLSADC
Main Program: SAPLSADC
Appliation area:
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:

Function SAPDB_DBM_EXECUTE_XL 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 'SAPDB_DBM_EXECUTE_XL'".
EXPORTING
DBNODE = "SAP DB: DBServer name
* NOHOLD = "
* SAPFLAG = "
* FORCE_MODE = "
DBNAME = "SAP DB: DBName
* DBUSER = "SAP DB: DBUser name
* SYSID = "Name of SAP R/3 System
* CONN = "Logical Name for a Database Connection
* PROFILE = "SAP DB: Name tp-profile (absolute)
DBMCMD = "SAP DB: DBMServer command
* XUSER = "SAP DB: XUSER Name
* CALL_MODE = 'C' "SAP DB: DBMRFC Call Mode
IMPORTING
DBMID = "SAP DB: Session ID for DBM_EXECUTE
SYSRC = "SAP DB: SysRC from DBM call
DBMRC = "SAP DB: Error code from DBMServer command
ERRTXT = "SAP DB: Error text from DBM command
TABLES
TANSW = "SAP DB: Response Line from DBM Command
EXCEPTIONS
COMMUNICATION_FAILURE = 1 SYSTEM_FAILURE = 2 DBM_SYSTEM_ERROR = 3 DBM_EXECUTE_ERROR = 4 NO_PERMISSION = 5
IMPORTING Parameters details for SAPDB_DBM_EXECUTE_XL
DBNODE - SAP DB: DBServer name
Data type: SDB_DBNODEOptional: No
Call by Reference: Yes
NOHOLD -
Data type: FLAGOptional: Yes
Call by Reference: Yes
SAPFLAG -
Data type: FLAGOptional: Yes
Call by Reference: Yes
FORCE_MODE -
Data type: FLAGOptional: Yes
Call by Reference: Yes
DBNAME - SAP DB: DBName
Data type: SDB_DBNAMEOptional: No
Call by Reference: Yes
DBUSER - SAP DB: DBUser name
Data type: SDB_DBUSEROptional: Yes
Call by Reference: Yes
SYSID - Name of SAP R/3 System
Data type: SYSYSIDOptional: Yes
Call by Reference: Yes
CONN - Logical Name for a Database Connection
Data type: DBCON_NAMEOptional: Yes
Call by Reference: Yes
PROFILE - SAP DB: Name tp-profile (absolute)
Data type: SDB_PROFOptional: Yes
Call by Reference: Yes
DBMCMD - SAP DB: DBMServer command
Data type: SDB_C512Optional: No
Call by Reference: Yes
XUSER - SAP DB: XUSER Name
Data type: SDB_XUSEROptional: Yes
Call by Reference: Yes
CALL_MODE - SAP DB: DBMRFC Call Mode
Data type: SDB_CMODEDefault: 'C'
Optional: Yes
Call by Reference: Yes
EXPORTING Parameters details for SAPDB_DBM_EXECUTE_XL
DBMID - SAP DB: Session ID for DBM_EXECUTE
Data type: SDB_DBMIDOptional: No
Call by Reference: Yes
SYSRC - SAP DB: SysRC from DBM call
Data type: SDB_SYSRCOptional: No
Call by Reference: Yes
DBMRC - SAP DB: Error code from DBMServer command
Data type: SDB_DBMRCOptional: No
Call by Reference: Yes
ERRTXT - SAP DB: Error text from DBM command
Data type: SDB_ERRTXTOptional: No
Call by Reference: Yes
TABLES Parameters details for SAPDB_DBM_EXECUTE_XL
TANSW - SAP DB: Response Line from DBM Command
Data type: SDBLINE512Optional: No
Call by Reference: Yes
EXCEPTIONS details
COMMUNICATION_FAILURE -
Data type:Optional: No
Call by Reference: No ( called with pass by value option)
SYSTEM_FAILURE -
Data type:Optional: No
Call by Reference: No ( called with pass by value option)
DBM_SYSTEM_ERROR -
Data type:Optional: No
Call by Reference: No ( called with pass by value option)
DBM_EXECUTE_ERROR -
Data type:Optional: No
Call by Reference: No ( called with pass by value option)
NO_PERMISSION -
Data type:Optional: No
Call by Reference: No ( called with pass by value option)
Copy and paste ABAP code example for SAPDB_DBM_EXECUTE_XL 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_dbmid | TYPE SDB_DBMID, " | |||
| lt_tansw | TYPE STANDARD TABLE OF SDBLINE512, " | |||
| lv_dbnode | TYPE SDB_DBNODE, " | |||
| lv_communication_failure | TYPE SDB_DBNODE, " | |||
| lv_nohold | TYPE FLAG, " | |||
| lv_sapflag | TYPE FLAG, " | |||
| lv_force_mode | TYPE FLAG, " | |||
| lv_sysrc | TYPE SDB_SYSRC, " | |||
| lv_dbname | TYPE SDB_DBNAME, " | |||
| lv_system_failure | TYPE SDB_DBNAME, " | |||
| lv_dbmrc | TYPE SDB_DBMRC, " | |||
| lv_dbuser | TYPE SDB_DBUSER, " | |||
| lv_dbm_system_error | TYPE SDB_DBUSER, " | |||
| lv_sysid | TYPE SYSYSID, " | |||
| lv_errtxt | TYPE SDB_ERRTXT, " | |||
| lv_dbm_execute_error | TYPE SDB_ERRTXT, " | |||
| lv_conn | TYPE DBCON_NAME, " | |||
| lv_no_permission | TYPE DBCON_NAME, " | |||
| lv_profile | TYPE SDB_PROF, " | |||
| lv_dbmcmd | TYPE SDB_C512, " | |||
| lv_xuser | TYPE SDB_XUSER, " | |||
| lv_call_mode | TYPE SDB_CMODE. " 'C' |
|   CALL FUNCTION 'SAPDB_DBM_EXECUTE_XL' " |
| EXPORTING | ||
| DBNODE | = lv_dbnode | |
| NOHOLD | = lv_nohold | |
| SAPFLAG | = lv_sapflag | |
| FORCE_MODE | = lv_force_mode | |
| DBNAME | = lv_dbname | |
| DBUSER | = lv_dbuser | |
| SYSID | = lv_sysid | |
| CONN | = lv_conn | |
| PROFILE | = lv_profile | |
| DBMCMD | = lv_dbmcmd | |
| XUSER | = lv_xuser | |
| CALL_MODE | = lv_call_mode | |
| IMPORTING | ||
| DBMID | = lv_dbmid | |
| SYSRC | = lv_sysrc | |
| DBMRC | = lv_dbmrc | |
| ERRTXT | = lv_errtxt | |
| TABLES | ||
| TANSW | = lt_tansw | |
| EXCEPTIONS | ||
| COMMUNICATION_FAILURE = 1 | ||
| SYSTEM_FAILURE = 2 | ||
| DBM_SYSTEM_ERROR = 3 | ||
| DBM_EXECUTE_ERROR = 4 | ||
| NO_PERMISSION = 5 | ||
| . " SAPDB_DBM_EXECUTE_XL | ||
ABAP code using 7.40 inline data declarations to call FM SAPDB_DBM_EXECUTE_XL
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.| DATA(ld_call_mode) | = 'C'. | |||
Search for further information about these or an SAP related objects