SAP PI Tables (Process Integration Tables) – SAP XI tables

SAP Process Integration

SAP PI Tables or SAP XI tables lists the most important tables to consider in SAP Process Integration.

It contains the list of SAP PI Administration Tables, SAP XI Monitoring Tables, Mapping Related Tables in SAP XI …

Read also Important SAP PI Tcodes (Process Integration Transaction Codes) – SAP XI Tcodes

SAP PI (ABAP) schema Tables

Let’s start by the SAP PI messages Tables on the ABAP side.
First at all, SAP PI tables starts usually with SX* or SW*.

The main list for SAP PI ABAP schema Database Transaction Codes are:

TableSAP PI Tables
SXMSPMASTXI Messages – Master
SXMSPHISTXI Messages – Master History table
SXMSPEMASIntegration Engine: Enhanced Message Queue (Master)
SXMSPVERSIntegration Engine: Message Version
SXMSPERRORXML Message Broker: Message Queue (Incorrect Entries)
SXMSCLUPCluster – Compressed Message Payload Property
SXMSCLURCluster – Compressed Message Payload Resource (attachments)

Check more detail on Message Monitoring in SAP PI

SAP PI Mapping Related Tables

“In a message mapping, you assign a source and a target message type (according to the source and target operation of the operation mapping the message mapping is assigned to).

Using a graphical editor, you can define the mapping between the source and target message type.” (source)

The main Message Mapping Related Tables in SAP PI are:

TableSAP PI Tables
SMPPMAP3Mapping Runtime: Mapping
SMPPREL3Mapping Runtime: Mapping Relation
SMPPSPLITXI Mapping: Merge and Split

SAP PI Tables for Performance

In order to monitor SAP PI Performance, all the Integration Engine Header and Data are stored in the following PI Tables in the ABAP Side:

TableSAP PI Tables for Performance
SXMSPFRAWHIntegration Engine – Header Table for Raw Data for Performance Evaluation
SXMSPFRAWDIntegration Engine: Data Table for Raw Data for Performance

Check this article for more detail about how to monitor Performance in SAP PI.

SAP PI : ccBPM / BPE tables

ccBPM stands for Cross-Component Business Process Management.
“Cross-component Business Process Management (ccBPM) contains functions for enhanced service orchestration that are based on integration processes.

An integration process is composed of a specific flow of steps – including the sending and receiving of messages – during which the status of the process is persisted on the Integration Server.” (source)

BPE stands for Business Process Engine.

“The Business Process Engine (BPE) processes integration processes at runtime. Since the BPE uses functions of the Workflow Engine and generates workflows from integration processes at runtime, you must customize the Workflow Engine automatically by using transaction SWF_XI_CUSTOMIZING before you can use the BPE.” (source)

Here the main tables for ccBPM and BPE in SAP Process Integration

TableccBPM / BPE tables
SWFRXICNTXI Adapter: XML Container for a Message Object
SWFRXIHDRXI Adapter: Header Data for a Message Object
SWFRXIPRCXI-Adapter: Process-Dependent Message Data

IDoc Table for SAP PI

All IDoc Adapter Acknowledgments in SAP PI are managed in :

TableSAP PI Tables IDoc
IDXNOALEsuppress IDoc Adapter acknowledgments

here some useful reading on Idoc Adapter Acknowledgment in SAP PI:

SAP PI Alert Framework Tables

The use of Alert Framework in SAP PI can be:

TableSAP PI Alert Framework Tables

Further Reading for SAP NetWeaver PI / PO

If you want to go deeper into SAP Process Integration (XI for the Old name and PO for Process Orchestration for the New one), check the following SAP Books: