SAP MSSDBLOCKS table - structure returned about blocking db locks for SQL Server details in SAP

SAP MSSDBLOCKS table summary

Object Name: MSSDBLOCKS
Dictionary Type: Structure
Description: structure returned about blocking db locks for SQL Server

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

Details

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

View list of all SAP tables(S4H/ECC)

Select data from SAP table