SAP MSS_ACTIVE_REQUEST table - Active SQL Server requests with their connections & sessions details in SAP


SAP MSS_ACTIVE_REQUEST table summary

Object Name: MSS_ACTIVE_REQUEST
Dictionary Type: Structure
Description: Active SQL Server requests with their connections & sessions


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

Details
MSS_ACTIVE_REQUEST-SESSIONID table field - Session ID for SQL Server

Description: Session ID for SQL Server
Field Name: SESSIONID
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 SESSIONID

MSS_ACTIVE_REQUEST-LOGINTIME table field - The time at which client process logged into SQL Server.

Description: The time at which client process logged into SQL Server.
Field Name: LOGINTIME
Data Element: MSQPRLGTME
Data Type: CHAR
length (Dec): 24(0)
Check table:
Conversion Routine:
Domain Name: CHAR24
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGINTIME

MSS_ACTIVE_REQUEST-HOSTNAME table field - Hostname of the application server logged into SQL Server.

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

MSS_ACTIVE_REQUEST-PROGNAME table field - Name of the application program which owns the connection.

Description: Name of the application program which owns the connection.
Field Name: PROGNAME
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 PROGNAME

MSS_ACTIVE_REQUEST-HOSTPID table field - Process ID on app. server

Description: Process ID on app. server
Field Name: HOSTPID
Data Element: MSSHPID
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 HOSTPID

MSS_ACTIVE_REQUEST-CLIENTINFVER table field - MSS Session client interface name

Description: MSS Session client interface name
Field Name: CLIENTINFVER
Data Element: MSSSESSINTFVER
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENTINFVER

MSS_ACTIVE_REQUEST-CLIENTINFNAME table field - MSS Session client interface name

Description: MSS Session client interface name
Field Name: CLIENTINFNAME
Data Element: MSSSESSINTFNAME
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: CHAR64
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENTINFNAME

MSS_ACTIVE_REQUEST-LOGINNAME table field - The user name used to log into the SQL Server database

Description: The user name used to log into the SQL Server database
Field Name: LOGINNAME
Data Element: MSQUSRNAME
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 LOGINNAME

MSS_ACTIVE_REQUEST-NTDOMAIN table field - NT domain for the client connected to SQL Server.

Description: NT domain for the client connected to SQL Server.
Field Name: NTDOMAIN
Data Element: MSQNTDOMA
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 NTDOMAIN

MSS_ACTIVE_REQUEST-NTUNAME table field - Windows NT user name for the process connected to SQL Server

Description: Windows NT user name for the process connected to SQL Server
Field Name: NTUNAME
Data Element: MSQNTUNAME
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 NTUNAME

MSS_ACTIVE_REQUEST-CPUTIME table field - CPU time for a SQL session (ms)

Description: CPU time for a SQL session (ms)
Field Name: CPUTIME
Data Element: MSSSESCPUTIME
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_ACTIVE_REQUEST-MEMUSAGE table field - The pages allocated by the SQL process in procedure cache.

Description: The pages allocated by the SQL process in procedure cache.
Field Name: MEMUSAGE
Data Element: MSQPRMEMUS
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 MEMUSAGE

MSS_ACTIVE_REQUEST-TTLSCHEDTIME table field - SQL Server session scheduled time

Description: SQL Server session scheduled time
Field Name: TTLSCHEDTIME
Data Element: MSSESSCHTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TTLSCHEDTIME

MSS_ACTIVE_REQUEST-TTLELAPSEDTIME table field - SQL Server session elapsed time

Description: SQL Server session elapsed time
Field Name: TTLELAPSEDTIME
Data Element: MSSESSELPTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TTLELAPSEDTIME

MSS_ACTIVE_REQUEST-SESS_NUMREADS table field - number of reads performed in a session

Description: number of reads performed in a session
Field Name: SESS_NUMREADS
Data Element: MSSSESNUMREADS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_NUMREADS

MSS_ACTIVE_REQUEST-SESS_NUMWRITES table field - Number of writes performed in a session

Description: Number of writes performed in a session
Field Name: SESS_NUMWRITES
Data Element: MSSSESNUMWRITES
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_NUMWRITES

MSS_ACTIVE_REQUEST-SESS_NUMLOGICALREADS table field - number of reads performed by a session

Description: number of reads performed by a session
Field Name: SESS_NUMLOGICALREADS
Data Element: MSSSESNUMLOGRDS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_NUMLOGICALREADS

MSS_ACTIVE_REQUEST-TRXISOLEVEL table field - MSS Transaction Isolation level

Description: MSS Transaction Isolation level
Field Name: TRXISOLEVEL
Data Element: MSSTRXISOLEVEL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRXISOLEVEL

MSS_ACTIVE_REQUEST-ORIGLOGINNAME table field - Original name used to login to SQL Server

