P3413

-- ============================================================
-- Program: P3413 MPS Time Series — the screen that shows an item's time-phased supply and demand picture (the planning time series) produced by the last MRP/MPS run.
-- Purpose: MPS Time Series — the screen that shows an item's time-phased supply and demand picture (the planning time series) produced by the last MRP/MPS run. — auto-generated boilerplate from program-table-map
-- Grain  : F3413 × F3411, F4102 — 1:N joins yield one row per detail line
-- Tables : F3413, F3411, F4102
-- 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.MRITM AS "Short item number — part of the primary key",
  TRIM(h.MRMCU) AS "Branch/plant — part of the primary key; right-justified 12-character",
  h.MRQT AS "Quantity type — the row dimension of the time series (forecast, gross requirements, planned orders, projected available, ATP, ...); part of the primary key",
  CASE WHEN h.MRSTRT IS NULL OR h.MRSTRT = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(h.MRSTRT AS INT) DIV 1000, 1, 1), CAST(h.MRSTRT AS INT) % 1000 - 1) END AS "Bucket start date (Julian CYYDDD) — part of the primary key",  -- CYYDDD Julian → DATE
  f.MMUKID AS "Internal unique key — single-column primary key with no business meaning"
FROM <catalog>.<schema_data>.f3413 h
LEFT JOIN <catalog>.<schema_data>.f3411 f
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
LEFT JOIN <catalog>.<schema_data>.f4102 ib
  ON ib.IBITM = h.MRITM
 AND ib.IBMCU = h.MRMCU
WHERE
  h.MRITM = <ITM>
  AND h.MRMCU = '<MCU>'
ORDER BY h.MRITM;