BKPF

-- ============================================================
-- Table  : BKPF Accounting Document Header
-- Purpose: Column-selected read of BKPF — auto-generated from field metadata
-- Grain  : One row per BUKRS + BELNR + GJAHR
-- Notes  : Auto-generated skeleton. For multi-table transaction query patterns, see the linked t-codes on this page. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  h.MANDT AS "Client",
  h.BUKRS AS "Company Code",
  h.BELNR AS "Accounting Document Number",
  h.GJAHR AS "Fiscal Year",
  h.BLART AS "Document Type",
  h.BLDAT AS "Document Date in Document",
  h.BUDAT AS "Posting Date in the Document",
  h.MONAT AS "Fiscal Period"
FROM <catalog>.<schema>.bkpf h
WHERE
  h.MANDT = '<MANDT>'
  -- AND h.BUKRS = '<BUKRS>'
  -- AND h.GJAHR = <GJAHR>
ORDER BY h.BUKRS;