SAP PI – Java Stack – Database Tables

Hi All

In this blog I am going to list out database tables (along with their purpose) related to SAP PI – Java Stack. During my SAP PI research, I realized that it would be good idea to place this collective information at one place.

Here these are:

• XI_DIRTSRP_ENTITY – This table likely holds information about entities used in transport directory services.
• XI_DIRDATASERVICE – This table might store data related to various services used in the integration directory. 
• XI_DIRKEYNAME – This table could be related to storing key names used for various directory objects. 
• XI_DIRCACHEEVENT – This table might track cache-related events, potentially for performance optimization. 
• XI_DIRCACHEOBJ – This table could be used to cache directory objects for quicker access. 

• XI_DIRDATAPERSON – This table might store data related to individuals or people associated with integration objects. 
• XI_DIRDATASRVIDS – This table could store service IDs associated with data in the integration directory. 
• XI_DIR_TXTOGR_VERS – This table might be related to versions of text objects in the integration directory. 
• XI_DIRDATAPARTYIDS – This table could store party IDs related to data in the integration directory. 
• XI_DIR_TXTSHT_VERS – This table might be related to versions of short text objects in the integration directory. 

• XI_DIR_TXTOBJ_VERS – This table could be associated with versions of text objects in the integration directory. 
• XI_DIRDATA_LNK – This table might store links or associations between different data elements in the integration directory. 
• XI_DIRDATACHANNEL – This table could hold information about communication channels used in integration scenarios. 
• XI_DIRSYNCADMIN – This table might store administrative data related to synchronization processes. 
• XI_DIRCHANGELIST – This table could be used to track changes made to the integration directory objects. 

• XI_DIRKEYSERVICE – This table might store keys or identifiers related to services in the integration directory. 
• XI_DIRSYNC_RD_RULE – This table could be related to synchronization rules used for runtime data. 
• XI_DIR_TXTSHT_SYNC – This table might be associated with synchronization of short text objects in the integration directory. 
• XI_DIRKEY_RD_RULE – This table could store keys or identifiers for runtime data rules. 
• XI_DIR_TXTOBJ_VERS – This table might relate to versions of text objects in the integration directory. 

• XI_DIRDATAADMIN – This table could store administrative data related to directory objects. 
• XI_DIRSYNCCHANNEL – This table might hold information about channels used in synchronization processes. 
• XI_DIRKEYPARTY – This table could store keys or identifiers related to parties in the integration directory. 
• XI_DIRSYNCPARTYIDS – This table might store party IDs related to synchronization processes. 
• XI_DIRKEY_DIR_VIEW – This table could be related to key management for directory views. 

• XI_DIRSYNCDIRVIEWN – This table might be used for synchronizing directory views. 
• XI_DIRSYNC_LNK – This table could store links or associations between different elements in synchronization processes. 
• XI_DIRSYNCMODULESQ – This table might relate to module sequences used in synchronization processes. 
• XI_DIRSYNCMODULECF – This table could store configuration data for synchronization modules. 
• XI_DIRSYNC_RD_EXTR – This table might relate to extraction of runtime data during synchronization. 

• XI_DIRSYNCSERVICE – This table could store information about services involved in synchronization processes. 
• XI_DIRSYNCSRVIDS – This table might store service IDs related to synchronization processes. 
• XI_DIRKEYCHANNEL – This table could hold keys or identifiers for communication channels. 
• XI_DIRBND – This table might store binding information between different objects in the integration directory. 
• XI_DIRCACHEERRORS – This table could be used to store error information related to cache operations. 

• XI_DIRCACHERCLVIEW – This table might relate to caching of views in the integration directory. 
• XI_DIRDATAALLINONE – This table could store various types of data in a consolidated manner. 
• XI_DIRDATAALRU_CON – This table might store consolidated runtime data for various objects. 
• XI_DIRDATAALRU_ERR – This table could store consolidated error-related data for various objects. 
• XI_DIRDATAALRU_RT – This table might store consolidated runtime data for various objects. 

