SAP SQLMRECORDBYROOT table - SQL Monitor: Data Record Aggregated By Root details in SAP


SAP SQLMRECORDBYROOT table summary

Object Name: SQLMRECORDBYROOT
Dictionary Type: Structure
Description: SQL Monitor: Data Record Aggregated By Root


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

Details
SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-TABLENAMES table field - SQL Monitor: Table Names

Description: SQL Monitor: Table Names
Field Name: TABLENAMES
Data Element: SQLMTABLENAMES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLENAMES

SQLMRECORDBYROOT-INCLUDE table field - ABAP Program Name

Description: ABAP Program Name
Field Name: INCLUDE
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 INCLUDE

SQLMRECORDBYROOT-LINE table field - 4 Byte Signed Integer

Description: 4 Byte Signed Integer
Field Name: LINE
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 LINE

SQLMRECORDBYROOT-FRAGMENT table field - SQL Monitor: Source Code Fragment

Description: SQL Monitor: Source Code Fragment
Field Name: FRAGMENT
Data Element: SQLMFRAGMENT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FRAGMENT

SQLMRECORDBYROOT-PGMID table field - Program ID in Requests and Tasks

Description: Program ID in Requests and Tasks
Field Name: PGMID
Data Element: PGMID
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: PGMID
MemoryID:
AppClass: STRW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PGMID

SQLMRECORDBYROOT-OBJECT table field - Object Type

Description: Object Type
Field Name: OBJECT
Data Element: TROBJTYPE
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: OBJECT
MemoryID:
AppClass: STRW
SHLP: SCTSOBJECT
SHLP Field: OBJECT
ConvExit:

See all SAP tables containing field OBJECT

SQLMRECORDBYROOT-OBJ_NAME table field - Object Name in Object Directory

Description: Object Name in Object Directory
Field Name: OBJ_NAME
Data Element: SOBJ_NAME
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: SOBJ_NAME
MemoryID:
AppClass: STRW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJ_NAME

SQLMRECORDBYROOT-DEVCLASS table field - Package

Description: Package
Field Name: DEVCLASS
Data Element: DEVCLASS
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: DEVCLASS
MemoryID: DVC
AppClass: STRW
SHLP: DEVCLASS
SHLP Field: DEVCLASS
ConvExit:

See all SAP tables containing field DEVCLASS

SQLMRECORDBYROOT-PROGDATE table field - SQL Monitor: Program Date

Description: SQL Monitor: Program Date
Field Name: PROGDATE
Data Element: SQLMPROGDATE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROGDATE

SQLMRECORDBYROOT-PROGTIME table field - SQL Monitor: Program Time

Description: SQL Monitor: Program Time
Field Name: PROGTIME
Data Element: SQLMPROGTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROGTIME

SQLMRECORDBYROOT-OUTDATED table field - SQL Monitor: Outdated

Description: SQL Monitor: Outdated
Field Name: OUTDATED
Data Element: SQLMOUTDATED
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OUTDATED

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

Description: SQL Monitor: Total Number of Executions
Field Name: XCNT
Data Element: SQLMZEXECNT
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 XCNT

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

Description: SQL Monitor: Internal Sessions Affected
Field Name: RCNT
Data Element: SQLMZROLLAREACNT
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 RCNT

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-RTCNT table field - SQL Monitor: Total Number of Executions

Description: SQL Monitor: Total Number of Executions
Field Name: RTCNT
Data Element: SQLMZEXECNT
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 RTCNT

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

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

Description: SQL Monitor: Minimum Value of Processed Records
Field Name: DBMIN
Data Element: SQLMZDBCOUNTMIN
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 DBMIN

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

Description: SQL Monitor: Maximum Value of Processed Records
Field Name: DBMAX
Data Element: SQLMZDBCOUNTMAX
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 DBMAX

SQLMRECORDBYROOT-DBCNT table field - SQL Monitor: Total Number of Executions

Description: SQL Monitor: Total Number of Executions
Field Name: DBCNT
Data Element: SQLMZEXECNT
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 DBCNT

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-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

SQLMRECORDBYROOT-WPTIMESUM table field - SQL Monitor: Total Time in Workprocesses [ms]

Description: SQL Monitor: Total Time in Workprocesses [ms]
Field Name: WPTIMESUM
Data Element: SQLMREQWPTIMESUM
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 WPTIMESUM

SQLMRECORDBYROOT-DBTIMESUM table field - SQL Monitor: Total Database Execution Time [ms]

Description: SQL Monitor: Total Database Execution Time [ms]
Field Name: DBTIMESUM
Data Element: SQLMREQDBTIMESUM
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 DBTIMESUM

SQLMRECORDBYROOT-ROLLAREACNT table field - SQL Monitor: Number of Internal Sessions

Description: SQL Monitor: Number of Internal Sessions
Field Name: ROLLAREACNT
Data Element: SQLMZREQROLLAREACNT
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 ROLLAREACNT

SQLMRECORDBYROOT-CNT table field - 4 Byte Signed Integer

Description: 4 Byte Signed Integer
Field Name: CNT
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 CNT


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table