P3411

-- ============================================================
-- Program: P3411 MRP/MPS Detail Message Revisions — the screen where planners review and process the action messages MRP generated, releasing them into work orders or purchase orders.
-- Purpose: MRP/MPS Detail Message Revisions — the screen where planners review and process the action messages MRP generated, releasing them into work orders or purchase orders. — auto-generated boilerplate from program-table-map
-- Grain  : F3411 × F3412, F4102, F4801 — 1:N joins yield one row per detail line
-- Tables : F3411, F3412, F4102, 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.
-- ============================================================
SELECT
  h.MMUKID AS "Internal unique key — single-column primary key with no business meaning",
  h.MMDSC1 AS "Message text shown to the planner",
  ib.IBITM AS "Short item number - the internal numeric item key",
  TRIM(ib.IBMCU) AS "Business unit / branch plant (right-justified, space-padded to 12)"
FROM <catalog>.<schema_data>.f3411 h
LEFT JOIN <catalog>.<schema_data>.f3412 f
  ON f.MWUKID = h.MMUKID
LEFT JOIN <catalog>.<schema_data>.f4102 ib
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
LEFT JOIN <catalog>.<schema_data>.f4801 f4
  ON f4.WADOCO = h.MMDOCO
ORDER BY h.MMUKID;