EKET

-- ============================================================
-- Table  : EKET Scheduling Agreement Schedule Lines
-- Purpose: Column-selected read of EKET — auto-generated from field metadata
-- Grain  : One row per EBELN + EBELP + ETENR
-- 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.ETENR AS "Delivery Schedule Line Counter",
  e.EINDT AS "Item Delivery Date",
  e.SLFDT AS "Statistics-Relevant Delivery Date",
  e.LPEIN AS "Category of Delivery Date",
  e.MENGE AS "Scheduled Quantity",
  e.AMENG AS "Previous Quantity (Delivery Schedule Lines)",
  e.WEMNG AS "Quantity of Goods Received",
  e.WAMNG AS "Issued Quantity",
  e.UZEIT AS "Delivery Time",
  e.BANFN AS "Purchase Requisition Number",
  e.BNFPO AS "Item Number of Purchase Requisition",
  e.ESTKZ AS "Creation Indicator",
  e.DAT01 AS "Committed Date",
  e.MNG02 AS "Committed Quantity"
FROM <catalog>.<schema>.eket e
WHERE
  e.MANDT = '<MANDT>'
ORDER BY e.EBELN;