SAP MSQPROCESS table - MS SQL server processes ( as from sysprocesses ) details in SAP

Description: MS SQL Server process ID
Field Name: SPID
Data Element: MSQSYPROID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPID

Description: Windows operating system thread ID
Field Name: KPID
Data Element: MSQTHREDID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KPID

Description: SPID of blocking process.
Field Name: BLOCKED
Data Element: MSQBLOPRID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCKED

Description: Wait type of waiting process, reserved field of sysprocesses
Field Name: WAITTYPE
Data Element: MSQWAITTYP
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITTYPE

Description: MS SQL Server database ID
Field Name: DBID
Data Element: MSQDBASEID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBID

Description: MS SQL Server - user identification ID
Field Name: USERID
Data Element: MSQUID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERID

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

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

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

Description: Login Time for client process or system startup time
Field Name: LOGINTIME
Data Element: MSQLOGTIME
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

Description: Last time exec. of remote stored proc. call or sql stat.
Field Name: LSTBATTIME
Data Element: MSQLSTEXST
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

Description: SQL Server process status; ie sleeping, running etc.
Field Name: PROSTATUS
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 PROSTATUS

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

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

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

Description: The application program's process ID on the given host
Field Name: HOSTPRO
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 HOSTPRO

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

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

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

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

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

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