SAP Business Planning and Consolidation Tables
Are you looking for the right table related to SAP Business Planning and Consolidation 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 Business Planning and Consolidation (EPM-BPC) module.
Top 10 tables in Business Planning and Consolidation
| Table | Description |
|---|---|
| UJMIG_MAP_HIER | Mapping BPC-BW Hierarchy |
| UJXO_CLS_ID_TBL | Cluster table to store shared buffer identified by guid |
| UJX0_AT_EXEC | AT execution overview table |
| UJXO_DIM_CACHE | Dimension cache |
| UJXO_HIR_CACHE | Dimension cache for TDH, only hierarchy version |
| UJX0_AT_SUBSCRIB | AT test result subscriber table |
| UJMIG_MAP_M_DEV | Runtime Mapping Definition |
| UJXO_DH_CACHE | Dimension cache for TDH, both dim and hierarchy version |
| UJ0_UT_DETAIL | BPC:Unit test report details |
| UJ0_UT_FILE | BPC: Unit Test Files |
List of tables in Business Planning and Consolidation
| Table | Description |
|---|---|
| UJMIG_MAP_HIER | Mapping BPC-BW Hierarchy |
| UJXO_CLS_ID_TBL | Cluster table to store shared buffer identified by guid |
| UJX0_AT_EXEC | AT execution overview table |
| UJXO_DIM_CACHE | Dimension cache |
| UJXO_HIR_CACHE | Dimension cache for TDH, only hierarchy version |
| UJX0_AT_SUBSCRIB | AT test result subscriber table |
| UJMIG_MAP_M_DEV | Runtime Mapping Definition |
| UJXO_DH_CACHE | Dimension cache for TDH, both dim and hierarchy version |
| UJ0_UT_DETAIL | BPC:Unit test report details |
| UJ0_UT_FILE | BPC: Unit Test Files |
| UJMIG_MAP_LOG_IP | Mapping BPC-BW Log-Table InfoProvider |
| UJXO_QUERY_BUF | Shared Buffer for Query Object |
| UJXO_TDH_CACHE | Dimension cache for TDH, only dimension version |
| UJXA_JOB_INFO | BPC: Basic information regarding the ongoing jobs |
| UJMIG_MAP_LOG | Mapping BPC-BW Log-Table |
| UJMIG_MAP_APPL | Mapping BPC-BW Model |
| UJMIG_MAP_ATTR | Mapping BPC-BW Attribures |
| UJP_UT_LOG | BPC: Consolidation UT Engine Configuration |
| UJMIG_MAP_ENV | Mapping BPC-BW Header |
| UJ0_UT_FLOG | BPC: Unit Test File Change Log |
| UJXA_JOB_INFOT | Message information for the jobs |
| UJX0_AT_TESTLOG | BPC: automation test test case record logs table |
| UJX0_AT_RESULT | AT Result table |
| UJX0_TMP_REC | BPC: automation test temp record list table |
| UJX0_AT_TESTCASE | BPC: automation test test case table |
| UJP_UT_CONFIG | BPC: Consolidation UT Engine Configuration |
| UJXO_CLUSTER_TBL | Cluster table to store shared buffer for dimension cache |
| UJMIG_MAP_APPL_D | Mapping BPC-BW Model - Dimensions |
| UJX0_AT_RS_CASE | automation test result of testcase level |
| UJMIG_MAP_LOG_T | Mapping BPC-BW Log-Table - Texts |
| UJMIG_MAP_DIM | Mapping BPC-BW Dimension |
| UJR_PARAM | BPC: Application specific customer info |
| UJMIG_MAP_APPL_K | Mapping BPC-BW Model - Keyfigures, Time and Unit |
| UJX0_USER_REC | BPC: automation test user recordable and sequence list table |
| UJO2_ENGINE_LIST | Registered Query Engines and their priorities |