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:
|Table||SAP PI Tables|
|SXMSPMAST||XI Messages – Master|
|SXMSPHIST||XI Messages – Master History table|
|SXMSPEMAS||Integration Engine: Enhanced Message Queue (Master)|
|SXMSPVERS||Integration Engine: Message Version|
|SXMSPERROR||XML Message Broker: Message Queue (Incorrect Entries)|
|SXMSCLUP||Cluster – Compressed Message Payload Property|
|SXMSCLUR||Cluster – 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:
|Table||SAP PI Tables|
|SMPPMAP3||Mapping Runtime: Mapping|
|SMPPREL3||Mapping Runtime: Mapping Relation|
|SMPPSPLIT||XI 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:
|Table||SAP PI Tables for Performance|
|SXMSPFRAWH||Integration Engine – Header Table for Raw Data for Performance Evaluation|
|SXMSPFRAWD||Integration Engine: Data Table for Raw Data for Performance|
Check this help.sap.com 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
|Table||ccBPM / BPE tables|
|SWFRXICNT||XI Adapter: XML Container for a Message Object|
|SWFRXIHDR||XI Adapter: Header Data for a Message Object|
|SWFRXIPRC||XI-Adapter: Process-Dependent Message Data|
IDoc Table for SAP PI
All IDoc Adapter Acknowledgments in SAP PI are managed in :
|Table||SAP PI Tables IDoc|
|IDXNOALE||suppress IDoc Adapter acknowledgments|
here some useful reading on Idoc Adapter Acknowledgment in SAP PI:
- Configuring Acknowledgments for a Receiver IDoc Adapter (AAE)
- Configuring Acknowledgments for a Sender IDoc Adapter (AAE)
SAP PI Alert Framework Tables
The use of Alert Framework in SAP PI can be:
|Table||SAP PI Alert Framework Tables|
|SXMSALERTLOGGER||XI alerts log|
|SXMSALERTRULES||XI alerts rules|
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:
- SAP Certified Development Associate – Process Integration with SAP NetWeaver (PI 7.3) Paperback May 16, 2015
- SAP Process Orchestration (SAP PO): Next Generation of SAP Process Integration (SAP PI) (SAP PRESS) Hardcover May 3, 2015
- Mastering IDoc Business Scenarios with SAP NetWeaver PI 2nd Edition
- Practical Guide to SAP NetWeaver PI – Development 2nd Edition
- XI Tables in SAP
- LIST OF SAP XI TABLES