VT01N

-- ============================================================
-- T-Code : VT01N Create Shipment
-- Purpose: Create Shipment — auto-generated boilerplate from tcode-table-map
-- Grain  : One row per VTTK joined to VTTP, VTTS, VTSP, VTPA
-- Tables : VTTK, VTTP, VTTS, VTSP, VTPA
-- 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.TKNUM   AS "Shipment Number",
  l.TPNUM   AS "Item Number in the Shipment",
  v.TSNUM   AS "Stage Number in Transport",
  vt.TSNUM  AS "Stage Number in Transport",
  vt.TPNUM  AS "Item Number in the Shipment",
  vtp.VBELN AS "Shipment Number",
  vtp.POSNR AS "Item number of the SD document",
  vtp.PARVW AS "Partner Function"
FROM <catalog>.<schema>.vttk h
LEFT JOIN <catalog>.<schema>.vttp l
  ON l.MANDT = h.MANDT
 AND l.TKNUM = h.TKNUM
LEFT JOIN <catalog>.<schema>.vtts v
  ON v.MANDT = h.MANDT
 AND v.TKNUM = h.TKNUM
LEFT JOIN <catalog>.<schema>.vtsp vt
  ON vt.MANDT = h.MANDT
 AND vt.TKNUM = h.TKNUM
LEFT JOIN <catalog>.<schema>.vtpa vtp
  ON vtp.MANDT = h.MANDT
WHERE
  h.MANDT = '<MANDT>'
  AND h.TKNUM = '<TKNUM>'
ORDER BY h.TKNUM;