SAP MSSDEADLCK table - Database Deadlock Information for MSSQL Server details in SAP


SAP MSSDEADLCK table summary

Object Name: MSSDEADLCK
Dictionary Type: Transparent table
Description: Database Deadlock Information for MSSQL Server


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

Details
MSSDEADLCK-OCCURTSTMP table field - Timestamp for deadlock tracking

Description: Timestamp for deadlock tracking
Field Name: OCCURTSTMP
Data Element: MSSTSTMP
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: MSSTSTMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OCCURTSTMP

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

MSSDEADLCK-SPNAME table field - Stored procedure name

Description: Stored procedure name
Field Name: SPNAME
Data Element: MSSSPNAME
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPNAME

MSSDEADLCK-ABAPREPORT table field - Name of the ABAP report

Description: Name of the ABAP report
Field Name: ABAPREPORT
Data Element: MSSABNAME
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: PROGNAME
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ABAPREPORT

MSSDEADLCK-ABAPLOCAT table field - Offset of a Processing Control Block

Description: Offset of a Processing Control Block
Field Name: ABAPLOCAT
Data Element: ABP_CONT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ABAPLOCAT

MSSDEADLCK-HOSTNAME table field - Name of the Host Server

Description: Name of the Host Server
Field Name: HOSTNAME
Data Element: MSHOST2
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: MSHOST2
MemoryID:
AppClass: STSK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

MSSDEADLCK-HOSTPID table field - Process ID on app. server

Description: Process ID on app. server
Field Name: HOSTPID
Data Element: MSSHPID
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 HOSTPID

MSSDEADLCK-WP_NUM table field - Work process number

Description: Work process number
Field Name: WP_NUM
Data Element: MSSWPNUM
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 WP_NUM

MSSDEADLCK-WP_TYPE table field - Work process type

Description: Work process type
Field Name: WP_TYPE
Data Element: MSSWPTYPE
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: MSSWPTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WP_TYPE

MSSDEADLCK-WINNER table field - Survivor of deadlock flag

Description: Survivor of deadlock flag
Field Name: WINNER
Data Element: MSSWINNER
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: MSSWINNER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WINNER

MSSDEADLCK-SEQ table field - Deadlock sequence number

Description: Deadlock sequence number
Field Name: SEQ
Data Element: MSSSEQ
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 SEQ

MSSDEADLCK-TNAME table field - Table name

Description: Table name
Field Name: TNAME
Data Element: MSSTABLE
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 TNAME

MSSDEADLCK-MESSAGE table field - Deadlock message

Description: Deadlock message
Field Name: MESSAGE
Data Element: MSSMSG
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: MSSMSG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MESSAGE

MSSDEADLCK-TCODE table field - Transaction code

Description: Transaction code
Field Name: TCODE
Data Element: MSSTCODE
Data Type: CHAR
length (Dec): 20(0)
Check table: *
Conversion Routine:
Domain Name: TCODE
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TCODE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table