DB6_VIEW_TBSNAP_DETAIL SAP (DB6: View Data of Tablespace Snapshot Details) Structure details

Dictionary Type: Structure
Description: DB6: View Data of Tablespace Snapshot Details




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




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

DB6_VIEW_TBSNAP_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: View Data of Tablespace 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_TBSNAP_DETAIL TYPE DB6_VIEW_TBSNAP_DETAIL.

The DB6_VIEW_TBSNAP_DETAIL table consists of various fields, each holding specific information or linking keys about DB6: View Data of Tablespace Snapshot Details data available in SAP. These include COUNT_ROWS (), TABS (), 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_TBSNAP_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
COUNT_ROWS 0
TABS 0
DBMSTRTTMEDBA: ISO conform timestamp with ms precission DB6DATETIMCHAR26
COMPTIMEDBA: ISO conform timestamp with ms precission DB6DATETIMCHAR26
PARTITN Partition Number0
TBS_NAMEDB6: Tablespace Name DB6TSPNAMECHAR30
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
AVG_DIRECT_WTM Average Direct Write Time0
AVG_DIRECT_RTM Average Direct Read Time0
AVG_PHYSICAL_WTM Average Physical Write Time0
AVG_PHYSICAL_RTM Average Pyhsical Read Time0
POOL_PHYSICAL_WRITES Physical Writes0
POOL_PHYSICAL_READS Physical Reads0
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 Logical Reads0
PL_TD_PRS Pool Temp Data Physical Reads0
PL_TI_LRS Pool Temp Index Logical Reads0
PL_TI_PRS Pool Temp Index Physical Reads0
PL_A_DRRQ Asynchronous Index Read Requests0
PL_A_IRRQ Asynchronous Index Read Requests0
PL_ASYNC_XDA_RDS 0
PL_ASYNC_XDA_RRQ 0
PL_ASYNC_XDA_WRT 0
PL_TEMP_XDA_L_RD 0
PL_TEMP_XDA_P_RD 0
POOL_XDA_L_READS 0
POOL_XDA_P_READS 0
POOL_XDA_WRITES 0
PL_NO_VICTIM_BUF pool_no_victim_buffer0
COLORALV control: Field name with simple row color coding LVC_CIFNMCHAR30CHAR30
BPNAMEDB6: long table name DB6TABNAMLCHAR128
UNREADPFPG unread_prefetch_pages0
TOTAL_IO 0
TOTAL_READ_IO 0
TOTAL_WRITE_IO 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
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
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
PL_ASYNC_COL_RDS Pool Async COL Reads0
PL_ASYNC_COL_RRQ Pool Async COL Read Requests0
PL_ASYNC_COL_WRT Pool Async COL Writes0
BP_C_HITRT 0
BP_C_SPRS Index Synchronous Physical Reads0
BP_C_SWS Index Synchronous Physical Writes0
WA_DB6PMSTBS 0
DBMSTRTTMEDBA: ISO conform timestamp with ms precission DB6DATETIMCHAR26
COMPTIMEDBA: ISO conform timestamp with ms precission DB6DATETIMCHAR26
PARTITN Partition Number0
TBS_NAMEDB6: Tablespace Name DB6TSPNAMECHAR30
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
AVG_DIRECT_WTM Average Direct Write Time0
AVG_DIRECT_RTM Average Direct Read Time0
AVG_PHYSICAL_WTM Average Physical Write Time0
AVG_PHYSICAL_RTM Average Pyhsical Read Time0
POOL_PHYSICAL_WRITES Physical Writes0
POOL_PHYSICAL_READS Physical Reads0
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 Logical Reads0
PL_TD_PRS Pool Temp Data Physical Reads0
PL_TI_LRS Pool Temp Index Logical Reads0
PL_TI_PRS Pool Temp Index Physical Reads0
PL_A_DRRQ Asynchronous Index Read Requests0
PL_A_IRRQ Asynchronous Index Read Requests0
PL_ASYNC_XDA_RDS 0
PL_ASYNC_XDA_RRQ 0
PL_ASYNC_XDA_WRT 0
PL_TEMP_XDA_L_RD 0
PL_TEMP_XDA_P_RD 0
POOL_XDA_L_READS 0
POOL_XDA_P_READS 0
POOL_XDA_WRITES 0
PL_NO_VICTIM_BUF pool_no_victim_buffer0
COLORALV control: Field name with simple row color coding LVC_CIFNMCHAR30CHAR30
BPNAMEDB6: long table name DB6TABNAMLCHAR128
UNREADPFPG unread_prefetch_pages0
TOTAL_IO 0
TOTAL_READ_IO 0
TOTAL_WRITE_IO 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
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
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
PL_ASYNC_COL_RDS Pool Async COL Reads0
PL_ASYNC_COL_RRQ Pool Async COL Read Requests0
PL_ASYNC_COL_WRT Pool Async COL Writes0
BP_C_HITRT 0
BP_C_SPRS Index Synchronous Physical Reads0
BP_C_SWS Index Synchronous Physical Writes0
IT_DB6PMSTBS 0

Key field Non-key field



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

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

How to access SAP table DB6_VIEW_TBSNAP_DETAIL

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