Description: Original name used to login to SQL Server
Field Name: ORIGLOGINNAME
Data Element: MSSORIGUSRNAME
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 ORIGLOGINNAME

MSS_ACTIVE_REQUEST-CONNECTIONID table field - SQL Server connection id

Description: SQL Server connection id
Field Name: CONNECTIONID
Data Element: MSSCONNECTIONID
Data Type: CHAR
length (Dec): 36(0)
Check table:
Conversion Routine:
Domain Name: MSSUNIQIDENT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONNECTIONID

MSS_ACTIVE_REQUEST-PARENT_CONNID table field - SQL Server parent connection id

Description: SQL Server parent connection id
Field Name: PARENT_CONNID
Data Element: MSSPARENTCONNID
Data Type: CHAR
length (Dec): 36(0)
Check table:
Conversion Routine:
Domain Name: MSSUNIQIDENT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARENT_CONNID

MSS_ACTIVE_REQUEST-CONN_SESSIONID table field - Session ID running on connection

Description: Session ID running on connection
Field Name: CONN_SESSIONID
Data Element: MSSCONNSID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONN_SESSIONID

MSS_ACTIVE_REQUEST-CONNECT_TIME table field - Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS

Description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
Field Name: CONNECT_TIME
Data Element: MSSCONNDATE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONNECT_TIME

MSS_ACTIVE_REQUEST-NET_TRANSPORT table field - The network transport type used by the connection

Description: The network transport type used by the connection
Field Name: NET_TRANSPORT
Data Element: MSSNETRANSPORT
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 NET_TRANSPORT

MSS_ACTIVE_REQUEST-PROTOCOL_TYPE table field - The network transport protocol used by the connection

Description: The network transport protocol used by the connection
Field Name: PROTOCOL_TYPE
Data Element: MSSPROTYPE
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 PROTOCOL_TYPE

MSS_ACTIVE_REQUEST-AFFINITY_NODE table field - Node Affinity from DMV connection

Description: Node Affinity from DMV connection
Field Name: AFFINITY_NODE
Data Element: MSSNODEAFF
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AFFINITY_NODE

MSS_ACTIVE_REQUEST-CONN_NUMREADS table field - SQL Server connection number of reads over the connection

Description: SQL Server connection number of reads over the connection
Field Name: CONN_NUMREADS
Data Element: MSSCONNUMREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONN_NUMREADS

MSS_ACTIVE_REQUEST-CONN_NUMWRITES table field - SQL Server conneciton number of writes over the connection

Description: SQL Server conneciton number of writes over the connection
Field Name: CONN_NUMWRITES
Data Element: MSSCONNUMWRITES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONN_NUMWRITES

MSS_ACTIVE_REQUEST-LAST_READ table field - Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS

Description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
Field Name: LAST_READ
Data Element: MSSCONNLASTRD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_READ

MSS_ACTIVE_REQUEST-LAST_WRITE table field - Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS

Description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
Field Name: LAST_WRITE
Data Element: MSSCONNLASTWT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_WRITE

MSS_ACTIVE_REQUEST-NET_PACKET_SIZE table field - SQL Server packet size

Description: SQL Server packet size
Field Name: NET_PACKET_SIZE
Data Element: MSSPACKSZ
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NET_PACKET_SIZE

MSS_ACTIVE_REQUEST-CLIENT_NET_ADDR table field - Connection network address

Description: Connection network address
Field Name: CLIENT_NET_ADDR
Data Element: MSSCONNETADDR
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CHAR40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENT_NET_ADDR

MSS_ACTIVE_REQUEST-REQ_SESSIONID table field - Session ID associated with the request being processed

Description: Session ID associated with the request being processed
Field Name: REQ_SESSIONID
Data Element: MSSREQSID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_SESSIONID

MSS_ACTIVE_REQUEST-REQUESTID table field - SQL Server Request ID

Description: SQL Server Request ID
Field Name: REQUESTID
Data Element: MSSREQUESTID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQUESTID

MSS_ACTIVE_REQUEST-START_TIME table field - Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS

Description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
Field Name: START_TIME
Data Element: MSSREQDATE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_TIME

MSS_ACTIVE_REQUEST-STATUS table field - SQL Server process status; ie sleeping, running etc.

Description: SQL Server process status; ie sleeping, running etc.
Field Name: STATUS
Data Element: MSQPROSTAT
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: CHAR60
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

MSS_ACTIVE_REQUEST-COMMAND table field - Command currently being executed by the given process id

Description: Command currently being executed by the given process id
Field Name: COMMAND
Data Element: MSQEXECMD
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: CHAR32
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMAND

MSS_ACTIVE_REQUEST-SQLHANDLE table field - handle pointing to sql statment or procedure

