SAP ABAP Data Element MSSLOCKTYP (MS SQL Server lock type number)
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
Data Element MSSLOCKTYP
Short Description MS SQL Server lock type number  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type INT2    
Data Type INT2   2-byte integer, only for length field before LCHR or LRAW 
Length 5    
Decimal Places 0    
Output Length 5    
Value Table      
Further Characteristics
Search Help: Name    
Search Help: Parameters    
Parameter ID   
Default Component name    
Change document    
No Input History    
Basic direction is set to LTR    
No BIDI Filtering    
Field Label
  Length  Field Label  
Short 10 lock type 
Medium 15 SQL lock type 
Long 20 MS SQL lock type 
Heading 30 MS SQL Server lock type 
Documentation

Definition

Type of the blocking lock. Numbers > 255 indicate a blocking lock. The following table shows the numbers with their matching documentation texts:

1 Ex_table
2 Sh_table
3 Ex_intent
4 Sh_intent
5 ShTab_ExIntent
6 Ex_page
7 Sh_page
8 Update_page
9 Insert_page
10 Link_page
12 Ex_extent
13 Update_extent
14 Next_extent
15 Prev_extent
257 Ex_table-blk
258 Sh_table-blk
259 Ex_intent-blk
260 Sh_intent-blk
261 ShTab_ExIntent-blk
262 Ex_page-blk
263 Sh_page-blk
264 Update_page-blk
265 Insert_page-blk
266 Link_page-blk
268 Ex_extent-blk
269 Update_extent-blk
270 Next_extent-blk
271 Prev_extent-blk

History
Last changed by/on SAP  20130604 
SAP Release Created in