SAP Table MSSDEADLCK
Database Deadlock Information for MSSQL Server
The table MSSDEADLCK (Database Deadlock Information for MSSQL Server) is a standard table in SAP ERP.
It belongs to the package STUS.
Technical Information
Table |
MSSDEADLCK |
Short Text |
Database Deadlock Information for MSSQL Server |
Package |
STUS
|
Table Type |
Transparent Table
|
Fields for Table MSSDEADLCK
Field Name |
Key |
Description |
Data Element |
Type |
Length |
Check Table |
OCCURTSTMP |
✔ |
Timestamp for deadlock tracking |
MSSTSTMP |
CHAR |
14 |
|
SPID |
✔ |
MS SQL Server process ID |
MSSSPID |
INT2 |
5 |
|
SPNAME |
|
Stored procedure name |
MSSSPNAME |
CHAR |
128 |
|
ABAPREPORT |
|
Name of the ABAP report |
MSSABNAME |
CHAR |
40 |
|
ABAPLOCAT |
|
Offset of a Processing Control Block |
ABP_CONT |
INT4 |
10 |
|
HOSTNAME |
|
Name of Application Server |
MSHOST2 |
CHAR |
32 |
|
HOSTPID |
|
Process ID on app. server |
MSSHPID |
INT4 |
10 |
|
WP_NUM |
|
Work process number |
MSSWPNUM |
INT4 |
10 |
|
WP_TYPE |
|
Work process type |
MSSWPTYPE |
CHAR |
2 |
|
WINNER |
|
Survivor of deadlock flag |
MSSWINNER |
CHAR |
1 |
|
SEQ |
|
Deadlock sequence number |
MSSSEQ |
INT4 |
10 |
|
TNAME |
|
Table name |
MSSTABLE |
CHAR |
128 |
|
MESSAGE |
|
Deadlock message |
MSSMSG |
CHAR |
255 |
|
TCODE |
|
Transaction code |
MSSTCODE |
CHAR |
20 |
* |