DB6PM1ST4 SAP (DB6: Initial Screen of Transaction ST04) Structure details
Description: DB6: Initial Screen of Transaction ST04
Structure field list including key, data, relationships and ABAP select examples
DB6PM1ST4 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: Initial Screen of Transaction ST04" 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_DB6PM1ST4 TYPE DB6PM1ST4.
The DB6PM1ST4 table consists of various fields, each holding specific information or linking keys about DB6: Initial Screen of Transaction ST04 data available in SAP. These include DBMSTRTTME (DB6: Timestamp (Format: YYYYMMDDHHMMSS)), COMPTIME (DB6: Timestamp (Format: YYYYMMDDHHMMSS)), DBMSTRTTME (DB6: Timestamp (Format: YYYYMMDDHHMMSS)), COMPTIME (DBA: ISO conform timestamp with ms precission).. 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 DB6PM1ST4 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 | 0 | ||||||||
DBMSTRTTME | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
COMPTIME | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
DBMSTRTTME | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
COMPTIME | DBA: ISO conform timestamp with ms precission | DB6DATETIM | CHAR | 26 | |||||
LAST_RESET | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
BUFFPAGE | Default Buffer Pool Size of DB CFG (4 KB Pages) | 0 | |||||||
LAST_RESET | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
BP_SZ | Total Buffer Pool Size (KB) | 0 | |||||||
BUFFPAGE | Default Buffer Pool Size of DB CFG (4 KB Pages) | 0 | |||||||
BP_SZ | Total Buffer Pool Size (KB) | 0 | |||||||
BP_QAL | Overall Buffer Quality (%) | 0 | |||||||
BP_QAL | Overall Buffer Quality (%) | 0 | |||||||
BP_AV_RTM | Average Physical Read Time (ms) | 0 | |||||||
BP_AV_RTM | Average Physical Read Time (ms) | 0 | |||||||
BP_AV_WTM | Average Physical Write Time (ms) | 0 | |||||||
BP_AV_WTM | Average Physical Write Time (ms) | 0 | |||||||
BP_D_HITRT | Buffer Pool Data Hit Ratio (%) | 0 | |||||||
BP_D_HITRT | Buffer Pool Data Hit Ratio (%) | 0 | |||||||
BP_I_HITRT | Buffer Pool Index Hit Ratio (%) | 0 | |||||||
BP_NUM | Number of Buffer Pools | 0 | |||||||
BP_I_HITRT | Buffer Pool Index Hit Ratio (%) | 0 | |||||||
BP_NUM | Number of Buffer Pools | 0 | |||||||
PL_D_LRS | Data Logical Reads | 0 | |||||||
PL_D_LRS | Data Logical Reads | 0 | |||||||
PL_D_PRS | Data Physical Reads | 0 | |||||||
PL_D_WS | Data Physical Writes | 0 | |||||||
PL_D_PRS | Data Physical Reads | 0 | |||||||
PL_D_WS | Data Physical Writes | 0 | |||||||
BP_D_SPRS | Data Synchronous Physical Reads | 0 | |||||||
BP_D_SWS | Data Synchronous Physical Writes | 0 | |||||||
BP_D_SPRS | Data Synchronous Physical Reads | 0 | |||||||
BP_D_SWS | Data Synchronous Physical Writes | 0 | |||||||
PL_I_LRS | Index Logical Reads | 0 | |||||||
PL_I_LRS | Index Logical Reads | 0 | |||||||
PL_I_PRS | Index Physical Reads | 0 | |||||||
PL_I_WS | Index Physical Writes | 0 | |||||||
PL_I_PRS | Index Physical Reads | 0 | |||||||
PL_I_WS | Index Physical Writes | 0 | |||||||
BP_I_SPRS | Index Synchronous Physical Reads | 0 | |||||||
BP_I_SWS | Index Synchronous Physical Writes | 0 | |||||||
BP_I_SPRS | Index Synchronous Physical Reads | 0 | |||||||
BP_I_SWS | Index Synchronous Physical Writes | 0 | |||||||
PL_RD_TM | Pool Read Time | 0 | |||||||
PL_RD_TM | Pool Read Time | 0 | |||||||
PL_WT_TM | Pool Write Time | 0 | |||||||
CATCA_SZ | Catalog Cache Size (KB) | 0 | |||||||
PL_WT_TM | Pool Write Time | 0 | |||||||
CATCA_SZ | Catalog Cache Size (KB) | 0 | |||||||
CATCA_QAL | Catalog Cache Quality % | 0 | |||||||
MAXAPPLS | Maximum Number of Active Applications | 0 | |||||||
CATCA_QAL | Catalog Cache Quality % | 0 | |||||||
MAXAPPLS | Maximum Number of Active Applications | 0 | |||||||
PKG_CA_SZ | Package Cache Size (KB) | 0 | |||||||
PKG_CA_SZ | Package Cache Size (KB) | 0 | |||||||
PKG_CA_QAL | Package Cache Quality (%) | 0 | |||||||
CATCA_LKU | Catalog Cache Lookups | 0 | |||||||
PKG_CA_QAL | Package Cache Quality (%) | 0 | |||||||
CATCA_INS | Catalog Cache Inserts | 0 | |||||||
CATCA_LKU | Catalog Cache Lookups | 0 | |||||||
CATCA_OF | Catalog Cache Overflows | 0 | |||||||
CATCA_INS | Catalog Cache Inserts | 0 | |||||||
CATCA_OF | Catalog Cache Overflows | 0 | |||||||
CATCA_HPFL | Catalog Cache Heap Full | 0 | |||||||
CATCA_HPFL | Catalog Cache Heap Full | 0 | |||||||
PKG_CA_LKU | Package Cache Lookups | 0 | |||||||
PKG_CA_INS | Package Cache Inserts | 0 | |||||||
PKG_CA_LKU | Package Cache Lookups | 0 | |||||||
PKG_CA_INS | Package Cache Inserts | 0 | |||||||
PKG_NUM_OV | Package Cache Number Overflows | 0 | |||||||
PKG_NUM_OV | Package Cache Number Overflows | 0 | |||||||
PKG_SZ_TOP | Package Cache Size Top | 0 | |||||||
NUM_IOSVRS | Number of I/O Servers | 0 | |||||||
PKG_SZ_TOP | Package Cache Size Top | 0 | |||||||
AV_ASP_RTM | Average Asynchronous Physical Read Time (ms) | 0 | |||||||
NUM_IOSVRS | Number of I/O Servers | 0 | |||||||
AV_ASP_RTM | Average Asynchronous Physical Read Time (ms) | 0 | |||||||
NUM_IOCLNS | Number of I/O Cleaners | 0 | |||||||
AV_ASP_WTM | Average Asynchronous Physical Write Time (ms) | 0 | |||||||
NUM_IOCLNS | Number of I/O Cleaners | 0 | |||||||
PL_A_DRS | Data Asynchronous Physical Reads | 0 | |||||||
AV_ASP_WTM | Average Asynchronous Physical Write Time (ms) | 0 | |||||||
PL_A_DRS | Data Asynchronous Physical Reads | 0 | |||||||
PL_A_DWS | Data Asynchronous Physical Writes | 0 | |||||||
PL_A_DWS | Data Asynchronous Physical Writes | 0 | |||||||
PL_A_IRS | Index Asynchronous Physical Reads | 0 | |||||||
PL_A_IRS | Index Asynchronous Physical Reads | 0 | |||||||
PL_A_IWS | Index Asynchronous Physical Writes | 0 | |||||||
PL_A_IWS | Index Asynchronous Physical Writes | 0 | |||||||
PL_A_RTM | Asynchronous Read Time | 0 | |||||||
PL_A_RTM | Asynchronous Read Time | 0 | |||||||
PL_A_WTM | Asynchronous Write Time | 0 | |||||||
PL_A_WTM | Asynchronous Write Time | 0 | |||||||
LCKLISTSZ | Lock List Size (KB) | 0 | |||||||
LCKLISTSZ | Lock List Size (KB) | 0 | |||||||
LCK_LSTIU | Lock List in Use (KB) | 0 | |||||||
LCK_LSTIU | Lock List in Use (KB) | 0 | |||||||
LCK_ESCALS | Lock Escalations | 0 | |||||||
LCK_ESCALS | Lock Escalations | 0 | |||||||
X_LCK_ESCA | Exclusive Lock Escalations | 0 | |||||||
LCK_WAITS | Total Lock Waits | 0 | |||||||
X_LCK_ESCA | Exclusive Lock Escalations | 0 | |||||||
LCK_W_TM | Time Waited for Locks (ms) | 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 | |||||||
AV_WTM_LCK | Average Wait Time per Lock (ms) | 0 | |||||||
DEADLOCKS | Deadlocks Detected | 0 | |||||||
LCKS_HELD | Locks Currently Held | 0 | |||||||
DEADLOCKS | Deadlocks Detected | 0 | |||||||
LCK_TMOUT | Lock Timeouts | 0 | |||||||
LCK_TMOUT | Lock Timeouts | 0 | |||||||
CMMT_SQLST | COMMITs | 0 | |||||||
CMMT_SQLST | COMMITs | 0 | |||||||
RBCK_SQLST | ROLLBACKs | 0 | |||||||
RBCK_SQLST | ROLLBACKs | 0 | |||||||
SELC_SQLST | SELECT Statements | 0 | |||||||
UID_SQLST | UPDATE/INSERT/DELETE Statements | 0 | |||||||
SELC_SQLST | SELECT Statements | 0 | |||||||
DYN_SQLST | Dynamic SQL Statements | 0 | |||||||
UID_SQLST | UPDATE/INSERT/DELETE Statements | 0 | |||||||
DYN_SQLST | Dynamic SQL Statements | 0 | |||||||
STC_SQLST | Static SQL Statements | 0 | |||||||
STC_SQLST | Static SQL Statements | 0 | |||||||
FAIL_SQLST | Failed SQL Statements | 0 | |||||||
DDL_SQLST | Data Definition Language Statements | 0 | |||||||
FAIL_SQLST | Failed SQL Statements | 0 | |||||||
DDL_SQLST | Data Definition Language Statements | 0 | |||||||
RW_DELETED | Rows Deleted | 0 | |||||||
RW_DELETED | Rows Deleted | 0 | |||||||
RW_INSRTED | Rows Inserted | 0 | |||||||
RW_INSRTED | Rows Inserted | 0 | |||||||
RW_SELECED | Rows Selected | 0 | |||||||
RW_SELECED | Rows Selected | 0 | |||||||
RW_UPDATED | Rows Updated | 0 | |||||||
RW_UPDATED | Rows Updated | 0 | |||||||
SORTHEAPSZ | Total Sort Heap Size (KB) | 0 | |||||||
SORTHEAPSZ | Total Sort Heap Size (KB) | 0 | |||||||
SRT_HP_ALO | Sort Heap Allocated (KB) | 0 | |||||||
TOT_SORTS | Total Sorts | 0 | |||||||
SRT_HP_ALO | Sort Heap Allocated (KB) | 0 | |||||||
TOT_SORTS | Total Sorts | 0 | |||||||
TOT_SRT_TM | Total Sort Time (ms) | 0 | |||||||
AV_SORT_TM | Average Sort Time (ms) | 0 | |||||||
TOT_SRT_TM | Total Sort Time (ms) | 0 | |||||||
SRT_OF | Sort Overflows | 0 | |||||||
AV_SORT_TM | Average Sort Time (ms) | 0 | |||||||
SRT_OF | Sort Overflows | 0 | |||||||
ACTIV_SORT | Active Sorts | 0 | |||||||
DIRCT_RDS | Direct Reads | 0 | |||||||
ACTIV_SORT | Active Sorts | 0 | |||||||
DIRCT_RDS | Direct Reads | 0 | |||||||
DIRCT_WTS | Direct Writes | 0 | |||||||
DIRCT_RTM | Direct Read Time | 0 | |||||||
DIRCT_WTS | Direct Writes | 0 | |||||||
DIRCT_RTM | Direct Read Time | 0 | |||||||
DIRCT_WTM | Direct Write Time | 0 | |||||||
DIRCT_WTM | Direct Write Time | 0 | |||||||
DIRCT_RRQS | Direct Read Requests | 0 | |||||||
DIRCT_RRQS | Direct Read Requests | 0 | |||||||
DIRCT_WRQS | Direct Write Requests | 0 | |||||||
AV_DCT_RTM | Average Direct Read Time | 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_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 | |||||||
AV_DCT_WTS | Average Direct Writes | 0 | |||||||
PL_D_FE | Pool Data from Extended Storage | 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 | |||||||
PL_I_TE | Pool Index to Extended Storage | 0 | |||||||
PL_I_FE | Pool Index from Extended Storage | 0 | |||||||
TOT_LGUTOP | Maximum Total Log Space Used by Database | 0 | |||||||
SEC_LGUSTP | Maximum Secondary Log Space Used | 0 | |||||||
TOT_LGUTOP | Maximum Total Log Space Used by Database | 0 | |||||||
SEC_LGALLO | Number of Secondary Logs Allocated | 0 | |||||||
SEC_LGUSTP | Maximum Secondary Log Space Used | 0 | |||||||
LOG_READS | Number of Log Pages Read | 0 | |||||||
SEC_LGALLO | Number of Secondary Logs Allocated | 0 | |||||||
LOG_READS | Number of Log Pages Read | 0 | |||||||
LOG_WRITES | Number of Log Pages Written | 0 | |||||||
LOG_WRITES | Number of Log Pages Written | 0 | |||||||
TOT_LGUSED | Current Total Log Space Used by Database | 0 | |||||||
TOT_LGAVL | Log Space Available for Database | 0 | |||||||
TOT_LGUAVG | Average Total Log Space Used by Database | 0 | |||||||
LOGFILSIZ | Size of Log Files (Pages 4 KB) Configured | 0 | |||||||
TOT_LGUSED | Current Total Log Space Used by Database | 0 | |||||||
TOT_LGAVL | Log Space Available for Database | 0 | |||||||
LOGPRIMARY | Number of Primary Log Files Configured | 0 | |||||||
LOGBUFSZ | Log Buffer Size (4 KB) | 0 | |||||||
LOGSECOND | Number of Secondary Log Files Configured | 0 | |||||||
TOT_HAJN | Number of Hash Joins | 0 | |||||||
LOGFILSIZ | Size of Log Files (Pages 4 KB) Configured | 0 | |||||||
LOGPRIMARY | Number of Primary Log Files Configured | 0 | |||||||
TOT_HALOOP | Number of Hash Loops | 0 | |||||||
HAJN_OF | Number of Hash Join Overflows | 0 | |||||||
LOGSECOND | Number of Secondary Log Files Configured | 0 | |||||||
TOT_HAJN | Number of Hash Joins | 0 | |||||||
HAJN_SM_OF | Small Hash Join Overflows | 0 | |||||||
PL_TD_LRS | Temp Data Logical Reads | 0 | |||||||
TOT_HALOOP | Number of Hash Loops | 0 | |||||||
HAJN_OF | Number of Hash Join Overflows | 0 | |||||||
PL_TD_PRS | Temp Data Physical Reads | 0 | |||||||
PL_TI_LRS | Temp Index Logical Reads | 0 | |||||||
HAJN_SM_OF | Small Hash Join Overflows | 0 | |||||||
PL_TD_LRS | Temp Data Logical Reads | 0 | |||||||
PL_TI_PRS | Temp Index Physical Reads | 0 | |||||||
PL_A_DRRQ | Asynchronous Data Read Requests | 0 | |||||||
PL_TD_PRS | Temp Data Physical Reads | 0 | |||||||
PL_A_IRRQ | Asynchronous Index Read Requests | 0 | |||||||
PL_TI_LRS | Temp Index Logical Reads | 0 | |||||||
PL_TI_PRS | Temp Index Physical Reads | 0 | |||||||
CATCASZTOP | Catalog Cache Size Top (High Water Mark) | 0 | |||||||
PL_A_DRRQ | Asynchronous Data Read Requests | 0 | |||||||
LSNGAP_PCT | LSN Gap | 0 | |||||||
PL_A_IRRQ | Asynchronous Index Read Requests | 0 | |||||||
RESTRTRNGE | Restart Range | 0 | |||||||
AVGLWTPPAG | Average Log Write Time / Page | 0 | |||||||
CATCASZTOP | Catalog Cache Size Top (High Water Mark) | 0 | |||||||
AVGLWTPIO | Average Log Write Time / IO | 0 | |||||||
LSNGAP_PCT | LSN Gap | 0 | |||||||
AVGLRTPPAG | Average Log Read Time / Page | 0 | |||||||
RESTRTRNGE | Restart Range | 0 | |||||||
AVGLRTPIO | Average Log Read Time / IO | 0 | |||||||
AVGLWTPPAG | Average Log Write Time / Page | 0 | |||||||
AVGLWTPIO | Average Log Write Time / IO | 0 | |||||||
LGBUFHITRT | Log Buffer Hit Ratio | 0 | |||||||
LOGREADTS | Log Read Time (seconds) | 0 | |||||||
AVGLRTPPAG | Average Log Read Time / Page | 0 | |||||||
AVGLRTPIO | Average Log Read Time / IO | 0 | |||||||
LOGREADTNS | Log Read Time (micro seconds) | 0 | |||||||
LOGWRITS | Log Write Time (seconds) | 0 | |||||||
LGBUFHITRT | Log Buffer Hit Ratio | 0 | |||||||
LOGREADTS | Log Read Time (seconds) | 0 | |||||||
LOGWRITNS | Log Write Time (micro seconds) | 0 | |||||||
LOGREADTNS | Log Read Time (micro seconds) | 0 | |||||||
NUMLOGWRIO | Number of Log Write IO | 0 | |||||||
LOGWRITS | Log Write Time (seconds) | 0 | |||||||
NUMLOGRDIO | Number of Log Read IO | 0 | |||||||
LOGWRITNS | Log Write Time (micro seconds) | 0 | |||||||
NUMLOGPPIO | num_log_part_page_io | 0 | |||||||
NUMLOGBFUL | num_log_buffer_full | 0 | |||||||
NUMLOGWRIO | Number of Log Write IO | 0 | |||||||
NUMLOGDFND | num_log_data_found_in_buffer | 0 | |||||||
NUMLOGRDIO | Number of Log Read IO | 0 | |||||||
LOGREDOREC | log_to_redo_for_recovery | 0 | |||||||
NUMLOGPPIO | num_log_part_page_io | 0 | |||||||
LOGHELDDTY | log_held_by_dirty_pages | 0 | |||||||
NUMLOGBFUL | num_log_buffer_full | 0 | |||||||
SOFTMAX | SOFTMAX Parameter | 0 | |||||||
NUMLOGDFND | num_log_data_found_in_buffer | 0 | |||||||
SCPERHOUR | Soft Checkpoints / hour | 0 | |||||||
LOGREDOREC | log_to_redo_for_recovery | 0 | |||||||
LOGHELDDTY | log_held_by_dirty_pages | 0 | |||||||
ACTIVE_HASH_JOIN | Active Hash Joins | 0 | |||||||
DBNAME | DB Name | 0 | |||||||
SOFTMAX | SOFTMAX Parameter | 0 | |||||||
SCPERHOUR | Soft Checkpoints / hour | 0 | |||||||
PL_ASYNC_XDA_RDS | Pool Async XDA Reads | 0 | |||||||
ACTIVE_HASH_JOIN | Active Hash Joins | 0 | |||||||
PL_ASYNC_XDA_RRQ | Pool Async XDA Read Requests | 0 | |||||||
DBNAME | DB Name | 0 | |||||||
PL_ASYNC_XDA_WRT | Pool Async XDA Writes | 0 | |||||||
PL_ASYNC_XDA_RDS | Pool Async XDA Reads | 0 | |||||||
PL_TEMP_XDA_L_RD | Pool Temp XDA Logical Reads | 0 | |||||||
PL_ASYNC_XDA_RRQ | Pool Async XDA Read Requests | 0 | |||||||
PL_TEMP_XDA_P_RD | Pool Temp XDA Physical Reads | 0 | |||||||
PL_ASYNC_XDA_WRT | Pool Async XDA Writes | 0 | |||||||
POOL_XDA_L_READS | Pool XDA Logical Reads | 0 | |||||||
PL_TEMP_XDA_L_RD | Pool Temp XDA Logical Reads | 0 | |||||||
POOL_XDA_P_READS | Pool XDA Physical Reads | 0 | |||||||
POOL_XDA_WRITES | Pool XDA Writes | 0 | |||||||
PL_TEMP_XDA_P_RD | Pool Temp XDA Physical Reads | 0 | |||||||
POOL_XDA_L_READS | Pool XDA Logical Reads | 0 | |||||||
POST_SHRTHRS_HAJ | post_shrthreshold_hash_joins | 0 | |||||||
POOL_XDA_P_READS | Pool XDA Physical Reads | 0 | |||||||
POST_SHRTHRS_SRT | post_shrthreshold_sorts | 0 | |||||||
POOL_XDA_WRITES | Pool XDA Writes | 0 | |||||||
SMALLEST_LOG_AVL | Smallest Log available | 0 | |||||||
APPL_ID_OLDEST_X | appl_id_oldest_xact | 0 | |||||||
POST_SHRTHRS_HAJ | post_shrthreshold_hash_joins | 0 | |||||||
ELPSD_EXC_TIM_MS | elapsed_exec_time_ms | 0 | |||||||
POST_SHRTHRS_SRT | post_shrthreshold_sorts | 0 | |||||||
ELPSD_EXC_TIM_S | elapsed_exec_time_s | 0 | |||||||
SMALLEST_LOG_AVL | Smallest Log available | 0 | |||||||
APPL_ID_OLDEST_X | appl_id_oldest_xact | 0 | |||||||
NUM_DB_STORPATHS | num_db_storage_paths | 0 | |||||||
ELPSD_EXC_TIM_MS | elapsed_exec_time_ms | 0 | |||||||
NUM_INDOUBT_TRAN | num_indoubt_trans | 0 | |||||||
ELPSD_EXC_TIM_S | elapsed_exec_time_s | 0 | |||||||
PL_NO_VICTIM_BUF | pool_no_victim_buffer | 0 | |||||||
ROWS_READ | rows_read | 0 | |||||||
NUM_DB_STORPATHS | num_db_storage_paths | 0 | |||||||
PRV_WS_NUM_OVFL | priv_workspace_num_overflows | 0 | |||||||
NUM_INDOUBT_TRAN | num_indoubt_trans | 0 | |||||||
PL_NO_VICTIM_BUF | pool_no_victim_buffer | 0 | |||||||
PRV_WS_SCT_INSRT | priv_workspace_section_inserts | 0 | |||||||
ROWS_WRITTEN | rows_read | 0 | |||||||
PRV_WS_SCT_LKUP | priv_workspace_section_lookups | 0 | |||||||
ROWS_READ | rows_read | 0 | |||||||
PRV_WS_SIZE_TOP | priv_workspace_size_top | 0 | |||||||
PRV_WS_NUM_OVFL | priv_workspace_num_overflows | 0 | |||||||
SHR_WS_NUM_OVFL | shr_workspace_num_overflows | 0 | |||||||
PRV_WS_SCT_INSRT | priv_workspace_section_inserts | 0 | |||||||
SHR_WS_SCT_INSRT | shr_workspace_section_inserts | 0 | |||||||
PRV_WS_SCT_LKUP | priv_workspace_section_lookups | 0 | |||||||
SHR_WS_SCT_LKUP | shr_workspace_section_lookups | 0 | |||||||
PRV_WS_SIZE_TOP | priv_workspace_size_top | 0 | |||||||
SHR_WS_SIZE_TOP | shr_workspace_size_top | 0 | |||||||
SHR_WS_NUM_OVFL | shr_workspace_num_overflows | 0 | |||||||
SORT_SHRHEAP_ALL | sort_shrheap_allocated | 0 | |||||||
SHR_WS_SCT_INSRT | shr_workspace_section_inserts | 0 | |||||||
SORT_SHRHEAP_TOP | sort_shrheap_top | 0 | |||||||
SHEAPTRES | sortheap_threshold | 0 | |||||||
SHR_WS_SCT_LKUP | shr_workspace_section_lookups | 0 | |||||||
SHR_WS_SIZE_TOP | shr_workspace_size_top | 0 | |||||||
SORT_SHRHEAP_ALL | sort_shrheap_allocated | 0 | |||||||
SORT_SHRHEAP_TOP | sort_shrheap_top | 0 | |||||||
SHEAPTRES | sortheap_threshold | 0 | |||||||
ACTIVE_OLAP_FUNCS | 0 | ||||||||
ASYNC_RUNSTATS | 0 | ||||||||
NUM_THRESHOLD_VIOLATIONS | 0 | ||||||||
OLAP_FUNC_OVERFLOWS | 0 | ||||||||
STATS_CACHE_SIZE | 0 | ||||||||
STATS_FABRICATE_TIME | 0 | ||||||||
STATS_FABRICATIONS | 0 | ||||||||
SYNC_RUNSTATS | 0 | ||||||||
SYNC_RUNSTATS_TIME | 0 | ||||||||
ACC_EFFICIENCY | rows read / rows processed | 0 | |||||||
BPGETS_ROWRET | 0 | ||||||||
BPGETS_EXEC | 0 | ||||||||
SUBMISQLST | 0 | ||||||||
UNREADPFPG | 0 | ||||||||
PREFETCH_WAITS | 0 | ||||||||
PREFETCH_WAIT_TIME | 0 | ||||||||
SKP_PRF_DATA_P_READS | 0 | ||||||||
SKP_PRF_INDEX_P_READS | 0 | ||||||||
SKP_PRF_TEMP_DATA_P_READS | 0 | ||||||||
SKP_PRF_TEMP_INDEX_P_READS | 0 | ||||||||
SKP_PRF_TEMP_XDA_P_READS | 0 | ||||||||
SKP_PRF_UOW_DATA_P_READS | 0 | ||||||||
SKP_PRF_UOW_INDEX_P_READS | 0 | ||||||||
SKP_PRF_UOW_TEMP_DATA_P_READS | 0 | ||||||||
SKP_PRF_UOW_TEMP_INDEX_P_READS | 0 | ||||||||
SKP_PRF_UOW_TEMP_XDA_P_READS | 0 | ||||||||
SKP_PRF_UOW_XDA_P_READS | 0 | ||||||||
SKP_PRF_XDA_P_READS | 0 | ||||||||
PL_QUED_ASYNC_DATA_PAGES | 0 | ||||||||
PL_QUED_ASYNC_DATA_REQS | 0 | ||||||||
PL_QUED_ASYNC_INDEX_PAGES | 0 | ||||||||
PL_QUED_ASYNC_INDEX_REQS | 0 | ||||||||
PL_QUED_ASYNC_OTHER_REQS | 0 | ||||||||
PL_QUED_ASYNC_TEMP_DATA_PAGES | 0 | ||||||||
PL_QUED_ASYNC_TEMP_DATA_REQS | 0 | ||||||||
PL_QUED_ASYNC_TEMP_INDEX_PAGES | 0 | ||||||||
PL_QUED_ASYNC_TEMP_INDEX_REQS | 0 | ||||||||
PL_QUED_ASYNC_TEMP_XDA_PAGES | 0 | ||||||||
PL_QUED_ASYNC_TEMP_XDA_REQS | 0 | ||||||||
PL_QUED_ASYNC_XDA_PAGES | 0 | ||||||||
PL_QUED_ASYNC_XDA_REQS | 0 | ||||||||
PL_FAILED_ASYNC_DATA_REQS | 0 | ||||||||
PL_FAILED_ASYNC_INDEX_REQS | 0 | ||||||||
PL_FAILED_ASYNC_OTHER_REQS | 0 | ||||||||
PL_FAILED_ASYNC_TEMP_DATA_REQS | 0 | ||||||||
PL_FAILED_ASYNC_TEMP_INDEX_REQ | 0 | ||||||||
PL_FAILED_ASYNC_TEMP_XDA_REQS | 0 | ||||||||
PL_FAILED_ASYNC_XDA_REQS | 0 | ||||||||
LAST_BACKUP | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | |||||
PL_D_GBP_INDEP_PAGES_FND_LBP | 0 | ||||||||
PL_D_GBP_INVALID_PAGES | 0 | ||||||||
PL_D_GBP_L_READS | 0 | ||||||||
PL_D_GBP_P_READS | 0 | ||||||||
PL_D_LBP_PAGES_FOUND | 0 | ||||||||
PL_I_GBP_INDEP_PAGES_FND_LBP | 0 | ||||||||
PL_I_GBP_INVALID_PAGES | 0 | ||||||||
PL_I_GBP_L_READS | 0 | ||||||||
PL_I_GBP_P_READS | 0 | ||||||||
PL_I_LBP_PAGES_FOUND | 0 | ||||||||
PL_X_GBP_INDEP_PAGES_FND_LBP | 0 | ||||||||
PL_X_GBP_INVALID_PAGES | 0 | ||||||||
PL_X_GBP_L_READS | 0 | ||||||||
PL_X_GBP_P_READS | 0 | ||||||||
PL_X_LBP_PAGES_FOUND | 0 | ||||||||
PL_C_GBP_INDEP_PAGES_FND_LBP | 0 | ||||||||
PL_C_GBP_INVALID_PAGES | 0 | ||||||||
PL_C_GBP_L_READS | 0 | ||||||||
PL_C_GBP_P_READS | 0 | ||||||||
PL_C_LBP_PAGES_FOUND | 0 | ||||||||
LBP_GBP_DEP_HIT_RATIO | 0 | ||||||||
LBP_GBP_IND_HIT_RATIO | 0 | ||||||||
GBP_HIT_RATIO | 0 | ||||||||
D_LBP_GBP_DEP_HIT_RATIO | 0 | ||||||||
D_LBP_GBP_IND_HIT_RATIO | 0 | ||||||||
D_GBP_HIT_RATIO | 0 | ||||||||
I_LBP_GBP_DEP_HIT_RATIO | 0 | ||||||||
I_LBP_GBP_IND_HIT_RATIO | 0 | ||||||||
I_GBP_HIT_RATIO | 0 | ||||||||
X_LBP_GBP_DEP_HIT_RATIO | 0 | ||||||||
X_LBP_GBP_IND_HIT_RATIO | 0 | ||||||||
X_GBP_HIT_RATIO | 0 | ||||||||
C_LBP_GBP_DEP_HIT_RATIO | 0 | ||||||||
C_LBP_GBP_IND_HIT_RATIO | 0 | ||||||||
C_GBP_HIT_RATIO | 0 | ||||||||
PL_A_D_GBP_INDEP_PAGES_FND_LBP | 0 | ||||||||
PL_A_D_GBP_INVALID_PAGES | 0 | ||||||||
PL_A_D_GBP_L_READS | 0 | ||||||||
PL_A_D_GBP_P_READS | 0 | ||||||||
PL_A_D_LBP_PAGES_FOUND | 0 | ||||||||
PL_A_I_GBP_INDEP_PAGES_FND_LBP | 0 | ||||||||
PL_A_I_GBP_INVALID_PAGES | 0 | ||||||||
PL_A_I_GBP_L_READS | 0 | ||||||||
PL_A_I_GBP_P_READS | 0 | ||||||||
PL_A_I_LBP_PAGES_FOUND | 0 | ||||||||
PL_A_X_GBP_INDEP_PAGES_FND_LBP | 0 | ||||||||
PL_A_X_GBP_INVALID_PAGES | 0 | ||||||||
PL_A_X_GBP_L_READS | 0 | ||||||||
PL_A_X_GBP_P_READS | 0 | ||||||||
PL_A_X_LBP_PAGES_FOUND | 0 | ||||||||
LBP_HIT_RATIO | 0 | ||||||||
PREFETCH_PAGES_FOUND_GBP | 0 | ||||||||
D_LBP_HIT_RATIO | 0 | ||||||||
D_PREFETCH_PAGES_FOUND_GBP | 0 | ||||||||
I_LBP_HIT_RATIO | 0 | ||||||||
I_PREFETCH_PAGES_FOUND_GBP | 0 | ||||||||
X_LBP_HIT_RATIO | 0 | ||||||||
X_PREFETCH_PAGES_FOUND_GBP | 0 | ||||||||
PL_A_C_GBP_INDEP_PAGES_FND_LBP | 0 | ||||||||
PL_A_C_GBP_INVALID_PAGES | 0 | ||||||||
PL_A_C_GBP_L_READS | 0 | ||||||||
PL_A_C_GBP_P_READS | 0 | ||||||||
PL_A_C_LBP_PAGES_FOUND | 0 | ||||||||
C_LBP_HIT_RATIO | 0 | ||||||||
C_PREFETCH_PAGES_FOUND_GBP | 0 | ||||||||
AVG_LOGGER_WTM | AVG Logger Write Time | 0 | |||||||
AVG_LOGGER_RTM | AVG Logger Read Time | 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 | ||||||||
PL_QUED_ASYNC_COL_PAGES | 0 | ||||||||
PL_QUED_ASYNC_COL_REQS | 0 | ||||||||
PL_QUED_ASYNC_TEMP_COL_PAGES | 0 | ||||||||
PL_QUED_ASYNC_TEMP_COL_REQS | 0 | ||||||||
PL_FAILED_ASYNC_COL_REQS | 0 | ||||||||
PL_FAILED_ASYNC_TEMP_COL_REQS | 0 | ||||||||
BP_C_HITRT | 0 | ||||||||
BP_C_SPRS | Index Synchronous Physical Reads | 0 | |||||||
BP_C_SWS | Index Synchronous Physical Writes | 0 | |||||||
PL_ASYNC_COL_RDS | Pool Async COL Reads | 0 | |||||||
PL_ASYNC_COL_RRQ | Pool Async COL Read Requests | 0 | |||||||
PL_ASYNC_COL_WRT | Pool Async COL Writes | 0 | |||||||
SKP_PRF_COL_P_READS | 0 | ||||||||
SKP_PRF_TEMP_COL_P_READS | 0 | ||||||||
SKP_PRF_UOW_COL_P_READS | 0 | ||||||||
SKP_PRF_UOW_TEMP_COL_P_READS | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure DB6PM1ST4 using ABAP code?
As DB6PM1ST4 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 DB6PM1ST4 as there is no data to select.How to access SAP table DB6PM1ST4
Within an ECC or HANA version of SAP you can also view further information about DB6PM1ST4 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