R3482

-- ============================================================
-- Program: R3482 MRP/MPS Requirements Planning — the batch job that runs single-facility MRP/MPS, netting forecasts, sales orders, and on-hand supply into time-phased plans and action messages.
-- Purpose: MRP/MPS Requirements Planning — the batch job that runs single-facility MRP/MPS, netting forecasts, sales orders, and on-hand supply into time-phased plans and action messages. — auto-generated boilerplate from program-table-map
-- Grain  : F3411 × F3412, F4801 — 1:N joins yield one row per detail line
-- Tables : F3411, F3412, F4801
-- 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: F3413, F3460, F4102 are cataloged for this program, but no verified join condition connects them to F3411, so they are left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.MMUKID AS "Internal unique key — single-column primary key with no business meaning",
  h.MMDSC1 AS "Message text shown to the planner"
FROM <catalog>.<schema_data>.f3411 h
LEFT JOIN <catalog>.<schema_data>.f3412 f3
  ON f3.MWUKID = h.MMUKID
LEFT JOIN <catalog>.<schema_data>.f4801 f4
  ON f4.WADOCO = h.MMDOCO
ORDER BY h.MMUKID;