• XI_DIRDATABHDMPNG – This table could be used for data backup and dumping. 
• XI_DIRDATABINDIF – This table might store binding information for interfaces. 
• XI_DIRDATABLOB – This table could be related to storing binary large objects (BLOBs) associated with data objects. 
• XI_DIRDATABPCONT – This table might store business partner contact information. 
• XI_DIRDATABPPROP – This table could store business partner properties or attributes. 

• XI_DIRDATADIRVIEWN – This table might be used for storing data related to directory views. 
• XI_DIRDATAFOLDER – This table could store information about folders or directory structures. 
• XI_DIRDATAHEAD_RU – This table might store runtime header data for various objects. 
• XI_DIRDATAIFL – This table could hold data related to interfaces in the integration directory. 
• XI_DIRDATAIFLBLB – This table might be related to data associated with interface labels. 

• XI_DIRDATALINK – This table might store links or associations between different data elements in the integration directory. 
• XI_DIRDATAMAPDRELA – This table could be related to mapping data relationships in the integration directory. 
• XI_DIRDATAMAPDRELG – This table might store mapping data relationships, possibly for grouping. 
• XI_DIRDATAMAPDRELS – This table could be related to mapping data relationships, possibly for specific instances. 
• XI_DIRDATAMODULECF – This table might store configuration data for data modules in the integration directory. 

• XI_DIRDATAORIGINAL – This table could store original data in the integration directory. 
• XI_DIRDATAPIPCONF – This table might store configuration data related to pipelines in the integration directory. 
• XI_DIRDATAPIPCOPAR – This table could be related to pipeline configuration parameters. 
• XI_DIRDATAUSERIDS – This table might store user IDs associated with data in the integration directory. 
• XI_DIRDATAVALMAP – This table could store value mapping data in the integration directory. 

• XI_DIRDATAVALMAPGR – This table might be related to value mapping groups in the integration directory. 
• XI_DIRDATAVALMAPN – This table could be used for value mapping relationships in the integration directory. 
• XI_DIRDATAVALUEMAP – This table might store specific value mappings in the integration directory. 
• XI_DIRDATA_AIOPROP – This table could hold data related to adapter input/output properties. 
• XI_DIRDATA_CONN – This table might store connection-related data in the integration directory. 

• XI_DIRDATA_CSTATE – This table could store data about communication states. 
• XI_DIRDATA_RD_COND – This table might store runtime data conditions. 
• XI_DIRDATA_RD_DYN – This table could be related to runtime data dynamics. 
• XI_DIRDATA_RD_EXTR – This table might store extracted runtime data. 
• XI_DIRDATA_RD_NSP – This table could be related to runtime data namespace prefixes. 

• XI_DIRDATA_RD_REL – This table might store runtime data relationships. 
• XI_DIRDATA_RD_RULE – This table could be related to runtime data rules. 
• XI_DIRDATA_SCEN – This table might store information about scenarios in the integration directory. 
• XI_DIRDATA_SMAP – This table could be related to scenario mappings. 
• XI_DIRIFLDPL – This table might store planning data for interfaces in the integration directory. 

• XI_DIRIFLDPLLG – This table could be related to planning data for large interfaces. 
• XI_DIRKEYADAPTERMD – This table might store keys or identifiers related to adapter metadata. 
• XI_DIRKEYALERTRULE – This table could be used for keys related to alert rules. 
• XI_DIRKEYARCHVSUB – This table might store keys or identifiers related to archived subscriptions. 
• XI_DIRKEYBINDING – This table could be related to keys for object bindings in the integration directory. 

• XI_DIRKEYBINDP2P – This table might be related to keys for peer-to-peer bindings. 
• XI_DIRKEYEXTPROG – This table could store keys or identifiers related to external programs. 
• XI_DIRKEYFOLDER – This table might be used for keys related to folders in the integration directory. 
• XI_DIRKEYIFL – This table could store keys or identifiers related to interfaces. 
• XI_DIRKEYMAPKIDET – This table might be related to keys for mapping key details. 

