SAP DB_DATA_MOVE Function Module for









DB_DATA_MOVE is a standard db data move 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 db data move FM, simply by entering the name DB_DATA_MOVE into the relevant SAP transaction such as SE37 or SE38.

Function Group: SDB2
Program Name: SAPLSDB2
Main Program: SAPLSDB2
Appliation area:
Release date: N/A
Mode(Normal, Remote etc): Remote-Enabled
Update:



Function DB_DATA_MOVE 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_DATA_MOVE'"
  EXPORTING
*  SRC_TAB =  "
*  DDPROF_USE = ' ' "
*  ACT_MODE = 'M' "
*  CLI_ADD_TYPE = ' ' "
*  DDLCH_WA =  "
*  DST_TAB =  "
*  PRID = 0 "
*  NO_EXEC = 'X' "
*  DATA_CHECK = 'W' "Error gravity for data existence, ' ' = no test
*  COM_SIZE = 16777216 "
*  CLIENT_STATE = ' ' "
*  WITH_LOCK = 'X' "
*  LOADER =  "

 IMPORTING
   STATISTICS =  "
   NO_OF_SUB_POOLS =  "

CHANGING
*  SCHEMA = '' "

TABLES
*  STATEMENTS =  "

EXCEPTIONS
   OP_FAILURE = 1    SRC_TAB_MISSING = 10    NO_OF_POOLS_EXCEEDED = 11    SRC_TAB_ILLEGAL = 12    ILLEGAL_VALUE = 2    SYNTAX_ERROR = 3    WRONG_METHOD = 4    DST_NTAB_ILLEGAL = 5    DST_TAB_ILLEGAL = 6    DST_TAB_MISSING = 7    DATA_EXISTS = 8    SRC_NTAB_ILLEGAL = 9
.



IMPORTING Parameters details for DB_DATA_MOVE

SRC_TAB -

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

DDPROF_USE -

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

ACT_MODE -

Data type: TCNV-ACTMODE
Default: 'M'
Optional: Yes
Call by Reference: No ( called with pass by value option)

CLI_ADD_TYPE -

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

DDLCH_WA -

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

DST_TAB -

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

PRID -

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

NO_EXEC -

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

DATA_CHECK - Error gravity for data existence, ' ' = no test

Data type: GMESS-SEV
Default: 'W'
Optional: Yes
Call by Reference: No ( called with pass by value option)

COM_SIZE -

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

CLIENT_STATE -

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

WITH_LOCK -

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

LOADER -

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

EXPORTING Parameters details for DB_DATA_MOVE

STATISTICS -

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

NO_OF_SUB_POOLS -

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

CHANGING Parameters details for DB_DATA_MOVE

SCHEMA -

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

TABLES Parameters details for DB_DATA_MOVE

STATEMENTS -

Data type: DDSTATEMENTS
Optional: Yes
Call by Reference: Yes

EXCEPTIONS details

OP_FAILURE -

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

SRC_TAB_MISSING -

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)

SRC_TAB_ILLEGAL -

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

ILLEGAL_VALUE -

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

SYNTAX_ERROR -

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

WRONG_METHOD -

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

DST_NTAB_ILLEGAL -

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

DST_TAB_ILLEGAL -

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

DST_TAB_MISSING -

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

DATA_EXISTS -

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

SRC_NTAB_ILLEGAL -

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

