SAP MSSALLLOCKS table - Lock information from list of all locks on the server details in SAP

SAP MSSALLLOCKS table summary

Object Name: MSSALLLOCKS
Dictionary Type: Structure
Description: Lock information from list of all locks on the server

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

Details

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

MSSALLLOCKS-ENTITY_ID table field - ID of the entity with which a resource is associated ▼

Description: ID of the entity with which a resource is associated
Field Name: ENTITY_ID
Data Element: MSSENTITYID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ENTITY_ID

MSSALLLOCKS-OBJ_NAME table field - MS SQL Server object name ▼

Description: MS SQL Server object name
Field Name: OBJ_NAME
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 OBJ_NAME

MSSALLLOCKS-DB_NAME table field - Database name ▼

Description: Database name
Field Name: DB_NAME
Data Element: MSSDB
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: MSSSYSNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB_NAME

MSSALLLOCKS-IND_ID table field - Index id ▼

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

See all SAP tables containing field IND_ID

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

MSSALLLOCKS-WAITSUBRSC table field - Wait Sub Resource as seen in sys.dm_tran_lock ▼

Description: Wait Sub Resource as seen in sys.dm_tran_lock
Field Name: WAITSUBRSC
Data Element: MSSWAITSUBRSC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITSUBRSC

MSSALLLOCKS-REQ_MODE table field - Granted mode or mode being requested ▼

Description: Granted mode or mode being requested
Field Name: REQ_MODE
Data Element: MSSREQMODE
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_MODE

MSSALLLOCKS-REQ_STATUS table field - Status: GRANTED, CONVERT, or WAIT. ▼

Description: Status: GRANTED, CONVERT, or WAIT.
Field Name: REQ_STATUS
Data Element: MSSREQSTATUS
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_STATUS

MSSALLLOCKS-RES_DESC table field - Lock resource description (dm_tran_locks) ▼

Description: Lock resource description (dm_tran_locks)
Field Name: RES_DESC
Data Element: MSSRESDESC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RES_DESC

MSSALLLOCKS-OBJ_ID table field - Object id ▼

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

See all SAP tables containing field OBJ_ID

MSSALLLOCKS-LINE_COLOR table field - Line color based on wait status ▼

Description: Line color based on wait status
Field Name: LINE_COLOR
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 LINE_COLOR

View list of all SAP tables(S4H/ECC)

Select data from SAP table