Description: handle pointing to sql statment or procedure
Field Name: SQLHANDLE
Data Element: MSSSQLHANDLE
Data Type: CHAR
length (Dec): 130(0)
Check table:
Conversion Routine:
Domain Name: MSSHANDLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLHANDLE

MSS_ACTIVE_REQUEST-STMT_START_OFFSET table field - SQL Server int4

Description: SQL Server int4
Field Name: STMT_START_OFFSET
Data Element: MSSINT4
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_START_OFFSET

MSS_ACTIVE_REQUEST-STMT_END_OFFSET table field - SQL Server int4

Description: SQL Server int4
Field Name: STMT_END_OFFSET
Data Element: MSSINT4
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_END_OFFSET

MSS_ACTIVE_REQUEST-PLAN_HANDLE table field - handle pointing to plan used in execution of sql stmt/proc

Description: handle pointing to plan used in execution of sql stmt/proc
Field Name: PLAN_HANDLE
Data Element: MSSPLANHANDLE
Data Type: CHAR
length (Dec): 130(0)
Check table:
Conversion Routine:
Domain Name: MSSHANDLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLAN_HANDLE

MSS_ACTIVE_REQUEST-DBNAME table field - Database name

Description: Database name
Field Name: DBNAME
Data Element: MSSDB
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

MSS_ACTIVE_REQUEST-USERNAME table field - The user name used to log into the SQL Server database

Description: The user name used to log into the SQL Server database
Field Name: USERNAME
Data Element: MSQUSRNAME
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 USERNAME

MSS_ACTIVE_REQUEST-REQ_CONNECTIONID table field - SQL Server connection id

Description: SQL Server connection id
Field Name: REQ_CONNECTIONID
Data Element: MSSREQCONNID
Data Type: CHAR
length (Dec): 36(0)
Check table:
Conversion Routine:
Domain Name: MSSUNIQIDENT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_CONNECTIONID

MSS_ACTIVE_REQUEST-BLOCKING_SESSION_ID table field - Blocking session ID for SQL Server

Description: Blocking session ID for SQL Server
Field Name: BLOCKING_SESSION_ID
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 BLOCKING_SESSION_ID

MSS_ACTIVE_REQUEST-WAIT_TIME table field - Current wait time of the process in milliseconds

Description: Current wait time of the process in milliseconds
Field Name: WAIT_TIME
Data Element: MSQWAITIME
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 WAIT_TIME

MSS_ACTIVE_REQUEST-LAST_WAIT_TYPE table field - The locked resource process is waiting for (object ID).

Description: The locked resource process is waiting for (object ID).
Field Name: LAST_WAIT_TYPE
Data Element: MSQSQLWAIT
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: CHAR64
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_WAIT_TYPE

MSS_ACTIVE_REQUEST-WAIT_RESOURCE 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: WAIT_RESOURCE
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 WAIT_RESOURCE

MSS_ACTIVE_REQUEST-OPEN_TRAN_CNT table field - Number of open transactions for the SQL Server process

Description: Number of open transactions for the SQL Server process
Field Name: OPEN_TRAN_CNT
Data Element: MSSOPENTRAN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPEN_TRAN_CNT

MSS_ACTIVE_REQUEST-OPEN_RESULTSET_CNT table field - Number of open result sets for the SQL Server process

Description: Number of open result sets for the SQL Server process
Field Name: OPEN_RESULTSET_CNT
Data Element: MSSOPENRES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPEN_RESULTSET_CNT

MSS_ACTIVE_REQUEST-TRANSACTION_ID table field - Transaction identifier request executes under

Description: Transaction identifier request executes under
Field Name: TRANSACTION_ID
Data Element: MSSTRANSACTIONID
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRANSACTION_ID

MSS_ACTIVE_REQUEST-PERCENT_COMPLETE table field - Percentage complete

Description: Percentage complete
Field Name: PERCENT_COMPLETE
Data Element: MSSPRCCOMP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERCENT_COMPLETE

MSS_ACTIVE_REQUEST-EST_COMPLETION_TIME table field - Estimated Completion time of SQL Request

Description: Estimated Completion time of SQL Request
Field Name: EST_COMPLETION_TIME
Data Element: MSSESTCMPTIME
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EST_COMPLETION_TIME

MSS_ACTIVE_REQUEST-REQ_CPUTIME table field - CPU time for a request

Description: CPU time for a request
Field Name: REQ_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 REQ_CPUTIME

MSS_ACTIVE_REQUEST-REQ_TTLTIME table field - Total elapsed time utilized by a request

Description: Total elapsed time utilized by a request
Field Name: REQ_TTLTIME
Data Element: MSSREQTTL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_TTLTIME

