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

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)
SXMSPFADDRESSAddresses 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)

Check also   How to SAP Mass Download of ABAP Download Programs in HTML/TEXT format

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 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)

Check also   SAP Incoterms Overview in SAP MM and SAP SD

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:

SXMSALERTLOGGERXI alerts log
SXMSALERTRULESXI alerts rules

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:

Check also   Display Popup Window in WebDynpro Abap

Sab125

Hi. I have been working as SAP Technical and functional for a decade. Through this blog, I am trying to share with you my experience. Hopefull, it makes your ways easier path ...Sab

Leave a Reply

Your email address will not be published. Required fields are marked *