SAP MSQPROCINF table - MS SQL server - processes informations details in SAP

SAP MSQPROCINF table summary

Object Name: MSQPROCINF
Dictionary Type: Structure
Description: MS SQL server - processes informations

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

Details

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

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

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

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

MSQPROCINF-DBNAME table field - The name of the database in SQL Server instance. ▼

Description: The name of the database in SQL Server instance.
Field Name: DBNAME
Data Element: MSQDBNAME
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 DBNAME

MSQPROCINF-UIDNAME table field - MS SQL Server - user identification ID ▼

Description: MS SQL Server - user identification ID
Field Name: UIDNAME
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 UIDNAME

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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