SAP SQLMSHCD table - SQL Monitor: Data / Request details in SAP


SAP SQLMSHCD table summary

Object Name: SQLMSHCD
Dictionary Type: Transparent table
Description: SQL Monitor: Data / Request


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

Details
SQLMSHCD-SNAPSHOTID table field - SQL Monitor: Snapshot ID

Description: SQL Monitor: Snapshot ID
Field Name: SNAPSHOTID
Data Element: SQLMSNAPSHOTID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAPSHOTID

SQLMSHCD-PROGNAME table field - ABAP Program Name

Description: ABAP Program Name
Field Name: PROGNAME
Data Element: PROGNAME
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: PROGNAME
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROGNAME

SQLMSHCD-PROGKIND table field - SQL Monitor: Program Kind

Description: SQL Monitor: Program Kind
Field Name: PROGKIND
Data Element: SQLMPROGKIND
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: SQLMPROGKIND
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROGKIND

SQLMSHCD-PROCTYPE table field - SQL Monitor: Processing Block Type

Description: SQL Monitor: Processing Block Type
Field Name: PROCTYPE
Data Element: SQLMPROCTYPE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROCTYPE

SQLMSHCD-PROCNAME table field - SQL Monitor: Processing Block Name

Description: SQL Monitor: Processing Block Name
Field Name: PROCNAME
Data Element: SQLMPROCNAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROCNAME

SQLMSHCD-PROCLINE table field - SQL Monitor: Line Number in Processing Block

Description: SQL Monitor: Line Number in Processing Block
Field Name: PROCLINE
Data Element: SQLMPROCLINE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROCLINE

SQLMSHCD-HASHCODE table field - SQL Monitor: Source Hash Code

Description: SQL Monitor: Source Hash Code
Field Name: HASHCODE
Data Element: SQLMHASHCODE
Data Type: RAW
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: SQLMCRC64
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HASHCODE

SQLMSHCD-RUNLEVEL table field - SQL Monitor: Run Mode

Description: SQL Monitor: Run Mode
Field Name: RUNLEVEL
Data Element: SQLMRUNLEVEL
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: SQLMRUNLEVEL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RUNLEVEL

SQLMSHCD-ROOTTYPE table field - SQL Monitor: Request Type

Description: SQL Monitor: Request Type
Field Name: ROOTTYPE
Data Element: SQLMROOTTYPE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: SQLMROOTTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROOTTYPE

SQLMSHCD-ROOTNAME table field - SQL Monitor: Request Entry Point (Transaction, etc.)

Description: SQL Monitor: Request Entry Point (Transaction, etc.)
Field Name: ROOTNAME
Data Element: SQLMROOTNAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROOTNAME

SQLMSHCD-STMTKIND table field - SQL Monitor: SQL Operation

Description: SQL Monitor: SQL Operation
Field Name: STMTKIND
Data Element: SQLMSTMTKIND
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: SQLMSTMTKIND
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMTKIND

SQLMSHCD-TABLENAME table field - SQL Monitor: Table Name

Description: SQL Monitor: Table Name
Field Name: TABLENAME
Data Element: SQLMTABLENAME
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: DBOBJ_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLENAME

SQLMSHCD-XCNT table field - SQL Monitor: Total Number of Executions

Description: SQL Monitor: Total Number of Executions
Field Name: XCNT
Data Element: SQLMEXECNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field XCNT

SQLMSHCD-RCNT table field - SQL Monitor: Internal Sessions Affected

Description: SQL Monitor: Internal Sessions Affected
Field Name: RCNT
Data Element: SQLMROLLAREACNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RCNT

SQLMSHCD-XCNTRCNT table field - SQL Monitor: Executions per Internal Sessions

Description: SQL Monitor: Executions per Internal Sessions
Field Name: XCNTRCNT
Data Element: SQLMEXECNTROLLAREACNT
Data Type: DEC
length (Dec): 31(3)
Check table:
Conversion Routine:
Domain Name: SQLMDECIMAL3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field XCNTRCNT

SQLMSHCD-RTMIN table field - SQL Monitor: Minimum Value of SQL Execution Time

Description: SQL Monitor: Minimum Value of SQL Execution Time
Field Name: RTMIN
Data Element: SQLMRUNTIMEMIN
Data Type: DEC
length (Dec): 31(3)
Check table:
Conversion Routine:
Domain Name: SQLMRUNTIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTMIN

SQLMSHCD-RTMAX table field - SQL Monitor: Maximum Value of Database Execution Time

Description: SQL Monitor: Maximum Value of Database Execution Time
Field Name: RTMAX
Data Element: SQLMRUNTIMEMAX
Data Type: DEC
length (Dec): 31(3)
Check table:
Conversion Routine:
Domain Name: SQLMRUNTIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTMAX

