SAPWL_TABSTAT_GET_STATISTIC SAP Function module

SAPWL_TABSTAT_GET_STATISTIC 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 SAPWL_TABSTAT_GET_STATISTIC into the relevant SAP transaction such as SE37 or SE80.

Associated Function Group: STUW
Released Date: Not Released
Processing type: Remote-Enabled

Pattern for FM SAPWL_TABSTAT_GET_STATISTIC - SAPWL TABSTAT GET STATISTIC

CALL FUNCTION 'SAPWL_TABSTAT_GET_STATISTIC' "
  EXPORTING
    periodtype =                " sapwlacctp-periodtype  Period type
*   hostid =                    " sapwlserv-host  Host ID
*   instanceno =                " sapwltastr-instnochar  Instance number
    startdate =                 " sapwlacctp-startdate  Period start date
*   instance =                  " sapwlserv-name
*   hostshort =                 " sapwlserv-hostshort
  IMPORTING
    statdate =                  " sy-datum
    stattime =                  " sy-uzeit
  TABLES
    table_calls =               " dbstatdec
  EXCEPTIONS
    UNKNOWN_PERIODTYPE = 1      "               Invalid period type specified
    NO_DATA_FOUND = 2           "               No data found for specified selection
    STATISTIC_INCOMPLETE = 3    "
    .  "  SAPWL_TABSTAT_GET_STATISTIC

ABAP code example for Function Module SAPWL_TABSTAT_GET_STATISTIC

The ABAP code below is a full code listing to execute function module SAPWL_TABSTAT_GET_STATISTIC 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).

DATA:
ld_statdate  
 
 TYPE SY-DATUM
,
ld_stattime  
 
 TYPE SY-UZEIT
,
it_table_calls  
 
 TYPE STANDARD TABLE OF DBSTATDEC,"TABLES PARAM
wa_table_calls
 
 LIKE LINE OF it_table_calls
.



DATA(ld_periodtype) = some text here
 

SELECT single HOST 
  FROM SAPWLSERV 
  INTO @DATA(ld_hostid).



DATA(ld_instanceno) = some text here


DATA(ld_startdate) = 20210129
 

SELECT single NAME 
  FROM SAPWLSERV 
  INTO @DATA(ld_instance).

 

SELECT single HOSTSHORT 
  FROM SAPWLSERV 
  INTO @DATA(ld_hostshort).

 

"populate fields of struture and append to itab
append wa_table_calls to it_table_calls.
.

CALL FUNCTION 'SAPWL_TABSTAT_GET_STATISTIC'
  EXPORTING
    periodtype =                 ld_periodtype
*   hostid =                     ld_hostid
*   instanceno =                 ld_instanceno
    startdate =                  ld_startdate
*   instance =                   ld_instance
*   hostshort =                  ld_hostshort
  IMPORTING
    statdate =                   ld_statdate
    stattime =                   ld_stattime
  TABLES
    table_calls =                it_table_calls
  EXCEPTIONS
    UNKNOWN_PERIODTYPE =         1
    NO_DATA_FOUND =              2
    STATISTIC_INCOMPLETE =       3
    .  "  SAPWL_TABSTAT_GET_STATISTIC

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
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_statdate
 
 TYPE SY-DATUM ,
ld_periodtype
 
 TYPE SAPWLACCTP-PERIODTYPE ,
it_table_calls
 
 TYPE STANDARD TABLE OF DBSTATDEC ,
wa_table_calls
 
 LIKE LINE OF it_table_calls,
ld_stattime
 
 TYPE SY-UZEIT ,
ld_hostid
 
 TYPE SAPWLSERV-HOST ,
ld_instanceno
 
 TYPE SAPWLTASTR-INSTNOCHAR ,
ld_startdate
 
 TYPE SAPWLACCTP-STARTDATE ,
ld_instance
 
 TYPE SAPWLSERV-NAME ,
ld_hostshort
 
 TYPE SAPWLSERV-HOSTSHORT .



ld_periodtype = some text here 

"populate fields of struture and append to itab
append wa_table_calls to it_table_calls.

SELECT single HOST 
  FROM SAPWLSERV 
  INTO ld_hostid.


ld_instanceno = some text here

ld_startdate = 20210129

SELECT single NAME 
  FROM SAPWLSERV 
  INTO ld_instance.


SELECT single HOSTSHORT 
  FROM SAPWLSERV 
  INTO ld_hostshort.