BSEG

-- ============================================================
-- Table  : BSEG Accounting Document Segment
-- Purpose: Column-selected read of BSEG — auto-generated from field metadata
-- Grain  : One row per BUKRS + BELNR + GJAHR + BUZEI
-- 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
  l.MANDT AS "Client",
  l.BUKRS AS "Company Code",
  l.BELNR AS "Accounting Document Number",
  l.GJAHR AS "Fiscal Year",
  l.BUZEI AS "Number of Line Item Within Accounting Document",
  l.BSCHL AS "Posting Key",
  l.KOART AS "Account Type",
  l.HKONT AS "General Ledger Account",
  l.DMBTR AS "Amount in Local Currency",
  l.WRBTR AS "Amount in Document Currency"
FROM <catalog>.<schema>.bseg l
WHERE
  l.MANDT = '<MANDT>'
  -- AND l.BUKRS = '<BUKRS>'
  -- AND l.GJAHR = <GJAHR>
ORDER BY l.BUKRS;