DB6PMSA SAP (DB6: Application Snapshot) Structure details
Description: DB6: Application Snapshot
Structure field list including key, data, relationships and ABAP select examples
DB6PMSA 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_DB6PMSA TYPE DB6PMSA.
The DB6PMSA table consists of various fields, each holding specific information or linking keys about DB6: Application Snapshot data available in SAP. These include PARTITN (dbpartitionnum), AGENT_ID (), AP_STATUS (application status), CODEPG_ID (codepage ID).. 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 DB6PMSA 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 |
PARTITN | dbpartitionnum | 0 | |||||||
AGENT_ID | 0 | ||||||||
AP_STATUS | application status | 0 | |||||||
CODEPG_ID | codepage ID | 0 | |||||||
NUM_ASS_AG | number of associated agents | 0 | |||||||
CRD_NODE | coordinator node number | 0 | |||||||
AP_STATUS | application status | 0 | |||||||
CODEPG_ID | codepage ID | 0 | |||||||
AUTHORITY_LEVEL | 0 | ||||||||
CLI_PID | client pid | 0 | |||||||
STAT_CHGTM | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
APPL_NAME | DB6: General identifier | DB6IDENT | CHAR | 20 | |||||
CRD_AG_PID | coordinator agent pid | 0 | |||||||
IPADDRESS | IP Address | NI_NODEADDR | CHAR | 45 | IPADD | NI_NODEADDR | |||
STAT_CHGTM | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
APPL_ID | 0 | ||||||||
CLI_PLATFO | client_platform: Platform of Client Application | 0 | |||||||
SEQU_NO | 0 | ||||||||
CLI_PRTC | client_protocol: Communications Protocol of Client | 0 | |||||||
AUTH_ID | DB6: General identifier primary auth. ID | DB6IDENT | CHAR | 20 | |||||
COUNTRY_CD | territory code | 0 | |||||||
CLI_NAME | DB6: General identifier client_nname | DB6IDENT | CHAR | 20 | |||||
APPL_NAME | 0 | ||||||||
APPL_ID | 0 | ||||||||
CLI_PRDID | DB6: General identifier client_prdID | DB6IDENT | CHAR | 20 | |||||
SEQU_NO | 0 | ||||||||
IN_DB_ALIA | DB6: General identifier input DB alias | DB6IDENT | CHAR | 20 | |||||
AUTH_ID | primary auth. ID | 0 | |||||||
CLI_DBALIA | DB6: General identifier client DB alias | DB6IDENT | CHAR | 20 | |||||
DB_NAME | DB6: General identifier | DB6IDENT | CHAR | 20 | |||||
SESSION_AUTH_ID | session auth. ID | 0 | |||||||
DB_PATH | DB6: File Path | DB6PATH | CHAR | 255 | DB6PATH | ||||
CLI_NAME | client_nname | 0 | |||||||
CLI_PRDID | client_prdID | 0 | |||||||
LCKS_HELD | locks_held: Locks Currently Held by Application | 0 | |||||||
LCK_WAITS | lock_waits: Lock Waits Since Application Connect | 0 | |||||||
IN_DB_ALIA | input DB alias | 0 | |||||||
LCK_W_TM | lock_wait_time: Total Time Application Waited for Locks | 0 | |||||||
CLI_DBALIA | client DB alias | 0 | |||||||
DB_NAME | 0 | ||||||||
LCK_ESCALS | lock_escals: Lock Escalations Since Application Connect | 0 | |||||||
DB_PATH | 0 | ||||||||
X_LCK_ESCA | x_lock_escals: X Lock Escalations Since Application Connect | 0 | |||||||
EXEC_ID | execution ID | 0 | |||||||
DEADLOCKS | deadlocks: Deadlocks Since Application Connect | 0 | |||||||
UOW_LWTM | uow_lock_wait_time: Time UOW Waited for Locks (ms) | 0 | |||||||
CORR_TOKEN | 0 | ||||||||
TOT_SORTS | total_sorts: Total Sorts Since Connect | 0 | |||||||
TPMON_ACC_STR | 0 | ||||||||
TOT_SRT_TM | total_sort_time: Elapsed Time Spent in Sorts | 0 | |||||||
TPMON_CLIENT_APP | 0 | ||||||||
SRT_OF | sort_overflows: Number of Sort Overflows | 0 | |||||||
TPMON_CLIENT_UID | 0 | ||||||||
PL_D_LRS | pool_data_l_reads: Pool Data Logical Reads Since Connect | 0 | |||||||
TPMON_CLIENT_WKS | 0 | ||||||||
PL_D_PRS | pool_data_p_reads: Pool Data Reads Since First Connect | 0 | |||||||
WORKLOAD_ID | 0 | ||||||||
PL_D_WS | pool_data_writes: Pool Data Writes Since First Connect | 0 | |||||||
IS_SYSTEM_APPL | 0 | ||||||||
COMPTIME | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
PL_I_LRS | pool_index_l_reads: Pool Index Logical Reads Since Connect | 0 | |||||||
PL_I_PRS | pool_index_p_reads: Pool Index Reads Since First Connect | 0 | |||||||
CALLERFLAG | Who Has Called this Program | 0 | |||||||
PL_I_WS | pool_index_writes: Pool Index Writes Since First Connect | 0 | |||||||
DBMSTRTTME | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
PRGVERS | Version of Program Inserted this Row | 0 | |||||||
PL_RD_TM | pool_read_time: Buffer Pool Read Time Since First Connect | 0 | |||||||
PL_WT_TM | pool_write_time: Buffer Pool Write Time Since First Connect | 0 | |||||||
IPADDRESS | IP Address | NI_NODEADDR | CHAR | 45 | IPADD | NI_NODEADDR | |||
LCKS_HELD | locks_held: Locks Currently Held by Application | 0 | |||||||
CMMT_SQLST | commit_sql_stmts: Number of COMMIT SQL Statements Since Conn | 0 | |||||||
LCK_WAITS | lock_waits: Lock Waits Since Application Connect | 0 | |||||||
RBCK_SQLST | rollback_sql_stmts: No. of ROLLBACK SQL Stmts Since Connect | 0 | |||||||
LCK_W_TM | lock_wait_time: Total Time Application Waited for Locks | 0 | |||||||
DYN_SQLST | dynamic_sql_stmts: Number of Dynamic SQL Stmts Since Connect | 0 | |||||||
STC_SQLST | static_sql_stmts: Number of Static SQL Statements Since Conn | 0 | |||||||
LCK_ESCALS | lock_escals: Lock Escalations Since Application Connect | 0 | |||||||
FAIL_SQLST | failed_sql_stmts: Number of Failed SQL Stmts Since Connect | 0 | |||||||
X_LCK_ESCA | x_lock_escals: X Lock Escalations Since Application Connect | 0 | |||||||
DEADLOCKS | deadlocks: Deadlocks Since Application Connect | 0 | |||||||
SELC_SQLST | select_sql_stmts: Number of SQL SELECT Stmts Since Connect | 0 | |||||||
UOW_LWTM | uow_lock_wait_time: Time UOW Waited for Locks (ms) | 0 | |||||||
DDL_SQLST | ddl_sql_stmts: Number of Data Definition Language Statements | 0 | |||||||
TOT_SORTS | total_sorts: Total Sorts Since Connect | 0 | |||||||
UID_SQLST | uid_sql_stmts: Number of UPDATE/INSERT/DELETE Statements | 0 | |||||||
INT_ATRBND | int_auto_rebinds: Number of Auto Rebinds Since First Connect | 0 | |||||||
TOT_SRT_TM | total_sort_time: Elapsed Time Spent in Sorts | 0 | |||||||
SRT_OF | sort_overflows: Number of Sort Overflows | 0 | |||||||
INT_RW_DEL | int_rows_deleted: No. of Casc. Deletes Since First Connect | 0 | |||||||
PL_D_LRS | pool_data_l_reads: Pool Data Logical Reads Since Connect | 0 | |||||||
INT_RW_UPD | int_rows_updated: Number of Set Null Deletes Since Connect | 0 | |||||||
PL_D_PRS | pool_data_p_reads: Pool Data Reads Since First Connect | 0 | |||||||
INT_CMMTS | int_commits: Number of Int. COMMITs Since First Connect | 0 | |||||||
INT_RB | int_rollbacks: Number of Int. ROLLBACKs Since First Connect | 0 | |||||||
PL_D_WS | pool_data_writes: Pool Data Writes Since First Connect | 0 | |||||||
PL_I_LRS | pool_index_l_reads: Pool Index Logical Reads Since Connect | 0 | |||||||
INT_DL_RB | int_deadlock_rollbacks: # of ROLLBACKs due to Deadlck S. Con | 0 | |||||||
PL_I_PRS | pool_index_p_reads: Pool Index Reads Since First Connect | 0 | |||||||
RW_DELETED | rows_deleted: Number of Rows Deleted Since Connect | 0 | |||||||
PL_I_WS | pool_index_writes: Pool Index Writes Since First Connect | 0 | |||||||
RW_INSRTED | rows_inserted: Number of Rows Inserted Since Connect | 0 | |||||||
PL_RD_TM | pool_read_time: Buffer Pool Read Time Since First Connect | 0 | |||||||
RW_UPDATED | rows_updated: Number of Rows Updated Since Connect | 0 | |||||||
PL_WT_TM | pool_write_time: Buffer Pool Write Time Since First Connect | 0 | |||||||
RW_SELECED | rows_selected: Number of Rows Selected Since Connect | 0 | |||||||
BIND_PRECC | binds_precompiles: # of BINDs/PRECOMPILEs Since First Conn. | 0 | |||||||
CMMT_SQLST | commit_sql_stmts: Number of COMMIT SQL Statements Since Conn | 0 | |||||||
RBCK_SQLST | rollback_sql_stmts: No. of ROLLBACK SQL Stmts Since Connect | 0 | |||||||
UOW_LGSPUD | uow_log_space_used: Log Space Used in Most Recent UOW | 0 | |||||||
DYN_SQLST | dynamic_sql_stmts: Number of Dynamic SQL Stmts Since Connect | 0 | |||||||
UOW_CMPSTA | uow_comp_status: Previous UOW Completion Status | 0 | |||||||
STC_SQLST | static_sql_stmts: Number of Static SQL Statements Since Conn | 0 | |||||||
PR_UOW_STM | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
FAIL_SQLST | failed_sql_stmts: Number of Failed SQL Stmts Since Connect | 0 | |||||||
UOW_STRTTM | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
SELC_SQLST | select_sql_stmts: Number of SQL SELECT Stmts Since Connect | 0 | |||||||
UOW_STOPTM | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
DDL_SQLST | ddl_sql_stmts: Number of Data Definition Language Statements | 0 | |||||||
OPN_RM_CR | open_rem_curs: Remote Cursors Currently Open | 0 | |||||||
UID_SQLST | uid_sql_stmts: Number of UPDATE/INSERT/DELETE Statements | 0 | |||||||
OPN_RM_CRB | open_rem_curs_blk: Remote Cursors Curr. Open Within Block | 0 | |||||||
INT_ATRBND | int_auto_rebinds: Number of Auto Rebinds Since First Connect | 0 | |||||||
REJ_CR_BLK | rej_curs_blk: Rejected Block Remote Cursor Requests | 0 | |||||||
ACC_CU_BLK | acc_curs_blk: Acc. Block Remote Cursor Requests | 0 | |||||||
INT_RW_DEL | int_rows_deleted: No. of Casc. Deletes Since First Connect | 0 | |||||||
AP_CON_TM | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
INT_RW_UPD | int_rows_updated: Number of Set Null Deletes Since Connect | 0 | |||||||
INT_CMMTS | int_commits: Number of Int. COMMITs Since First Connect | 0 | |||||||
CN_CMPL_TM | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
INT_RB | int_rollbacks: Number of Int. ROLLBACKs Since First Connect | 0 | |||||||
LAST_RESET | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
INT_DL_RB | int_deadlock_rollbacks: # of ROLLBACKs due to Deadlck S. Con | 0 | |||||||
AP_IDLE_TM | appl_idle_time: Application Idle Time (Seconds) | 0 | |||||||
PL_D_TE | pool_data_to_estore: No. of Pages Copied from BP to ExStor. | 0 | |||||||
RW_DELETED | rows_deleted: Number of Rows Deleted Since Connect | 0 | |||||||
PL_I_TE | pool_index_to_estore: No. of Pages Copied from BP to ExStor. | 0 | |||||||
RW_INSRTED | rows_inserted: Number of Rows Inserted Since Connect | 0 | |||||||
PL_I_FE | pool_index_from_estore: No of Pages Copied from ExStor to BP | 0 | |||||||
RW_UPDATED | rows_updated: Number of Rows Updated Since Connect | 0 | |||||||
PL_D_FE | pool_data_from_estore: No. of Pages Copied from ExStor to BP | 0 | |||||||
RW_SELECED | rows_selected: Number of Rows Selected Since Connect | 0 | |||||||
AUTHO_LVL | authority_lvl: User Authorizations | 0 | |||||||
BIND_PRECC | binds_precompiles: # of BINDs/PRECOMPILEs Since First Conn. | 0 | |||||||
SQL_RSCMMT | sql_reqs_since_commit: No. of SQL Requests Since Last COMMIT | 0 | |||||||
UOW_LGSPUD | uow_log_space_used: Log Space Used in Most Recent UOW | 0 | |||||||
NUM_SCAPS | num_sec_appl_structs: Secondary Application Information | 0 | |||||||
UOW_CMPSTA | uow_comp_status: Previous UOW Completion Status | 0 | |||||||
LCK_TMOUT | lock_timeouts: Number of Lock Timeouts Since Connect | 0 | |||||||
PR_UOW_STM | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
AGT_UCP_S | agent_usr_cpu_time.seconds: Total User CPU Time of Appl. | 0 | |||||||
UOW_STRTTM | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
AGT_UPT_MS | agent_usr_cpu_time.microsec: Total User CPU Time of Appl. | 0 | |||||||
UOW_STOPTM | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
AGT_SCT_S | agent_sys_cpu_time.seconds: Total Application System CPU Tim | 0 | |||||||
OPN_RM_CR | open_rem_curs: Remote Cursors Currently Open | 0 | |||||||
AGT_SPT_MS | agent_sys_cpu_time.microsec: Total Appl. System CPU Time | 0 | |||||||
OPN_RM_CRB | open_rem_curs_blk: Remote Cursors Curr. Open Within Block | 0 | |||||||
INT_RW_INS | int_rows_inserted: Number of Rows Inserted for Trigger | 0 | |||||||
REJ_CR_BLK | rej_curs_blk: Rejected Block Remote Cursor Requests | 0 | |||||||
RW_READ | rows_read: Number of Rows Read Since Connection | 0 | |||||||
ACC_CU_BLK | acc_curs_blk: Acc. Block Remote Cursor Requests | 0 | |||||||
AP_CON_TM | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
RW_WRITTEN | rows_written: Number of Rows Written Since Connection | 0 | |||||||
DIRCT_RDS | direct_reads: Direct Reads Since Connect | 0 | |||||||
CN_CMPL_TM | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
DIRCT_WTS | direct_writes: Direct Writes Since Connect | 0 | |||||||
LAST_RESET | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
AP_IDLE_TM | appl_idle_time: Application Idle Time (Seconds) | 0 | |||||||
DIRCT_RRQS | direct_read_reqs: Direct Read Requests Since Connect | 0 | |||||||
PL_D_TE | pool_data_to_estore: No. of Pages Copied from BP to ExStor. | 0 | |||||||
DIRCT_WRQS | direct_write_reqs: Direct Write Requests Since Connect | 0 | |||||||
PL_I_TE | pool_index_to_estore: No. of Pages Copied from BP to ExStor. | 0 | |||||||
DIRCT_RTM | direct_read_time: Direct Read Time Since Connect | 0 | |||||||
PL_I_FE | pool_index_from_estore: No of Pages Copied from ExStor to BP | 0 | |||||||
DIRCT_WTM | direct_write_time: Direct Write Time Since Connect | 0 | |||||||
PL_D_FE | pool_data_from_estore: No. of Pages Copied from ExStor to BP | 0 | |||||||
OPN_LC_CR | open_loc_curs: Local Cursors Currently Open | 0 | |||||||
AUTHO_LVL | authority_lvl: User Authorizations | 0 | |||||||
OPN_LC_CRB | open_loc_curs_blk: Local Cursors Currently Open Within Block | 0 | |||||||
EXEC_ID | DB6: General identifier execution ID | DB6IDENT | CHAR | 20 | |||||
SQL_RSCMMT | sql_reqs_since_commit: No. of SQL Requests Since Last COMMIT | 0 | |||||||
NUM_SCAPS | num_sec_appl_structs: Secondary Application Information | 0 | |||||||
CORR_TOKEN | DB6: Long identifier | DB6LONGID | CHAR | 32 | |||||
CLI_PID | client pid | 0 | |||||||
LCK_TMOUT | lock_timeouts: Number of Lock Timeouts Since Connect | 0 | |||||||
AGT_UCP_S | agent_usr_cpu_time.seconds: Total User CPU Time of Appl. | 0 | |||||||
CLI_PLATFO | client_platform: Platform of Client Application | 0 | |||||||
CLI_PRTC | client_protocol: Communications Protocol of Client | 0 | |||||||
AGT_UPT_MS | agent_usr_cpu_time.microsec: Total User CPU Time of Appl. | 0 | |||||||
AGT_SCT_S | agent_sys_cpu_time.seconds: Total Application System CPU Tim | 0 | |||||||
COUNTRY_CD | territory code | 0 | |||||||
AGT_SPT_MS | agent_sys_cpu_time.microsec: Total Appl. System CPU Time | 0 | |||||||
PKG_CA_LKU | pkg_cache_lookups: Number of Section Lookups | 0 | |||||||
INT_RW_INS | int_rows_inserted: Number of Rows Inserted for Trigger | 0 | |||||||
PKG_CA_INS | pkg_cache_inserts: Number of Sections Inserted into Cache | 0 | |||||||
RW_READ | rows_read: Number of Rows Read Since Connection | 0 | |||||||
CATCA_LKU | cat_cache_lookups: Number of Table Descriptor Lookups | 0 | |||||||
CATCA_INS | cat_cache_inserts: Number of Table Descriptors Inserted | 0 | |||||||
RW_WRITTEN | rows_written: Number of Rows Written Since Connection | 0 | |||||||
CATCA_OF | cat_cache_overflows: Number of Catalog Cache Overflows | 0 | |||||||
DIRCT_RDS | direct_reads: Direct Reads Since Connect | 0 | |||||||
DIRCT_WTS | direct_writes: Direct Writes Since Connect | 0 | |||||||
CATCA_HPFL | cat_cache_heap_full: Number of Overflows due to DB Heap Full | 0 | |||||||
CRD_NODE | coordinator node number | 0 | |||||||
DIRCT_RRQS | direct_read_reqs: Direct Read Requests Since Connect | 0 | |||||||
DIRCT_WRQS | direct_write_reqs: Direct Write Requests Since Connect | 0 | |||||||
NUM_ASS_AG | number of associated agents | 0 | |||||||
DIRCT_RTM | direct_read_time: Direct Read Time Since Connect | 0 | |||||||
NUM_AGENTS | num_agents: Number of Agents Currently Active | 0 | |||||||
DIRCT_WTM | direct_write_time: Direct Write Time Since Connect | 0 | |||||||
AGT_STOLEN | agents_stolen: Total Number of Agents Stolen from Appl. | 0 | |||||||
OPN_LC_CR | open_loc_curs: Local Cursors Currently Open | 0 | |||||||
ASS_AGT_TP | associated_agents_top: # of Agents Associated with this Appl | 0 | |||||||
AP_PRIO | appl_priority: Priority with Which Application Agents Work | 0 | |||||||
OPN_LC_CRB | open_loc_curs_blk: Local Cursors Currently Open Within Block | 0 | |||||||
AP_PRIO_TY | appl_priority_type: Dynamic or Static | 0 | |||||||
PKG_CA_LKU | pkg_cache_lookups: Number of Section Lookups | 0 | |||||||
PF_WTTM | prefetch_wait_time: Time Waited for Prefetch (ms) | 0 | |||||||
PKG_CA_INS | pkg_cache_inserts: Number of Sections Inserted into Cache | 0 | |||||||
CATCA_LKU | cat_cache_lookups: Number of Table Descriptor Lookups | 0 | |||||||
CRD_AG_PID | coordinator agent pid | 0 | |||||||
CATCA_INS | cat_cache_inserts: Number of Table Descriptors Inserted | 0 | |||||||
AP_SEC_LKU | appl_section_lookups: Number of Section Lookups | 0 | |||||||
CATCA_OF | cat_cache_overflows: Number of Catalog Cache Overflows | 0 | |||||||
AP_SEC_INS | appl_section_inserts: Number of Sections Inserted | 0 | |||||||
LCK_WTING | locks_waiting: Number of Agents Currently Waiting for Locks | 0 | |||||||
CATCA_HPFL | cat_cache_heap_full: Number of Overflows due to DB Heap Full | 0 | |||||||
NUM_AGENTS | num_agents: Number of Agents Currently Active | 0 | |||||||
OB_CN_ADDR | DB6: Long identifier | DB6LONGID | CHAR | 32 | |||||
AGT_STOLEN | agents_stolen: Total Number of Agents Stolen from Appl. | 0 | |||||||
INBND_CNAD | DB6: Long identifier | DB6LONGID | CHAR | 32 | |||||
ASS_AGT_TP | associated_agents_top: # of Agents Associated with this Appl | 0 | |||||||
OB_CN_PRTC | outbound_comm_protocol: Outbound Communications Protocol | 0 | |||||||
AP_PRIO | appl_priority: Priority with Which Application Agents Work | 0 | |||||||
TOT_HAJN | total_hash_joins: Number of Hash Joins | 0 | |||||||
AP_PRIO_TY | appl_priority_type: Dynamic or Static | 0 | |||||||
TOT_HALOOP | total_hash_loops: Number of Hash Loops | 0 | |||||||
HAJN_OF | hash_join_overflows: Number of Hash Join Overflows | 0 | |||||||
PF_WTTM | prefetch_wait_time: Time Waited for Prefetch (ms) | 0 | |||||||
AP_SEC_LKU | appl_section_lookups: Number of Section Lookups | 0 | |||||||
HAJN_SM_OF | hash_join_small_overflows: Small Hash Join Overflows | 0 | |||||||
UOW_ELA_S | uow_elapsed_time_s: Unit of Work elapse time sec | 0 | |||||||
AP_SEC_INS | appl_section_inserts: Number of Sections Inserted | 0 | |||||||
LCK_WTING | locks_waiting: Number of Agents Currently Waiting for Locks | 0 | |||||||
UOW_ELA_MS | uow_elapsed_time_ms: Unit of Work elapse time ms | 0 | |||||||
OB_CN_ADDR | DB6: Long identifier | DB6LONGID | CHAR | 32 | |||||
UNREADPFPG | unread_prefetch_pages: Unread prefetched pages | 0 | |||||||
PL_TD_LRS | pool_temp_data_l_reads | 0 | |||||||
INBND_CNAD | DB6: Long identifier | DB6LONGID | CHAR | 32 | |||||
PL_TD_PRS | pool_temp_data_p_reads | 0 | |||||||
OB_CN_PRTC | outbound_comm_protocol: Outbound Communications Protocol | 0 | |||||||
TOT_HAJN | total_hash_joins: Number of Hash Joins | 0 | |||||||
PL_TI_LRS | pool_temp_index_l_reads | 0 | |||||||
PL_TI_PRS | pool_temp_index_p_reads | 0 | |||||||
TOT_HALOOP | total_hash_loops: Number of Hash Loops | 0 | |||||||
HAJN_OF | hash_join_overflows: Number of Hash Join Overflows | 0 | |||||||
POOL_XDA_L_READS | 0 | ||||||||
HAJN_SM_OF | hash_join_small_overflows: Small Hash Join Overflows | 0 | |||||||
POOL_XDA_P_READS | 0 | ||||||||
UOW_ELA_S | uow_elapsed_time_s: Unit of Work elapse time sec | 0 | |||||||
POOL_XDA_WRITES | 0 | ||||||||
UOW_ELA_MS | uow_elapsed_time_ms: Unit of Work elapse time ms | 0 | |||||||
PL_TEMP_XDA_L_RD | 0 | ||||||||
UNREADPFPG | unread_prefetch_pages: Unread prefetched pages | 0 | |||||||
PL_TEMP_XDA_P_RD | 0 | ||||||||
PL_TD_LRS | pool_temp_data_l_reads | 0 | |||||||
ELPSD_EXC_TIM_MS | 0 | ||||||||
PL_TD_PRS | pool_temp_data_p_reads | 0 | |||||||
ELPSD_EXC_TIM_S | 0 | ||||||||
PL_TI_LRS | pool_temp_index_l_reads | 0 | |||||||
INACT_STMTHISTSZ | 0 | ||||||||
PL_TI_PRS | pool_temp_index_p_reads | 0 | |||||||
LOCK_TIMEOUT_VAL | 0 | ||||||||
PRV_WS_NUM_OVFL | 0 | ||||||||
POOL_XDA_L_READS | 0 | ||||||||
POOL_XDA_P_READS | 0 | ||||||||
PRV_WS_SCT_INSRT | 0 | ||||||||
POOL_XDA_WRITES | 0 | ||||||||
PRV_WS_SCT_LKUP | 0 | ||||||||
PRV_WS_SIZE_TOP | 0 | ||||||||
PL_TEMP_XDA_L_RD | 0 | ||||||||
SHR_WS_NUM_OVFL | 0 | ||||||||
PL_TEMP_XDA_P_RD | 0 | ||||||||
ELPSD_EXC_TIM_MS | 0 | ||||||||
SHR_WS_SCT_INSRT | 0 | ||||||||
ELPSD_EXC_TIM_S | 0 | ||||||||
SHR_WS_SCT_LKUP | 0 | ||||||||
SHR_WS_SIZE_TOP | 0 | ||||||||
INACT_STMTHISTSZ | 0 | ||||||||
SESSION_AUTH_ID | session auth. ID | 0 | |||||||
LOCK_TIMEOUT_VAL | 0 | ||||||||
TPMON_ACC_STR | 0 | ||||||||
PRV_WS_NUM_OVFL | 0 | ||||||||
PRV_WS_SCT_INSRT | 0 | ||||||||
TPMON_CLIENT_APP | 0 | ||||||||
PRV_WS_SCT_LKUP | 0 | ||||||||
TPMON_CLIENT_UID | 0 | ||||||||
PRV_WS_SIZE_TOP | 0 | ||||||||
TPMON_CLIENT_WKS | 0 | ||||||||
AUTHORITY_LEVEL | 0 | ||||||||
SHR_WS_NUM_OVFL | 0 | ||||||||
SHR_WS_SCT_INSRT | 0 | ||||||||
SHR_WS_SCT_LKUP | 0 | ||||||||
SHR_WS_SIZE_TOP | 0 | ||||||||
OLAP_FUNC_OVERFLOWS | 0 | ||||||||
TOTAL_OLAP_FUNCS | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure DB6PMSA using ABAP code?
As DB6PMSA 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 DB6PMSA as there is no data to select.How to access SAP table DB6PMSA
Within an ECC or HANA version of SAP you can also view further information about DB6PMSA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects