Data Element list used by SAP ABAP Table MSSLOCKINF (MS SQL-Server: Lock Information)
SAP ABAP Table
MSSLOCKINF (MS SQL-Server: Lock Information) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | MSSBLOCKED | MS SQL Server sp ID of blocking process | ||
| 2 | MSSCOMMAND | MS SQL Server command | ||
| 3 | MSSHOSTNM_ | Hostname of the application server logged into SQL Server | ||
| 4 | MSSHOSTPID | MS SQL-Server host process id (= OS work process ID) | ||
| 5 | MSSKPID | Windows NT thread ID | ||
| 6 | MSSLDBNAME | MS SQL Server: Database name | ||
| 7 | MSSLOCKID | MS SQL-Server lock ID | ||
| 8 | MSSLOCKPG | MS SQL Server locked page number | ||
| 9 | MSSLOCKTXT | MS SQL Server lock description text | ||
| 10 | MSSLOCKTYP | MS SQL Server lock type number | ||
| 11 | MSSOBJNAME | MS SQL Server object name | ||
| 12 | MSSOBJTYPE | Object type | ||
| 13 | MSSPRGNAME | Name of the application program which owns the connection | ||
| 14 | MSSSPID | MS SQL Server process ID | ||
| 15 | MSSSTATUS | MS SQL-Server process status | ||
| 16 | MSSUNAME | MS SQL Server user name | ||
| 17 | MSSWAITTYP | MS SQL Server wait type | ||
| 18 | NESTLEVEL | Nesting level for lock waiters | ||
| 19 | WPBNAME | User Currently Served | ||
| 20 | WPREPORT | Report now running |