SAP MSSDBLOCKS_WP table - MS SQL Server lock monitor details in SAP


SAP MSSDBLOCKS_WP table summary

Object Name: MSSDBLOCKS_WP
Dictionary Type: Structure
Description: MS SQL Server lock monitor


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

Details
MSSDBLOCKS_WP-ACTFLAG table field -

Description:
Field Name: ACTFLAG
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACTFLAG

MSSDBLOCKS_WP-FIRSTOCCUR table field -

Description:
Field Name: FIRSTOCCUR
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRSTOCCUR

MSSDBLOCKS_WP-REQSPID table field - MS SQL Server process ID

Description: MS SQL Server process ID
Field Name: REQSPID
Data Element: MSSREQSPID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQSPID

MSSDBLOCKS_WP-HOLDSPID table field - MS SQL Server process ID (blocking)

Description: MS SQL Server process ID (blocking)
Field Name: HOLDSPID
Data Element: MSSBLKSPID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOLDSPID

MSSDBLOCKS_WP-REQPID table field - MS SQL-Server host process id (= OS work process ID)

Description: MS SQL-Server host process id (= OS work process ID)
Field Name: REQPID
Data Element: MSSHOSTPID
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: WPPID
MemoryID:
AppClass: STSK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQPID

MSSDBLOCKS_WP-OPEN_TRAN table field - Number of open transactions for the SQL Server process

Description: Number of open transactions for the SQL Server process
Field Name: OPEN_TRAN
Data Element: MSSOPENTRAN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPEN_TRAN

MSSDBLOCKS_WP-PROCSTAT table field - MS SQL-Server process status

Description: MS SQL-Server process status
Field Name: PROCSTAT
Data Element: MSSSTATUS
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROCSTAT

MSSDBLOCKS_WP-USERNAME table field - MS SQL Server user name

Description: MS SQL Server user name
Field Name: USERNAME
Data Element: MSSUNAME
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 USERNAME

MSSDBLOCKS_WP-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

MSSDBLOCKS_WP-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

MSSDBLOCKS_WP-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

MSSDBLOCKS_WP-INPUTBUFF table field - Output from DBCC INPUTBUFFER for lock display

Description: Output from DBCC INPUTBUFFER for lock display
Field Name: INPUTBUFF
Data Element: MSSINPUTBUFF
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INPUTBUFF

MSSDBLOCKS_WP-WAITTIME table field - Current wait time of the process in milliseconds

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

See all SAP tables containing field WAITTIME

MSSDBLOCKS_WP-WAITRSC table field - Wait Resource as seen in sysprocesses

Description: Wait Resource as seen in sysprocesses
Field Name: WAITRSC
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 WAITRSC

MSSDBLOCKS_WP-LASTWTYPE table field - Last Wait Type as seen in sysprocesses

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

See all SAP tables containing field LASTWTYPE

MSSDBLOCKS_WP-DBNAME table field - MS SQL Server: Database name

Description: MS SQL Server: Database name
Field Name: DBNAME
Data Element: MSSLDBNAME
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 DBNAME

MSSDBLOCKS_WP-OBJNAME table field - Table name

Description: Table name
Field Name: OBJNAME
Data Element: MSSTNAME
Data Type: CHAR
length (Dec): 30(0)
Check table: *
Conversion Routine:
Domain Name: AS4TAB
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJNAME

MSSDBLOCKS_WP-INDEXNAME table field - MS SQL Server object name

Description: MS SQL Server object name
Field Name: INDEXNAME
Data Element: MSSOBJNAME
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 INDEXNAME

MSSDBLOCKS_WP-LOCKRSC table field - Textual description of a lock resource from syslockinfo

Description: Textual description of a lock resource from syslockinfo
Field Name: LOCKRSC
Data Element: MSSLOCKRSC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKRSC

MSSDBLOCKS_WP-LOCKTYPE table field - Char representation of rsc_type from syslockinfo

Description: Char representation of rsc_type from syslockinfo
Field Name: LOCKTYPE
Data Element: MSSCHARLOCKTYP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKTYPE

MSSDBLOCKS_WP-LOCKNAME table field - MS SQL Server lock description text

Description: MS SQL Server lock description text
Field Name: LOCKNAME
Data Element: MSSLOCKTXT
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: TEXT35
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKNAME

MSSDBLOCKS_WP-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

MSSDBLOCKS_WP-REQ_REFCNT table field - req_refcnt from syslockinfo for blocking/blocked lock entry

Description: req_refcnt from syslockinfo for blocking/blocked lock entry
Field Name: REQ_REFCNT
Data Element: MSSREQREFCNT
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_REFCNT

MSSDBLOCKS_WP-REQ_OWNERTYPE table field - req_refcnt from syslockinfo for blocking/blocked lock entry

Description: req_refcnt from syslockinfo for blocking/blocked lock entry
Field Name: REQ_OWNERTYPE
Data Element: MSSREQOWNTYP
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_OWNERTYPE

MSSDBLOCKS_WP-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

MSSDBLOCKS_WP-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

MSSDBLOCKS_WP-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

MSSDBLOCKS_WP-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

MSSDBLOCKS_WP-SAPUSER table field - The user name in the SAP system.

Description: The user name in the SAP system.
Field Name: SAPUSER
Data Element: MSSSAPUSER
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SAPUSER

MSSDBLOCKS_WP-REPORTNAME table field - Report now running

Description: Report now running
Field Name: REPORTNAME
Data Element: WPREPORT
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: WPREPORT
MemoryID:
AppClass: STSK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REPORTNAME

MSSDBLOCKS_WP-NESTLEVEL table field - Nesting level for lock waiters

Description: Nesting level for lock waiters
Field Name: NESTLEVEL
Data Element: NESTLEVEL
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NESTLEVEL

MSSDBLOCKS_WP-HPID_TEXT table field - MS SQL-Server host process ID (decimal)

Description: MS SQL-Server host process ID (decimal)
Field Name: HPID_TEXT
Data Element: MSSHPIDTXT
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HPID_TEXT

MSSDBLOCKS_WP-SPID_TEXT table field - MS SQL Server process ID

Description: MS SQL Server process ID
Field Name: SPID_TEXT
Data Element: MSSSPIDTXT
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPID_TEXT


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table