ME31L

-- ============================================================
-- T-Code : ME31L Create Scheduling Agreement
-- Purpose: Create Scheduling Agreement — auto-generated boilerplate from tcode-table-map
-- Grain  : One row per EKKO joined to EKPO, EKET, T161
-- Tables : EKKO, EKPO, EKET, T161
-- Notes  : Auto-generated skeleton. Add MAKT/T001W/LFA1/KNA1 enrichment joins as needed for the business question. 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.DESCRIPTION AS "Description",
  l.EBELP       AS "Item Number of Purchasing Document",
  e.EBELP       AS "Item Number of Purchasing Document",
  e.ETENR       AS "Delivery Schedule Line Counter",
  t.BSTYP       AS "Purchasing Document Category"
FROM <catalog>.<schema>.ekko h
LEFT JOIN <catalog>.<schema>.ekpo l
  ON l.MANDT = h.MANDT
 AND l.EBELN = h.EBELN
LEFT JOIN <catalog>.<schema>.eket e
  ON e.MANDT = h.MANDT
 AND e.EBELN = h.EBELN
LEFT JOIN <catalog>.<schema>.t161 t
  ON t.MANDT = h.MANDT
 AND t.BSART = h.BSART
WHERE
  h.MANDT = '<MANDT>'
  AND h.EBELN = '<EBELN>'
ORDER BY h.EBELN;