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 × F4102 — 1:N joins yield one row per detail line
-- Tables : F3413, 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.
-- Omitted: F3411 is cataloged for this program, but no verified join condition connects it to F3413, so it is left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
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
FROM <catalog>.<schema_data>.f3413 h
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;