SAP DD_SQLT_ACT Function Module for









DD_SQLT_ACT is a standard dd sqlt act 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 dd sqlt act FM, simply by entering the name DD_SQLT_ACT into the relevant SAP transaction such as SE37 or SE38.

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



Function DD_SQLT_ACT 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 'DD_SQLT_ACT'"
  EXPORTING
*  DEVICE = 'F' "Output device
*  GET_STATE = 'M' "String for controll. read routines for phys. pools/clusters
*  NTAB_PUTSTATE = 'A' "Dict: Flag ('N','A'): Is nametab written inactive/active?
*  WRITE_ENDMESS = 'X' "
*  NO_CHECK = ' ' "
*  PATH = ' ' "
   TABNAME =  "Name of Pool/Cluster in the Database
*  TIMER_ON = ' ' "DD: Flag ('X',''): Switch on timer ?
*  DISPLAY = ' ' "
*  AUTH_CHK = 'X' "DD.: Flag if author. check for DB changes executed
*  EXCOMMIT = ' ' "DD: Flag ('X','') if commit should be performed
*  SETTMST = ' ' "Force updating of the time stamp
*  FUNCT = 'ACT' "

 IMPORTING
   RC =  "Return Code

CHANGING
*  PROTNAME = ' ' "
*  PRID = 0 "Internal Tables, Current Row Index
*  DD06V_WA =  "SQLT Source, Header
*  DD16V_TAB =  "SQLT Source, Fields
*  DD09L_WA =  "

EXCEPTIONS
   NOT_CREATED = 1    WRONG_INPUT_PARAMETER = 2    NOT_FOUND = 3
.



IMPORTING Parameters details for DD_SQLT_ACT

DEVICE - Output device

Data type: SPRWR-DEVICE
Default: 'F'
Optional: Yes
Call by Reference: Yes

GET_STATE - String for controll. read routines for phys. pools/clusters

Data type: DCSQLTCTRL-GETSTATE
Default: 'M'
Optional: Yes
Call by Reference: Yes

NTAB_PUTSTATE - Dict: Flag ('N','A'): Is nametab written inactive/active?

Data type: DCSQLTCTRL-NTABSTATE
Default: 'A'
Optional: Yes
Call by Reference: Yes

WRITE_ENDMESS -

Data type: DCSQLTCTRL-WRITE_ENDM
Default: 'X'
Optional: Yes
Call by Reference: Yes

NO_CHECK -

Data type: DCSQLTCTRL-NO_CHECK
Default: ' '
Optional: Yes
Call by Reference: Yes

PATH -

Data type:
Default: ' '
Optional: Yes
Call by Reference: Yes

TABNAME - Name of Pool/Cluster in the Database

Data type: DD06L-SQLTAB
Optional: No
Call by Reference: Yes

TIMER_ON - DD: Flag ('X',''): Switch on timer ?

Data type: DCSQLTCTRL-TIMER_ON
Default: ' '
Optional: Yes
Call by Reference: Yes

DISPLAY -

Data type: DDREFSTRUC-BOOL
Default: ' '
Optional: Yes
Call by Reference: Yes

AUTH_CHK - DD.: Flag if author. check for DB changes executed

Data type: DCSQLTCTRL-DB_AUTH
Default: 'X'
Optional: Yes
Call by Reference: Yes

EXCOMMIT - DD: Flag ('X','') if commit should be performed

Data type: DCSQLTCTRL-EXCOMMIT
Default: ' '
Optional: Yes
Call by Reference: Yes

SETTMST - Force updating of the time stamp

Data type: DCSQLTCTRL-SETTMST
Default: ' '
Optional: Yes
Call by Reference: Yes

FUNCT -

Data type: DCSQLTCTRL-FUNCT
Default: 'ACT'
Optional: Yes
Call by Reference: Yes

EXPORTING Parameters details for DD_SQLT_ACT

RC - Return Code

Data type: SYST-SUBRC
Optional: No
Call by Reference: Yes

CHANGING Parameters details for DD_SQLT_ACT

PROTNAME -

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

PRID - Internal Tables, Current Row Index

Data type: SYST-TABIX
Optional: Yes
Call by Reference: Yes

DD06V_WA - SQLT Source, Header

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

DD16V_TAB - SQLT Source, Fields

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

DD09L_WA -

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

EXCEPTIONS details

NOT_CREATED -

Data type:
Optional: No
Call by Reference: Yes

WRONG_INPUT_PARAMETER -

Data type:
Optional: No
Call by Reference: Yes

NOT_FOUND -

Data type:
Optional: No
Call by Reference: Yes

