SAP MSS_REQHIST table - SQL request history details in SAP

SAP MSS_REQHIST table summary

Warning: Undefined array key "id" in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 101

Object Name: MSS_REQHIST
Dictionary Type: Structure
Description: SQL request history

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

Details

MSS_REQHIST-SRH_ID table field - Unique ID of a set of collected expensive SQL Statements ▼

Description: Unique ID of a set of collected expensive SQL Statements
Field Name: SRH_ID
Data Element: MSSSTMTHCOLLID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SRH_ID

MSS_REQHIST-COLLDT table field - Date when SQL Statement statistics were saved ▼

Description: Date when SQL Statement statistics were saved
Field Name: COLLDT
Data Element: MSSSTMTHDT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COLLDT

MSS_REQHIST-COLLTM table field - Time when SQL Statement statistics were saved ▼

Description: Time when SQL Statement statistics were saved
Field Name: COLLTM
Data Element: MSSSTMTHTM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COLLTM

MSS_REQHIST-SESSID table field - Session ID for SQL Server ▼

Description: Session ID for SQL Server
Field Name: SESSID
Data Element: MSSSESSIONID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: MSSINT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESSID

MSS_REQHIST-HOSTNM table field - Hostname of the application server logged into SQL Server. ▼

Description: Hostname of the application server logged into SQL Server.
Field Name: HOSTNM
Data Element: MSQHOSTNE
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 HOSTNM

MSS_REQHIST-PROGNM table field - Name of the application program which owns the connection. ▼

Description: Name of the application program which owns the connection.
Field Name: PROGNM
Data Element: MSQAPPPROG
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROGNM

MSS_REQHIST-STRTDT table field - Date when the statement started ▼

Description: Date when the statement started
Field Name: STRTDT
Data Element: MSSSTRTDT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STRTDT

MSS_REQHIST-STRTTM table field - Time when request started ▼

Description: Time when request started
Field Name: STRTTM
Data Element: MSSSTRTTM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STRTTM

MSS_REQHIST-SQLTXT table field - First 50 characters of a SQL Server statement ▼

Description: First 50 characters of a SQL Server statement
Field Name: SQLTXT
Data Element: MSSPARTIALSQL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLTXT

MSS_REQHIST-CMD table field - MS SQL Server command ▼

Description: MS SQL Server command
Field Name: CMD
Data Element: MSSCOMMAND
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: TEXT16
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CMD

MSS_REQHIST-BLKSESS table field - Blocking session ID for SQL Server ▼

Description: Blocking session ID for SQL Server
Field Name: BLKSESS
Data Element: MSSBLKSESSIONID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLKSESS

MSS_REQHIST-WAITTYP table field - wait type from sys.dm_os_wait_stats ▼

Description: wait type from sys.dm_os_wait_stats
Field Name: WAITTYP
Data Element: MSSWAITTYPE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITTYP

MSS_REQHIST-WAITRES table field - Name of the locked resource the process is waiting for. ▼

Description: Name of the locked resource the process is waiting for.
Field Name: WAITRES
Data Element: MSQSAPWAIT
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: CHAR255
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITRES

MSS_REQHIST-WAITTIME table field - Current wait time of the process in milliseconds ▼

Description: Current wait time of the process in milliseconds
Field Name: WAITTIME
Data Element: MSSWAITTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITTIME

MSS_REQHIST-CPUTIME table field - CPU time for a request ▼

Description: CPU time for a request
Field Name: CPUTIME
Data Element: MSSREQCPUTIME
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 CPUTIME

MSS_REQHIST-TTL_ELAPSED table field - Total elapsed time in milliseconds ▼

Description: Total elapsed time in milliseconds
Field Name: TTL_ELAPSED
Data Element: MSSELAPSEDMS
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 TTL_ELAPSED

MSS_REQHIST-SQLCPUPCT table field - SQL Server CPU utilization ▼

Description: SQL Server CPU utilization
Field Name: SQLCPUPCT
Data Element: MSSSQLCPUPCT
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 SQLCPUPCT

MSS_REQHIST-DWRITMSIO table field - Data file ms per write IO ▼

Description: Data file ms per write IO
Field Name: DWRITMSIO
Data Element: MSSDWRITMSIO
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DWRITMSIO

MSS_REQHIST-LWRITMSIO table field - Log file ms per write IO ▼

Description: Log file ms per write IO
Field Name: LWRITMSIO
Data Element: MSSLWRITMSIO
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LWRITMSIO

MSS_REQHIST-DREADMSIO table field - Data file ms per read IO ▼

Description: Data file ms per read IO
Field Name: DREADMSIO
Data Element: MSSDREADMSIO
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DREADMSIO

MSS_REQHIST-LREADMSIO table field - Log file ms per read IO ▼

Description: Log file ms per read IO
Field Name: LREADMSIO
Data Element: MSSLREADMSIO
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LREADMSIO

MSS_REQHIST-OBJ_NAME table field - MS SQL Server object name ▼

Description: MS SQL Server object name
Field Name: OBJ_NAME
Data Element: MSSOBJNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJ_NAME

MSS_REQHIST-ABAP_NAME table field - Name of the ABAP report ▼

Description: Name of the ABAP report
Field Name: ABAP_NAME
Data Element: MSSABNAME
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 ABAP_NAME

MSS_REQHIST-ABAP_LOC table field - Offset of a Processing Control Block ▼

Description: Offset of a Processing Control Block
Field Name: ABAP_LOC
Data Element: ABP_CONT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ABAP_LOC

Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 234 Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 278 Warning: Undefined variable $obj1 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj2 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj3 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj4 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj5 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj6 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj7 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj8 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj9 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj10 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj11 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279

View list of all SAP tables(S4H/ECC)

Select data from SAP table