Universal Journal Entry Line Items — Consolidation — the unified/consolidation-journal companion to the ACDOCA actuals spine already defined in this repo, holding group-close (SAP S/4HANA for group reporting) consolidated line items in the same universal-journal shape as ACDOCA/ACDOCP. Used for intercompany elimination, currency translation, and consolidation-of-investment postings that produce the group-level financial statements. SAP's real table carries roughly 106 fields (source: saplearners.com field listing, corroborated by SAP Community descriptions of the S/4HANA Group Reporting universal journal); leanx.eu has no page for this HANA-era table, so this definition is scoped to the key, ledger, organizational (consolidation unit/company, cost/profit center, functional area, business area, controlling area, segment), account, amount (per-currency value fields), quantity, date, and version (consolidation end-result version) fields a group-close crosswalk consumes.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| CLI key | cliens | Client | MANDT | CLNT 3 | — |
| LBR key | liber | Ledger in General Ledger Accounting — the consolidation ledger this line belongs to | FINS_LEDGER | CHAR 2 | FINSC_LEDGER |
| ANF key | annus fiscalis | Fiscal Year | GJAHR_POS | NUMC 4 | — |
| NDO key | numerus documenti | Document Number | BELNR_D | CHAR 10 | — |
| INS_POS_DOC key | inscriptio positio documentum | Posting Item / Document Line Number | DOCLN6 | CHAR 6 | — |
| TBR_CTS_DOC | tabula rationum coetus documentum | Consolidation Dimension — the consolidation chart of accounts/group structure this document belongs to | FC_RDIMEN | CHAR 4 | FCOMC_DIM |
| VRS_FIN_EFC | versio finis effectus | Version — the consolidation end-result version (actual, plan, forecast at the group level) | RVERS | CHAR 3 | T894 |
| SOC_UNI_INS | societas unitas inscriptio | Company — the consolidation unit/company posting this line | RCOMP | CHAR 6 | T880 |
| UNI | unitas | Consolidation Unit | FC_RCOMP | CHAR 10 | FCOMC_CONS_UNIT |
| CTS | coetus | Consolidation Group | FC_RCONGR | CHAR 10 | FCOMC_CONS_GRP |
| RAT_NUM_CTS | ratio numerus coetus | Account Number — the group/consolidation account this line posts against | RACCT | CHAR 10 | SKA1 |
| POS_TBR | positio tabula rationum | FS Item — the financial-statement item in the consolidation chart of accounts | FC_ITEM | CHAR 10 | FCOMC_ITEM |
| POS_SCS_SOC | positio socius societas | Sub-item — the consolidation sub-item (e.g. partner company for elimination detail) | FC_SITEM | CHAR 10 | FCOMC_SITEM |
| CSM | centrum sumptus | Cost Center | KOSTL | CHAR 10 | CSKS |
| CLU | centrum lucri | Profit Center | PRCTR | CHAR 10 | CEPC |
| AFN | area functionis | Functional Area | FKBER | CHAR 16 | TFKB |
| ANG | area negotii | Business Area | GSBER | CHAR 4 | TGSB |
| AMD | area moderationis | Controlling Area | KOKRS | CHAR 4 | TKA01 |
| SEG | segmentum | Segment for Segmental Reporting | FB_SEGMENT | CHAR 10 | FAGL_SEGM |
| SOC_SCS | societas socius | Company ID of Trading/Consolidation Partner — the intercompany partner for elimination | RASSC | CHAR 6 | T880 |
| SCS_CLU | socius centrum lucri | Partner Profit Center | PPRCTR | CHAR 10 | CEPC |
| SCS_SEG | socius segmentum | Partner Segment for Segmental Reporting | FB_PSEGMENT | CHAR 10 | FAGL_SEGM |
| TBR | tabula rationum | Chart of Accounts | KTOPL | CHAR 4 | T004 |
| GEN_INS_MON | genus inscriptio moneta | Business Transaction Type — identifies the consolidation posting type (e.g. IC elimination, currency translation, investment consolidation) | FINS_BTTYPE | CHAR 4 | FINSC_BTTYPE |
| RFR | referentia | Reference procedure | AWTYP | CHAR 5 | — |
| RFR_NDO | referentia numerus documenti | Reference document number | AWREF | CHAR 10 | — |
| USR_NOM | usor nomen | User Name | USNAM | CHAR 12 | — |
| MON | moneta | Transaction Currency | FINS_CURRW | CUKY 5 | — |
| SOC_MON | codex societatis moneta | Company Code / Local Currency | FINS_CURRH | CUKY 5 | — |
| CTS_MON | coetus moneta | Group Currency | FINS_CURRK | CUKY 5 | — |
| SUM_MON | summa moneta | Amount in Transaction Currency | FINS_VWCUR12 | CURR 23,2 | — |
| SUM_SOC_MON | summa codex societatis moneta | Amount in Local (Company Code) Currency | FINS_VHCUR12 | CURR 23,2 | — |
| SUM_CTS_MON | summa coetus moneta | Amount in Group Currency — the primary consolidated reporting value | FINS_VKCUR12 | CURR 23,2 | — |
| QNT | quantitas | Quantity | QUAN1_12 | QUAN 23,3 | — |
| DBT_CRD_IDX | debitum creditum index | Debit/Credit Indicator | SHKZG | CHAR 1 | — |
| INS_PER | inscriptio periodus | Posting period | POPER | NUMC 3 | — |
| DIN_DOC | dies inscriptionis documentum | Posting Date in the Document | BUDAT | DATS 8 | — |
| PER_ANN | periodus annus | Period/Year | JAHRPER | NUMC 7 | — |
| ANF2 | annus fiscalis | Fiscal Year Variant | PERIV | CHAR 2 | — |
| DIE_DOC | dies documentum | Day On Which Accounting Document Was Entered | CPUDT | DATS 8 | — |
| TMP_FRM | tempus forma | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC 15 | — |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
RLDNR | FINSC_LEDGER | RLDNR |
RDIMEN | FCOMC_DIM | RDIMEN |
RVERS | T894 | RVERS |
RCOMP | T880 | RCOMP |
RBUNIT | FCOMC_CONS_UNIT | RCOMP |
RCONGR | FCOMC_CONS_GRP | RCONGR |
RACCT | SKA1 | SAKNR |
RITCLG | FCOMC_ITEM | RITCLG |
RITEM | FCOMC_SITEM | RITEM |
RCNTR | CSKS | KOSTL |
PRCTR | CEPC | PRCTR |
RFAREA | TFKB | FKBER |
RBUSA | TGSB | GSBER |
KOKRS | TKA01 | KOKRS |
SEGMENT | FAGL_SEGM | SEGMENT |
RASSC | T880 | RCOMP |
PPRCTR | CEPC | PRCTR |
PSEGMENT | FAGL_SEGM | SEGMENT |
KTOPL | T004 | KTOPL |
BTTYPE | FINSC_BTTYPE | BTTYPE |