SAP MSQBLOLCKS table - MS SQL server blocked locks details in SAP

SAP MSQBLOLCKS table summary

Object Name: MSQBLOLCKS
Dictionary Type: Structure
Description: MS SQL server blocked locks

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

Details

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

MSQBLOLCKS-OBJECTNAME table field - Object name as defined in system table sysobjects. ▼

Description: Object name as defined in system table sysobjects.
Field Name: OBJECTNAME
Data Element: MSQOBJNAME
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 OBJECTNAME

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

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

MSQBLOLCKS-BLOCKEDBY table field - SPID of blocking process. ▼

Description: SPID of blocking process.
Field Name: BLOCKEDBY
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 BLOCKEDBY

MSQBLOLCKS-LOCKRSC table field - Textual description of a lock resource from syslockinfo. ▼

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

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

MSQBLOLCKS-LCKTYPE table field - Lock resource type as e. g. KEY or PAGE. ▼

Description: Lock resource type as e. g. KEY or PAGE.
Field Name: LCKTYPE
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 LCKTYPE

MSQBLOLCKS-RSCLCKBIN table field - MS SQL server - binary lock resource ▼

Description: MS SQL server - binary lock resource
Field Name: RSCLCKBIN
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 RSCLCKBIN

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

MSQBLOLCKS-INDNAME table field - MS SQL server table or index name ▼

Description: MS SQL server table or index name
Field Name: INDNAME
Data Element: MSQTABNAME
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 INDNAME

MSQBLOLCKS-LCKSTATUS table field - Lock request mode translated from table sptvalue. ▼

Description: Lock request mode translated from table sptvalue.
Field Name: LCKSTATUS
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 LCKSTATUS

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

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

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

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

MSQBLOLCKS-LCKOWNER 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: LCKOWNER
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 LCKOWNER

MSQBLOLCKS-PROSSTAT table field - SQL Server process status; ie sleeping, running etc. ▼

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

MSQBLOLCKS-PROSUSER 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: PROSUSER
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 PROSUSER

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

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

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

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

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

View list of all SAP tables(S4H/ECC)

Select data from SAP table