SAP DB6PMSQ table - DB6: Snapshot SQL Cache details in SAP

SAP DB6PMSQ table summary

Object Name: DB6PMSQ
Dictionary Type: Structure
Description: DB6: Snapshot SQL Cache

Field list for DB6PMSQ table on an S/4 SAP system

Details

DB6PMSQ-COMPTIME table field - DB6: Timestamp (Format: YYYYMMDDHHMMSS) ▼

Description: DB6: Timestamp (Format: YYYYMMDDHHMMSS)
Field Name: COMPTIME
Data Element: DB6TSTAMP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMPTIME

DB6PMSQ-PARTITN table field - Partition Number ▼

Description: Partition Number
Field Name: PARTITN
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTITN

DB6PMSQ-ARTIF_KEY table field - artif_key: Artificial Key for Uniqueness ▼

Description: artif_key: Artificial Key for Uniqueness
Field Name: ARTIF_KEY
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ARTIF_KEY

DB6PMSQ-CALLERFLAG table field - Who Has Called this Program ▼

Description: Who Has Called this Program
Field Name: CALLERFLAG
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CALLERFLAG

DB6PMSQ-DBMSTRTTME table field - DB6: Timestamp (Format: YYYYMMDDHHMMSS) ▼

Description: DB6: Timestamp (Format: YYYYMMDDHHMMSS)
Field Name: DBMSTRTTME
Data Element: DB6TSTAMP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBMSTRTTME

DB6PMSQ-PRGVERS table field - Version of Program Inserted this Row ▼

Description: Version of Program Inserted this Row
Field Name: PRGVERS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRGVERS

DB6PMSQ-NUM_EXECUT table field - num_executions: Number of Executions ▼

Description: num_executions: Number of Executions
Field Name: NUM_EXECUT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUM_EXECUT

DB6PMSQ-NUM_COMPIL table field - num_compilations: Number of Compilations ▼

Description: num_compilations: Number of Compilations
Field Name: NUM_COMPIL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUM_COMPIL

DB6PMSQ-PREPTWORST table field - prep_time_worst: Worst Preparation Time (ms) ▼

Description: prep_time_worst: Worst Preparation Time (ms)
Field Name: PREPTWORST
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PREPTWORST

DB6PMSQ-PREPTBEST table field - prep_time_best: Best Preparation Time (ms) ▼

Description: prep_time_best: Best Preparation Time (ms)
Field Name: PREPTBEST
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PREPTBEST

DB6PMSQ-INT_RW_DEL table field - int_rows_deleted: Rows Deleted ▼

Description: int_rows_deleted: Rows Deleted
Field Name: INT_RW_DEL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INT_RW_DEL

DB6PMSQ-INT_RW_INS table field - int_rows_inserted: Rows Inserted ▼

Description: int_rows_inserted: Rows Inserted
Field Name: INT_RW_INS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INT_RW_INS

DB6PMSQ-RW_READ table field - rows_read: Rows Read ▼

Description: rows_read: Rows Read
Field Name: RW_READ
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RW_READ

DB6PMSQ-INT_RW_UPD table field - int_rows_updated: Rows Updated ▼

Description: int_rows_updated: Rows Updated
Field Name: INT_RW_UPD
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INT_RW_UPD

DB6PMSQ-RW_WRITTEN table field - rows_written: Rows Written ▼

Description: rows_written: Rows Written
Field Name: RW_WRITTEN
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RW_WRITTEN

DB6PMSQ-STMT_SORTS table field - stmt_sorts: Statement Sorts ▼

Description: stmt_sorts: Statement Sorts
Field Name: STMT_SORTS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_SORTS

DB6PMSQ-TOTEXETS table field - total_exec_time_s: Total Execution Time (sec) ▼

Description: total_exec_time_s: Total Execution Time (sec)
Field Name: TOTEXETS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTEXETS

DB6PMSQ-TOTEXETMS table field - total_exec_time_ms: Total Execution Time (ms) ▼

Description: total_exec_time_ms: Total Execution Time (ms)
Field Name: TOTEXETMS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTEXETMS

DB6PMSQ-TOTUSRCTS table field - tot_u_cpu_time_s: Total User CPU Time (sec) ▼

Description: tot_u_cpu_time_s: Total User CPU Time (sec)
Field Name: TOTUSRCTS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTUSRCTS

DB6PMSQ-TOTUSRCTMS table field - tot_u_cpu_time_ms: Total User CPU Time (ms) ▼

Description: tot_u_cpu_time_ms: Total User CPU Time (ms)
Field Name: TOTUSRCTMS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTUSRCTMS

DB6PMSQ-TOTSYSCTS table field - tot_s_cpu_time_s: Total System CPU Time (sec) ▼

