SAP MSQLOCKINF table - MS sql server lock info information for blockers and waiters details in SAP


SAP MSQLOCKINF table summary

Object Name: MSQLOCKINF
Dictionary Type: Structure
Description: MS sql server lock info information for blockers and waiters


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

Details
MSQLOCKINF-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

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

MSQLOCKINF-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: MSQPRSTAT
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

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

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

MSQLOCKINF-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: MSQPRONE
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 PROGNAME

MSQLOCKINF-HOSTPID 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: HOSTPID
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 HOSTPID

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

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

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

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

MSQLOCKINF-BINLOCK table field - MS SQL server - binary lock resource

Description: MS SQL server - binary lock resource
Field Name: BINLOCK
Data Element: MSQRSCBIN
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: MSQHEX16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BINLOCK

MSQLOCKINF-LCKVALBLK table field - MS SQL server - lock value block.

Description: MS SQL server - lock value block.
Field Name: LCKVALBLK
Data Element: MSQRSCLKBK
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: MSQHEX16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LCKVALBLK

MSQLOCKINF-INDNAME table field - Object name

Description: Object name
Field Name: INDNAME
Data Element: MSSOBJECT
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 INDNAME

MSQLOCKINF-LCKSTATUS table field - MS SQL server - Lock request status

Description: MS SQL server - Lock request status
Field Name: LCKSTATUS
Data Element: MSQLCKSTAT
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 LCKSTATUS

MSQLOCKINF-LCKREFCNT table field - MS SQL server - lock reference count

Description: MS SQL server - lock reference count
Field Name: LCKREFCNT
Data Element: MSQLKRECNT
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 LCKREFCNT

MSQLOCKINF-LCKCARCNT table field - MS SQL server - lock carry-over reference count

Description: MS SQL server - lock carry-over reference count
Field Name: LCKCARCNT
Data Element: MSQLKCRYCT
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 LCKCARCNT

MSQLOCKINF-LCKLFETIME table field - MS SQL server - lock lifetime bitmap.

Description: MS SQL server - lock lifetime bitmap.
Field Name: LCKLFETIME
Data Element: MSQLKLFTIM
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 LCKLFETIME

MSQLOCKINF-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: MSQECID
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

MSQLOCKINF-LCKOWNERTY table field - MS SQL server - type of object associated with a lock

Description: MS SQL server - type of object associated with a lock
Field Name: LCKOWNERTY
Data Element: MSQLCKOWN
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 LCKOWNERTY

MSQLOCKINF-DBASENAME table field - Database name

Description: Database name
Field Name: DBASENAME
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 DBASENAME

MSQLOCKINF-OBJNAME table field - Object name

Description: Object name
Field Name: OBJNAME
Data Element: MSSOBJECT
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 OBJNAME

MSQLOCKINF-LOCKRES table field - Textual description of a lock resource from syslockinfo.

Description: Textual description of a lock resource from syslockinfo.
Field Name: LOCKRES
Data Element: MSQRSCTXT
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 LOCKRES

MSQLOCKINF-LOCKTYPE table field - Lock resource type as e. g. KEY or PAGE.

Description: Lock resource type as e. g. KEY or PAGE.
Field Name: LOCKTYPE
Data Element: MSQLCKRSC
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKTYPE

MSQLOCKINF-LOCKNAME table field - Lock request mode translated from table sptvalue.

Description: Lock request mode translated from table sptvalue.
Field Name: LOCKNAME
Data Element: MSQSPTNAME
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: CHAR35
MemoryID:
AppClass: MW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKNAME


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table