SAP Business Rules back-end Tables
Are you looking for the right table related to SAP Business Rules back-end 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 Rules back-end (EPM-BPC-NW-TDL) module.
Top 10 tables in Business Rules back-end
| Table | Description |
|---|---|
| UJP_DIM_GENERATE | BPC: Dimension Generation |
| UJP_CALC_ACCOUNT | BPC: Account Transformation details |
| UJP_E_CTRL_PARA | BPC: Control parameters for embedded model |
| UJP_EPU_SRC | Equity pick up business rule details(Source account) |
| UJP_E_CALC_ACCHT | BPC: Account Transformation header texts |
| UJP_CALC_ACCHT | BPC: Account Transformation header texts |
| UJP_E_ICBOOK | BPC: IC Booking |
| UJP_E_FXTRANSH | BPC: Currency Translation header |
| UJP_COPY_OPE | BPC: Copy Opening |
| UJP_CLUSTER | Cluster table for parallel cons and ct |
List of tables in Business Rules back-end
| Table | Description |
|---|---|
| UJP_DIM_GENERATE | BPC: Dimension Generation |
| UJP_CALC_ACCOUNT | BPC: Account Transformation details |
| UJP_E_CTRL_PARA | BPC: Control parameters for embedded model |
| UJP_EPU_SRC | Equity pick up business rule details(Source account) |
| UJP_E_CALC_ACCHT | BPC: Account Transformation header texts |
| UJP_CALC_ACCHT | BPC: Account Transformation header texts |
| UJP_E_ICBOOK | BPC: IC Booking |
| UJP_E_FXTRANSH | BPC: Currency Translation header |
| UJP_COPY_OPE | BPC: Copy Opening |
| UJP_CLUSTER | Cluster table for parallel cons and ct |
| UJP_E_METHODH | BPC: Method headers |
| UJP_E_FXTRANSHT | BPC: Texts for Currency Translation headers |
| UJP_E_FXTRANS | BPC: Currency Translation detail |
| UJP_E_TASK_SEQP | Obsolete:BPC Embedded: Business rule task sequence parameter |
| UJP_E_METHODHT | BPC: Method texts |
| UJP_ELIMHT | BPC: Elimination header texts |
| UJP_STAMP_CONS | BPC: Time Stamp Table for Consolidation Result |
| UJP_E_CALC_ACCH | BPC: Account Transformation headers |
| UJP_CALC_ACCH | BPC: Account Transformation headers |
| UJP_E_TASK_SEQ | Obsolete:BPC Embedded: Business rule task sequence |
| UJP_E_METHOD | BPC: Method |
| UJP_E_ELIMHT | BPC: Elimination header texts |
| UJP_E_STAMP_ENT | Obsolete: BPC: Timestamp table period lock(Entity Level). |
| UJP_METHOD | BPC: Method |
| UJP_E_RULE | BPC: Rule Details |
| UJP_E_RULEH | BPC: Rule Header |
| UJP_PARALCONSLOG | for parallel consolidation log |
| UJP_FXTRANSHT | BPC: Texts for Currency Translation headers |
| UJP_E_TASK_SEQPT | BPC Embedded: Business rule task sequence parameters TLOGO |
| UJP_STAMP_CT | BPC: Time Stamp Tabl for CT Result |
| UJP_ENV_RULE | BPC PAK: Detail table of environment level business rules |
| UJP_E_RULEHT | BPC: Rule Header texts |
| UJP_METHODHT | BPC: Method texts |
| UJP_VALID_DEF | BPC: Validation Logic Definition |
| UJP_VALID_LOGIC | BPC: Necessary dimension and property for specific logic. |
| UJP_ELIM | BPC: Elimination Details |
| UJP_STAMP_EPU | BPC: Time Stamp Table for EPU Result |
| UJP_E_TASK_SEQH | Obsolete:BPC Embedded: Business rule task sequence header |
| UJP_E_HIER_REF | BPC PAK: Hierarchy used in business rules |
| UJP_E_TASK_SEQT | Obsolete:BPC Embedded: Business rule task sequence texts |
| UJP_PROC_LOG | Consolidation Process error log |
| UJP_PROC_STEP_A | BPC: Archive Table of Consolidation Process Step |
| UJP_E_TASK_SEQHT | BPC PAK: Header table of model level task sequence for TLOGO |
| UJP_RULEHT | BPC: Rule Header texts |
| UJP_FXTRANSH | BPC: Currency Translation header |
| UJP_US_ELIM | BPC: US Elimination |
| UJP_E_CALC_ACC | BPC: Account Transformation details |
| UJP_ICBOOK | BPC: IC Booking |
| UJP_E_COPY_OPE | BPC: Copy Opening |
| UJP_EPU_DEST | Equity pick up business rule details(Destination account) |
| UJP_MODEL_RULEHT | BPC PAK: Text table of model level business rules |
| UJP_E_ICBOOKH | BPC: IC Booking headers |
| UJP_VALIDATION | BPC: Validation |
| UJP_EPUHT | BPC: Equity Pick Up header texts |
| UJP_PROC_STEP_EA | BPC: Archive Table of Consolidation Process Step |
| UJP_E_PROC_STEP | BPC: Process Step of Consolidation |
| UJP_E_ELIMH | BPC: Elimination header |
| UJP_E_ICBOOKHT | BPC: IC Booking header texts |
| UJP_E_TASK_SEQO | Obsolete: Business rule task sequence other dimensions |
| UJP_E_US_ELIM | BPC: US Elimination |
| UJP_ENV_RULEH | BPC PAK: Header table of environment level business rules |
| UJP_E_ELIM | BPC: Elimination Details |
| UJP_ENV_RULEHT | BPC PAK: Text table of environment level business rules |
| UJP_FXTRANS | BPC: Currency Translation detail |
| UJP_STAMP_ENT | BPC: Time Stamp table for Transaction Data(Entity Level). |
| UJP_RULEH | BPC: Rule Header |
| UJP_E_STAMP_ENT2 | BPC: Timestamp table period lock(Entity Level). |
| UJP_E_TASK_SEQOT | BPC Embedded: Business rule task sequence other dimensions |
| UJP_ELIMH | BPC: Elimination header |
| UJP_METHODH | BPC: Method headers |
| UJP_MODEL_RULEH | BPC PAK: Header table of model level business rules |
| UJP_E_TASK_SEQTT | BPC Embedded: Text table of model level task sequence |
| UJP_ICBOOKHT | BPC: IC Booking header texts |
| UJP_ICBOOKH | BPC: IC Booking headers |
| UJP_E_TASK_SEQTL | BPC Embedded: Business rule task sequence with TLOGO |
| UJP_PROC_STEP | BPC: Process Step of Consolidation |
| UJP_RULE | BPC: Rule Details |
| UJP_MODEL_RULE | BPC PAK: Detail table of model level business rules |
| UJP_VALIDATIONH | BPC: Validation Header |
| UJP_EPUH | BPC: Equity Pick Up header |