PI Tables

PI Tables 

ABAP

ABAP schema Database Transaction Codes

   SE11

   SE16

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)

*N.B.,
   The Switch equivalents for the 7 tables above have the suffix 2, e.g. SXMSPMAST2  

Mapping Related Tables
SMPPMAP3	Mapping Runtime: Mapping
SMPPREL3	Mapping Runtime: Mapping Relation
SMPPSPLIT	XI Mapping: Merge and Split

Performance

SXMSPFRAWH	Integration Engine - Header Table for Raw Data for Performance Evaluation
SXMSPFRAWD	Integration Engine: Data Table for Raw Data for Performance

ccBPM / BPE tables

SWFRXIHDR	XI Adapter: Header Data for a Message Object
SWFRXICNT	XI Adapter: XML Container for a Message Object
SWFRXIPRC	XI-Adapter: Process-Dependent Message Data

IDoc

IDXNOALE

suppress IDoc Adapter acknowledgements

Java 

Adapter Engine

XI_AF_MSG	AF XI Message
XI_AF_MSG_AUDIT	audit log entries
BC_MSG	AF PI 7.1  Message
BC_MSG_AUDIT	PI 7.1 audit log entries (**)

**N.B.,

Integration Builder

SAP_<SID>DB.XI_REP*	Repository objects
SAP_<SID>DB.XI_DIR*	Directory objects

Integartion Builder versioning

SAP<SID>DB.XI_P*	Repository versioning information
SAP<SID>DB.XI_Q*	Directory versioning information

Alert Framework Tables

Alert
SXMSALERTLOGGER	XI alerts log

Java SE11/SE16 equivalent - Dictionary Table Maintenance Utility Tool

Interesting ABAP tables in XI - Part I

Fast growing tables in PI 7.0

Integration Engines
SXMSPMAST	Integration Engine (master) Message Queue table
SXMSCLUP/SXMSCLUR	contain the application payload in a compressed form
SXMSPHIST	contains history data. History data consists of a small amount of header information from deleted messages. This history data is stored in a separate table with a minimum retention period of seven days.
SXMSPFRAWH/SXMSPFRAWD	contain PI performance data.
Business Process Engine
SWWLOGHIST	all information about one process step
SWWWIHEAD	header information for processes
SWWCNTP0	context information for processes, for example, references to messages
Adapter Engine
XI_AF_MSG	stores incoming and outgoing messages
XI_AF_MSG_AUDIT	audit log entries for messages stored in XI_AF_MSG
XI_SEC	only for security message archiving