• XI_DIRKEYPC – This table could be used for keys or identifiers related to processing components. 
• XI_DIRKEYPIPCONF – This table might store keys or identifiers related to pipeline configurations. 
• XI_DIRKEYSUBNAME – This table could be related to keys or identifiers for subscription names. 
• XI_DIRKEYVALMAP – This table might store keys or identifiers for value mappings. 
• XI_DIRKEYVALMAPCTX – This table could be used for keys or identifiers for value mapping contexts. 

• XI_DIRKEYVALMAPGRP – This table might store keys or identifiers for value mapping groups. 
• XI_DIRKEYVALMAPSCH – This table could be related to keys or identifiers for value mapping schemas. 
• XI_DIRKEYVALMAPTYP – This table might store keys or identifiers for value mapping types. 
• XI_DIRKEYVALUEMAP – This table could be used for keys or identifiers for specific value mappings. 
• XI_DIRKEY_ALLINONE – This table might store keys or identifiers in a consolidated manner. 

• XI_DIRKEY_RD_RELAT – This table could be related to keys for runtime data relationships. 
• XI_DIRKEY_SCENARIO – This table might store keys or identifiers related to scenarios. 
• XI_DIROPENCONFLICT – This table could be used to track open conflicts or issues. 
• XI_DIRSM_CONFIG – This table might store configuration data related to the synchronization manager. 
• XI_DIRSM_LINKS – This table could be related to links used by the synchronization manager. 

• XI_DIRSM_SCENARIO – This table might store scenarios related to the synchronization manager. 
• XI_DIRSM_TEXT – This table could be used to store text data used by the synchronization manager. 
• XI_DIRSNAPSHOTS – This table might store data snapshots for the integration directory. 
• XI_DIRSYNCALLINONE – This table could store synchronized data in a consolidated manner. 
• XI_DIRSYNCALRU_CON – This table might store consolidated runtime data for synchronization. 

• XI_DIRSYNCALRU_ERR – This table could be related to consolidated error data for synchronization. 
• XI_DIRSYNCALRU_RT – This table might store consolidated runtime data for synchronization. 
• XI_DIRSYNCBHDMPNG – This table could be related to data backup and dumping for synchronization. 
• XI_DIRSYNCBINDIF – This table might store binding data for interfaces in synchronization. 
• XI_DIRSYNCBLOB – This table could be used for storing binary large objects (BLOBs) related to synchronization. 

• XI_DIRSYNCBPCONT – This table might store business partner contact information related to synchronization. 
• XI_DIRSYNCBPPROP – This table could be related to business partner properties or attributes in synchronization. 
• XI_DIRSYNCFOLDER – This table might store information about folders or directory structures in synchronization. 
• XI_DIRSYNCHEAD_RU – This table could be related to runtime header data in synchronization. 
• XI_DIRSYNCIFL – This table might store data related to interfaces in synchronization. 

• XI_DIRSYNCIFLBLB – This table could be related to data associated with interface labels in synchronization. 
• XI_DIRSYNCLINK – This table might store links or associations between different elements in synchronization. 
• XI_DIRSYNCMAPDRELA – This table could be related to mapping data relationships in synchronization. 
• XI_DIRSYNCMAPDRELG – This table might store mapping data relationships, possibly for grouping, in synchronization. 
• XI_DIRSYNCMAPDRELS – This table could be related to mapping data relationships, possibly for specific instances, in synchronization. 

• XI_DIRSYNCPIPCONF – This table might store pipeline configuration data in synchronization. 
• XI_DIRSYNCPIPCOPAR – This table could be related to pipeline configuration parameters in synchronization. 
• XI_DIRSYNCTXT_L – This table might be used for storing long text data in synchronization. 
• XI_DIRSYNCTXT_S – This table could be related to storing short text data in synchronization. 
• XI_DIRSYNCUSERIDS – This table might store user IDs associated with synchronization data. 

• XI_DIRSYNCVALMAPGR – This table could be used for value mapping groups in synchronization. 
• XI_DIRSYNCVALMAPN – This table might be related to value mapping relationships in synchronization. 
• XI_DIRSYNC_AIOPROP – This table could store data related to adapter input/output properties in synchronization. 
• XI_DIRSYNC_CONN – This table might store connection-related data in synchronization. 
• XI_DIRSYNC_RD_COND – This table could be related to runtime data conditions in synchronization. 

