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 …?

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:

SXMSPMASTXI Messages – Master
SXMSPHISTXI Messages – Master History table
SXMSPEMAS??Integration Engine: Enhanced Message Queue (Master)
SXMSPVERS?Integration Engine: Message Version
SXMSPERRORXML Message Broker: Message Queue (Incorrect Entries)
SXMSCLUP?Cluster – 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:

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:

SXMSPFRAWHIntegration Engine – Header Table for Raw Data for Performance Evaluation
SXMSPFRAWD?Integration 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

SWFRXIHDRXI Adapter: Header Data for a Message Object
SWFRXICNT?XI Adapter: XML Container for a Message Object
SWFRXIPRCXI-Adapter: Process-Dependent Message Data

IDoc Table for SAP PI

All IDoc Adapter Acknowlegments in SAP PI are managed in :

IDXNOALEsuppress IDoc Adapter acknowledgements

here some usefull reading on Idoc Adapter Acknowlegment in SAP PI:

SAP PI Alert Framework Tables

The use of Alert Framework in SAP PI can be:


Further Reading for SAP Netwearver 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), chec the following SAP Books: