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
Table of Contents
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) |
SXMSPFADDRESS | Addresses 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
“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
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.
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 |
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:
The use of Alert Framework in SAP PI can be:
Table | SAP PI Alert Framework Tables |
---|---|
SXMSALERTLOGGER | XI alerts log |
SXMSALERTRULES | XI alerts rules |
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 ISU Tables for Technical master data, for Billing Master Data, Billing and invoicing Tables?…
SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd…
Dunning is the business practice of informing a customer of past due payment. Dunning letters…
SAP AP Tcodes & SAP AR Tcodes: House Banks Tcodes, Advance Payments or Down Payments,…
What are the main SAP Payment Terms Tables ? What are the related Tables in…
Work center consists of master data related to routing of products. It contains data related…