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

SAP Table DB6PMSQ

DB6: Snapshot SQL Cache

Unsere Literaturempfehlung

IDoc-Entwicklung für SAP: Customizing, Erweiterung, Eigenentwicklung

Wenn der Standard nicht ausreicht: Mit diesem Buch lernen Sie, IDocs selbstständig zu programmieren und zu erweitern. Die Autorin beschreibt Customizing-Techniken, die Erweiterung der Standardbausteine und komplette Eigenentwicklungen. Ob Rückmeldungen von Statuswerten, E-Mail-Workflows oder Serialisierung – für alle Aufgaben finden Sie Anleitungen und Tipps aus der Programmierpraxis. Neu in dieser Auflage: Überwachung und Fehlerbehandlung mit dem SAP Application Interface Framework.

Bei amazon.de ansehen →

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