Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
akashjagga
Participant

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

Labels in this area