SAP S/4HANA · General Ledger
General Ledger Data Model
Three GL factsOn ACDOCAConformed dimensions
One owned model for the General Ledger. The line-item, balance, and journal facts are all built from ACDOCA and join one shared set of conformed dimensions. The same set every other finance module uses.
One source (ACDOCA) · three GL facts · one shared set of conformed dimensions — the same set your finance model uses.
Why it matters: when the General Ledger facts share the same account, account, and date, a number means the same thing in every General Ledger report — and it reconciles with the rest of finance, because the dimensions are the same ones the enterprise model uses.
Tap a section to drill in.
◆ The General Ledger facts— each is a thin view over the source, sharing the same keys.
| Fact | Grain (one row per) | Built from |
|---|---|---|
| fct_gl_line_items | G/L posting line | ACDOCA · I_GLAccountLineItem |
| fct_gl_balance | account × period balance | ACDOCA aggregated by RACCT |
| fct_journal_lines | journal document line | ACDOCA + BKPF header |
All three read the same table — ACDOCA — and differ only in grain. The trial balance and financial statement are the balance fact rolled up the dim_fsv_node hierarchy; the journal is the line keyed by document.
◆ The conformed dimensions— one account, one account, one calendar — used by every fact.
| Dimension | What it is | Master |
|---|---|---|
| dim_gl_account | G/L account & FSV node (RACCT) | SKA1 · G/L master |
| dim_company_code | Company code (RBUKRS) | T001 |
| dim_cost_center | Cost center (RCNTR) | CSKS |
| dim_date | Fiscal year & posting period | calendar |
| dim_fsv_node | Financial statement version node | I_FinancialStatementVersionNode |
Conformed means the same dimension table, the same keys, joined by every fact that needs it — so a value means the same thing in every report.
◆ Why it is one model, not three— the dimensions are shared, and it plugs straight into your finance model.
- Shared dimensions — all three facts join the same account, account, and date dimensions, so a number reconciles across the reports instead of arguing.
- One source — ACDOCA feeds every fact; the reports differ only in grain.
- It is the same conformed set the rest of finance uses — dim_company_code, dim_gl_account, and dim_date are shared with the enterprise model, so General Ledger is not a silo.
- Add later without rebuilding — new measures join the dimensions that already exist.
◆ How it is built & owned— over the source + released CDS views, on your cloud, extracted the compliant way.
- Source — ACDOCA for the postings; the released views I_GLAccountLineItem and I_FinancialStatementVersionNode for the account and FSV dimensions.
- Build — dbt models: the facts and conformed dimensions, reconciled to the source ERP before go-live.
- Land — your own cloud warehouse: GCP, AWS, or Azure.
- Extract — released CDS + ODP-OData, SLT, or Table/Table-CDC; never ODP-RFC. See the extraction pattern →
- Fits the whole — these facts and dimensions slot into the enterprise data model via the conformed keys.
Terms on this page
- G/L account (RACCT)
- The account a posting hits; in S/4HANA it carries the cost element too.
- FSV node
- A node of the financial statement version — how accounts roll into the balance sheet and P&L.
- Trial balance
- Debits and credits per account per period — the balance fact.
- Fact
- A table of measures and keys — the numbers you aggregate.
- Conformed dimension
- One dimension shared by every fact, so a value means the same thing everywhere.
- ACDOCA
- The Universal Journal — the single S/4HANA table behind the finance facts.
- Star schema
- One fact surrounded by its dimensions — the report-friendly shape.
- Grain
- What one row of a fact represents — the level of detail.
Want your General Ledger model built & owned?
We build the line-item, balance, and journal facts on ACDOCA — reconciled to the trial balance before go-live — and your team owns every line of code.