SAP MSSXEDEADLCK table - Deadlock Information for MSSQL Server from X-Events details in SAP

SAP MSSXEDEADLCK table summary

Object Name: MSSXEDEADLCK
Dictionary Type: Structure
Description: Deadlock Information for MSSQL Server from X-Events

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

Details

MSSXEDEADLCK-DT table field - Date when a deadlock occurred ▼

Description: Date when a deadlock occurred
Field Name: DT
Data Element: MSSDLDT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DT

MSSXEDEADLCK-TM table field - Time when deadlock occurred ▼

Description: Time when deadlock occurred
Field Name: TM
Data Element: MSSDLTM
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: SYTIME
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TM

MSSXEDEADLCK-PROCESSID table field - Deadlock process ID ▼

Description: Deadlock process ID
Field Name: PROCESSID
Data Element: MSSDLPID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROCESSID

MSSXEDEADLCK-VICTIM table field - Was this process a victim ▼

Description: Was this process a victim
Field Name: VICTIM
Data Element: MSSDLVICTIM
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: BOOLEAN
MemoryID:
AppClass: KA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VICTIM

MSSXEDEADLCK-SPID table field - MS SQL Server process ID ▼

Description: MS SQL Server process ID
Field Name: SPID
Data Element: MSSSPID
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 SPID

MSSXEDEADLCK-DB table field - Database name ▼

Description: Database name
Field Name: DB
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

MSSXEDEADLCK-WAITRESOURCE table field - Wait Resource as seen in sysprocesses ▼

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

MSSXEDEADLCK-WAITTIME table field - Process wait time ▼

Description: Process wait time
Field Name: WAITTIME
Data Element: MSSDLWAITTM
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

MSSXEDEADLCK-HOSTNAME table field - Application server name ▼

Description: Application server name
Field Name: HOSTNAME
Data Element: MSSAPPHOST
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSHOST
MemoryID:
AppClass: STSK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

MSSXEDEADLCK-HOSTPID 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: HOSTPID
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 HOSTPID

MSSXEDEADLCK-LOGINNAME table field - Login name ▼

Description: Login name
Field Name: LOGINNAME
Data Element: MSSLOGINNAME
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 LOGINNAME

MSSXEDEADLCK-INPUTBUF table field - Output from DBCC INPUTBUFFER for lock display ▼

Description: Output from DBCC INPUTBUFFER for lock display
Field Name: INPUTBUF
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 INPUTBUF

MSSXEDEADLCK-TXACTNAME table field - Transaction name ▼

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

See all SAP tables containing field TXACTNAME

MSSXEDEADLCK-OWNEROBJNAME table field - Owner object name ▼

Description: Owner object name
Field Name: OWNEROBJNAME
Data Element: MSSOWNOBJ
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OWNEROBJNAME

MSSXEDEADLCK-OWNERINDNAME table field - Owner index name ▼

Description: Owner index name
Field Name: OWNERINDNAME
Data Element: MSSOWNIND
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OWNERINDNAME

MSSXEDEADLCK-OWNERMODE table field - Owner mode ▼

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

See all SAP tables containing field OWNERMODE

MSSXEDEADLCK-WAITEROBJNAME table field - Waiter object name ▼

Description: Waiter object name
Field Name: WAITEROBJNAME
Data Element: MSSWAITEROBJ
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITEROBJNAME

MSSXEDEADLCK-WAITERINDNAME table field - Waiter index name ▼

Description: Waiter index name
Field Name: WAITERINDNAME
Data Element: MSSWAITERIND
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITERINDNAME

MSSXEDEADLCK-WAITERMODE table field - Waiter mode ▼

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

See all SAP tables containing field WAITERMODE

MSSXEDEADLCK-DEADLOCKGRAPH table field - Deadlock graph ▼

Description: Deadlock graph
Field Name: DEADLOCKGRAPH
Data Element: MSSDLGRAPH
Data Type: STRG
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name: STRING
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEADLOCKGRAPH

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

MSSXEDEADLCK-STMT_START_OFFSET table field - Start statement offset ▼

Description: Start statement offset
Field Name: STMT_START_OFFSET
Data Element: MSSSTARTOFFSET
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 STMT_START_OFFSET

MSSXEDEADLCK-STMT_END_OFFSET table field - Statement end offset ▼

Description: Statement end offset
Field Name: STMT_END_OFFSET
Data Element: MSSENDOFFSET
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 STMT_END_OFFSET

View list of all SAP tables(S4H/ECC)

Select data from SAP table