SXMSMSGLST_SORTED SAP (Sorted Message List) Structure details

Dictionary Type: Structure
Description: Sorted Message List




ABAP Code to SELECT data from SXMSMSGLST_SORTED
Related tables to SXMSMSGLST_SORTED
Access table SXMSMSGLST_SORTED




Structure field list including key, data, relationships and ABAP select examples

SXMSMSGLST_SORTED is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Sorted Message List" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_SXMSMSGLST_SORTED TYPE SXMSMSGLST_SORTED.

The SXMSMSGLST_SORTED table consists of various fields, each holding specific information or linking keys about Sorted Message List data available in SAP. These include MANDT (Client ID), MSGGUID (XI: Message ID), PID (Integration Engine: Pipeline ID), MSGTYPE (Integration Engine: Message Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP SXMSMSGLST_SORTED structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
SORTINDEXSort Index SXMXINDEXINT410SXMXINDEX
MANDTClient ID SYMANDTCLNT3Assigned to domainMANDT
MSGGUIDXI: Message ID SXMSMGUIDRAW16SYSUUID
PIDIntegration Engine: Pipeline ID SXMSPIDCHAR40Assigned to domainSXMSPID
MSGTYPEIntegration Engine: Message Type SXMSPMTYPECHAR1SXMSPMTYPE
MSGSTATEIntegration Engine: Message Status SXMSPMSTATNUMC3Assigned to domainSXMSPMSTAT
QOSMODEIntegration Engine: Quality of Service SXMSQOSCHAR4SXMSQOS
EXETIMESTUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
INITTIMESTUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
SENDTIMESTUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
SNDRGUIDSender ID SXMSSNDRIDRAW16SYSUUID
QUEUEGUIDID for Message Queue SXMSQIDCHAR32SXMSQID
EO_REFIDIntegration Engine: Reference Type SXMSREFIDCHAR8SXMSREFID
EO_REFVALIntegration Engine: Reference Value SXMSREFVALCHAR32
ADAPT_TYPPipeline Service Type SXMSPSTYPECHAR10SXMSPSTYPE
ADAPT_STATIntegration Engine: Adapter Status SXMSPASTATNUMC3SXMSPASTAT
PARENTMSGXI: Message ID SXMSMGUIDRAW16SYSUUID
CHILDCOUNTNumc3, internal use NUMC3NUMC3NUMC3
CLIENTClient ID SYMANDTCLNT3Assigned to domainMANDT
ADMINUSERUser Name SYUNAMECHAR12SYCHAR12
GEN_ENTRYXMS: Flag (true/false) SXMSFLAGCHAR1SXMSFLAG
MANUALSTATXMS: Flag (true/false) SXMSFLAGCHAR1SXMSFLAG
RETRYCOUNTNumc3, internal use NUMC3NUMC3NUMC3
ITFACTIONIntegration Engine: Action for Interface SXMSITFACTCHAR4SXMSITFACT
COMMITACTXMS: Flag (true/false) SXMSFLAGCHAR1SXMSFLAG
EO_REFID_IIntegration Engine: Reference Type SXMSREFIDCHAR8SXMSREFID
EO_REFVL_IIntegration Engine: Reference Value SXMSREFVALCHAR32
ADAPT_TP_IPipeline Service Type SXMSPSTYPECHAR10SXMSPSTYPE
REST_VERSSequence Number for a Message Log ID SXMSLSQNBRNUMC3
EO_REFID_OIntegration Engine: Reference Type SXMSREFIDCHAR8SXMSREFID
EO_REFVL_OIntegration Engine: Reference Value SXMSREFVALCHAR32
QUEUEINTName of tRFC Queue TRFCQNAMCHAR24TRFCQNAM
REF_TO_MSGXI: Message ID SXMSMGUIDRAW16SYSUUID
REF_TO_REC_MSGXI: Message ID SXMSMGUIDRAW16SYSUUID
ACK_STATEXI: Acknowledgment Status SXMSPACKSTATNUMC3SXMSPACKSTAT
REORGReorganization Status SXMSREORGCHAR3SXMSREORG
RND_NUMBERRandom Number for Integration Engine Messages SXMSRNDNUMNUMC2SXMSRNDNUM
VERSSequence Number for a Message Log ID SXMSLSQNBRNUMC3
SECURITYSecurity Flag SXMSSECURITYNUMC1SXMSSECURITY
WS_HASH_CODEMessage ID Hash Code WS_MSGID_HASH_CODEINT410WS_MSGID_HASH_CODE
RETRYCOUNT_MANManual Retry Counter SXMS_MAN_RETRYCOINT410SXMS_MAN_RETRYCO
USERINFOSTORAGEUnique Identifier for Saving USERINFO Metadata USERINFO_GUIDRAW16SYSUUID
USERINFODATAKey for Engine Look Up Table SXMS_ENGINE_KEYRAW16SYSUUID
MSG_SIZEMessage Size SXMS_SIZE_MSGDEC20SXMS_SIZE_MSG
BULK_ERRORError in Bulk SXMS_BULK_ERRORCHAR1SXMS_BULK_ERROR
HOSTApplication Server SYHOSTCHAR32HOST_ID
OB_SYSTEMSending System AIT_SNDRCHAR60AIT_SYSTEM
OB_NSOutbound Interface Namespace RM_OIFNSCHAR255SAI_NSPCE
OB_NAMEOutbound Interface Name RM_OIFNAMECHAR120AIT_INTF
OB_PARTYXI: Communication Party SXI_PARTYCHAR60SXI_PARTY
OB_PARTY_TYPEXI Partner: Identification Schema SXI_PARTY_TYPECHAR120SXI_PARTY_TYPE
OB_PARTY_AGENCYXI Partner: Agency SXI_PARTY_AGENCYCHAR120SXI_PARTY_AGENCY
OB_OPERATIONOperation of Service Interface SXI_OPERATIONCHAR120SXI_OPERATION
IB_SYSTEMReceiving System AIT_RCVRCHAR60AIT_SYSTEM
IB_NSInbound Interface Namespace RM_IIFNSCHAR255SAI_NSPCE
IB_NAMEInbound Interface Name RM_IIFNAMECHAR120AIT_INTF
IB_PARTYXI: Communication Party SXI_PARTYCHAR60SXI_PARTY
IB_PARTY_TYPEXI Partner: Identification Schema SXI_PARTY_TYPECHAR120SXI_PARTY_TYPE
IB_PARTY_AGENCYXI Partner: Agency SXI_PARTY_AGENCYCHAR120SXI_PARTY_AGENCY
IB_OPERATIONOperation of Service Interface SXI_OPERATIONCHAR120SXI_OPERATION
JOB_IDJob ID SXMSJOBCHAR32SXMS_PRG_JOB_ID_ALL
STATUSJob Processing Status SXMSMSGREFSTATUSCHAR1SXMSMSGREFSTATUS
ERRCATXI: Error Category SXMSERRCATCHAR20TEXT20
ERRCODEXI: Error ID SXMSERRIDCHAR30
ERRLABELXI: Status Detail: Description SXMSERRLABELTXTCHAR255SXMSERRLABELTXT

Key field Non-key field



How do I retrieve data from SAP structure SXMSMSGLST_SORTED using ABAP code?

As SXMSMSGLST_SORTED is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SXMSMSGLST_SORTED as there is no data to select.

How to access SAP table SXMSMSGLST_SORTED

Within an ECC or HANA version of SAP you can also view further information about SXMSMSGLST_SORTED and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!