SAP Integration Engine Tables
Are you looking for the right table related to SAP Integration Engine Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Integration Engine (BC-XI-IS-IEN) module.
Top 10 tables in Integration Engine
| Table | Description |
|---|---|
| SXMSARCITF2 | XML Message: Archiving for Interface/NS |
| SXMS_QM | XML Message Broker: Queue Monitor |
| SXMSCXFTESTSEQU | CXF Interop Tests |
| SXMSMONSET | Selection Table for Integ. Engine Application Monitoring |
| SXMSPIPET | XMS: Pipeline Description |
| SXMS_QERROR_S | Queue Error Alert |
| SXMSHELP | Help Assistant |
| SXMSHELPT | Help Assistant (Short Text) |
| SXMS_HC_MSG | XI HC: msgkey store of all faulty XI-msgs /w ref to HC issue |
| SXMSSYERRT | XMS: Brief Description of System Error Error Codes |
List of tables in Integration Engine
| Table | Description |
|---|---|
| SXMSARCITF2 | XML Message: Archiving for Interface/NS |
| SXMS_QM | XML Message Broker: Queue Monitor |
| SXMSCXFTESTSEQU | CXF Interop Tests |
| SXMSMONSET | Selection Table for Integ. Engine Application Monitoring |
| SXMSPIPET | XMS: Pipeline Description |
| SXMS_QERROR_S | Queue Error Alert |
| SXMSHELP | Help Assistant |
| SXMSHELPT | Help Assistant (Short Text) |
| SXMS_HC_MSG | XI HC: msgkey store of all faulty XI-msgs /w ref to HC issue |
| SXMSSYERRT | XMS: Brief Description of System Error Error Codes |
| SXMSMETERAGGPART | Service Metering - partly aggregated records runtime inserts |
| SXMSBLKAGG | XMB: Aggregated Data for Package Statistics |
| SXMSCONFDF | XMS: Integration Engine Configuration Parameters |
| SXMSQUEUE_REORG | Storage Location for Queues That Are Being Reorganized |
| SXMS_HC_CONTROL | XI HC: Control Table |
| SXMS_HC_FIL_PAR | XI HC: Config Parameters |
| SXMS_WS_SYSERR | Qualified Names for System Error Fragments |
| SXMSQUEUESTATUS | Queue Status During Upgrade Phase |
| SXMSGLOBAL | Integration Engine: Obsolete |
| SXMS_EO_RETRY_ER | Automatic Retry Message Counter Table |
| SXMS_QERROR | Queue Error |
| SXMS_QUEUE_PRIO | Prioritized EOIO Queues |
| SXMSMETERAGGDEF | Service Metering - Definition of the Aggregation Record |
| SXMS_SND_RCV | Proxy: Sender-Receiver Determination |
| SXMSTRC_SEL | XMS: Selection Conditions for Trace Start |
| SXMSPLSRVT | XMS: Description of Pipeline Services |
| SXMS_HC_PAR_DEF | XI HC: Parameter definitions |
| SXMSINTF | XMB: Container for Application Monitoring (Template) |
| SXMSTSTRIG | Table of Troubleshooting Trigger |
| SXMSTSACT | Action Table for Integration Server Troubleshooting |
| SXMSPADM | XMS Pipeline: Execution Settings |
| SXMS_WS_SYSERSAP | Qualified Names for System Error Fragments |
| SXMSSYERR | XMS: System Error Error Codes |
| SXMS_BCONF_SPEC | Specific Packaging Configuration |
| SXMS_PACKCOUNT | Counter for Packaged Messages |
| SXMSPERFT | XMS: Monitor Table for Runtime Measurement |
| SXMSARCITF | XML Message Archiving |
| SXMS_FEH_LOG | Application Log for Forward Error Handling (FEH) |
| SXMS_SCOPY | WS/XI Log Table for System Copy |
| SXMSBULK | XML Message Broker: Bulk Statistics |
| SXMSTESTCHECK | Check-Table |
| SXMSTRANS_CONFIG | Configuration Table for Message Transfer |
| SXMSPERRO2 | XMB: Message Queue (Entries with Errors) (Switch Table) |
| SXMS_NAC_SA | SA-Bridge Enhancement for WS NAC Scenario |
| SXMSQUEUE_RCV | Mapping Queue Receiver |
| SXMSPHIST2 | XML Message Broker: History (Switch Table) |
| SXMSEPBUFFER | Exchange Profile Value Buffer |
| SXMSTRANS_HEADER | Lookup Table for Message Transfer |
| SXMSLOOKUPENGINE | Look Up Table for Engine Type and Engine Name |
| SXMSRECVT | Technical Receiver |
| SXMS_EXT_FIL | Filter for Extractors |
| SXMSCLUR2 | XMB: Resources Cluster (Switch Table) |
| SXMSPMAST | Integration Engine: Message Queue (Master) |
| SXMS_ESOA_DEST | Test Configuration for IS Short Cut |
| SXMS_QERROR_Q | Configuration: Queue Error |
| SXMSPVERS | Integration Engine: Message Version |
| SXMSJOBS | Jobs for Time-Controlled Message Processing |
| SXMSMSGDEF | Message Definition |
| SXMSBLKRAWDET | XMB: Detailed Data for Bulk Statistics |
| SXMS_LCR_VERS | XI: Version Information form SLD About Receiver Systems |
| SXMSCONFPP | Principal Propagation Configuration for IE |
| SXMS_HC_FILTERS | XI HC: Config Table |
| SXMSCLUR | XMB: Resources Cluster |
| SXMS_HC_AGGR | XI HC: store of the Aggregation Key attrib values per issue |
| SXMS_LMS_EXTR | Lean Message Search Extractor |
| SXMS_SEQUENCE | Sequences |
| SXMSCLUP | XMB: Property Cluster |
| SXMSPMAST2 | XML Message Broker: Message Queue (Master) (Switch Table) |
| SXMSSPDIAGS | Objects for SXMS SUPPORT DIAGNOSTICS |
| SXMS_AS_STATUS | Status Table of Synchronous/Asynchronous Bridge |
| SXMSBLKRAW | XMB: Raw Data for Package Statistics |
| SXMSPIPEEL | Pipeline Element Definition |
| SXMSMSGREF | Message Reference Storage |
| SXMSPLSRV | XMS: Pipeline Service Specification |
| SXMSJINFO | Integration Engine: Job Information |
| SXMSINTFT | Sender/Receiver Interfaces |
| SXMS_NAC_SEQU | Non Addressible Client Scenario: Inbound Sequence |
| SXMS_EOIOREORG | Reorganization of EOIO Queues |
| SXMS_QM_SERVER | XI: Server for Queue Monitoring |
| SXMSPDATA | Archive for Message Extract |
| SXMS_SYSPAR | SAP System Parameter and Storage Location |
| SXMS_NSPREFIX | Table for Extractor Namespace Prefixes |
| SXMS_ESOA_T | Test Configuration for IS Short Cut |
| SXMSITF | Search Help for Interface for Archiving (Without Content) |
| SXMSPEMAS2 | Integration Engine: Extended Message Queue (Switch Table) |
| SXMS_SH_MEM | Shared Memory Area Configuration |
| SXMSPHIST | XML Message Broker: History |
| SXMS_VIOL_LOG | Exception Handling in EOIO Processing |
| SXMS_BCFG_MAST | Package Configuration Types |
| SXMSMETERAGG | Service Metering - Aggregated data |
| SXMS_EOIO_ERR | Error Table for Overserialized EOIO Queues |
| SXMSPLELT | XMS: Description of Pipeline Elements |
| SXMSMONSEL | Selection Table for Integ. Engine Application Monitoring |
| SXMS_HC_ISSUE | XI HC: store of created and yet-not-resolved issues/NOT USED |
| SXMS_CUST_HDR | Encrypting Customer Header |
| SXMS_BCONF | Assignment Package Configuration |
| SXMS_TCMP_TEST | Test Data Event-Driven Message Processing |
| SXMSCLUP2 | XMB: Property Cluster (Switch Table) |
| SXMS_SEQU_QUEUE | Assignment of WS Inbound Sequence to XI Queue ID |
| SXMSCONFVL | XMS: Integration Engine Configuration Data |
| SXMSINTERFACE | Sender/Receiver Definition |
| SXMSPIPE | XML Message Server: Pipeline Definition |
| SXMS_FEH | Lock Entries for FEH |
| SXMS_PASSPORT | Passport for XI Messages |
| SXMS_MULTIM_REF | Link Table Leading Message - Submessages |
| SXMS_EOIO_REORG | Reorganization of EOIO Queues |
| SXMS_BCFG_MATT | Text Table for SXMS_BCFG_MAST |
| SXMS_EOIO_STAT | Maximum Number of EOIO Queues |
| SXMSPEMAS | Integration Engine: Enhanced Message Queue (Master) |
| SXMS_HC_PAR_DEFT | XI HC: Parameter definitions texts |
| SXMSPCONF | XMB: Administrative Data for Pipeline Configuration |
| SXMSTRANS_MSG | Body Table for Message Transfer |
| SXMS_NAC_MAP | Non Addr. Client: Mapping Sender Sequence/Number Receiver |
| SXMSPVERS2 | Integration Engine: Message Version (Switch Table) |
| SXMSDCONF | Integration Engine: Settings for Deletion Concept |
| SXMSFTEST | Table for XI Runtime Engine Test |
| SXMSPERROR | XML Message Broker: Message Queue (Incorrect Entries) |
| SXMSTRC_DAT | XMS: Trace Data |
| SXMS_EOIO_VIOL | Exception Handling in EOIO Processing |
| SXMS_WSRM_XI_MAP | Map Table Between Inbound Sequence/Queue and Outbound Seq. |