Data Element list used by SAP ABAP Table MSSLOCK7 (MS SQL Server lock monitor)
SAP ABAP Table 
MSSLOCK7 (MS SQL Server lock monitor) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
MSQBLOPRID | SPID of blocking process. | |
| 2 | Data Element |
MSQECID | Execution context ID used to uniquely identify subthreads | |
| 3 | Data Element |
MSQEXECMD | Command currently being executed by the given process id | |
| 4 | Data Element |
MSQHOSTNE | Hostname of the application server logged into SQL Server. | |
| 5 | Data Element |
MSQLCKOWN | MS SQL server - type of object associated with a lock | |
| 6 | Data Element |
MSQLCKRSC | Lock resource type as e. g. KEY or PAGE. | |
| 7 | Data Element |
MSQLCKSTAT | MS SQL server - Lock request status | |
| 8 | Data Element |
MSQLKCRYCT | MS SQL server - lock carry-over reference count | |
| 9 | Data Element |
MSQLKLFTIM | MS SQL server - lock lifetime bitmap. | |
| 10 | Data Element |
MSQLKRECNT | MS SQL server - lock reference count | |
| 11 | Data Element |
MSQPRONE | Name of the application program which owns the connection. | |
| 12 | Data Element |
MSQPRSTAT | SQL Server process status; ie sleeping, running etc. | |
| 13 | Data Element |
MSQRSCBIN | MS SQL server - binary lock resource | |
| 14 | Data Element |
MSQRSCLKBK | MS SQL server - lock value block. | |
| 15 | Data Element |
MSQRSCTXT | Textual description of a lock resource from syslockinfo. | |
| 16 | Data Element |
MSQSERPRID | SQL Server process ID | |
| 17 | Data Element |
MSQSPTNAME | Lock request mode translated from table sptvalue. | |
| 18 | Data Element |
MSQTHREDID | Windows operating system thread ID | |
| 19 | Data Element |
MSQUSRNAME | The user name used to log into the SQL Server database | |
| 20 | Data Element |
MSQWAITIME | Current wait time of the process in milliseconds | |
| 21 | Data Element |
MSQWAITTYP | Wait type of waiting process, reserved field of sysprocesses | |
| 22 | Data Element |
MSQWKPROID | The application program's process ID on the given host | |
| 23 | Data Element |
MSSDB | Database name | |
| 24 | Data Element |
MSSHPIDTXT | MS SQL-Server host process ID (decimal) | |
| 25 | Data Element |
MSSLCKOWNT | MS SQL Server lock owner type (text) | |
| 26 | Data Element |
MSSLCKTXT | Lock status as granted, waiting, or converting. | |
| 27 | Data Element |
MSSOBJECT | Object name | |
| 28 | Data Element |
MSSOBJECT | Object name | |
| 29 | Data Element |
MSSSAPUSER | The user name in the SAP system. | |
| 30 | Data Element |
MSSSPIDTXT | MS SQL Server process ID | |
| 31 | Data Element |
NESTLEVEL | Nesting level for lock waiters | |
| 32 | Data Element |
WPREPORT | Report now running |
