VL06O

-- ============================================================
-- T-Code : VL06O Outbound Delivery Monitor
-- Purpose: Outbound Delivery Monitor — auto-generated boilerplate from tcode-table-map
-- Grain  : One row per LIKP joined to LIPS
-- Tables : LIKP, LIPS
-- 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.VBELN AS "Delivery",
  l.POSNR AS "Delivery Item"
FROM <catalog>.<schema>.likp h
LEFT JOIN <catalog>.<schema>.lips l
  ON l.MANDT = h.MANDT
 AND l.VBELN = h.VBELN
WHERE
  h.MANDT = '<MANDT>'
  AND h.VBELN = '<VBELN>'
ORDER BY h.VBELN;