SAP DB6_HIS_DBTBS_DETAIL_XP Function Module for DB6: get details of space history









DB6_HIS_DBTBS_DETAIL_XP is a standard db6 his dbtbs detail xp SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for DB6: get details of space history processing and below is the pattern details for this FM, 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 db6 his dbtbs detail xp FM, simply by entering the name DB6_HIS_DBTBS_DETAIL_XP into the relevant SAP transaction such as SE37 or SE38.

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



Function DB6_HIS_DBTBS_DETAIL_XP 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 'DB6_HIS_DBTBS_DETAIL_XP'"DB6: get details of space history
  EXPORTING
   STATTYPE =  "DB6: Type of statistics (D=daily,W=weekly,M=monthly)
   OBJECTNAME =  "DB2 Universal Database: Tablespace Name
   PARTITN =  "DB6: Partition Number
*  CONNECTION =  "Logical name for a database connection
*  OLDSTATFROMDATE =  "Field of type DATS
*  OLDSTATTODATE =  "Field of type DATS

TABLES
   IT_DB6PM_XP =  "DB6: detail record of tablespace & DB space statistics

EXCEPTIONS
   NO_HISTORY_FOUND = 1    SYSTEM_ERROR = 2
.



IMPORTING Parameters details for DB6_HIS_DBTBS_DETAIL_XP

STATTYPE - DB6: Type of statistics (D=daily,W=weekly,M=monthly)

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

OBJECTNAME - DB2 Universal Database: Tablespace Name

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

PARTITN - DB6: Partition Number

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

CONNECTION - Logical name for a database connection

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

OLDSTATFROMDATE - Field of type DATS

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

OLDSTATTODATE - Field of type DATS

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

TABLES Parameters details for DB6_HIS_DBTBS_DETAIL_XP

IT_DB6PM_XP - DB6: detail record of tablespace & DB space statistics

Data type: DB6PM_XP
Optional: No
Call by Reference: Yes

EXCEPTIONS details

NO_HISTORY_FOUND - required history records could not be read

Data type:
Optional: No
Call by Reference: Yes

SYSTEM_ERROR -

Data type:
Optional: No
Call by Reference: Yes

Copy and paste ABAP code example for DB6_HIS_DBTBS_DETAIL_XP 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_stattype  TYPE DB6PM_XP-STATTYPE, "   
lt_it_db6pm_xp  TYPE STANDARD TABLE OF DB6PM_XP, "   
lv_no_history_found  TYPE DB6PM_XP, "   
lv_objectname  TYPE DB6PM_XP-OBJECTNAME, "   
lv_system_error  TYPE DB6PM_XP, "   
lv_partitn  TYPE DB6PM_XP-PARTITN, "   
lv_connection  TYPE DB6NAVSYST-DBCNAME, "   
lv_oldstatfromdate  TYPE DATS, "   
lv_oldstattodate  TYPE DATS. "   

  CALL FUNCTION 'DB6_HIS_DBTBS_DETAIL_XP'  "DB6: get details of space history
    EXPORTING
         STATTYPE = lv_stattype
         OBJECTNAME = lv_objectname
         PARTITN = lv_partitn
         CONNECTION = lv_connection
         OLDSTATFROMDATE = lv_oldstatfromdate
         OLDSTATTODATE = lv_oldstattodate
    TABLES
         IT_DB6PM_XP = lt_it_db6pm_xp
    EXCEPTIONS
        NO_HISTORY_FOUND = 1
        SYSTEM_ERROR = 2
. " DB6_HIS_DBTBS_DETAIL_XP




ABAP code using 7.40 inline data declarations to call FM DB6_HIS_DBTBS_DETAIL_XP

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 STATTYPE FROM DB6PM_XP INTO @DATA(ld_stattype).
 
 
 
"SELECT single OBJECTNAME FROM DB6PM_XP INTO @DATA(ld_objectname).
 
 
"SELECT single PARTITN FROM DB6PM_XP INTO @DATA(ld_partitn).
 
"SELECT single DBCNAME FROM DB6NAVSYST INTO @DATA(ld_connection).
 
 
 


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!