dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table DB6PMSQ

DB6: Snapshot SQL Cache

Recommended Now

Fire TV Stick Lite Essentials Bundle

This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.

Check it out on amazon.com →

The table DB6PMSQ (DB6: Snapshot SQL Cache) is a standard table in SAP ERP. It belongs to the package STU6.

Technical Information

Table DB6PMSQ
Short Text DB6: Snapshot SQL Cache
Package STU6
Table Type Transparent Table

Fields for Table DB6PMSQ

Field Name Key Description Data Element Type Length Check Table
COMPTIME ✔ DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
PARTITN ✔ Partition Number INT4 10
ARTIF_KEY ✔ artif_key: Artificial Key for Uniqueness INT4 10
CALLERFLAG ✔ Who Has Called this Program CHAR 1
DBMSTRTTME DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
PRGVERS Version of Program Inserted this Row CHAR 20
NUM_EXECUT num_executions: Number of Executions DEC 22
NUM_COMPIL num_compilations: Number of Compilations DEC 22
PREPTWORST prep_time_worst: Worst Preparation Time (ms) DEC 22
PREPTBEST prep_time_best: Best Preparation Time (ms) DEC 22
INT_RW_DEL int_rows_deleted: Rows Deleted DEC 22
INT_RW_INS int_rows_inserted: Rows Inserted DEC 22
RW_READ rows_read: Rows Read DEC 22
INT_RW_UPD int_rows_updated: Rows Updated DEC 22
RW_WRITTEN rows_written: Rows Written DEC 22
STMT_SORTS stmt_sorts: Statement Sorts DEC 22
TOTEXETS total_exec_time_s: Total Execution Time (sec) DEC 22
TOTEXETMS total_exec_time_ms: Total Execution Time (ms) DEC 22
TOTUSRCTS tot_u_cpu_time_s: Total User CPU Time (sec) DEC 22
TOTUSRCTMS tot_u_cpu_time_ms: Total User CPU Time (ms) DEC 22
TOTSYSCTS tot_s_cpu_time_s: Total System CPU Time (sec) DEC 22
TOTSYSCTMS tot_s_cpu_time_ms: Total System CPU Time (ms) DEC 22
DB_NAME DB6: General identifier DB6IDENT CHAR 20
PL_D_LRS pool_data_l_reads DEC 22
PL_D_PRS pool_data_p_reads DEC 22
PL_I_LRS pool_index_l_reads DEC 22
PL_I_PRS pool_index_p_reads DEC 22
PL_TD_LRS pool_temp_data_l_reads DEC 22
PL_TD_PRS pool_temp_data_p_reads DEC 22
PL_TI_LRS pool_temp_index_l_reads DEC 22
PL_TI_PRS pool_temp_index_p_reads DEC 22
SORT_OVERFLOWS sort_overflows DEC 22
TOTAL_SORT_TIME total_sort_time DEC 22
PL_XDA_LRS pool_xda_l_reads DEC 22
PL_XDA_PRS pool_xda_p_reads DEC 22
PL_TEMP_XDA_LRS pool_temp_xda_l_reads DEC 22
PL_TEMP_XDA_PRS pool_temp_Xda_p_reads DEC 22
STATS_FABRICATE_TIME DEC 22
SYNC_RUNSTATS_TIME DEC 22
ROWS_RETURNED DEC 22
STMT_PKGCACHE_ID DEC 22
INSERT_TIMESTAMP DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
STMT_LEN stmt_txtln: Length Field of LCHR stmt_txt INT4 10
STMT_TEXT stmt_text: SQL Statement STRI 0