Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

DB6PMSAPP SAP (DB6: Application Snapshot) Structure details

Dictionary Type: Structure
Description: DB6: Application Snapshot

ABAP Code to SELECT data from DB6PMSAPP
Related tables to DB6PMSAPP
Access table DB6PMSAPP

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Structure field list including key, data, relationships and ABAP select examples

DB6PMSAPP is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "DB6: Application Snapshot" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DB6PMSAPP TYPE DB6PMSAPP.

The DB6PMSAPP table consists of various fields, each holding specific information or linking keys about DB6: Application Snapshot data available in SAP. These include PARTITN (Partition Number), DBMSTRTTME (DB6: Timestamp (Format: YYYYMMDDHHMMSS)), AUTH_ID (DB6: General identifier), AGENT_ID (Application Handle).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP DB6PMSAPP structure fields - Full list of fields found in SAP data dictionary

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
COMPTIME	DB6: Timestamp (Format: YYYYMMDDHHMMSS)	DB6TSTAMP	CHAR	14
PARTITN	Partition Number			0
DBMSTRTTME	DB6: Timestamp (Format: YYYYMMDDHHMMSS)	DB6TSTAMP	CHAR	14
AUTH_ID	DB6: General identifier	DB6IDENT	CHAR	20
AGENT_ID	Application Handle			0
AGENT_PID	db2agent Process/Thread ID			0
APPL_NAME	DB6: General identifier	DB6IDENT	CHAR	20
CLI_PID	Process Thread ID of Client Application			0
CLI_HOST	Host Name	NI_HOSTNAME	CHAR	63
CLI_PLATFO	Platform of Client Application			0
AP_STATUS	Application Status			0
BP_QAL	Overall Buffer Quality (%)			0
BP_AV_RTM	Average Physical Read Time (ms)			0
BP_AV_WTM	Average Physical Write Time (ms)			0
BP_D_HITRT	Buffer Pool Data Hit Ratio (%)			0
BP_I_HITRT	Buffer Pool Index Hit Ratio (%)			0
PL_D_LRS	Data Logical Reads			0
PL_D_PRS	Data Physical Reads			0
PL_D_WS	Data Physical Writes			0
PL_I_LRS	Index Logical Reads			0
PL_I_PRS	Index Physical Reads			0
PL_I_WS	Index Physical Writes			0
PL_RD_TM	Pool Read Time			0
PL_WT_TM	Pool Write Time			0
DIRCT_RDS	Direct Reads			0
DIRCT_WTS	Direct Writes			0
DIRCT_RTM	Direct Read Time			0
DIRCT_WTM	Direct Write Time			0
DIRCT_RRQS	Direct Read Requests			0
DIRCT_WRQS	Direct Write Requests			0
AV_DCT_RTM	Average Direct Read Time			0
AV_DCT_WTM	Average Direct Write Time			0
AV_DCT_RDS	Average Direct Reads			0
AV_DCT_WTS	Average Direct Writes			0
PL_D_TE	Pool Data to Extended Storage			0
PL_D_FE	Pool Data from Extended Storage			0
PL_I_TE	Pool Index to Extended Storage			0
PL_I_FE	Pool Index from Extended Storage			0
LCK_ESCALS	Lock Escalations			0
X_LCK_ESCA	Exclusive Lock Escalations			0
LCK_WAITS	Total Lock Waits			0
LCK_W_TM	Time Waited for Locks (ms)			0
AV_WTM_LCK	Average Wait Time per Lock (ms)			0
LCKS_HELD	Locks Currently Held			0
DEADLOCKS	Deadlocks Detected			0
LCK_TMOUT	Lock Timeouts			0
CMMT_SQLST	COMMITs			0
RBCK_SQLST	ROLLBACKs			0
SELC_SQLST	SELECT Statements			0
UID_SQLST	UPDATE/INSERT/DELETE Statements			0
DYN_SQLST	Dynamic SQL Statements Since Connect			0
STC_SQLST	Static SQL Statements Since Connect			0
FAIL_SQLST	Failed SQL Statements Since Connect			0
DDL_SQLST	Data Definition Language Statements			0
RW_DELETED	Rows Deleted			0
RW_INSRTED	Rows Inserted			0
RW_SELECED	Rows Selected			0
RW_UPDATED	Rows Updated			0
TOT_SORTS	Total Sorts			0
TOT_SRT_TM	Total Sort Time (ms)			0
AV_SORT_TM	Average Sort Time (ms)			0
SRT_OF	Sort Overflows			0
CATCA_QAL	Catalog Cache Quality %			0
PKG_CA_QAL	Package Cache Quality (%)			0
CATCA_LKU	Catalog Cache Lookups			0
CATCA_INS	Catalog Cache Inserts			0
CATCA_OF	Catalog Cache Overflows			0
CATCA_HPFL	Catalog Cache Heap Full			0
PKG_CA_LKU	Package Cache Lookups			0
PKG_CA_INS	Package Cache Inserts			0
AP_CON_DT	Application Connect Date			0
AP_CON_TM	Application Connect Time			0
AP_IDLE_TM	Application Idle Time (Seconds)			0
PF_WTTM	Time Waited for Prefetch (ms)			0
AGT_UCP_S	Total User CPU Time of Application			0
AGT_SCT_S	Total Application System CPU time			0
CRD_AG_PID	Coordinator Agent Process/Thread ID			0
NUM_ASS_AG	Agents Currently Associated			0
ASS_AGT_TP	Agents Associated with this Application			0
AGT_STOLEN	Agents Stolen from Application			0
UOW_STRTDT	UOW Start Time Date			0
UOW_STRTTM	UOW Start Time			0
UOW_STOPDT	UOW Stop Time Date			0
UOW_STOPTM	UOW Stop Time			0
UOW_LWTM	uow_lock_wait_time: Time UOW Waited for Locks (ms)			0
UOW_LGSPUD	uow_log_space_used: Log Space Used in Most Recent UOW			0
PR_UOW_SDT	Previous UOW completion Date			0
PR_UOW_STM	Previous UOW completion Time			0
UOW_ELA_S	uow_elapsed_time_s: Unit of Work elapse time sec			0
UOW_ELA_MS	uow_elapsed_time_ms: Unit of Work elapse time ms			0
UOW_CMPSTA	uow_comp_status: Previous UOW Completion Status			0
TOT_HAJN	total_hash_joins: Number of Hash Joins			0
TOT_HALOOP	total_hash_loops: Number of Hash Loops			0
HAJN_OF	hash_join_overflows: Number of Hash Join Overflows			0
HAJN_SM_OF	hash_join_small_overflows: Small Hash Join Overflows			0
PL_TD_LRS	Pool_Temp_Data_Logical_Reads			0
PL_TD_PRS	Pool_Temp_Data_Physical_Reads			0
PL_TI_LRS	Pool_Temp_Index_Logical_Reads			0
PL_TI_PRS	Pool_Temp_Index_Physical_Reads			0
POOL_XDA_L_READS				0
POOL_XDA_P_READS				0
POOL_XDA_WRITES				0
PL_TEMP_XDA_L_RD				0
PL_TEMP_XDA_P_RD				0
ELPSD_EXC_TIM_MS				0
ELPSD_EXC_TIM_S				0
INACT_STMTHISTSZ				0
LOCK_TIMEOUT_VAL				0
PRV_WS_NUM_OVFL				0
PRV_WS_SCT_INSRT				0
PRV_WS_SCT_LKUP				0
PRV_WS_SIZE_TOP				0
SHR_WS_NUM_OVFL				0
SHR_WS_SCT_INSRT				0
SHR_WS_SCT_LKUP				0
SHR_WS_SIZE_TOP				0
SESSION_AUTH_ID				0
TPMON_ACC_STR				0
TPMON_CLIENT_APP				0
TPMON_CLIENT_UID				0
TPMON_CLIENT_WKS				0
AUTHORITY_LEVEL				0
OLAP_FUNC_OVERFLOWS				0
TOTAL_OLAP_FUNCS				0
WORKLOAD_ID				0
IS_SYSTEM_APPL				0
AGENT_PRIO	WLM agent priority (derived from Service Class)			0
AGENT_PRIO_MAX	OS specific max. priority			0
AGENT_PRIO_MIN	OS specific min. priority			0
PREFETCH_PRIO	WLM prefetch priority (derived from Service Class)			0
PREFETCH_PRIO_MAX	max. priority			0
PREFETCH_PRIO_MIN	min. priority			0
POOL_COL_L_READS				0
POOL_COL_P_READS				0
POOL_TEMP_COL_L_READS				0
POOL_TEMP_COL_P_READS				0
POOL_COL_WRITES				0
BP_C_HITRT				0

Key field

Non-key field

How do I retrieve data from SAP structure DB6PMSAPP using ABAP code?

As DB6PMSAPP is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DB6PMSAPP as there is no data to select.

How to access SAP table DB6PMSAPP

Within an ECC or HANA version of SAP you can also view further information about DB6PMSAPP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

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!