SAP SDBCMDSTAT table - SAP DB: sysinfo.commandstatistics (Command Stats Shared SQL) details in SAP

SAP SDBCMDSTAT table summary

Object Name: SDBCMDSTAT
Dictionary Type: Structure
Description: SAP DB: sysinfo.commandstatistics (Command Stats Shared SQL)

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

Details

SDBCMDSTAT-COMMANDID table field - SAP DB: Syskey ▼

Description: SAP DB: Syskey
Field Name: COMMANDID
Data Element: ADA_SYSK
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: CHAR16
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMANDID

SDBCMDSTAT-INTERNAL table field - 3-Byte field ▼

Description: 3-Byte field
Field Name: INTERNAL
Data Element: CHAR3
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: CHAR3
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INTERNAL

SDBCMDSTAT-HASHVALUE table field - 4 Byte Signed Integer ▼

Description: 4 Byte Signed Integer
Field Name: HASHVALUE
Data Element: INT4
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HASHVALUE

SDBCMDSTAT-HASHTBSLOT table field - 4 Byte Signed Integer ▼

Description: 4 Byte Signed Integer
Field Name: HASHTBSLOT
Data Element: INT4
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HASHTBSLOT

SDBCMDSTAT-STATUS table field - Character Field with Length 10 ▼

Description: Character Field with Length 10
Field Name: STATUS
Data Element: CHAR10
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

SDBCMDSTAT-USERNAME table field - SAP DB: DBUser name ▼

Description: SAP DB: DBUser name
Field Name: USERNAME
Data Element: SDB_DBUSER
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: SDB_DBUSER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERNAME

SDBCMDSTAT-SCHEMANAME table field - SAP DB: DBUser name ▼

Description: SAP DB: DBUser name
Field Name: SCHEMANAME
Data Element: SDB_DBUSER
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: SDB_DBUSER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCHEMANAME

SDBCMDSTAT-SQLMODE table field - Character Field with Length 10 ▼

Description: Character Field with Length 10
Field Name: SQLMODE
Data Element: CHAR10
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLMODE

SDBCMDSTAT-ISOLEVEL table field - 2 Byte Signed Integer ▼

Description: 2 Byte Signed Integer
Field Name: ISOLEVEL
Data Element: INT2
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISOLEVEL

SDBCMDSTAT-DATEFORMAT table field - Char 15 ▼

Description: Char 15
Field Name: DATEFORMAT
Data Element: CHAR15
Data Type: CHAR
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: CHAR15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATEFORMAT

SDBCMDSTAT-MASSCMD table field - 3-Byte field ▼

Description: 3-Byte field
Field Name: MASSCMD
Data Element: CHAR3
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: CHAR3
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MASSCMD

SDBCMDSTAT-CODETYPE table field - Char 20 ▼

Description: Char 20
Field Name: CODETYPE
Data Element: CHAR20
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CODETYPE

SDBCMDSTAT-STMNTSIZE table field - 4 Byte Signed Integer ▼

Description: 4 Byte Signed Integer
Field Name: STMNTSIZE
Data Element: INT4
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMNTSIZE

SDBCMDSTAT-S_SQLSTMNT table field - SAP DB: Start of SQL command ▼

Description: SAP DB: Start of SQL command
Field Name: S_SQLSTMNT
Data Element: ADA_SSTMT
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: CHAR80
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field S_SQLSTMNT

SDBCMDSTAT-PLANSIZE table field - 4 Byte Signed Integer ▼

Description: 4 Byte Signed Integer
Field Name: PLANSIZE
Data Element: INT4
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLANSIZE

SDBCMDSTAT-PREPCOUNT table field - SYSDBA.MONITOR.VALUE ▼

Description: SYSDBA.MONITOR.VALUE
Field Name: PREPCOUNT
Data Element: ADA_VALUE
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DEC20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PREPCOUNT

SDBCMDSTAT-REFCOUNT table field - SYSDBA.MONITOR.VALUE ▼

Description: SYSDBA.MONITOR.VALUE
Field Name: REFCOUNT
Data Element: ADA_VALUE
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DEC20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REFCOUNT

SDBCMDSTAT-CUREXECCNT table field - 4 Byte Signed Integer ▼

Description: 4 Byte Signed Integer
Field Name: CUREXECCNT
Data Element: INT4
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CUREXECCNT

SDBCMDSTAT-EXEC_COUNT table field - SAP DB: Counter for command calls ▼

Description: SAP DB: Counter for command calls
Field Name: EXEC_COUNT
Data Element: ADA_CCNT
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DEC20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXEC_COUNT

SDBCMDSTAT-PREP_TIME table field - SAP DB: SQL command runtime in seconds ▼

Description: SAP DB: SQL command runtime in seconds
Field Name: PREP_TIME
Data Element: ADA_RTIM
Data Type: DEC
length (Dec): 20(3)
Check table:
Conversion Routine:
Domain Name: DEC20_3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PREP_TIME

