SAP ABAP Table MSSDEADLCK (Database Deadlock Information for MSSQL Server)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MSSDEADLCK	Table Relationship Diagram
Short Description	Database Deadlock Information for MSSQL Server

Delivery and Maintenance

Pool/cluster
Delivery Class	S	System table, maint. only by SAP, change = modification
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	OCCURTSTMP	☑	MSSTSTMP	MSSTSTMP	CHAR	14	0	Timestamp for deadlock tracking
2	SPID	☑	MSSSPID	INT2	INT2	5	0	MS SQL Server process ID
3	SPNAME	☐	MSSSPNAME	CHAR128	CHAR	128	0	Stored procedure name
4	ABAPREPORT	☐	MSSABNAME	PROGNAME	CHAR	40	0	Name of the ABAP report
5	ABAPLOCAT	☐	ABP_CONT		INT4	10	0	Offset of a Processing Control Block
6	HOSTNAME	☐	MSHOST2	MSHOST2	CHAR	32	0	Name of the Host Server
7	HOSTPID	☐	MSSHPID	MSSINT4	INT4	10	0	Process ID on app. server
8	WP_NUM	☐	MSSWPNUM	MSSINT4	INT4	10	0	Work process number
9	WP_TYPE	☐	MSSWPTYPE	MSSWPTYPE	CHAR	2	0	Work process type
10	WINNER	☐	MSSWINNER	MSSWINNER	CHAR	1	0	Survivor of deadlock flag
11	SEQ	☐	MSSSEQ	MSSINT4	INT4	10	0	Deadlock sequence number
12	TNAME	☐	MSSTABLE	MSSSYSNAME	CHAR	128	0	Table name
13	MESSAGE	☐	MSSMSG	MSSMSG	CHAR	255	0	Deadlock message
14	TCODE	☐	MSSTCODE	TCODE	CHAR	20	0	Transaction code	*

History

Last changed by/on	SAP	20141013
SAP Release Created in