• XI_DIRSYNC_RD_DYN – This table might store runtime data dynamics in synchronization. 
• XI_DIRSYNC_RD_NSP – This table could be related to runtime data namespace prefixes in synchronization. 
• XI_DIRSYNC_RD_REL – This table might store runtime data relationships in synchronization. 
• XI_DIRSYNC_SCEN – This table could be related to scenarios in synchronization. 
• XI_DIRSYNC_SMAP – This table might store scenario mappings in synchronization. 

• XI_DIRTEXTHEAD – This table could store header information for text objects. 
• XI_DIRTEXTLONG – This table might store long text data. 
• XI_DIRTEXTLONG_TX – This table could be related to long text data with a text key. 
• XI_DIRTEXTSHORT – This table might store short text data. 
• XI_DIRTEXTSHORT_TX – This table could be related to short text data with a text key. 

• XI_DIRTPCOLLECTION – This table might store information about transport collections in the integration directory. 
• XI_DIRTPINFO – This table could be related to transport information in the integration directory. 
• XI_DIRTPPERFORM – This table might store performance-related information for transports. 
• XI_DIRTPPROTOCOL – This table could be related to transport protocols in the integration directory. 
• XI_DIRUPGRADEDATA – This table might store data related to system upgrades. 

• XI_DIRVERSION – This table could be related to version information for objects in the integration directory. 
• XI_DIRWORKSP – This table might store workspace-related data. 
• XI_DIRWORKSPACE – This table could be related to workspace data in the integration directory. 
• XI_DIRWORKSP_DEP – This table might store workspace dependencies. 
• XI_DIR_API_CHANNEL – This table could be related to API-related channel data. 

• XI_DIR_API_CT – This table might store data related to API communication. 
• XI_DIR_API_TUCC_CL – This table could be related to API transport user-specific customizing. 
• XI_DIR_P2P_API_CT – This table might store data related to peer-to-peer API communication. 
• XI_DIR_P2P_CHANNEL – This table could be related to peer-to-peer channels. 
• XI_DIR_P2P_TUCC_CL – This table might store data related to peer-to-peer transport user-specific customizing. 

• XI_DIR_TXTLNG_SYNC – This table could be related to synchronization of long text objects. 
• XI_DIR_TXTLNG_VERS – This table might store version information for long text objects. 
• XI_DIRDATAALRULE – This table could be related to data associated with alert rules. 
• XI_DIRDATAALRU_OBJ – This table might store data objects related to alerts. 
• XI_DIRDATABINDING – This table could be used for data binding-related information. 

• XI_DIRSYNCALRULE – This table might store synchronization data for alert rules. 
• XI_DIRSYNCALRU_OBJ – This table could be related to synchronization objects for alerts. 
• XI_DIRDATABINDING – This table might store data binding-related information. 
• XI_DIRLINK – This table could be related to links between different objects. 
• XI_DIRKEYLINK – This table might store keys or identifiers for links. 

• XI_DIRAPIREV – This table could be used for API revision data. 
• XI_DIRCACHE – This table might store cached data for the integration directory. 
• XI_DIRCHDL – This table could be related to channel handlers. 
• XI_DIRDELTA – This table might store delta data for changes. 
• XI_DIRKEY – This table could be used for key information. 

• XI_DIRLINKC – This table might store data related to linked configurations. 
• XI_DIRMSGEXC – This table could be used for message exceptions. 
• XI_DIRMSGLOG – This table might store message logs. 
• XI_DIRPRELOAD – This table could be related to preloading data. 
• XI_DIRRULE – This table might store rule information. 

• XI_DIRRULELOG – This table could be related to rule logs. 
• XI_DIRSYNCALRU_CON – This table might store consolidated runtime data for synchronization alerts. 
• XI_DIRSYNCALRU_ERR – This table could be used for consolidated error data for synchronization alerts. 

There are going to be lot of more tables as well because it is huge database, but I suppose this list contains the most important tables list.

I hope this read will provide some helpful information.

Happy reading 🙂 Best Wishes