SDBCMDSTAT-EXEC_TIME table field - SAP DB: SQL command runtime in seconds ▼

Description: SAP DB: SQL command runtime in seconds
Field Name: EXEC_TIME
Data Element: ADA_RTIM
Data Type: DEC
length (Dec): 20(3)
Check table:
Conversion Routine:
Domain Name: DEC20_3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXEC_TIME

SDBCMDSTAT-AVGEXECTIM table field - SAP DB: SQL command runtime in seconds ▼

Description: SAP DB: SQL command runtime in seconds
Field Name: AVGEXECTIM
Data Element: ADA_RTIM
Data Type: DEC
length (Dec): 20(3)
Check table:
Conversion Routine:
Domain Name: DEC20_3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVGEXECTIM

SDBCMDSTAT-MINEXECTIM table field - SAP DB: SQL command runtime in seconds ▼

Description: SAP DB: SQL command runtime in seconds
Field Name: MINEXECTIM
Data Element: ADA_RTIM
Data Type: DEC
length (Dec): 20(3)
Check table:
Conversion Routine:
Domain Name: DEC20_3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MINEXECTIM

SDBCMDSTAT-MAXEXECTIM table field - SAP DB: SQL command runtime in seconds ▼

Description: SAP DB: SQL command runtime in seconds
Field Name: MAXEXECTIM
Data Element: ADA_RTIM
Data Type: DEC
length (Dec): 20(3)
Check table:
Conversion Routine:
Domain Name: DEC20_3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAXEXECTIM

SDBCMDSTAT-ROWS_READ table field - SAP DB: Counter for rows read ▼

Description: SAP DB: Counter for rows read
Field Name: ROWS_READ
Data Element: ADA_READ
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DEC20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWS_READ

SDBCMDSTAT-ROWS_QUAL table field - SAP DB: Counter for qualified rows ▼

Description: SAP DB: Counter for qualified rows
Field Name: ROWS_QUAL
Data Element: ADA_QUAL
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DEC20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROWS_QUAL

SDBCMDSTAT-VIRTUAL_R table field - SAP DB: Counter for virtual reads ▼

Description: SAP DB: Counter for virtual reads
Field Name: VIRTUAL_R
Data Element: ADA_VRDS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DEC20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VIRTUAL_R

SDBCMDSTAT-PHYS_READ table field - SAP DB: Counter for physical I/O access ▼

Description: SAP DB: Counter for physical I/O access
Field Name: PHYS_READ
Data Element: ADA_PHIO
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DEC20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PHYS_READ

SDBCMDSTAT-R_FETCHED table field - SAP DB: Counter for 'gotten' rows ▼

Description: SAP DB: Counter for 'gotten' rows
Field Name: R_FETCHED
Data Element: ADA_RFET
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DEC20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field R_FETCHED

SDBCMDSTAT-VSUSPENDS table field - SAP DB: Counter for task suspensions ▼

Description: SAP DB: Counter for task suspensions
Field Name: VSUSPENDS
Data Element: ADA_VSUS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DEC20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VSUSPENDS

SDBCMDSTAT-VWAITS table field - SAP DB: Counter for SQL waits ▼

Description: SAP DB: Counter for SQL waits
Field Name: VWAITS
Data Element: ADA_VWAI
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DEC20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VWAITS

SDBCMDSTAT-RQ_PEREXEC table field - SAP DB: Qualified rows per execution ▼

Description: SAP DB: Qualified rows per execution
Field Name: RQ_PEREXEC
Data Element: ADA_RQPE
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DEC20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RQ_PEREXEC

SDBCMDSTAT-VR_PEREXEC table field - SAP DB: Number of page accesses per execution ▼

Description: SAP DB: Number of page accesses per execution
Field Name: VR_PEREXEC
Data Element: ADA_VRPE
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DEC20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VR_PEREXEC

SDBCMDSTAT-VR_PERLINE table field - SAP DB: Number of page accesses per row ▼

Description: SAP DB: Number of page accesses per row
Field Name: VR_PERLINE
Data Element: ADA_VRPL
Data Type: DEC
length (Dec): 20(2)
Check table:
Conversion Routine:
Domain Name: DEC20_2
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VR_PERLINE

SDBCMDSTAT-TABNAME table field - SDB Table Name ▼

Description: SDB Table Name
Field Name: TABNAME
Data Element: ADATABNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABNAME

SDBCMDSTAT-OPERATION table field - SAP DB: SQL operation ▼

Description: SAP DB: SQL operation
Field Name: OPERATION
Data Element: ADA_OP
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPERATION

SDBCMDSTAT-TOTAL_IO table field - SYSDBA.MONITOR.VALUE ▼

Description: SYSDBA.MONITOR.VALUE
Field Name: TOTAL_IO
Data Element: ADA_VALUE
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DEC20
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTAL_IO

View list of all SAP tables(S4H/ECC)

Select data from SAP table