SAP Table SXMSPMAST

Integration Engine: Message Queue (Master)

The table SXMSPMAST (Integration Engine: Message Queue (Master)) is a standard table in SAP ERP. It belongs to the package SXMSPERSIST.

Technical Information

Table	SXMSPMAST
Short Text	Integration Engine: Message Queue (Master)
Package	SXMSPERSIST
Table Type	Transparent Table

Fields for Table SXMSPMAST

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client ID	SYMANDT	CLNT	3	*
MSGGUID	✔	XI: Message ID	SXMSMGUID	RAW	16
PID	✔	Integration Engine: Pipeline ID	SXMSPID	CHAR	40	*
MSGTYPE		Integration Engine: Message Type	SXMSPMTYPE	CHAR	1
MSGSTATE		Integration Engine: Message Status	SXMSPMSTAT	NUMC	3	*
QOSMODE		Integration Engine: Quality of Service	SXMSQOS	CHAR	4
EXETIMEST		UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	TIMESTAMPL	DEC	21
INITTIMEST		UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	TIMESTAMPL	DEC	21
SENDTIMEST		UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	TIMESTAMPL	DEC	21
SNDRGUID		Sender ID	SXMSSNDRID	RAW	16
QUEUEGUID		ID for Message Queue	SXMSQID	CHAR	32
EO_REFID		Integration Engine: Reference Type	SXMSREFID	CHAR	8
EO_REFVAL		Integration Engine: Reference Value	SXMSREFVAL	CHAR	32
ADAPT_TYP		Pipeline Service Type	SXMSPSTYPE	CHAR	10
ADAPT_STAT		Integration Engine: Adapter Status	SXMSPASTAT	NUMC	3
PARENTMSG		XI: Message ID	SXMSMGUID	RAW	16
CHILDCOUNT		Numc3, internal use	NUMC3	NUMC	3
CLIENT		Client ID	SYMANDT	CLNT	3	*
ADMINUSER		User Name	SYUNAME	CHAR	12
GEN_ENTRY		XMS: Flag (true/false)	SXMSFLAG	CHAR	1
MANUALSTAT		XMS: Flag (true/false)	SXMSFLAG	CHAR	1
RETRYCOUNT		Numc3, internal use	NUMC3	NUMC	3
ITFACTION		Integration Engine: Action for Interface	SXMSITFACT	CHAR	4
COMMITACT		XMS: Flag (true/false)	SXMSFLAG	CHAR	1
EO_REFID_I		Integration Engine: Reference Type	SXMSREFID	CHAR	8
EO_REFVL_I		Integration Engine: Reference Value	SXMSREFVAL	CHAR	32
ADAPT_TP_I		Pipeline Service Type	SXMSPSTYPE	CHAR	10
REST_VERS		Sequence Number for a Message Log ID	SXMSLSQNBR	NUMC	3
EO_REFID_O		Integration Engine: Reference Type	SXMSREFID	CHAR	8
EO_REFVL_O		Integration Engine: Reference Value	SXMSREFVAL	CHAR	32
QUEUEINT		Name of tRFC Queue	TRFCQNAM	CHAR	24
REF_TO_MSG		XI: Message ID	SXMSMGUID	RAW	16
REF_TO_REC_MSG		XI: Message ID	SXMSMGUID	RAW	16
ACK_STATE		XI: Acknowledgment Status	SXMSPACKSTAT	NUMC	3
REORG		Reorganization Status	SXMSREORG	CHAR	3
RND_NUMBER		Random Number for Integration Engine Messages	SXMSRNDNUM	NUMC	2
VERS		Sequence Number for a Message Log ID	SXMSLSQNBR	NUMC	3
SECURITY		Security Flag	SXMSSECURITY	NUMC	1
WS_HASH_CODE		Message ID Hash Code	WS_MSGID_HASH_CODE	INT4	10
RETRYCOUNT_MAN		Manual Retry Counter	SXMS_MAN_RETRYCO	INT4	10
USERINFOSTORAGE		Unique Identifier for Saving USERINFO Metadata	USERINFO_GUID	RAW	16
USERINFODATA		Key for Engine Look Up Table	SXMS_ENGINE_KEY	RAW	16
MSG_SIZE		Message Size	SXMS_SIZE_MSG	DEC	20
BULK_ERROR		Error in Bulk	SXMS_BULK_ERROR	CHAR	1
HOST		Application Server	SYHOST	CHAR	32