SQLMSHCD-RTCNT table field - SQL Monitor: Count

Description: SQL Monitor: Count
Field Name: RTCNT
Data Element: SQLMRUNTIMECNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTCNT

SQLMSHCD-RTSUM table field - SQL Monitor: Summarized Database Execution Time [ms]

Description: SQL Monitor: Summarized Database Execution Time [ms]
Field Name: RTSUM
Data Element: SQLMRUNTIMESUM
Data Type: DEC
length (Dec): 31(3)
Check table:
Conversion Routine:
Domain Name: SQLMRUNTIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTSUM

SQLMSHCD-RTSQS table field - SQL Monitor: Runtime Sum of Squares

Description: SQL Monitor: Runtime Sum of Squares
Field Name: RTSQS
Data Element: SQLMRUNTIMESQS
Data Type: DEC
length (Dec): 31(6)
Check table:
Conversion Routine:
Domain Name: SQLMDECIMAL6
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTSQS

SQLMSHCD-RTAVG table field - SQL Monitor: Mean Value of DB Execution Time

Description: SQL Monitor: Mean Value of DB Execution Time
Field Name: RTAVG
Data Element: SQLMRUNTIMEAVG
Data Type: DEC
length (Dec): 31(3)
Check table:
Conversion Routine:
Domain Name: SQLMRUNTIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTAVG

SQLMSHCD-RTDEV table field - SQL Monitor: Standard Deviation of Database Execution Time

Description: SQL Monitor: Standard Deviation of Database Execution Time
Field Name: RTDEV
Data Element: SQLMRUNTIMEDEV
Data Type: DEC
length (Dec): 31(3)
Check table:
Conversion Routine:
Domain Name: SQLMRUNTIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTDEV

SQLMSHCD-DBMIN table field - SQL Monitor: Minimum Value of Processed Records

Description: SQL Monitor: Minimum Value of Processed Records
Field Name: DBMIN
Data Element: SQLMDBCOUNTMIN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBMIN

SQLMSHCD-DBMAX table field - SQL Monitor: Maximum Value of Processed Records

Description: SQL Monitor: Maximum Value of Processed Records
Field Name: DBMAX
Data Element: SQLMDBCOUNTMAX
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBMAX

SQLMSHCD-DBCNT table field - SQL Monitor: DB Count Count

Description: SQL Monitor: DB Count Count
Field Name: DBCNT
Data Element: SQLMDBCOUNTCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBCNT

SQLMSHCD-DBSUM table field - SQL Monitor: Total Processed Records

Description: SQL Monitor: Total Processed Records
Field Name: DBSUM
Data Element: SQLMDBCOUNTSUM
Data Type: DEC
length (Dec): 31(0)
Check table:
Conversion Routine:
Domain Name: SQLMINTEGER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBSUM

SQLMSHCD-DBSQS table field - SQL Monitor: DB Count Sum of Squares

Description: SQL Monitor: DB Count Sum of Squares
Field Name: DBSQS
Data Element: SQLMDBCOUNTSQS
Data Type: DEC
length (Dec): 31(0)
Check table:
Conversion Routine:
Domain Name: SQLMINTEGER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBSQS

SQLMSHCD-DBAVG table field - SQL Monitor: Mean Value of Processed Records

Description: SQL Monitor: Mean Value of Processed Records
Field Name: DBAVG
Data Element: SQLMDBCOUNTAVG
Data Type: DEC
length (Dec): 31(3)
Check table:
Conversion Routine:
Domain Name: SQLMDECIMAL3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBAVG

SQLMSHCD-DBDEV table field - SQL Monitor: Standard Deviation of Processed Records

Description: SQL Monitor: Standard Deviation of Processed Records
Field Name: DBDEV
Data Element: SQLMDBCOUNTDEV
Data Type: DEC
length (Dec): 31(3)
Check table:
Conversion Routine:
Domain Name: SQLMDECIMAL3
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBDEV

SQLMSHCD-DDATE table field - Date for Runtime Monitor DATA entry

Description: Date for Runtime Monitor DATA entry
Field Name: DDATE
Data Element: RTMDDATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: SYDATS
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DDATE

SQLMSHCD-DTIME table field - Time for Runtime Monitor data entry

Description: Time for Runtime Monitor data entry
Field Name: DTIME
Data Element: D_TIME
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: SYTIME
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DTIME

SQLMSHCD-RTMCNT table field - SQL Monitor: RTM Count

Description: SQL Monitor: RTM Count
Field Name: RTMCNT
Data Element: SQLMRTMCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTMCNT


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table