SAP Reference
FS10N
Report S/4HANA status: ActiveG/L Account Balance Display
Notes
On S/4HANA, account balances derive from ACDOCA (Universal Journal); FS10N remains available but reads from the new data model.
What the badges mean
- S/4HANA status: Active
- Active and unchanged in S/4HANA.
- S/4HANA status: Deprecated
- Still readable today, but no longer SAP's strategic path — plan around it.
- S/4HANA status: Replaced
- Replaced by a new persistence in S/4HANA; the classic name may still answer reads (see read mechanism).
- S/4HANA status: Migrating to IBP
- Planning scope is moving from APO toward IBP.
- S/4HANA status: Active (StRM) · Replaced (EWM)
- Path-dependent: active with SAP Stock Room Management, replaced where EWM is the warehouse path.
- S/4HANA status: Replaced · Compat View
- Compatibility view: the classic table name is redirected to a view over the new persistence — see how the physical model moved.
- S/4HANA status: Active · Proxy View
- Proxy view: reads route through NSDM proxy/CDS views — see how the physical model moved.
- master
- Data class: what the table holds — master data, transaction documents, org structure, config, or texts (one row per language — see the quirks guide).
In field listings, K marks a primary-key field, and linked type codes in the Type column jump to the matching quirks-guide section.
Boilerplate SQL
Databricks SQLStarting point for querying the tables behind this transaction. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.
Query parameters
6 parameters not filled: <catalog>, <schema>, <MANDT>, <BUKRS>, <GJAHR>, <SAKNR>
-- ============================================================
-- T-Code : FS10N G/L Account Balance Display
-- Purpose: Period-by-period balance for a G/L account in a fiscal year
-- Grain : One row per account / fiscal-year / period with period columns
-- Tables : ACDOCA (S/4HANA Universal Journal — preferred), GLT0 (classic GL) or FAGLFLEXT (new GL), SKAT, T001
-- Notes : On S/4HANA, ACDOCA (Universal Journal) is the source of truth for actuals — derive balances from ACDOCA or released CDS views (e.g., I_GLAccountLineItem). GLT0 (classic GL) and FAGLFLEXT (new GL) remain readable for ECC/legacy scenarios; this query targets GLT0 for ECC compatibility. HSL01..12 hold amounts per posting period 1–12; HSL13..16 exist for special periods but are omitted here for the standard 12-period fiscal year.
-- ============================================================
SELECT
-- Keys
g.MANDT AS "Client",
g.RLDNR AS "Ledger",
g.RBUKRS AS "Company Code",
g.RYEAR AS "Fiscal Year",
g.RACCT AS "G/L Account",
-- Descriptive text
gl.TXT50 AS "G/L Account Name",
cc.BUTXT AS "Company Code Name",
-- Amounts + Currency (paired)
g.RTCUR AS "Transaction Currency",
g.HSLVT AS "Balance Carried Forward (Local)",
g.HSL01 AS "Period 1 Amount (Local)",
g.HSL02 AS "Period 2 Amount (Local)",
g.HSL03 AS "Period 3 Amount (Local)",
g.HSL04 AS "Period 4 Amount (Local)",
g.HSL05 AS "Period 5 Amount (Local)",
g.HSL06 AS "Period 6 Amount (Local)",
g.HSL07 AS "Period 7 Amount (Local)",
g.HSL08 AS "Period 8 Amount (Local)",
g.HSL09 AS "Period 9 Amount (Local)",
g.HSL10 AS "Period 10 Amount (Local)",
g.HSL11 AS "Period 11 Amount (Local)",
g.HSL12 AS "Period 12 Amount (Local)",
-- Computed: annual total
(g.HSL01 + g.HSL02 + g.HSL03 + g.HSL04 +
g.HSL05 + g.HSL06 + g.HSL07 + g.HSL08 +
g.HSL09 + g.HSL10 + g.HSL11 + g.HSL12) AS "Annual Total (Local)",
-- Status / indicators
g.DRCRK AS "Debit/Credit Indicator",
-- Master data enrichment
gl.MCOD1 AS "G/L Short Description"
FROM glt0 g
LEFT JOIN skat gl
ON gl.MANDT = g.MANDT
AND gl.SAKNR = g.RACCT
AND gl.SPRAS = 'E'
LEFT JOIN <catalog>.<schema>.t001 cc
ON cc.MANDT = g.MANDT
AND cc.BUKRS = g.RBUKRS
WHERE
g.MANDT = '<MANDT>'
AND g.RBUKRS = '<BUKRS>'
AND g.RYEAR = <GJAHR>
-- AND g.RACCT = '<SAKNR>'
ORDER BY g.RYEAR DESC, g.RBUKRS, g.RACCT;Tables Used by This Transaction
No table mappings populated for this t-code yet.