F3412

-- ============================================================
-- Table  : F3412 MRP pegging — one row per lower-level requirement showing which parent item/order generated demand for a component, so you can trace a shortage up to the end-item order that caused it
-- Purpose: Column-selected read of F3412 — auto-generated from field metadata
-- Grain  : One row per MWUKID
-- Notes  : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. 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
  f.MWUKID AS "Internal unique key — the primary key; no business meaning",
  f.MWITM AS "Component short item number the requirement is for",
  TRIM(f.MWMCU) AS "Component branch/plant — right-justified 12-character",
  CASE WHEN f.MWDRQJ IS NULL OR f.MWDRQJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.MWDRQJ AS INT) DIV 1000, 1, 1), CAST(f.MWDRQJ AS INT) % 1000 - 1) END AS "Date the component is required (Julian CYYDDD)",  -- CYYDDD Julian → DATE
  f.MWLOVD AS "Leadtime offset days applied when exploding the requirement down from the parent",
  f.MWKIT AS "Parent short item number whose planned or actual order generated this demand",
  TRIM(f.MWMMCU) AS "Parent branch/plant — right-justified 12-character",
  f.MWUORG AS "Requirement quantity pegged to the parent",
  f.MWDOCO AS "Order number of the pegged supply/demand order (work order, purchase order, etc.)",
  f.MWDCTO AS "Order type of the pegged order",
  f.MWRKCO AS "Company of the related order",
  f.MWRORN AS "Related order number — carries the originating order reference through the peg",
  f.MWRCTO AS "Related order type",
  f.MWRLLN / POWER(10, 3) AS "Related order line number; 3 implied decimals",  -- implied decimals: 3 (verify in F9210)
  f.MWPLNK AS "Pegging record link — internal pointer chaining related pegging rows across levels",
  f.MWPRJM AS "Project number for project-driven requirements",
  f.MWSRDM AS "Source demand reference for replenishment-driven requirements",
  f.MWPNS AS "Production number short for production-number-controlled pegging"
FROM <catalog>.<schema_data>.f3412 f
WHERE
  f.MWDRQJ >= <DRQJ_FROM>  -- Julian CYYDDD, e.g. 126001
  -- AND f.MWDRQJ <= <DRQJ_TO>  -- Julian CYYDDD, e.g. 126365
ORDER BY f.MWUKID;