SAP DB6_PM_TABLESNAP Function Module for DB6: Get Table Snapshot









DB6_PM_TABLESNAP is a standard db6 pm tablesnap 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 Table Snapshot 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 pm tablesnap FM, simply by entering the name DB6_PM_TABLESNAP into the relevant SAP transaction such as SE37 or SE38.

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



Function DB6_PM_TABLESNAP 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_PM_TABLESNAP'"DB6: Get Table Snapshot
EXPORTING
ACTION = "
PARTITN = "Partition Number
CALLERFLAG = "Who Has Called this Program
* COMPTIME = "DB6: Timestamp (Format: YYYYMMDDHHMMSS)
* CONNECTION = "Logical name for a database connection

TABLES
IT_DB6PMST_HD = "DB6: Snapshot Table Header
* IT_DB6PMST = "DB6: Snapshot Table

EXCEPTIONS
INVALID_PARAMETER_SET = 1 C_CALL_FAILED = 2 HISTORY_INSERT_FAILED = 3 NODE_INFORMATION_NOT_FOUND = 4 NO_HISTORY_FOUND = 5 ADBC_ERROR = 6
.



IMPORTING Parameters details for DB6_PM_TABLESNAP

ACTION -

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

PARTITN - Partition Number

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

CALLERFLAG - Who Has Called this Program

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

COMPTIME - DB6: Timestamp (Format: YYYYMMDDHHMMSS)

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

CONNECTION - Logical name for a database connection

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

TABLES Parameters details for DB6_PM_TABLESNAP

IT_DB6PMST_HD - DB6: Snapshot Table Header

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

IT_DB6PMST - DB6: Snapshot Table

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

EXCEPTIONS details

INVALID_PARAMETER_SET - invalid or missing parameters

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

C_CALL_FAILED - error at processing of C call to DB collector RDI

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

HISTORY_INSERT_FAILED - retrieved data could not be inserted to database

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

NODE_INFORMATION_NOT_FOUND - list of DB6 nodes(partitions) could not be read

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

NO_HISTORY_FOUND - required history records could not be read

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

ADBC_ERROR -

Data type:
Optional: No
Call by Reference: Yes

Copy and paste ABAP code example for DB6_PM_TABLESNAP 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_action  TYPE I, "   
lt_it_db6pmst_hd  TYPE STANDARD TABLE OF DB6PMST_HD, "   
lv_invalid_parameter_set  TYPE DB6PMST_HD, "   
lv_partitn  TYPE DB6PMST-PARTITN, "   
lt_it_db6pmst  TYPE STANDARD TABLE OF DB6PMST, "   
lv_c_call_failed  TYPE DB6PMST, "   
lv_callerflag  TYPE DB6PMST-CALLERFLAG, "   
lv_history_insert_failed  TYPE DB6PMST, "   
lv_comptime  TYPE DB6PMST-COMPTIME, "   
lv_node_information_not_found  TYPE DB6PMST, "   
lv_connection  TYPE DBCON-CON_NAME, "   
lv_no_history_found  TYPE DBCON, "   
lv_adbc_error  TYPE DBCON. "   

  CALL FUNCTION 'DB6_PM_TABLESNAP'  "DB6: Get Table Snapshot
    EXPORTING
         ACTION = lv_action
         PARTITN = lv_partitn
         CALLERFLAG = lv_callerflag
         COMPTIME = lv_comptime
         CONNECTION = lv_connection
    TABLES
         IT_DB6PMST_HD = lt_it_db6pmst_hd
         IT_DB6PMST = lt_it_db6pmst
    EXCEPTIONS
        INVALID_PARAMETER_SET = 1
        C_CALL_FAILED = 2
        HISTORY_INSERT_FAILED = 3
        NODE_INFORMATION_NOT_FOUND = 4
        NO_HISTORY_FOUND = 5
        ADBC_ERROR = 6
. " DB6_PM_TABLESNAP




ABAP code using 7.40 inline data declarations to call FM DB6_PM_TABLESNAP

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 PARTITN FROM DB6PMST INTO @DATA(ld_partitn).
 
 
 
"SELECT single CALLERFLAG FROM DB6PMST INTO @DATA(ld_callerflag).
 
 
"SELECT single COMPTIME FROM DB6PMST INTO @DATA(ld_comptime).
 
 
"SELECT single CON_NAME FROM DBCON 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!