SAP MSSPRCINF7 table - MS SQL Server: Process Monitor details in SAP


SAP MSSPRCINF7 table summary

Object Name: MSSPRCINF7
Dictionary Type: Structure
Description: MS SQL Server: Process Monitor


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

Details
MSSPRCINF7-SPID table field - SQL Server process ID

Description: SQL Server process ID
Field Name: SPID
Data Element: MSQSERPRID
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 SPID

MSSPRCINF7-KPID table field - Windows operating system thread ID of SQL process

Description: Windows operating system thread ID of SQL process
Field Name: KPID
Data Element: MSQTHREADI
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 KPID

MSSPRCINF7-BLOCKED table field - The SPID of the process blocking this SQL process.

Description: The SPID of the process blocking this SQL process.
Field Name: BLOCKED
Data Element: MSQBLOCPRI
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 BLOCKED

MSSPRCINF7-WAITTYPE table field - The wait type of the waiting process.

Description: The wait type of the waiting process.
Field Name: WAITTYPE
Data Element: MSQWAITYPE
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 WAITTYPE

MSSPRCINF7-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: 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 WAITTIME

MSSPRCINF7-SQLWAITRES table field - The last wait event the process had to wait for..

Description: The last wait event the process had to wait for..
Field Name: SQLWAITRES
Data Element: MSQWAITRES
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 SQLWAITRES

MSSPRCINF7-SAPWAIT 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: SAPWAIT
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 SAPWAIT

MSSPRCINF7-SQLWAIT table field - The locked resource process is waiting for (object ID).

Description: The locked resource process is waiting for (object ID).
Field Name: SQLWAIT
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 SQLWAIT

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

MSSPRCINF7-CPU table field - MS SQL Server total cumulative CPU time for a SQL process

Description: MS SQL Server total cumulative CPU time for a SQL process
Field Name: CPU
Data Element: MSQCPUTIME
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

MSSPRCINF7-PHYSIO table field - The total cumulative disk reads and writes for the process.

Description: The total cumulative disk reads and writes for the process.
Field Name: PHYSIO
Data Element: MSQPHYSIIO
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 PHYSIO

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

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

MSSPRCINF7-LSTBATTIME table field - Last time a stor. proc. or EXEC was executed on SQL process.

Description: Last time a stor. proc. or EXEC was executed on SQL process.
Field Name: LSTBATTIME
Data Element: MSQLTBATTM
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 LSTBATTIME

MSSPRCINF7-ECID table field - Execution context ID used to uniquely identify subthreads

Description: Execution context ID used to uniquely identify subthreads
Field Name: ECID
Data Element: MSQPRCECID
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 ECID

MSSPRCINF7-OPENTRAN table field - Number of open transactions for the SQL Server process

Description: Number of open transactions for the SQL Server process
Field Name: OPENTRAN
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 OPENTRAN

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

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

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

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

MSSPRCINF7-HOSTPROS table field - The application program's process ID on the given host

Description: The application program's process ID on the given host
Field Name: HOSTPROS
Data Element: MSQWKPROID
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: CHAR16
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTPROS

MSSPRCINF7-EXECCMD table field - Command currently being executed by the given process id

Description: Command currently being executed by the given process id
Field Name: EXECCMD
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 EXECCMD

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

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

MSSPRCINF7-NETADD table field - Unique ID of the network interface of client (MAC address).

Description: Unique ID of the network interface of client (MAC address).
Field Name: NETADD
Data Element: MSQNETADDR
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NETADD

MSSPRCINF7-NETLIB table field - The network library the client is using.

Description: The network library the client is using.
Field Name: NETLIB
Data Element: MSQNETLIB
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NETLIB

MSSPRCINF7-SAPUSER table field - The user name in the SAP system.

Description: The user name in the SAP system.
Field Name: SAPUSER
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 SAPUSER

MSSPRCINF7-REPORTNAME table field - Report now running

Description: Report now running
Field Name: REPORTNAME
Data Element: WPREPORT
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: WPREPORT
MemoryID:
AppClass: STSK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REPORTNAME


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table