Data Element list used by SAP ABAP Table MSSDBLOCKS_WP (MS SQL Server lock monitor)
SAP ABAP Table 
MSSDBLOCKS_WP (MS SQL Server lock monitor) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
MSSBLKSPID | MS SQL Server process ID (blocking) | |
| 2 | Data Element |
MSSCHARLOCKTYP | Char representation of rsc_type from syslockinfo | |
| 3 | Data Element |
MSSCOMMAND | MS SQL Server command | |
| 4 | Data Element |
MSSHOSTNM_ | Hostname of the application server logged into SQL Server | |
| 5 | Data Element |
MSSHOSTPID | MS SQL-Server host process id (= OS work process ID) | |
| 6 | Data Element |
MSSHPIDTXT | MS SQL-Server host process ID (decimal) | |
| 7 | Data Element |
MSSINPUTBUFF | Output from DBCC INPUTBUFFER for lock display | |
| 8 | Data Element |
MSSINT4 | SQL Server int4 | |
| 9 | Data Element |
MSSINT4 | SQL Server int4 | |
| 10 | Data Element |
MSSLASTWTYPE | Last Wait Type as seen in sysprocesses | |
| 11 | Data Element |
MSSLDBNAME | MS SQL Server: Database name | |
| 12 | Data Element |
MSSLOCKMODE | req_mod from syslockinfo for blocking/blocked lock entry | |
| 13 | Data Element |
MSSLOCKRSC | Textual description of a lock resource from syslockinfo | |
| 14 | Data Element |
MSSLOCKTXT | MS SQL Server lock description text | |
| 15 | Data Element |
MSSOBJNAME | MS SQL Server object name | |
| 16 | Data Element |
MSSOPENTRAN | Number of open transactions for the SQL Server process | |
| 17 | Data Element |
MSSPLANHANDLE | handle pointing to plan used in execution of sql stmt/proc | |
| 18 | Data Element |
MSSPRGNAME | Name of the application program which owns the connection | |
| 19 | Data Element |
MSSREQOWNTYP | req_refcnt from syslockinfo for blocking/blocked lock entry | |
| 20 | Data Element |
MSSREQREFCNT | req_refcnt from syslockinfo for blocking/blocked lock entry | |
| 21 | Data Element |
MSSREQSPID | MS SQL Server process ID | |
| 22 | Data Element |
MSSSAPUSER | The user name in the SAP system. | |
| 23 | Data Element |
MSSSPIDTXT | MS SQL Server process ID | |
| 24 | Data Element |
MSSSQLHANDLE | handle pointing to sql statment or procedure | |
| 25 | Data Element |
MSSSTATUS | MS SQL-Server process status | |
| 26 | Data Element |
MSSTNAME | Table name | |
| 27 | Data Element |
MSSUNAME | MS SQL Server user name | |
| 28 | Data Element |
MSSWAITRSC | Wait Resource as seen in sysprocesses | |
| 29 | Data Element |
MSSWAITTIME | Current wait time of the process in milliseconds | |
| 30 | Data Element |
NESTLEVEL | Nesting level for lock waiters | |
| 31 | Data Element |
WPREPORT | Report now running |
