SAP DB2TOPSTMTS table - Structure for DB2 Subsystem Summary (Top SQL Stmts) details in SAP

SAP DB2TOPSTMTS table summary

Object Name: DB2TOPSTMTS
Dictionary Type: Structure
Description: Structure for DB2 Subsystem Summary (Top SQL Stmts)

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

Details

DB2TOPSTMTS-QW0316TD table field - Name of the table referenced in the statement ▼

Description: Name of the table referenced in the statement
Field Name: QW0316TD
Data Element: DB2QW316TD
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QW0316TD

DB2TOPSTMTS-RRSAFPGM table field - Program name ▼

Description: Program name
Field Name: RRSAFPGM
Data Element: DB2QW316T1
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RRSAFPGM

DB2TOPSTMTS-RAETOEXECS table field - Average elapsed time ▼

Description: Average elapsed time
Field Name: RAETOEXECS
Data Element: DB2RAETOEXECS
Data Type: DEC
length (Dec): 19(6)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V6
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RAETOEXECS

DB2TOPSTMTS-RAETOROWS table field - Average elapsed time / row ▼

Description: Average elapsed time / row
Field Name: RAETOROWS
Data Element: DB2RAETOROWS
Data Type: DEC
length (Dec): 19(6)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V6
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RAETOROWS

DB2TOPSTMTS-AVGCPU table field - Average CPU time ▼

Description: Average CPU time
Field Name: AVGCPU
Data Element: DB2AVGCT
Data Type: DEC
length (Dec): 19(6)
Check table:
Conversion Routine:
Domain Name: DB2DEC19V6
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVGCPU

DB2TOPSTMTS-AVGTIMWAITIO table field - Type to summarize dec 19 with 6 decimal places ▼

Description: Type to summarize dec 19 with 6 decimal places
Field Name: AVGTIMWAITIO
Data Element: DB2AVGTIMEWAIT
Data Type: DEC
length (Dec): 20(6)
Check table:
Conversion Routine:
Domain Name: DB2DEC20V6
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVGTIMWAITIO

DB2TOPSTMTS-RETOPROW table field - Examined/processed Rows (Only data rows are taken into acc.) ▼

Description: Examined/processed Rows (Only data rows are taken into acc.)
Field Name: RETOPROW
Data Element: DB2RETOPROW
Data Type: DEC
length (Dec): 21(2)
Check table:
Conversion Routine:
Domain Name: DB2DEC21V2
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RETOPROW

DB2TOPSTMTS-QSTCSTMT table field - Statement text ▼

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

See all SAP tables containing field QSTCSTMT

DB2TOPSTMTS-QSTCSTNM table field - DB2 statement name ▼

Description: DB2 statement name
Field Name: QSTCSTNM
Data Element: DB2QSTSTNM
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: DB2RAW16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCSTNM

DB2TOPSTMTS-QSTCTOKN table field - Statement ID ▼

Description: Statement ID
Field Name: QSTCTOKN
Data Element: DB2QSTTOKN
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2INT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QSTCTOKN

DB2TOPSTMTS-QSTCAET table field - Time elapsed ▼

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

See all SAP tables containing field QSTCAET

View list of all SAP tables(S4H/ECC)

Select data from SAP table