DB6_HIS_DBTBS_DETAIL_XT SAP Function module - DB6: get details of table/index history

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

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

Pattern for FM DB6_HIS_DBTBS_DETAIL_XT - DB6 HIS DBTBS DETAIL XT

CALL FUNCTION 'DB6_HIS_DBTBS_DETAIL_XT' "DB6: get details of table/index history
  EXPORTING
    stattype =                  " db6pm_xt-stattype  DB6: Type of statistics (D=daily,W=weekly,M=monthly)
    objectname =                " db6pm_xt-objectname  DB2 Universal Database: Tablespace Name
*   connection =                " db6navsyst-dbcname  Logical name for a database connection
*   oldstatfromdate =           " dats          Field of type DATS
*   oldstattodate =             " dats          Field of type DATS
  TABLES
    it_db6pm_xt =               " db6pm_xt      DB6: detail record of tablespace & DB table/idx statistics
  EXCEPTIONS
    NO_HISTORY_FOUND = 1        "               required history records could not be read
    SYSTEM_ERROR = 2            "
    .  "  DB6_HIS_DBTBS_DETAIL_XT

ABAP code example for Function Module DB6_HIS_DBTBS_DETAIL_XT

The ABAP code below is a full code listing to execute function module DB6_HIS_DBTBS_DETAIL_XT 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:
it_it_db6pm_xt  
 
 TYPE STANDARD TABLE OF DB6PM_XT,"TABLES PARAM
wa_it_db6pm_xt
 
 LIKE LINE OF it_it_db6pm_xt
.



DATA(ld_stattype) = some text here


DATA(ld_objectname) = some text here
 

SELECT single DBCNAME 
  FROM DB6NAVSYST 
  INTO @DATA(ld_connection).


DATA(ld_oldstatfromdate) = 'Check type of data required'.

DATA(ld_oldstattodate) = 'Check type of data required'.
 

"populate fields of struture and append to itab
append wa_it_db6pm_xt to it_it_db6pm_xt.
.

CALL FUNCTION 'DB6_HIS_DBTBS_DETAIL_XT'
  EXPORTING
    stattype =                   ld_stattype
    objectname =                 ld_objectname
*   connection =                 ld_connection
*   oldstatfromdate =            ld_oldstatfromdate
*   oldstattodate =              ld_oldstattodate
  TABLES
    it_db6pm_xt =                it_it_db6pm_xt
  EXCEPTIONS
    NO_HISTORY_FOUND =           1
    SYSTEM_ERROR =               2
    .  "  DB6_HIS_DBTBS_DETAIL_XT

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
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_stattype
 
 TYPE DB6PM_XT-STATTYPE ,
it_it_db6pm_xt
 
 TYPE STANDARD TABLE OF DB6PM_XT ,
wa_it_db6pm_xt
 
 LIKE LINE OF it_it_db6pm_xt,
ld_objectname
 
 TYPE DB6PM_XT-OBJECTNAME ,
ld_connection
 
 TYPE DB6NAVSYST-DBCNAME ,
ld_oldstatfromdate
 
 TYPE DATS ,
ld_oldstattodate
 
 TYPE DATS .



ld_stattype = some text here 

"populate fields of struture and append to itab
append wa_it_db6pm_xt to it_it_db6pm_xt.

ld_objectname = some text here

SELECT single DBCNAME 
  FROM DB6NAVSYST 
  INTO ld_connection.

ld_oldstatfromdate = 'Check type of data required'.
ld_oldstattodate = 'Check type of data required'.