Data Element list used by SAP ABAP Table MSQSAPSULK (MS SQL server - list of locks from sap_summary_locks)
SAP ABAP Table 
MSQSAPSULK (MS SQL server - list of locks from sap_summary_locks) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
MSQBLOPRID | SPID of blocking process. | |
| 2 | Data Element |
MSQDBNAME | The name of the database in SQL Server instance. | |
| 3 | Data Element |
MSQEXECMD | Command currently being executed by the given process id | |
| 4 | Data Element |
MSQHOSTNAM | Hostname of the application server logged into SQL Server. | |
| 5 | Data Element |
MSQLCKDUR | Time the blocking lock was hold in minutes. | |
| 6 | Data Element |
MSQLCKRSC | Lock resource type as e. g. KEY or PAGE. | |
| 7 | Data Element |
MSQOBJNAME | Object name as defined in system table sysobjects. | |
| 8 | Data Element |
MSQOBJNAME | Object name as defined in system table sysobjects. | |
| 9 | Data Element |
MSQRSCTXT | Textual description of a lock resource from syslockinfo. | |
| 10 | Data Element |
MSQSERPRID | SQL Server process ID | |
| 11 | Data Element |
MSQSPTNAME | Lock request mode translated from table sptvalue. | |
| 12 | Data Element |
MSQSPTNAME | Lock request mode translated from table sptvalue. | |
| 13 | Data Element |
MSQSQLCONN | Name of the application program which owns the connection | |
| 14 | Data Element |
MSQSTDATE | Time stamp when the blocking situation started. | |
| 15 | Data Element |
MSQTHREDID | Windows operating system thread ID | |
| 16 | Data Element |
MSQWAITTYP | Wait type of waiting process, reserved field of sysprocesses |
