SAP PI – Java Stack – Database Tables

[akashjagga]

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