DB6_VIEW_BPS_DETAIL SAP (DB6: Bufferpool Snapshot Details) Structure details

Dictionary Type: Structure
Description: DB6: Bufferpool Snapshot Details




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




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

DB6_VIEW_BPS_DETAIL 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: Bufferpool Snapshot Details" 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_DB6_VIEW_BPS_DETAIL TYPE DB6_VIEW_BPS_DETAIL.

The DB6_VIEW_BPS_DETAIL table consists of various fields, each holding specific information or linking keys about DB6: Bufferpool Snapshot Details data available in SAP. These include NUM_ROWS (), WA (), DBMSTRTTME (DBA: ISO conform timestamp with ms precission), 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 DB6_VIEW_BPS_DETAIL 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
RELATIVE_LOG_INDEXRow Index of Internal Tables SYTABIXINT410SYST_LONG
NUM_ROWS 0
WA 0
DBMSTRTTMEDBA: ISO conform timestamp with ms precission DB6DATETIMCHAR26
COMPTIMEDBA: ISO conform timestamp with ms precission DB6DATETIMCHAR26
PARTITN Partition Number0
BP_NAMEDB6: General identifier DB6IDENTCHAR20
BP_NUM Number of Buffer Pools0
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_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 Reads0
PL_D_PRS Data Physical Reads0
PL_D_WS Data Physical Writes0
BP_D_SPRS Data Synchronous Physical Reads0
BP_D_SWS Data Synchronous Physical Writes0
PL_I_LRS Index Logical Reads0
PL_I_PRS Index Physical Reads0
PL_I_WS Index Physical Writes0
BP_I_SPRS Index Synchronous Physical Reads0
BP_I_SWS Index Synchronous Physical Writes0
PL_RD_TM Pool Read Time0
PL_WT_TM Pool Write Time0
AV_ASP_RTM Average Asynchronous Physical Read Time (ms)0
AV_ASP_WTM Average Asynchronous Physical Write Time (ms)0
PL_A_DRS Data Asynchronous Physical Reads0
PL_A_DWS Data Asynchronous Physical Writes0
PL_A_IRS Index Asynchronous Physical Reads0
PL_A_IWS Index Asynchronous Physical Writes0
PL_A_RTM Asynchronous Read Time0
PL_A_WTM Asynchronous Write Time0
DIRCT_RDS Direct Reads0
DIRCT_WTS Direct Writes0
DIRCT_RTM Direct Read Time0
DIRCT_WTM Direct Write Time0
DIRCT_RRQS Direct Read Requests0
DIRCT_WRQS Direct Write Requests0
AV_DCT_RTM Average Direct Read Time0
AV_DCT_WTM Average Direct Write Time0
AV_DCT_RDS Average Direct Reads0
AV_DCT_WTS Average Direct Writes0
PL_D_TE Pool Data to Extended Storage0
PL_D_FE Pool Data from Extended Storage0
PL_I_TE Pool Index to Extended Storage0
PL_I_FE Pool Index from Extended Storage0
PL_TD_LRS pool_temp_data_l_reads0
PL_TD_PRS pool_temp_data_p_reads0
PL_TI_LRS pool_temp_index_l_reads0
PL_TI_PRS pool_temp_index_p_reads0
PL_A_DRRQ pool_async_data_read_reqs0
PL_A_IRRQ pool_async_index_read_reqs0
CURBUFFSZ curent BP size in pages (pagesize depends on buffpool pages)0
NEWBUFFSZ new BP size in pages0
AUTOSIZE_LABEL AUTOMATIC flag label0
AUTOSIZE AUTOMATIC flag0
PGS_FROM_BLOCKIO pages_from_block_ios0
PGS_FROM_VECTRIO pages_from_vectored_ios0
PHYS_PAGE_MAPS physical_page_maps0
PL_ASYNC_XDA_RD pool_async_xda_reads0
PL_ASYNC_XDA_RRQ pool_async_xda_read_reqs0
PL_ASYNC_XDA_WRT pool_aysnc_xda_writes0
PL_NO_VICTIM_BUF pool_no_victim_buffer0
POOL_XDA_L_READS pool_xda_l_reads0
POOL_XDA_P_READS pool_xda_p_reads0
POOL_XDA_WRITES pool_xda_writes0
PL_TEMP_XDA_L_RD pool_temp_xda_l_reads0
PL_TEMP_XDA_P_RD pool_temp_xda_p_reads0
VECTORED_IOS vectored_ios0
BP_PAGES_LEFT bp_pages_left_to_remove0
BP_TBSP_USE_CNT bp_tbsp_use_count0
PCT_SIZE 0
PCT_LREADS 0
PCT_PREADS 0
PCT_ASYNC_READS 0
UNREADPFPG unread_prefetch_pages0
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
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
SIZE_MB 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
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
BP_C_HITRT 0
BP_C_SPRS 0
BP_C_SWS 0
PL_ASYNC_COL_RDS 0
PL_ASYNC_COL_RRQ 0
PL_ASYNC_COL_WRT 0
IT_DB6PMSBP 0
WA_HISTORY 0
DBMSTRTTMEDBA: ISO conform timestamp with ms precission DB6DATETIMCHAR26
COMPTIMEDBA: ISO conform timestamp with ms precission DB6DATETIMCHAR26
PARTITN Partition Number0
BP_NAMEDB6: General identifier DB6IDENTCHAR20
BP_NUM Number of Buffer Pools0
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_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 Reads0
PL_D_PRS Data Physical Reads0
PL_D_WS Data Physical Writes0
BP_D_SPRS Data Synchronous Physical Reads0
BP_D_SWS Data Synchronous Physical Writes0
PL_I_LRS Index Logical Reads0
PL_I_PRS Index Physical Reads0
PL_I_WS Index Physical Writes0
BP_I_SPRS Index Synchronous Physical Reads0
BP_I_SWS Index Synchronous Physical Writes0
PL_RD_TM Pool Read Time0
PL_WT_TM Pool Write Time0
AV_ASP_RTM Average Asynchronous Physical Read Time (ms)0
AV_ASP_WTM Average Asynchronous Physical Write Time (ms)0
PL_A_DRS Data Asynchronous Physical Reads0
PL_A_DWS Data Asynchronous Physical Writes0
PL_A_IRS Index Asynchronous Physical Reads0
PL_A_IWS Index Asynchronous Physical Writes0
PL_A_RTM Asynchronous Read Time0
PL_A_WTM Asynchronous Write Time0
DIRCT_RDS Direct Reads0
DIRCT_WTS Direct Writes0
DIRCT_RTM Direct Read Time0
DIRCT_WTM Direct Write Time0
DIRCT_RRQS Direct Read Requests0
DIRCT_WRQS Direct Write Requests0
AV_DCT_RTM Average Direct Read Time0
AV_DCT_WTM Average Direct Write Time0
AV_DCT_RDS Average Direct Reads0
AV_DCT_WTS Average Direct Writes0
PL_D_TE Pool Data to Extended Storage0
PL_D_FE Pool Data from Extended Storage0
PL_I_TE Pool Index to Extended Storage0
PL_I_FE Pool Index from Extended Storage0
PL_TD_LRS pool_temp_data_l_reads0
PL_TD_PRS pool_temp_data_p_reads0
PL_TI_LRS pool_temp_index_l_reads0
PL_TI_PRS pool_temp_index_p_reads0
PL_A_DRRQ pool_async_data_read_reqs0
PL_A_IRRQ pool_async_index_read_reqs0
CURBUFFSZ curent BP size in pages (pagesize depends on buffpool pages)0
NEWBUFFSZ new BP size in pages0
AUTOSIZE_LABEL AUTOMATIC flag label0
AUTOSIZE AUTOMATIC flag0
PGS_FROM_BLOCKIO pages_from_block_ios0
PGS_FROM_VECTRIO pages_from_vectored_ios0
PHYS_PAGE_MAPS physical_page_maps0
PL_ASYNC_XDA_RD pool_async_xda_reads0
PL_ASYNC_XDA_RRQ pool_async_xda_read_reqs0
PL_ASYNC_XDA_WRT pool_aysnc_xda_writes0
PL_NO_VICTIM_BUF pool_no_victim_buffer0
POOL_XDA_L_READS pool_xda_l_reads0
POOL_XDA_P_READS pool_xda_p_reads0
POOL_XDA_WRITES pool_xda_writes0
PL_TEMP_XDA_L_RD pool_temp_xda_l_reads0
PL_TEMP_XDA_P_RD pool_temp_xda_p_reads0
VECTORED_IOS vectored_ios0
BP_PAGES_LEFT bp_pages_left_to_remove0
BP_TBSP_USE_CNT bp_tbsp_use_count0
PCT_SIZE 0
PCT_LREADS 0
PCT_PREADS 0
PCT_ASYNC_READS 0
UNREADPFPG unread_prefetch_pages0
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
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
SIZE_MB 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
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
BP_C_HITRT 0
BP_C_SPRS 0
BP_C_SWS 0
PL_ASYNC_COL_RDS 0
PL_ASYNC_COL_RRQ 0
PL_ASYNC_COL_WRT 0
IT_DB6PMSBP_HISTORY 0

Key field Non-key field



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

As DB6_VIEW_BPS_DETAIL 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 DB6_VIEW_BPS_DETAIL as there is no data to select.

How to access SAP table DB6_VIEW_BPS_DETAIL

Within an ECC or HANA version of SAP you can also view further information about DB6_VIEW_BPS_DETAIL 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!