Analytics Catalog/SAP S/4HANA
SAP S/4HANA · Analytics Catalog
SAP S/4HANA Analytics Catalog
Built on ACDOCACustomer-ownedSAP-compliant extraction
The reference for building customer-owned analytics on SAP S/4HANA — by module. For each report: what it is, the source tables, the SQL, the owned star schema, and how to extract it the way SAP now permits. The finance core is live; the rest is rolling out.
◆Finance modules
General Ledger · FI-GLLive
Journal entries, trial balance, financial statements — the ACDOCA hub module.
Accounts Payable · FI-APLive
Vendor open items, aging, balances — the payables sub-ledger.
Accounts Receivable · FI-ARLive
Customer open items, aging, balances — the receivables sub-ledger.
Fixed Assets · FI-AALive
Asset history sheet, balances, transactions, depreciation — on ACDOCA.
Transaction Tax · FI-TaxLive
VAT return, reconciliation, withholding — the BSET tax lines.
Controlling · COLive
Cost center actuals, profit center P&L, internal order budget vs actual.
◆Logistics modules
Materials / Inventory · MMSoon
Stock on hand, movements, valuation, PO register — on MATDOC.
Sales / Billing · SDSoon
Billing register, revenue, backlog — the order-to-cash flow.
◆Project & Cash
Projects · PSSoon
Project actuals, WBS cost, project P&L — on ACDOCA.
Cash / BankSoon
Bank reconciliation, cash position, cash flow.
◆Editorial
Open items as of a past dateLive
Key-date reports reconstruct with documented defects. The owned snapshot that answers exactly, every time.
Stock as of a past dateLive
The standard report computes backwards from now, times out, and shifts. The daily stock snapshot.
Inventory agingLive
Fifteen years of forum asks. Aging needs receipt layers the data model does not keep; the owned model does.
No history by designLive
Embedded analytics reads live tables: current data only, archived data gone. The layer that remembers.
Currency and ledgersLive
One revenue figure is four numbers by currency type and parallel ledger. Carry both as dimensions, qualify every amount.
The 10,000-row wallLive
Analytical apps truncate silently at 10,000 rows. Where each workaround stops, and the pipeline without one.
Purchase price varianceLive
No delivered vendor-by-material pivot. The variance cube split by receipt and invoice stage.
Clearing-account agingLive
Tedious even with the standard apps. Uncleared items aged at order-line grain with root causes assigned.
Statement rebuildLive
The painter library is deprecating. Statement layouts rebuilt as versioned code on extracted journal data.
Margin history across migrationLive
Costing-based history cannot migrate. The union model that keeps the trend across the boundary.
Order backlog as of a past dateLive
Status fields overwrite in place. Daily order snapshots make backlog a filter.
Extraction rules decoderLive
What SAP actually blocked, what stays permitted, and the real deadline, stated neutrally.
Analytics cloud limitsLive
Live-connection performance, blending walls, and publication rationing, with the owned alternative.
Data platform costLive
Capacity units nobody can decode, metered add-ons, and what an owned warehouse costs instead.
◆The spine — built once, used everywhere
ACDOCALive
The Universal Journal — the single line-item table every finance report reads.
Extraction patternLive
The SAP-compliant way to move S/4HANA data to your cloud (Note 3255746).
CDS views indexLive
The released analytical views — the right object to extract per module.
Enterprise data modelLive
How the module stars conform into one owned model.
Every report in the catalog reads the released CDS view or ACDOCA directly — never a compatibility view, never ODP-RFC (SAP Note 3255746). See the extraction pattern →
Want a working module on your cloud in 10 days?
We build the reports, the owned star schema, and the SAP-compliant extract — reconciled to your books, and you own the code.
Terms on this page
- ACDOCA
- The Universal Journal — SAP's single table holding every finance posting in S/4HANA.
- Universal Journal
- The S/4HANA design that merged the GL, sub-ledgers, and CO into one line-item table.
- Sub-ledger
- A detailed ledger behind a GL account — payables, receivables, or assets.
- CDS view
- Core Data Services — an SAP-supplied, upgrade-safe view onto the tables.
- Star schema
- A report-friendly layout: one "facts" table with "lookup" tables around it.
- Customer-owned
- The code and data model are yours — no vendor lock-in, no per-seat platform fee.
- Extraction
- Moving S/4HANA data to your own cloud the way SAP now permits (Note 3255746).
- ODP-RFC
- An older extraction route SAP now bans for non-SAP tools (Note 3255746).