SAP MSS_REQHIST table - SQL request history details in SAP


SAP MSS_REQHIST table summary

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


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table