SAP Journals Tables
Are you looking for the right table related to SAP Journals 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 Journals (EPM-BPC-NW-CC-JNL) module.
Top 10 tables in Journals
| Table | Description |
|---|---|
| UJJ_E_JRNL_ADITM | Embedded: copy from UJJ_JRNL_ADITMS |
| UJJ_E_JRNID_NRAN | Embedded: copy from UJJ_JRNID_NRANGE |
| UJJ_P_JRNTMPL_PA | Journal template parameters |
| UJJ_E_JRNTMPL_PA | obsolete, replaced by UJJ_P_JRNTMPL_PA |
| UJJ_E_TMPL_FLDS | Embedded: copy from UJJ_TMPL_FLDS |
| UJJ_E_JRNTMPL_IN | Embedded: copy from UJJ_JRNTMPL_INFO |
| UJJ_TRANS_MASTER | BPC: Journal transformation master |
| UJJ_JRNTMPL_NAME | Journal template name for multiple templates |
| UJJ_JRNL_ADITMS | BPC: Journal extra parameters |
| UJJ_DEPTBL | BPC: Dimension dependence table |
List of tables in Journals
| Table | Description |
|---|---|
| UJJ_E_JRNL_ADITM | Embedded: copy from UJJ_JRNL_ADITMS |
| UJJ_E_JRNID_NRAN | Embedded: copy from UJJ_JRNID_NRANGE |
| UJJ_P_JRNTMPL_PA | Journal template parameters |
| UJJ_E_JRNTMPL_PA | obsolete, replaced by UJJ_P_JRNTMPL_PA |
| UJJ_E_TMPL_FLDS | Embedded: copy from UJJ_TMPL_FLDS |
| UJJ_E_JRNTMPL_IN | Embedded: copy from UJJ_JRNTMPL_INFO |
| UJJ_TRANS_MASTER | BPC: Journal transformation master |
| UJJ_JRNTMPL_NAME | Journal template name for multiple templates |
| UJJ_JRNL_ADITMS | BPC: Journal extra parameters |
| UJJ_DEPTBL | BPC: Dimension dependence table |
| UJJ_E_TRANS_DTL | Embedded: copy from UJJ_TRANS_DETAIL |
| UJJ_JRN_ID_NR | Number range for journal idsof an application |
| UJJ_JRNL | BPC: Journals parameters |
| UJJ_P_JRNL_ADSO | BPC PAK: Mapping the relationship for journal adso |
| UJJ_E_JRN_ID_NR | Embedded: The journal ID tables for appset and application |
| UJJ_E_JRNBACKUP | Embedded: copy from UJJ_JRNBACKUP |
| UJJ_P_TMPL_ADITM | Embedded: enhance UJJ_E_TMPL_ADITM for TLOGO |
| UJJ_TRANS_DETAIL | BPC: Journal transformation detail |
| UJJ_ADDEDITEMS | Obsolete: Extra search items in journals header |
| UJJ_MEMSET | BPC: Dimension member set |
| UJJ_P_JRNTMPL_IN | Embedded: enhance UJJ_E_JRNTMPL_INFO for TLOGO |
| UJJ_P_JRNTMPL_NA | Embedded: enhance UJJ_E_JRNTMPL_NA for TLOGO |
| UJJ_P_TRANS_DTL | Embedded: enhance UJJ_E_TRANS_DTL for TLOGO |
| UJJ_P_TMPL_FLDS | Embedded: enhance UJJ_E_TMPL_FLDS for TLOGO |
| UJJ_E_TMPL_ADITM | Embedded: copy from UJJ_TMPL_ADITMS |
| UJJ_TMPL_FLDS | BPC: Journal header fields |
| UJJ_E_JRNTMPL_NA | Journal template name for multiple templates in embedded |
| UJJ_E_JRNL | Embedded: copy from UJJ_JRNL |
| UJJ_JRNBACKUP | BPC: backup information for Journal template |
| UJJ_P_JRNTMPL_FM | Embedded: store fixed dim members of header/detail dims |
| UJJ_JRNTMPL_FM | Standard: store fixed dim members of header/detail dims |
| UJJ_E_TRANS_MST | Embedded: copy from UJJ_E_TRANS_MASTER |
| UJJ_TMPL_ADITMS | BPC: Addtional items for template |
| UJJ_P_TRANS_MST | Embedded: enhance UJJ_E_TRANS_MST for TLOGO |
| UJJ_JRNID_NRANGE | Number range for journal ids of an application |
| UJJ_JRNTMPL_PARA | Journal template parameters for Standard |
| UJJ_JRNTMPL_INFO | BPC: Journals template |