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

SAP MSQPROCESS table summary

Object Name: MSQPROCESS
Dictionary Type: Structure
Description: MS SQL server processes ( as from sysprocesses )

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

Details

MSQPROCESS-SPID table field - MS SQL Server process ID ▼

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

MSQPROCESS-KPID table field - Windows operating system thread ID ▼

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

MSQPROCESS-BLOCKED table field - SPID of blocking process. ▼

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

MSQPROCESS-WAITTYPE table field - Wait type of waiting process, reserved field of sysprocesses ▼

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

MSQPROCESS-DBID table field - MS SQL Server database ID ▼

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

MSQPROCESS-USERID table field - MS SQL Server - user identification ID ▼

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

MSQPROCESS-CPUTIME 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: 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

MSQPROCESS-PHYIO 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: 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

MSQPROCESS-MEMUSUAGE 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: 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

MSQPROCESS-LOGINTIME table field - Login Time for client process or system startup time ▼

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

MSQPROCESS-LSTBATTIME table field - Last time exec. of remote stored proc. call or sql stat. ▼

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

MSQPROCESS-PROSTATUS table field - SQL Server process status; ie sleeping, running etc. ▼

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

MSQPROCESS-SIDNAME 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: 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

MSQPROCESS-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: 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

MSQPROCESS-PRONAME table field - Name of the application program which owns the connection. ▼

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

MSQPROCESS-HOSTPRO 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: 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

MSQPROCESS-CMD table field - Command currently being executed by the given process id ▼

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

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

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

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

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

MSQPROCESS-SUIDNAME 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: 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

View list of all SAP tables(S4H/ECC)

Select data from SAP table