SAP ABAP Table MSQSAPSULK (MS SQL server - list of locks from sap_summary_locks)
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 MSQSAPSULK   Table Relationship Diagram
Short Description MS SQL server - list of locks from sap_summary_locks    
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 DURATION MSQLCKDUR INT2 INT2 5   0   Time the blocking lock was hold in minutes.  
2 START_DATE MSQSTDATE CHAR20 CHAR 20   0   Time stamp when the blocking situation started.  
3 SPID MSQSERPRID INT4 INT4 10   0   SQL Server process ID  
4 TABLENAME MSQOBJNAME CHAR256 CHAR 256   0   Object name as defined in system table sysobjects.  
5 LCKNAME MSQSPTNAME CHAR35 CHAR 35   0   Lock request mode translated from table sptvalue.  
6 KPID MSQTHREDID INT2 INT2 5   0   Windows operating system thread ID  
7 BLOKSPID MSQBLOPRID INT2 INT2 5   0   SPID of blocking process.  
8 LCKRSC MSQRSCTXT CHAR32 CHAR 32   0   Textual description of a lock resource from syslockinfo.  
9 LCKTYPE MSQLCKRSC CHAR10 CHAR 10   0   Lock resource type as e. g. KEY or PAGE.  
10 DBASENAME MSQDBNAME CHAR255 CHAR 255   0   The name of the database in SQL Server instance.  
11 INDNAME MSQOBJNAME CHAR256 CHAR 256   0   Object name as defined in system table sysobjects.  
12 LCKSTATUS MSQSPTNAME CHAR35 CHAR 35   0   Lock request mode translated from table sptvalue.  
13 HOSTNAME MSQHOSTNAM CHAR256 CHAR 256   0   Hostname of the application server logged into SQL Server.  
14 CONNECTTYP MSQSQLCONN CHAR16 CHAR 16   0   Name of the application program which owns the connection  
15 WAITTYPE MSQWAITTYP INT2 INT2 5   0   Wait type of waiting process, reserved field of sysprocesses  
16 COMMAND MSQEXECMD CHAR32 CHAR 32   0   Command currently being executed by the given process id  
History
Last changed by/on SAP  20130604 
SAP Release Created in