EKBE

-- ============================================================
-- Table  : EKBE History per Purchasing Document
-- Purpose: Column-selected read of EKBE — auto-generated from field metadata
-- Grain  : One row per EBELN + EBELP + ZEKKN + VGABE + GJAHR + BELNR + 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
  e.MANDT AS "Client",
  e.EBELN AS "Purchasing Document Number",
  e.EBELP AS "Item Number of Purchasing Document",
  e.ZEKKN AS "Sequential Number of Account Assignment",
  e.VGABE AS "Transaction/Event Type",
  e.GJAHR AS "Material Document Year",
  e.BELNR AS "Number of Material Document",
  e.BUZEI AS "Item in Material Document",
  e.BEWTP AS "PO History Category",
  e.BWART AS "Movement Type (Inventory Management)",
  e.BUDAT AS "Posting Date in the Document",
  e.MENGE AS "Quantity",
  e.BPMNG AS "Quantity in Purchase Order Price Unit",
  e.DMBTR AS "Amount in Local Currency",
  e.WRBTR AS "Amount in Document Currency",
  e.WAERS AS "Currency Key",
  e.AREWR AS "GR/IR Account Clearing Value in Local Currency",
  e.WESBS AS "Goods Receipt Blocked Stock in Order Unit",
  e.BPWES AS "GR Blocked Stock Quantity in Order Price Unit",
  e.SHKZG AS "Debit/Credit Indicator",
  e.BWTAR AS "Valuation Type",
  e.ELIKZ AS "Delivery Completed Indicator",
  e.XBLNR AS "Reference Document Number",
  e.LFGJA AS "Fiscal Year of a Fiscal Year Variant",
  e.LFBNR AS "Document No. of a Reference Document",
  e.LFPOS AS "Item of a Reference Document",
  e.CPUDT AS "Day On Which Accounting Document Was Entered",
  e.CPUTM AS "Time of Entry",
  e.REEWR AS "Invoice Value in Local Currency",
  e.EVERE AS "Compliance with Shipping Instructions",
  e.REFWR AS "Invoice Value in Foreign Currency",
  e.MATNR AS "Material Number",
  e.WERKS AS "Plant",
  e.XWSBR AS "Reversal of GR Allowed for GR-Based IV Despite Invoice",
  e.ETENS AS "Sequential Number of Vendor Confirmation",
  e.KNUMV AS "Document Condition Number",
  e.MWSKZ AS "Tax on Sales/Purchases Code",
  e.LSMNG AS "Quantity in Unit of Measure from Delivery Note",
  e.LSMEH AS "Unit of Measure from Delivery Note"
FROM <catalog>.<schema>.ekbe e
WHERE
  e.MANDT = '<MANDT>'
  -- AND e.GJAHR = <GJAHR>
ORDER BY e.EBELN;