Copy and paste ABAP code example for DD_SQLT_ACT 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_rc  TYPE SYST-SUBRC, "   
lv_device  TYPE SPRWR-DEVICE, "   'F'
lv_protname  TYPE SPRWR, "   ' '
lv_not_created  TYPE SPRWR, "   
lv_get_state  TYPE DCSQLTCTRL-GETSTATE, "   'M'
lv_ntab_putstate  TYPE DCSQLTCTRL-NTABSTATE, "   'A'
lv_write_endmess  TYPE DCSQLTCTRL-WRITE_ENDM, "   'X'
lv_no_check  TYPE DCSQLTCTRL-NO_CHECK, "   ' '
lv_path  TYPE DCSQLTCTRL, "   ' '
lv_prid  TYPE SYST-TABIX, "   0
lv_wrong_input_parameter  TYPE SYST, "   
lv_tabname  TYPE DD06L-SQLTAB, "   
lv_dd06v_wa  TYPE DD06V, "   
lv_not_found  TYPE DD06V, "   
lv_timer_on  TYPE DCSQLTCTRL-TIMER_ON, "   ' '
lv_dd16v_tab  TYPE DDDD16VTAB, "   
lv_display  TYPE DDREFSTRUC-BOOL, "   ' '
lv_dd09l_wa  TYPE DD09L, "   
lv_auth_chk  TYPE DCSQLTCTRL-DB_AUTH, "   'X'
lv_excommit  TYPE DCSQLTCTRL-EXCOMMIT, "   ' '
lv_settmst  TYPE DCSQLTCTRL-SETTMST, "   ' '
lv_funct  TYPE DCSQLTCTRL-FUNCT. "   'ACT'

  CALL FUNCTION 'DD_SQLT_ACT'  "
    EXPORTING
         DEVICE = lv_device
         GET_STATE = lv_get_state
         NTAB_PUTSTATE = lv_ntab_putstate
         WRITE_ENDMESS = lv_write_endmess
         NO_CHECK = lv_no_check
         PATH = lv_path
         TABNAME = lv_tabname
         TIMER_ON = lv_timer_on
         DISPLAY = lv_display
         AUTH_CHK = lv_auth_chk
         EXCOMMIT = lv_excommit
         SETTMST = lv_settmst
         FUNCT = lv_funct
    IMPORTING
         RC = lv_rc
    CHANGING
         PROTNAME = lv_protname
         PRID = lv_prid
         DD06V_WA = lv_dd06v_wa
         DD16V_TAB = lv_dd16v_tab
         DD09L_WA = lv_dd09l_wa
    EXCEPTIONS
        NOT_CREATED = 1
        WRONG_INPUT_PARAMETER = 2
        NOT_FOUND = 3
. " DD_SQLT_ACT




ABAP code using 7.40 inline data declarations to call FM DD_SQLT_ACT

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 SYST INTO @DATA(ld_rc).
 
"SELECT single DEVICE FROM SPRWR INTO @DATA(ld_device).
DATA(ld_device) = 'F'.
 
DATA(ld_protname) = ' '.
 
 
"SELECT single GETSTATE FROM DCSQLTCTRL INTO @DATA(ld_get_state).
DATA(ld_get_state) = 'M'.
 
"SELECT single NTABSTATE FROM DCSQLTCTRL INTO @DATA(ld_ntab_putstate).
DATA(ld_ntab_putstate) = 'A'.
 
"SELECT single WRITE_ENDM FROM DCSQLTCTRL INTO @DATA(ld_write_endmess).
DATA(ld_write_endmess) = 'X'.
 
"SELECT single NO_CHECK FROM DCSQLTCTRL INTO @DATA(ld_no_check).
DATA(ld_no_check) = ' '.
 
DATA(ld_path) = ' '.
 
"SELECT single TABIX FROM SYST INTO @DATA(ld_prid).
 
 
"SELECT single SQLTAB FROM DD06L INTO @DATA(ld_tabname).
 
 
 
"SELECT single TIMER_ON FROM DCSQLTCTRL INTO @DATA(ld_timer_on).
DATA(ld_timer_on) = ' '.
 
 
"SELECT single BOOL FROM DDREFSTRUC INTO @DATA(ld_display).
DATA(ld_display) = ' '.
 
 
"SELECT single DB_AUTH FROM DCSQLTCTRL INTO @DATA(ld_auth_chk).
DATA(ld_auth_chk) = 'X'.
 
"SELECT single EXCOMMIT FROM DCSQLTCTRL INTO @DATA(ld_excommit).
DATA(ld_excommit) = ' '.
 
"SELECT single SETTMST FROM DCSQLTCTRL INTO @DATA(ld_settmst).
DATA(ld_settmst) = ' '.
 
"SELECT single FUNCT FROM DCSQLTCTRL INTO @DATA(ld_funct).
DATA(ld_funct) = 'ACT'.
 


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!