P4210

-- ============================================================
-- Program: P4210 Sales Order Entry — the interactive application that creates and maintains F4201/F4211 orders
-- Purpose: Sales Order Entry — the interactive application that creates and maintains F4201/F4211 orders — auto-generated boilerplate from program-table-map
-- Grain  : F4201 × F4211 — 1:N joins yield one row per detail line
-- Tables : F4201, F4211
-- 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: F41021, F0101 are cataloged for this program, but no verified join condition connects them to F4201, so they are left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.SHKCOO AS "Order key company - disambiguates order numbers across companies",
  h.SHDOCO AS "Order number",
  h.SHDCTO AS "Order type code (SO, ST, CO, ...)",
  d.SDLNID / POWER(10, 3) AS "Order line number, stored x1000 (3 implied decimals)"  -- implied decimals: 3 (verify in F9210)
FROM <catalog>.<schema_data>.f4201 h
LEFT JOIN <catalog>.<schema_data>.f4211 d
  ON d.SDDOCO = h.SHDOCO
 AND d.SDKCOO = h.SHKCOO
 AND d.SDDCTO = h.SHDCTO
WHERE
  h.SHKCOO = '<KCOO>'
  AND h.SHDOCO = <DOCO>
  AND h.SHDCTO = '<DCTO>'
ORDER BY h.SHKCOO;