SAP MSSBLOCKINGLOCKHIER table - Blocking lock hierarchy display details in SAP


SAP MSSBLOCKINGLOCKHIER table summary

Object Name: MSSBLOCKINGLOCKHIER
Dictionary Type: Structure
Description: Blocking lock hierarchy display


Field list for MSSBLOCKINGLOCKHIER table on an S/4 SAP system

Details
MSSBLOCKINGLOCKHIER-TOPSID table field - Top level session in blocking hierarchy

Description: Top level session in blocking hierarchy
Field Name: TOPSID
Data Element: MSSTOPSID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOPSID

MSSBLOCKINGLOCKHIER-LCKLEVEL table field - Locking/blocking level

Description: Locking/blocking level
Field Name: LCKLEVEL
Data Element: MSSLCKLEVEL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LCKLEVEL

MSSBLOCKINGLOCKHIER-HOSTNAME table field - Hostname of the application server logged into SQL Server

Description: Hostname of the application server logged into SQL Server
Field Name: HOSTNAME
Data Element: MSSHOSTNM_
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

MSSBLOCKINGLOCKHIER-PROGNAME table field - Name of the application program which owns the connection

Description: Name of the application program which owns the connection
Field Name: PROGNAME
Data Element: MSSPRGNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROGNAME

MSSBLOCKINGLOCKHIER-SESS_ID table field - Session ID for SQL Server

Description: Session ID for SQL Server
Field Name: SESS_ID
Data Element: MSSSESSIONID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: MSSINT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_ID

MSSBLOCKINGLOCKHIER-BLK_SESS_ID table field - Blocking session ID for SQL Server

Description: Blocking session ID for SQL Server
Field Name: BLK_SESS_ID
Data Element: MSSBLKSESSIONID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLK_SESS_ID

MSSBLOCKINGLOCKHIER-REQ_ID table field - SQL Server Request ID

Description: SQL Server Request ID
Field Name: REQ_ID
Data Element: MSSREQUESTID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_ID

MSSBLOCKINGLOCKHIER-WAIT_SEC table field - Current wait time of the process in seconds

Description: Current wait time of the process in seconds
Field Name: WAIT_SEC
Data Element: MSSWAITSEC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_SEC

MSSBLOCKINGLOCKHIER-SQL_TEXT table field - Beginning characters of a sql statement in a lock hierarchy

Description: Beginning characters of a sql statement in a lock hierarchy
Field Name: SQL_TEXT
Data Element: MSSLCKSQLTXT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQL_TEXT

MSSBLOCKINGLOCKHIER-WAIT_TYPE table field - Lock wait type

Description: Lock wait type
Field Name: WAIT_TYPE
Data Element: MSSLCKWAITTYP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_TYPE

MSSBLOCKINGLOCKHIER-WAIT_RES table field - Wait Resource as seen in sysprocesses

Description: Wait Resource as seen in sysprocesses
Field Name: WAIT_RES
Data Element: MSSWAITRSC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_RES

MSSBLOCKINGLOCKHIER-COMMAND table field - MS SQL Server command

Description: MS SQL Server command
Field Name: COMMAND
Data Element: MSSCOMMAND
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: TEXT16
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMAND

MSSBLOCKINGLOCKHIER-LOCKSTAT table field - req_mod from syslockinfo for blocking/blocked lock entry

Description: req_mod from syslockinfo for blocking/blocked lock entry
Field Name: LOCKSTAT
Data Element: MSSLOCKMODE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKSTAT

MSSBLOCKINGLOCKHIER-SQLHANDLE table field - handle pointing to sql statment or procedure

Description: handle pointing to sql statment or procedure
Field Name: SQLHANDLE
Data Element: MSSSQLHANDLE
Data Type: CHAR
length (Dec): 130(0)
Check table:
Conversion Routine:
Domain Name: MSSHANDLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLHANDLE

MSSBLOCKINGLOCKHIER-STMT_START_OFFSET table field - SQL Server int4

Description: SQL Server int4
Field Name: STMT_START_OFFSET
Data Element: MSSINT4
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_START_OFFSET

MSSBLOCKINGLOCKHIER-STMT_END_OFFSET table field - SQL Server int4

Description: SQL Server int4
Field Name: STMT_END_OFFSET
Data Element: MSSINT4
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_END_OFFSET

MSSBLOCKINGLOCKHIER-PLAN_HANDLE table field - handle pointing to plan used in execution of sql stmt/proc

Description: handle pointing to plan used in execution of sql stmt/proc
Field Name: PLAN_HANDLE
Data Element: MSSPLANHANDLE
Data Type: CHAR
length (Dec): 130(0)
Check table:
Conversion Routine:
Domain Name: MSSHANDLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLAN_HANDLE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table