EKKO

-- ============================================================
-- Table  : EKKO Purchasing Document Header
-- Purpose: Column-selected read of EKKO — auto-generated from field metadata
-- Grain  : One row per EBELN
-- 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.EBELN    AS "Purchasing Document Number",
  h.BUKRS    AS "Company Code",
  h.BSTYP    AS "Purchasing Document Category",
  h.BSART    AS "Purchasing Document Type",
  h.BSAKZ    AS "Control Indicator for Purchasing Document Type",
  h.LOEKZ    AS "Deletion Indicator in Purchasing Document",
  h.STATU    AS "Status of Purchasing Document",
  h.AEDAT    AS "Created On",
  h.ERNAM    AS "Name of Person Who Created the Object",
  h.PINCR    AS "Item Number Interval",
  h.LPONR    AS "Last Item Number",
  h.LIFNR    AS "Vendor Account Number",
  h.SPRAS    AS "Language Key",
  h.ZTERM    AS "Terms of Payment Key",
  h.ZBD1T    AS "Cash Discount Days 1",
  h.ZBD2T    AS "Cash Discount Days 2",
  h.ZBD3T    AS "Cash Discount Days 3 (Net Payment)",
  h.ZBD1P    AS "Cash Discount Percentage 1",
  h.ZBD2P    AS "Cash Discount Percentage 2",
  h.EKORG    AS "Purchasing Organization",
  h.EKGRP    AS "Purchasing Group",
  h.WAERS    AS "Currency Key",
  h.WKURS    AS "Exchange Rate",
  h.KUFIX    AS "Indicator: Fixing of Exchange Rate",
  h.BEDAT    AS "Purchasing Document Date",
  h.KDATB    AS "Start of Validity Period",
  h.KDATE    AS "End of Validity Period",
  h.BWBDT    AS "Closing Date for Applications",
  h.ANGDT    AS "Deadline for Submission of Bid/Quotation",
  h.BNDDT    AS "Binding Period for Quotation",
  h.GWLDT    AS "Warranty Date",
  h.KUNNR    AS "Customer Number",
  h.LLIEF    AS "Supplying Vendor",
  h.LPHIS    AS "Indicator for Scheduling Agreement Release Documentation",
  h.SUBMI    AS "Collective Number",
  h.KNUMV    AS "Number of the Document Condition",
  h.KALSM    AS "Procedure (Pricing, Output Control, Acct Det, etc.)",
  h.PROCSTAT AS "Purchasing Document Processing State",
  h.RLWRT    AS "Value at Time of Release (Total)"
  -- … plus 14 more columns — full list in the Fields section above
FROM <catalog>.<schema>.ekko h
WHERE
  h.MANDT = '<MANDT>'
ORDER BY h.EBELN;