SAP Retention Warehouse Tables
Are you looking for the right table related to SAP Retention Warehouse Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Retention Warehouse (BC-ILM-RW) module.
Top 10 tables in Retention Warehouse
| Table | Description |
|---|---|
| IWP_REPOS_BW | Available Tables for BW |
| IWP_DB_AREA_ND | Hierachy of the audit area |
| IWP_DB_REPOS_S | Retention Warehouse: Repository structures |
| IWP_IOBJA_APT_CP | Definition of Audit Area Template specific Infoobj. (copies) |
| IWP_BI_OBJECTNUM | Numbers of Objects to be created in BI |
| IWP_IOBJA_PT | Definition of Audit Area specific Infoobjects |
| IWP_HDB_TAB_MAP | Contains mapping of tables from DDIC to HANA ILM tables |
| IWP_DB_SET_F | Fields of the set |
| IWP_DB_SET_S | Structures of a set |
| IWP_AUTH_IOBJ | Definition of Infoobjects to be used for authorization |
List of tables in Retention Warehouse
| Table | Description |
|---|---|
| IWP_REPOS_BW | Available Tables for BW |
| IWP_DB_AREA_ND | Hierachy of the audit area |
| IWP_DB_REPOS_S | Retention Warehouse: Repository structures |
| IWP_IOBJA_APT_CP | Definition of Audit Area Template specific Infoobj. (copies) |
| IWP_BI_OBJECTNUM | Numbers of Objects to be created in BI |
| IWP_IOBJA_PT | Definition of Audit Area specific Infoobjects |
| IWP_HDB_TAB_MAP | Contains mapping of tables from DDIC to HANA ILM tables |
| IWP_DB_SET_F | Fields of the set |
| IWP_DB_SET_S | Structures of a set |
| IWP_AUTH_IOBJ | Definition of Infoobjects to be used for authorization |
| IWP_HDB_URI_ID | Resource Identifier Dictionary |
| IWP_HDB_STRUC | Structures included in Reporting/Work Package for HANA |
| IWP_APT_IPRV_MAP | Mapping between Audit Package template and Source Infoprov |
| IWP_DB_AREAT | Description of audit areas |
| IWP_HDB_VIEW_MAP | Contains mapping of package's structures to HANA views |
| IWP_KEYMOD | Adoption of the key field order |
| IWP_IOBJ_CUST_CP | Definition of Customer specific Infoobjects (copies) |
| IWP_NAV_ATTR_VP | Definition of Navigational Attributes for Virtual Providers |
| IWP_WPP_R | Relations of an Audit Package Template |
| IWP_REPOS_BW_V | Available Views for BW |
| IWP_DB_REPOS_FT | Retention Warehouse: Repository field description |
| IWP_CONF_MESSAGE | Adopt Messages in Message Log |
| IWP_HDB_QUERY_V | Contains mapping of Reporting package to Query Views |
| IWP_WP_VIEW | Views of an Audit Package |
| IWP_HIER_PROP | Properties of a hierarchy |
| IWP_IOBJA_PT_CP | Definition of Audit Area specific Infoobjects (copies) |
| IWP_WP_URI | Audit Package URI |
| IWP_WP_LOG | Log for Backgroundprocessing |
| IWP_NAV_ATTR | Definition of Navigational Attributes for Master Data |
| IWP_HDB_MODELS | VDM's for HANA Model Replication |
| IWP_SNMETA | Metadata from Archive Object SN_META |
| IWP_TABTYP | Table attributes |
| IWP_WP_PTH_STRC | Structures of the Pathes of an Audit Package |
| IWP_WP_AREA | Areas Assigned to Audit Packages |
| IWP_WPT | Work Package Texts |
| IWP_GEN_SETTINGS | Define Settings for Parallelization |
| IWP_WP | Audit Packages |
| IWP_DB_REPOS | Retention Warehouse: Repository |
| IWP_WP_RELA | Relations and Domain Values of an Audit Package |
| IWP_IOBJASS_CP | Definition of Audit Area specific Infoobjects (copies) |
| IWP_WP_FILELIST | File List to create a work package |
| IWP_PARA | Application Parameters |
| IWP_HDB_TAB_GEN | Stores HDB name, schema and package information |
| IWP_REPOS_BW_C | Available Tables for BW - Customer adoptions |
| IWP_WP_IOBJ | InfoObjects of an Audit Package |
| IWP_LR_SEL_FIELD | Local Reporting Selection Criteria fields |
| IWP_REPOS_BW_V_C | Available Views for BW - Customer adoption |
| IWP_WP_STRUCT | Describtion: Tables of an Audit Package |
| IWP_WPP | Audit Package Template |
| IWP_HDB_RP | ILM Reporting Package/Perspective |
| IWP_WP_IOBJT | InfoObjects of an Audit Package |
| IWP_DB_SETT | Set description |
| IWP_DB_SET | Set of tables |
| IWP_WP_IOBJ_ST | Definition structures of an Infoobject |
| IWP_WPP_F | Fields of an Audit Package Template |
| IWP_PERIOD_TABLE | Table where keyfigures are period based (example 'GLT0') |
| IWP_DATA_DELIVER | Metadata from Archive Object SN_META |
| IWP_GEN_CONFIG | Configuration of BI extraction |
| IWP_WP_METAURI | Audit Package URI for SN_META |
| IWP_DB_REPOS_F | Retention Warehouse: Repository Fields |
| IWP_IOBJ_CUST | Definition of Customer specific Infoobjects |
| IWP_LR_OP_FIELDS | Output fields selected during Local Reporting |
| IWP_WP_IPRV | InfoProviders of an Audit Package |
| IWP_DB_REPOST | Retention Warehouse: Repository Description |
| IWP_WP_JOB | Jobs for the Backgroundprocessing |
| IWP_WPP_S | Structures of an Audit Package Template |
| IWP_HDB_URI_LOAD | Audit Package URI Structure Loadstat |
| IWP_WP_HDB_GEN | Stores HDB name, schema and package information |
| IWP_IOBJASS | Definition of Audit Area specific Infoobjects |
| IWP_TRANS_ATTRIB | Transferattributes of a table |
| IWP_DB_REPOS_ST | Retention Warehouse: Repository structure description |
| IWP_HDB_CUST | Customizing for generating ILM content on HANA |
| IWP_WP_IPRVT | Text Table: InfoProviders of an Audit Package |
| IWP_TABLE_DIR | Directory of generated tables for data transfer |
| IWP_IOBJA_APT | Definition of Audit Area Template specific Infoobjects |
| IWP_DB_AREA | Audit Areas |
| IWP_DB_AREA_NDT | Description of a folder in the hierachy |
| IWP_TEXTTAB | Assignment of Texttables to Definitiontables |
| IWP_WPP_V | Views of an Audit Package Template |
| IWP_WP_STRUC | Tables of an Audit Package |
| IWP_WP_PATH | Paths of an Audit Package |
| IWP_WP_QUERY_MAP | Query name mapping for generating/copying queries |
| IWP_VP_CUST | Field mapping for Virtual Providers |
| IWP_WPPT | Audit Package Template |