Analytics Catalog/SAP S/4HANA/General Ledger/Data model
Explore the catalogACDOCATrial BalanceCDS viewsExtraction
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.

ACDOCA — the Universal Journal every G/L posting lands here · the single spine fct_gl_line_itemsLine itemsfct_gl_balanceTrial balancefct_journal_linesDocument journal Conformed dimensions — shared by every GL fact dim_gl_account · dim_company_code · dim_cost_center · dim_date · dim_fsv_node
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.
FactGrain (one row per)Built from
fct_gl_line_itemsG/L posting lineACDOCA · I_GLAccountLineItem
fct_gl_balanceaccount × period balanceACDOCA aggregated by RACCT
fct_journal_linesjournal document lineACDOCA + 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.
DimensionWhat it isMaster
dim_gl_accountG/L account & FSV node (RACCT)SKA1 · G/L master
dim_company_codeCompany code (RBUKRS)T001
dim_cost_centerCost center (RCNTR)CSKS
dim_dateFiscal year & posting periodcalendar
dim_fsv_nodeFinancial statement version nodeI_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.
◆ How it is built & owned— over the source + released CDS views, on your cloud, extracted the compliant way.
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.
Talk to us