Description: tot_s_cpu_time_s: Total System CPU Time (sec)
Field Name: TOTSYSCTS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTSYSCTS

DB6PMSQ-TOTSYSCTMS table field - tot_s_cpu_time_ms: Total System CPU Time (ms) ▼

Description: tot_s_cpu_time_ms: Total System CPU Time (ms)
Field Name: TOTSYSCTMS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTSYSCTMS

DB6PMSQ-DB_NAME table field - DB6: General identifier ▼

Description: DB6: General identifier
Field Name: DB_NAME
Data Element: DB6IDENT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB_NAME

DB6PMSQ-PL_D_LRS table field - pool_data_l_reads ▼

Description: pool_data_l_reads
Field Name: PL_D_LRS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PL_D_LRS

DB6PMSQ-PL_D_PRS table field - pool_data_p_reads ▼

Description: pool_data_p_reads
Field Name: PL_D_PRS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PL_D_PRS

DB6PMSQ-PL_I_LRS table field - pool_index_l_reads ▼

Description: pool_index_l_reads
Field Name: PL_I_LRS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PL_I_LRS

DB6PMSQ-PL_I_PRS table field - pool_index_p_reads ▼

Description: pool_index_p_reads
Field Name: PL_I_PRS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PL_I_PRS

DB6PMSQ-PL_TD_LRS table field - pool_temp_data_l_reads ▼

Description: pool_temp_data_l_reads
Field Name: PL_TD_LRS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PL_TD_LRS

DB6PMSQ-PL_TD_PRS table field - pool_temp_data_p_reads ▼

Description: pool_temp_data_p_reads
Field Name: PL_TD_PRS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PL_TD_PRS

DB6PMSQ-PL_TI_LRS table field - pool_temp_index_l_reads ▼

Description: pool_temp_index_l_reads
Field Name: PL_TI_LRS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PL_TI_LRS

DB6PMSQ-PL_TI_PRS table field - pool_temp_index_p_reads ▼

Description: pool_temp_index_p_reads
Field Name: PL_TI_PRS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PL_TI_PRS

DB6PMSQ-SORT_OVERFLOWS table field - sort_overflows ▼

Description: sort_overflows
Field Name: SORT_OVERFLOWS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORT_OVERFLOWS

DB6PMSQ-TOTAL_SORT_TIME table field - total_sort_time ▼

Description: total_sort_time
Field Name: TOTAL_SORT_TIME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTAL_SORT_TIME

DB6PMSQ-PL_XDA_LRS table field - pool_xda_l_reads ▼

Description: pool_xda_l_reads
Field Name: PL_XDA_LRS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PL_XDA_LRS

DB6PMSQ-PL_XDA_PRS table field - pool_xda_p_reads ▼

Description: pool_xda_p_reads
Field Name: PL_XDA_PRS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PL_XDA_PRS

DB6PMSQ-PL_TEMP_XDA_LRS table field - pool_temp_xda_l_reads ▼

Description: pool_temp_xda_l_reads
Field Name: PL_TEMP_XDA_LRS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PL_TEMP_XDA_LRS

DB6PMSQ-PL_TEMP_XDA_PRS table field - pool_temp_Xda_p_reads ▼

Description: pool_temp_Xda_p_reads
Field Name: PL_TEMP_XDA_PRS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PL_TEMP_XDA_PRS

DB6PMSQ-STATS_FABRICATE_TIME table field - ▼

Description:
Field Name: STATS_FABRICATE_TIME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATS_FABRICATE_TIME

DB6PMSQ-SYNC_RUNSTATS_TIME table field - ▼

Description:
Field Name: SYNC_RUNSTATS_TIME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SYNC_RUNSTATS_TIME

DB6PMSQ-ROWS_RETURNED table field - ▼

Description:
Field Name: ROWS_RETURNED
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWS_RETURNED

DB6PMSQ-STMT_PKGCACHE_ID table field - ▼

Description:
Field Name: STMT_PKGCACHE_ID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_PKGCACHE_ID

DB6PMSQ-INSERT_TIMESTAMP table field - DB6: Timestamp (Format: YYYYMMDDHHMMSS) ▼

Description: DB6: Timestamp (Format: YYYYMMDDHHMMSS)
Field Name: INSERT_TIMESTAMP
Data Element: DB6TSTAMP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSERT_TIMESTAMP

DB6PMSQ-STMT_LEN table field - stmt_txtln: Length Field of LCHR stmt_txt ▼

Description: stmt_txtln: Length Field of LCHR stmt_txt
Field Name: STMT_LEN
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_LEN

DB6PMSQ-STMT_TEXT table field - stmt_text: SQL Statement ▼

Description: stmt_text: SQL Statement
Field Name: STMT_TEXT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_TEXT

View list of all SAP tables(S4H/ECC)

Select data from SAP table