FS10N

-- ============================================================
-- 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;