ME32K

-- ============================================================
-- T-Code : ME32K Change Contract
-- Purpose: Change Contract — auto-generated boilerplate from tcode-table-map
-- Grain  : One row per EKKO joined to EKPO
-- Tables : EKKO, EKPO
-- 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"
FROM <catalog>.<schema>.ekko h
LEFT JOIN <catalog>.<schema>.ekpo l
  ON l.MANDT = h.MANDT
 AND l.EBELN = h.EBELN
WHERE
  h.MANDT = '<MANDT>'
  AND h.EBELN = '<EBELN>'
ORDER BY h.EBELN;