SAP Table SXMSMSGDSP

XML Message Formatting for Display in ALV

SXMSMSGDSP (XML Message Formatting for Display in ALV) 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 SXMSMSGDSP to other SAP tables.

Source: SXMSMSGDSP (XML Message Formatting for Display in ALV)

SXMSMSGDSP 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
OB_SYSTEM Sending System AIT_SNDR CHAR 60 0
OB_NS Outbound Interface Namespace RM_OIFNS CHAR 255 0
OB_NAME Outbound Interface Name RM_OIFNAME CHAR 120 0
OB_PARTY XI: Communication Party SXI_PARTY CHAR 60 0
OB_PARTY_TYPE XI Partner: Identification Schema SXI_PARTY_TYPE CHAR 120 0
OB_PARTY_AGENCY XI Partner: Agency SXI_PARTY_AGENCY CHAR 120 0
OB_OPERATION Operation of Service Interface SXI_OPERATION CHAR 120 0
IB_SYSTEM Receiving System AIT_RCVR CHAR 60 0
IB_NS Inbound Interface Namespace RM_IIFNS CHAR 255 0
IB_NAME Inbound Interface Name RM_IIFNAME CHAR 120 0
IB_PARTY XI: Communication Party SXI_PARTY CHAR 60 0
IB_PARTY_TYPE XI Partner: Identification Schema SXI_PARTY_TYPE CHAR 120 0
IB_PARTY_AGENCY XI Partner: Agency SXI_PARTY_AGENCY CHAR 120 0
IB_OPERATION Operation of Service Interface SXI_OPERATION CHAR 120 0
JOB_ID Job ID SXMSJOB CHAR 32 0
STATUS Job Processing Status SXMSMSGREFSTATUS CHAR 1 0
X Active
D Deleted
ERRCAT XI: Error Category SXMSERRCAT CHAR 20 0
ERRCODE XI: Error ID SXMSERRID CHAR 30 0
ERRLABEL XI: Status Detail: Description SXMSERRLABELTXT CHAR 255 0
STATICON Comment CHAR50 CHAR 50 0
ADAPICON Comment CHAR50 CHAR 50 0
ACKSTATICON Comment CHAR50 CHAR 50 0
INITDATE System Date SYDATUM DATS 8 0
INITTIME System Time SYUZEIT TIMS 6 0
EXEDATE System Date SYDATUM DATS 8 0
EXETIME System Time SYUZEIT TIMS 6 0
SENDDATE System Date SYDATUM DATS 8 0
SENDTIME System Time SYUZEIT TIMS 6 0
TYPETEXT Char 20 CHAR20 CHAR 20 0
VERSION Sequence Number for a Message Log ID SXMSLSQNBR NUMC 3 0
PELNAME Pipeline Element Name SXMPELNAME CHAR 60 0
LOG_ICON Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
INT_TIMEST UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPL DEC 21 7
INT_NUM Numc3, internal use NUMC3 NUMC 3 0
LINECOLOR Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
EXPANDED Single-Character Indicator CHAR1 CHAR 1 0
QUEUEICON Comment CHAR50 CHAR 50 0
QUEUESTATE Integration Engine: Queue Status SXMSPQSTAT NUMC 3 0
001 Queue Stopped
002 Message Has Errors
003 Message Waiting in Queue
004 Message Being Processed
REORGICON Comment CHAR50 CHAR 50 0
JOBICON Comment CHAR50 CHAR 50 0
DIRPARTY Party in Directory SWFDXIDIRPTY CHAR 60 0
DIRSERVICE Service(Process Name) in Directory SWFDXIDIRSRV CHAR 60 0
TASK ccBPM Process Definition SWF_XI_WF_ID CHAR 14 0
XI_PROXY XML Object Type: Name SWFDXMPNAM CHAR 30 0
WI_ID Work item ID SWW_WIID NUMC 12 0
BULKMESSAGE Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
MESSAGE_ID GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
PERSIST_ID GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
QUEUENAME Comment CHAR50 CHAR 50 0
ADAPTSTATICON Comment CHAR50 CHAR 50 0
AT1 Integration Engine: XML String SXMSSTRING STRG 0 0
AT2 Integration Engine: XML String SXMSSTRING STRG 0 0
AT3 Integration Engine: XML String SXMSSTRING STRG 0 0
AT4 Integration Engine: XML String SXMSSTRING STRG 0 0
AT5 Integration Engine: XML String SXMSSTRING STRG 0 0