SAP Table MSSDEADLCK
Database Deadlock Information for MSSQL Server
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
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 | * |