1. Home
  2. Resources
  3. SAP Tables
  4. SXMSPMAST2 - XML Message Broker: Message Queue (Master) (Switch Table)

SAP Table SXMSPMAST2

XML Message Broker: Message Queue (Master) (Switch Table)

SXMSPMAST2 (XML Message Broker: Message Queue (Master) (Switch Table)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SXMSPMAST2 to other SAP tables.

SXMSPMAST2 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client ID SYMANDT CLNT 3 0
MSGGUID XI: Message ID SXMSMGUID RAW 16 0
PID Integration Engine: Pipeline ID SXMSPID CHAR 40 0
MSGTYPE Integration Engine: Message Type SXMSPMTYPE CHAR 1 0
A Asynchronous Message
S Synchronous Message
MSGSTATE Integration Engine: Message Status SXMSPMSTAT NUMC 3 0
QOSMODE Integration Engine: Quality of Service SXMSQOS CHAR 4 0
BE Best Effort
EO Exactly Once
EOIO Exactly Once In Order
EXETIMEST UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPL DEC 21 7
INITTIMEST UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPL DEC 21 7
SENDTIMEST UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPL DEC 21 7
SNDRGUID Sender ID SXMSSNDRID RAW 16 0
QUEUEGUID ID for Message Queue SXMSQID CHAR 32 0
EO_REFID Integration Engine: Reference Type SXMSREFID CHAR 8 0
TID Transaction ID
MSGID Message ID
AMF Area Message Format
BGRFCTID BG RFC Transaction ID
EO_REFVAL Integration Engine: Reference Value SXMSREFVAL CHAR 32 0
ADAPT_TYP Pipeline Service Type SXMSPSTYPE CHAR 10 0
IENGINE Integration Engine
IDOC IDoc Adapter
=SWITCH= Dynamic Selection of an Adapter at Runtime
PLAINHTTP Adapter for Sending a Message Without Control Information
PROXY Proxy Framework
AENGINE Adapter Engine
PE Process Engine
SA_COMM Coupling Between Synchronous and Asynchronous Processing
WS Web Service
IS_URL Decentral Integration Engine
ADAPT_STAT Integration Engine: Adapter Status SXMSPASTAT NUMC 3 0
001 Message scheduled on outbound side
006 Message executed successfully on outbound side
008 Message being executed on outbound side
007 Message has error status on outbound side
PARENTMSG XI: Message ID SXMSMGUID RAW 16 0
CHILDCOUNT Numc3, internal use NUMC3 NUMC 3 0
CLIENT Client ID SYMANDT CLNT 3 0
ADMINUSER User Name SYUNAME CHAR 12 0
GEN_ENTRY XMS: Flag (true/false) SXMSFLAG CHAR 1 0
0 No (False)
1 Yes (True)
X Set (True)
MANUALSTAT XMS: Flag (true/false) SXMSFLAG CHAR 1 0
0 No (False)
1 Yes (True)
X Set (True)
RETRYCOUNT Numc3, internal use NUMC3 NUMC 3 0
ITFACTION Integration Engine: Action for Interface SXMSITFACT CHAR 4 0
ARCH Archive
DEL Delete
INIT Delete (Initial Value)
XRCH Archive First Version Only (Manually Changed Messages)
XACH Archive First Version Only
COMMITACT XMS: Flag (true/false) SXMSFLAG CHAR 1 0
0 No (False)
1 Yes (True)
X Set (True)
EO_REFID_I Integration Engine: Reference Type SXMSREFID CHAR 8 0
TID Transaction ID
MSGID Message ID
AMF Area Message Format
BGRFCTID BG RFC Transaction ID
EO_REFVL_I Integration Engine: Reference Value SXMSREFVAL CHAR 32 0
ADAPT_TP_I Pipeline Service Type SXMSPSTYPE CHAR 10 0
IENGINE Integration Engine
IDOC IDoc Adapter
=SWITCH= Dynamic Selection of an Adapter at Runtime
PLAINHTTP Adapter for Sending a Message Without Control Information
PROXY Proxy Framework
AENGINE Adapter Engine
PE Process Engine
SA_COMM Coupling Between Synchronous and Asynchronous Processing
WS Web Service
IS_URL Decentral Integration Engine
REST_VERS Sequence Number for a Message Log ID SXMSLSQNBR NUMC 3 0
EO_REFID_O Integration Engine: Reference Type SXMSREFID CHAR 8 0
TID Transaction ID
MSGID Message ID
AMF Area Message Format
BGRFCTID BG RFC Transaction ID
EO_REFVL_O Integration Engine: Reference Value SXMSREFVAL CHAR 32 0
QUEUEINT Name of tRFC Queue TRFCQNAM CHAR 24 0
REF_TO_MSG XI: Message ID SXMSMGUID RAW 16 0
REF_TO_REC_MSG XI: Message ID SXMSMGUID RAW 16 0
ACK_STATE XI: Acknowledgment Status SXMSPACKSTAT NUMC 3 0
001 No Acknowledgment Received
002 Acknowledgement: Application Executed Successfully
003 Acknowledgement: Message with Application Error
004 Acknowledgement: System Error in Request Message
005 Acknowledgement: System Error in ACK Message
006 Acknowledgement: Message Delivered to Target System
007 Acknowledgement: Transport ACK not Possible
008 Acknowledgement: Execution ACK Possible
009 Acknowledgement: Message to Multiple Receivers
REORG Reorganization Status SXMSREORG CHAR 3 0
MFA Selected for Archiving
MFD Selected for Deletion
DEL Deleted
ARC Archived
INI Initial
COP Copied
RND_NUMBER Random Number for Integration Engine Messages SXMSRNDNUM NUMC 2 0
VERS Sequence Number for a Message Log ID SXMSLSQNBR NUMC 3 0
SECURITY Security Flag SXMSSECURITY NUMC 1 0
WS_HASH_CODE Message ID Hash Code WS_MSGID_HASH_CODE INT4 10 0
RETRYCOUNT_MAN Manual Retry Counter SXMS_MAN_RETRYCO INT4 10 0
USERINFOSTORAGE Unique Identifier for Saving USERINFO Metadata USERINFO_GUID RAW 16 0
USERINFODATA Key for Engine Look Up Table SXMS_ENGINE_KEY RAW 16 0
MSG_SIZE Message Size SXMS_SIZE_MSG DEC 20 0
BULK_ERROR Error in Bulk SXMS_BULK_ERROR CHAR 1 0
HOST Application Server SYHOST CHAR 32 0