SXI_MSG_SELECT SAP (XI/WS: Structure for Message Selection in Database (Master)) Structure details

Dictionary Type: Structure
Description: XI/WS: Structure for Message Selection in Database (Master)




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




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

SXI_MSG_SELECT 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 "XI/WS: Structure for Message Selection in Database (Master)" 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_SXI_MSG_SELECT TYPE SXI_MSG_SELECT.

The SXI_MSG_SELECT table consists of various fields, each holding specific information or linking keys about XI/WS: Structure for Message Selection in Database (Master) data available in SAP. These include SENDTIME (System Time), SND2DATE (System Date), SND2TIME (System Time), EXEDATE (System Date).. 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: Cannot Be Enhanced


SAP SXI_MSG_SELECT 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
SENDDATESystem Date SYDATUMDATS8SYDATS
SENDTIMESystem Time SYUZEITTIMS6SYTIME
SND2DATESystem Date SYDATUMDATS8SYDATS
SND2TIMESystem Time SYUZEITTIMS6SYTIME
EXEDATESystem Date SYDATUMDATS8SYDATS
EXETIMESystem Time SYUZEITTIMS6SYTIME
EXE2DATESystem Date SYDATUMDATS8SYDATS
EXE2TIMESystem Time SYUZEITTIMS6SYTIME
INITDATESystem Date SYDATUMDATS8SYDATS
INITTIMESystem Time SYUZEITTIMS6SYTIME
INI2DATESystem Date SYDATUMDATS8SYDATS
INI2TIMESystem Time SYUZEITTIMS6SYTIME
PIDS 0
CLIENTClient ID SYMANDTCLNT3Assigned to domainMANDT
ADMINUSERUser Name SYUNAMECHAR12SYCHAR12
ADAPTER_TYPEPipeline Service Type SXMSPSTYPECHAR10SXMSPSTYPE
ADAPTER_TYPE_INPipeline Service Type SXMSPSTYPECHAR10SXMSPSTYPE
ADAPTER_STATEIntegration Engine: Adapter Status SXMSPASTATNUMC3SXMSPASTAT
SENDER_RECEIVER 0
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
MSGSTATE_TAB 0
QUEUEIDName of tRFC Queue TRFCQNAMCHAR24TRFCQNAM
MSGGUID_TAB 0
ERRCATXI: Error Category SXMSERRCATCHAR20TEXT20
EO_REFIDIntegration Engine: Reference Type SXMSREFIDCHAR8SXMSREFID
ERRCODEXI: Error ID SXMSERRIDCHAR30
EO_REFVALIntegration Engine: Reference Value SXMSREFVALCHAR32
MAN_RETRYCOManual Retry Counter SXMS_MAN_RETRYCOINT410SXMS_MAN_RETRYCO
MSGSTATE_TAB 0
QUEUEIDName of tRFC Queue TRFCQNAMCHAR24TRFCQNAM
MSG_TYPEIntegration Engine: Message Type SXMSPMTYPECHAR1SXMSPMTYPE
EO_REFIDIntegration Engine: Reference Type SXMSREFIDCHAR8SXMSREFID
PARENT_MSG_TAB 0
EO_REFVALIntegration Engine: Reference Value SXMSREFVALCHAR32
REF_TO_MSG_TAB 0
QUEUEGUIDID for Message Queue SXMSQIDCHAR32SXMSQID
MAN_RETRYCOManual Retry Counter SXMS_MAN_RETRYCOINT410SXMS_MAN_RETRYCO
MSG_TYPEIntegration Engine: Message Type SXMSPMTYPECHAR1SXMSPMTYPE
PARENT_MSG_TAB 0
REF_TO_MSG_TAB 0
QUEUEGUIDID for Message Queue SXMSQIDCHAR32SXMSQID
MANUALSTATXMS: Flag (true/false) SXMSFLAGCHAR1SXMSFLAG
EXTR_DATA 0
USE_ORXMS: Flag (true/false) SXMSFLAGCHAR1SXMSFLAG
ERRLABELXI: Status Detail: Identifier SXMSERRLABELIDNUMC10Assigned to domainSXMSERRLABELIDSXMSAGGERRLABEL

Key field Non-key field



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

As SXI_MSG_SELECT 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 SXI_MSG_SELECT as there is no data to select.

How to access SAP table SXI_MSG_SELECT

Within an ECC or HANA version of SAP you can also view further information about SXI_MSG_SELECT 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!