P4915

-- ============================================================
-- Program: P4915 Work With Shipments — the interactive workbench for reviewing, revising, routing, rating, and approving shipments after order entry creates them
-- Purpose: Work With Shipments — the interactive workbench for reviewing, revising, routing, rating, and approving shipments after order entry creates them — auto-generated boilerplate from program-table-map
-- Grain  : F4215 × F4941 — 1:N joins yield one row per detail line
-- Tables : F4215, F4941
-- Notes  : Auto-generated skeleton. Julian dates are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210). Audit columns (…USER/…PID/…UPMJ) are omitted — see the quirks guide. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- Omitted: F4211 is cataloged for this program, but no verified join condition connects it to F4215, so it is left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.XHSHPN AS "Shipment number - the system-assigned key that groups order lines for transport; the same value lands on F4211.SDSHPN.",
  f.RSRSSN / POWER(10, 1) AS "Routing step number within the shipment."  -- implied decimals: 1 (verify in F9210)
FROM <catalog>.<schema_data>.f4215 h
LEFT JOIN <catalog>.<schema_data>.f4941 f
  ON f.RSSHPN = h.XHSHPN
WHERE
  h.XHSHPN = <SHPN>
ORDER BY h.XHSHPN;