MSS_ACTIVE_REQUEST-SCHED_ID table field - ID of the scheduler used for the request

Description: ID of the scheduler used for the request
Field Name: SCHED_ID
Data Element: MSSREQSCHEDULERID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCHED_ID

MSS_ACTIVE_REQUEST-REQ_NUMREADS table field - number of reads performed by the request

Description: number of reads performed by the request
Field Name: REQ_NUMREADS
Data Element: MSSREQNUMREADS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_NUMREADS

MSS_ACTIVE_REQUEST-REQ_NUMWRITES table field - number of writes performed in a request

Description: number of writes performed in a request
Field Name: REQ_NUMWRITES
Data Element: MSSREQNUMWRITES
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_NUMWRITES

MSS_ACTIVE_REQUEST-REQ_NUMLOGICALREADS table field - number of reads performed by a request

Description: number of reads performed by a request
Field Name: REQ_NUMLOGICALREADS
Data Element: MSSREQNUMLOGRDS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_NUMLOGICALREADS

MSS_ACTIVE_REQUEST-REQ_ROWCOUNT table field - SQL Server count of rows returned

Description: SQL Server count of rows returned
Field Name: REQ_ROWCOUNT
Data Element: MSSROWCOUNT
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_ROWCOUNT

MSS_ACTIVE_REQUEST-DOP table field - DOP shown in sys.dm_exec_requests

Description: DOP shown in sys.dm_exec_requests
Field Name: DOP
Data Element: MSSREQDOP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DOP

MSS_ACTIVE_REQUEST-PAR_WORKER_CNT table field - Parallel worker count from sys.dm_exec_requests

Description: Parallel worker count from sys.dm_exec_requests
Field Name: PAR_WORKER_CNT
Data Element: MSSPARWORKCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAR_WORKER_CNT

MSS_ACTIVE_REQUEST-SQLTEXT table field - First 50 characters of a SQL Server statement

Description: First 50 characters of a SQL Server statement
Field Name: SQLTEXT
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 SQLTEXT

MSS_ACTIVE_REQUEST-WAITORDER table field - Sequential order of waiting queries within queue for Memory

Description: Sequential order of waiting queries within queue for Memory
Field Name: WAITORDER
Data Element: MSSWAITORDER
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITORDER

MSS_ACTIVE_REQUEST-REQMEMKB table field - Requested amount of memory in KB

Description: Requested amount of memory in KB
Field Name: REQMEMKB
Data Element: MSSREQMEMKB
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQMEMKB

MSS_ACTIVE_REQUEST-IOCOUNT table field - pending io count from sys.dm_os_tasks

Description: pending io count from sys.dm_os_tasks
Field Name: IOCOUNT
Data Element: MSSIOCOUNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IOCOUNT

MSS_ACTIVE_REQUEST-WAITTYPE table field - wait type from sys.dm_os_wait_stats

Description: wait type from sys.dm_os_wait_stats
Field Name: WAITTYPE
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 WAITTYPE

MSS_ACTIVE_REQUEST-OBJECT_NAME table field - MS SQL Server object name

Description: MS SQL Server object name
Field Name: OBJECT_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 OBJECT_NAME

MSS_ACTIVE_REQUEST-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_ACTIVE_REQUEST-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

MSS_ACTIVE_REQUEST-SAP_USER table field - The user name in the SAP system.

Description: The user name in the SAP system.
Field Name: SAP_USER
Data Element: MSSSAPUSER
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SAP_USER

MSS_ACTIVE_REQUEST-CPU_TTL table field - MS SQL Server cumulative cpu time

Description: MS SQL Server cumulative cpu time
Field Name: CPU_TTL
Data Element: MSSCPUTIME
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 CPU_TTL

MSS_ACTIVE_REQUEST-READS_TTL table field - Total number of reads performed by a session and request

Description: Total number of reads performed by a session and request
Field Name: READS_TTL
Data Element: MSSNUMREADS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field READS_TTL

MSS_ACTIVE_REQUEST-WRTS_TTL table field - Total number of writes performed

Description: Total number of writes performed
Field Name: WRTS_TTL
Data Element: MSSNUMWRITES
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WRTS_TTL

MSS_ACTIVE_REQUEST-LOGRDS_TTL table field - Total number of reads performed

Description: Total number of reads performed
Field Name: LOGRDS_TTL
Data Element: MSSNUMLOGREADS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGRDS_TTL

MSS_ACTIVE_REQUEST-WPNAME table field - ID of the R3 work process

Description: ID of the R3 work process
Field Name: WPNAME
Data Element: MSSWPNAME
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 WPNAME

MSS_ACTIVE_REQUEST-LINE_COLOR table field - Line color based on parallelism

Description: Line color based on parallelism
Field Name: LINE_COLOR
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LINE_COLOR


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table