SAP MSSLOCK7 table - MS SQL Server lock monitor details in SAP


SAP MSSLOCK7 table summary

Object Name: MSSLOCK7
Dictionary Type: Structure
Description: MS SQL Server lock monitor


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

MSSLOCK7-SAPUSER table field - The user name in the SAP system.

Description: The user name in the SAP system.
Field Name: SAPUSER
Data Element: MSSSAPUSER
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SAPUSER

MSSLOCK7-REPORTNAME table field - Report now running

Description: Report now running
Field Name: REPORTNAME
Data Element: WPREPORT
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: WPREPORT
MemoryID:
AppClass: STSK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REPORTNAME

MSSLOCK7-NESTLEVEL table field - Nesting level for lock waiters

Description: Nesting level for lock waiters
Field Name: NESTLEVEL
Data Element: NESTLEVEL
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 NESTLEVEL

MSSLOCK7-HPID_TEXT table field - MS SQL-Server host process ID (decimal)

Description: MS SQL-Server host process ID (decimal)
Field Name: HPID_TEXT
Data Element: MSSHPIDTXT
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HPID_TEXT

MSSLOCK7-SPID_TEXT table field - MS SQL Server process ID

Description: MS SQL Server process ID
Field Name: SPID_TEXT
Data Element: MSSSPIDTXT
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPID_TEXT

MSSLOCK7-STATUS_TXT table field - Lock status as granted, waiting, or converting.

Description: Lock status as granted, waiting, or converting.
Field Name: STATUS_TXT
Data Element: MSSLCKTXT
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 STATUS_TXT

MSSLOCK7-LCKOWNERTP table field - MS SQL Server lock owner type (text)

Description: MS SQL Server lock owner type (text)
Field Name: LCKOWNERTP
Data Element: MSSLCKOWNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LCKOWNERTP


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table