Now accepting guest editorial from SAP, Oracle, Workday and ServiceNow practitioners.Pitch a guide
The Sign-Off Table

Lesson 1 of 5

One table instead of many

7 min

If you have worked in SAP ECC, you will remember that "finance" was really several applications living side by side. The general ledger kept its line items and totals. Controlling (CO) kept its own line items and totals. Profit center accounting, asset accounting and the material ledger each had their own tables too. Every posting that touched more than one of them was written several times, and someone spent the end of every month proving those copies still agreed.

SAP S/4HANA replaced that with the Universal Journal: one line-item table, technically called ACDOCA, that holds the actual postings of the general ledger, controlling, profit center accounting, asset accounting, the material ledger and margin analysis together. Each line carries all the attributes those applications care about. SAP describes it as the single source of truth for financial data.

AreaSAP ECC (typical)SAP S/4HANA
General ledgerOwn line items plus period totals tablesLines in the Universal Journal
Controlling (cost centers, orders)Separate CO line items and totals; secondary cost elements as separate master dataSame lines, with cost center or order attributes
Profit center accountingSeparate ledger or new G/L scenarioProfit center field on every relevant line
Asset accountingSeparate asset line items and valuesAsset number on the asset-relevant lines
Material ledgerSeparate material ledger tablesMaterial ledger postings in the same journal
Profitability analysisSeparate CO-PA tablesMargin analysis attributes (customer, product, sales org and more) on the same lines
ReconciliationMonth-end checks between FI and CO; reconciliation ledgerLargely unnecessary: one set of lines
Before and after: where finance data lives.

Line items, not totals

ECC stored period totals (for example, the balance of account 400000 in period 9) in separate totals tables, updated with every posting. Those totals were how reports stayed fast on older databases. SAP S/4HANA runs on SAP HANA, an in-memory database that can add up millions of line items on the fly. So the totals tables were removed; for compatibility, views with the old names now calculate totals from the line items when a program asks for them. For you, the practical effect is that every balance in a report is the sum of real line items, and you can always drill down to them.

What stayed the same

The Universal Journal did not erase everything familiar. A journal entry still has a header and line items. The classic header and entry-view tables still exist and are still used for some operational processes such as open item management. Ledgers still exist: the leading ledger (usually called 0L) for your main accounting principle, and non-leading or extension ledgers for others. Company codes, fiscal years and posting periods are unchanged. What changed is that the detailed, reportable truth is in one place.

Source documentsBilling documents, goods movements, supplier invoices, asset postings, allocations, manual journal entries
Journal entry headerCompany code 1710, fiscal year, document type, posting date, reference to the source document
Universal Journal line itemsOne line per account and attribute combination: ledger, G/L account, amounts in several currencies, cost center, profit center, segment, asset, product, customer
Reports and appsTrial balance, line item reports, cost center reports, margin analysis, all reading the same lines
From source document to report in SAP S/4HANA.

In SAP S/4HANA Cloud Public Edition the Universal Journal works the same way. One difference worth knowing: Public Edition uses margin analysis only, while on-premise and Private Edition can still run costing-based profitability analysis alongside it, which keeps its own separate tables.

What would you do?

A Contoso controller who joined from an ECC shop asks when the monthly FI-CO reconciliation should be scheduled in the new SAP S/4HANA system. What is the best answer?

Key points
  • The Universal Journal (table ACDOCA) holds actual line items for G/L, controlling, profit centers, assets, material ledger and margin analysis.
  • Period totals are no longer stored; reports total line items on the fly.
  • Journal entries still have headers, ledgers and company codes.
  • Because FI and CO share one set of lines, they cannot drift apart.

Check your understanding · not graded

Lesson check

  1. 1. What is the technical name of the Universal Journal line-item table?

  2. 2. Which of these is NOT combined into the Universal Journal lines?

  3. 3. Why could SAP drop the period totals tables?

  4. 4. In SAP S/4HANA, what is the leading ledger usually called?