Copy and paste ABAP code example for DB_DATA_MOVE 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_schema  TYPE DDREFSTRUC-SYMBOL, "   ''
lv_src_tab  TYPE DD02L-TABNAME, "   
lv_op_failure  TYPE DD02L, "   
lt_statements  TYPE STANDARD TABLE OF DDSTATEMENTS, "   
lv_statistics  TYPE DDCPYSTAT, "   
lv_ddprof_use  TYPE DDREFSTRUC-BOOL, "   ' '
lv_src_tab_missing  TYPE DDREFSTRUC, "   
lv_act_mode  TYPE TCNV-ACTMODE, "   'M'
lv_no_of_pools_exceeded  TYPE TCNV, "   
lv_cli_add_type  TYPE DDREFSTRUC-CLI_ADD_TYPE, "   ' '
lv_src_tab_illegal  TYPE DDREFSTRUC, "   
lv_ddlch_wa  TYPE DDLCH, "   
lv_dst_tab  TYPE DD02L-TABNAME, "   
lv_illegal_value  TYPE DD02L, "   
lv_no_of_sub_pools  TYPE SY-TABIX, "   
lv_prid  TYPE SY-TABIX, "   0
lv_syntax_error  TYPE SY, "   
lv_no_exec  TYPE DDREFSTRUC-BOOL, "   'X'
lv_wrong_method  TYPE DDREFSTRUC, "   
lv_data_check  TYPE GMESS-SEV, "   'W'
lv_dst_ntab_illegal  TYPE GMESS, "   
lv_com_size  TYPE DDREFSTRUC-COM_SIZE, "   16777216
lv_dst_tab_illegal  TYPE DDREFSTRUC, "   
lv_client_state  TYPE DDREFSTRUC-STATE, "   ' '
lv_dst_tab_missing  TYPE DDREFSTRUC, "   
lv_with_lock  TYPE DDREFSTRUC-BOOL, "   'X'
lv_data_exists  TYPE DDREFSTRUC, "   
lv_loader  TYPE DDLOAD, "   
lv_src_ntab_illegal  TYPE DDLOAD. "   

  CALL FUNCTION 'DB_DATA_MOVE'  "
    EXPORTING
         SRC_TAB = lv_src_tab
         DDPROF_USE = lv_ddprof_use
         ACT_MODE = lv_act_mode
         CLI_ADD_TYPE = lv_cli_add_type
         DDLCH_WA = lv_ddlch_wa
         DST_TAB = lv_dst_tab
         PRID = lv_prid
         NO_EXEC = lv_no_exec
         DATA_CHECK = lv_data_check
         COM_SIZE = lv_com_size
         CLIENT_STATE = lv_client_state
         WITH_LOCK = lv_with_lock
         LOADER = lv_loader
    IMPORTING
         STATISTICS = lv_statistics
         NO_OF_SUB_POOLS = lv_no_of_sub_pools
    CHANGING
         SCHEMA = lv_schema
    TABLES
         STATEMENTS = lt_statements
    EXCEPTIONS
        OP_FAILURE = 1
        SRC_TAB_MISSING = 10
        NO_OF_POOLS_EXCEEDED = 11
        SRC_TAB_ILLEGAL = 12
        ILLEGAL_VALUE = 2
        SYNTAX_ERROR = 3
        WRONG_METHOD = 4
        DST_NTAB_ILLEGAL = 5
        DST_TAB_ILLEGAL = 6
        DST_TAB_MISSING = 7
        DATA_EXISTS = 8
        SRC_NTAB_ILLEGAL = 9
. " DB_DATA_MOVE




ABAP code using 7.40 inline data declarations to call FM DB_DATA_MOVE

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 SYMBOL FROM DDREFSTRUC INTO @DATA(ld_schema).
DATA(ld_schema) = ''.
 
"SELECT single TABNAME FROM DD02L INTO @DATA(ld_src_tab).
 
 
 
 
"SELECT single BOOL FROM DDREFSTRUC INTO @DATA(ld_ddprof_use).
DATA(ld_ddprof_use) = ' '.
 
 
"SELECT single ACTMODE FROM TCNV INTO @DATA(ld_act_mode).
DATA(ld_act_mode) = 'M'.
 
 
"SELECT single CLI_ADD_TYPE FROM DDREFSTRUC INTO @DATA(ld_cli_add_type).
DATA(ld_cli_add_type) = ' '.
 
 
 
"SELECT single TABNAME FROM DD02L INTO @DATA(ld_dst_tab).
 
 
"SELECT single TABIX FROM SY INTO @DATA(ld_no_of_sub_pools).
 
"SELECT single TABIX FROM SY INTO @DATA(ld_prid).
 
 
"SELECT single BOOL FROM DDREFSTRUC INTO @DATA(ld_no_exec).
DATA(ld_no_exec) = 'X'.
 
 
"SELECT single SEV FROM GMESS INTO @DATA(ld_data_check).
DATA(ld_data_check) = 'W'.
 
 
"SELECT single COM_SIZE FROM DDREFSTRUC INTO @DATA(ld_com_size).
DATA(ld_com_size) = 16777216.
 
 
"SELECT single STATE FROM DDREFSTRUC INTO @DATA(ld_client_state).
DATA(ld_client_state) = ' '.
 
 
"SELECT single BOOL FROM DDREFSTRUC INTO @DATA(ld_with_lock).
DATA(ld_with_lock) = 'X'.
 
 
 
 


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!