SAP ABAP Table SXMSPMAST2 (XML Message Broker: Message Queue (Master) (Switch Table))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-XI-IS-IEN (Application Component) Integration Engine
     ⤷ SXMSPERSIST (Package) XI: Integration Engine Persistence Layer

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SXMSPMAST2	Table Relationship Diagram
Short Description	XML Message Broker: Message Queue (Master) (Switch Table)

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	MANDT	☑	SYMANDT	MANDT	CLNT	3	0	Client ID	*
2	MSGGUID	☑	SXMSMGUID	SYSUUID	RAW	16	0	XI: Message ID
3	PID	☑	SXMSPID	SXMSPID	CHAR	40	0	Integration Engine: Pipeline ID	*
4	MSGTYPE	☐	SXMSPMTYPE	SXMSPMTYPE	CHAR	1	0	Integration Engine: Message Type
5	MSGSTATE	☐	SXMSPMSTAT	SXMSPMSTAT	NUMC	3	0	Integration Engine: Message Status	*
6	QOSMODE	☐	SXMSQOS	SXMSQOS	CHAR	4	0	Integration Engine: Quality of Service
7	EXETIMEST	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
8	INITTIMEST	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
9	SENDTIMEST	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
10	SNDRGUID	☐	SXMSSNDRID	SYSUUID	RAW	16	0	Sender ID
11	QUEUEGUID	☐	SXMSQID	SXMSQID	CHAR	32	0	ID for Message Queue
12	EO_REFID	☐	SXMSREFID	SXMSREFID	CHAR	8	0	Integration Engine: Reference Type
13	EO_REFVAL	☐	SXMSREFVAL		CHAR	32	0	Integration Engine: Reference Value
14	ADAPT_TYP	☐	SXMSPSTYPE	SXMSPSTYPE	CHAR	10	0	Pipeline Service Type
15	ADAPT_STAT	☐	SXMSPASTAT	SXMSPASTAT	NUMC	3	0	Integration Engine: Adapter Status
16	PARENTMSG	☐	SXMSMGUID	SYSUUID	RAW	16	0	XI: Message ID
17	CHILDCOUNT	☐	NUMC3	NUMC3	NUMC	3	0	Numc3, internal use
18	CLIENT	☐	SYMANDT	MANDT	CLNT	3	0	Client ID	*
19	ADMINUSER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
20	GEN_ENTRY	☐	SXMSFLAG	SXMSFLAG	CHAR	1	0	XMS: Flag (true/false)
21	MANUALSTAT	☐	SXMSFLAG	SXMSFLAG	CHAR	1	0	XMS: Flag (true/false)
22	RETRYCOUNT	☐	NUMC3	NUMC3	NUMC	3	0	Numc3, internal use
23	ITFACTION	☐	SXMSITFACT	SXMSITFACT	CHAR	4	0	Integration Engine: Action for Interface
24	COMMITACT	☐	SXMSFLAG	SXMSFLAG	CHAR	1	0	XMS: Flag (true/false)
25	EO_REFID_I	☐	SXMSREFID	SXMSREFID	CHAR	8	0	Integration Engine: Reference Type
26	EO_REFVL_I	☐	SXMSREFVAL		CHAR	32	0	Integration Engine: Reference Value
27	ADAPT_TP_I	☐	SXMSPSTYPE	SXMSPSTYPE	CHAR	10	0	Pipeline Service Type
28	REST_VERS	☐	SXMSLSQNBR		NUMC	3	0	Sequence Number for a Message Log ID
29	EO_REFID_O	☐	SXMSREFID	SXMSREFID	CHAR	8	0	Integration Engine: Reference Type
30	EO_REFVL_O	☐	SXMSREFVAL		CHAR	32	0	Integration Engine: Reference Value
31	QUEUEINT	☐	TRFCQNAM	TRFCQNAM	CHAR	24	0	Name of tRFC Queue
32	REF_TO_MSG	☐	SXMSMGUID	SYSUUID	RAW	16	0	XI: Message ID
33	REF_TO_REC_MSG	☐	SXMSMGUID	SYSUUID	RAW	16	0	XI: Message ID
34	ACK_STATE	☐	SXMSPACKSTAT	SXMSPACKSTAT	NUMC	3	0	XI: Acknowledgment Status
35	REORG	☐	SXMSREORG	SXMSREORG	CHAR	3	0	Reorganization Status
36	RND_NUMBER	☐	SXMSRNDNUM	SXMSRNDNUM	NUMC	2	0	Random Number for Integration Engine Messages
37	VERS	☐	SXMSLSQNBR		NUMC	3	0	Sequence Number for a Message Log ID
38	SECURITY	☐	SXMSSECURITY	SXMSSECURITY	NUMC	1	0	Security Flag
39	WS_HASH_CODE	☐	WS_MSGID_HASH_CODE	WS_MSGID_HASH_CODE	INT4	10	0	Message ID Hash Code
40	RETRYCOUNT_MAN	☐	SXMS_MAN_RETRYCO	SXMS_MAN_RETRYCO	INT4	10	0	Manual Retry Counter
41	USERINFOSTORAGE	☐	USERINFO_GUID	SYSUUID	RAW	16	0	Unique Identifier for Saving USERINFO Metadata
42	USERINFODATA	☐	SXMS_ENGINE_KEY	SYSUUID	RAW	16	0	Key for Engine Look Up Table
43	MSG_SIZE	☐	SXMS_SIZE_MSG	SXMS_SIZE_MSG	DEC	20	0	Message Size
44	BULK_ERROR	☐	SXMS_BULK_ERROR	SXMS_BULK_ERROR	CHAR	1	0	Error in Bulk
45	HOST	☐	SYHOST	HOST_ID	CHAR	32	0	Application Server

History

Last changed by/on	SAP	20141013
SAP Release Created in	620