SAP ABAP Table MSSLOCK7 (MS SQL Server lock monitor)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
Table Category INTTAB    Structure 
Structure MSSLOCK7   Table Relationship Diagram
Short Description MS SQL Server lock monitor    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 .INCLUDE       0   0   MS sql server lock info information for blockers and waiters  
2 SPID MSQSERPRID INT4 INT4 10   0   SQL Server process ID  
3 KPID MSQTHREDID INT2 INT2 5   0   Windows operating system thread ID  
4 STATUS MSQPRSTAT CHAR60 CHAR 60   0   SQL Server process status; ie sleeping, running etc.  
5 USERNAME MSQUSRNAME CHAR128 CHAR 128   0   The user name used to log into the SQL Server database  
6 HOSTNAME MSQHOSTNE CHAR128 CHAR 128   0   Hostname of the application server logged into SQL Server.  
7 PROGNAME MSQPRONE CHAR128 CHAR 128   0   Name of the application program which owns the connection.  
8 HOSTPID MSQWKPROID CHAR16 CHAR 16   0   The application program's process ID on the given host  
9 EXECCMD MSQEXECMD CHAR32 CHAR 32   0   Command currently being executed by the given process id  
10 BLOCKED MSQBLOPRID INT2 INT2 5   0   SPID of blocking process.  
11 WAITTYPE MSQWAITTYP INT2 INT2 5   0   Wait type of waiting process, reserved field of sysprocesses  
12 WAITTIME MSQWAITIME INT4 INT4 10   0   Current wait time of the process in milliseconds  
13 BINLOCK MSQRSCBIN MSQHEX16 RAW 16   0   MS SQL server - binary lock resource  
14 LCKVALBLK MSQRSCLKBK MSQHEX16 RAW 16   0   MS SQL server - lock value block.  
15 INDNAME MSSOBJECT MSSSYSNAME CHAR 128   0   Object name  
16 LCKSTATUS MSQLCKSTAT INT2 INT2 5   0   MS SQL server - Lock request status  
17 LCKREFCNT MSQLKRECNT INT2 INT2 5   0   MS SQL server - lock reference count  
18 LCKCARCNT MSQLKCRYCT INT2 INT2 5   0   MS SQL server - lock carry-over reference count  
19 LCKLFETIME MSQLKLFTIM INT4 INT4 10   0   MS SQL server - lock lifetime bitmap.  
20 ECID MSQECID INT4 INT4 10   0   Execution context ID used to uniquely identify subthreads  
21 LCKOWNERTY MSQLCKOWN INT2 INT2 5   0   MS SQL server - type of object associated with a lock  
22 DBASENAME MSSDB MSSSYSNAME CHAR 128   0   Database name  
23 OBJNAME MSSOBJECT MSSSYSNAME CHAR 128   0   Object name  
24 LOCKRES MSQRSCTXT CHAR32 CHAR 32   0   Textual description of a lock resource from syslockinfo.  
25 LOCKTYPE MSQLCKRSC CHAR10 CHAR 10   0   Lock resource type as e. g. KEY or PAGE.  
26 LOCKNAME MSQSPTNAME CHAR35 CHAR 35   0   Lock request mode translated from table sptvalue.  
27 SAPUSER MSSSAPUSER   CHAR 12   0   The user name in the SAP system.  
28 REPORTNAME WPREPORT WPREPORT CHAR 40   0   Report now running  
29 NESTLEVEL NESTLEVEL INT2 INT2 5   0   Nesting level for lock waiters  
30 HPID_TEXT MSSHPIDTXT CHAR20 CHAR 20   0   MS SQL-Server host process ID (decimal)  
31 SPID_TEXT MSSSPIDTXT CHAR20 CHAR 20   0   MS SQL Server process ID  
32 STATUS_TXT MSSLCKTXT CHAR10 CHAR 10   0   Lock status as granted, waiting, or converting.  
33 LCKOWNERTP MSSLCKOWNT   CHAR 12   0   MS SQL Server lock owner type (text)  
History
Last changed by/on SAP  20130604 
SAP Release Created in