MPDMAT

-- ============================================================
-- Table  : MPDMAT — Product structure materials — one row per component in a product structure, with the quantity consumed per unit produced; the design-time counterpart of MWOMAT, joined to its header by PRNO + STRT
-- Purpose: Column-selected read of MPDMAT — auto-generated from field metadata
-- Grain  : One row per company (CONO) + PMFACI + PMPRNO + PMSTRT + PMMSEQ
-- Notes  : Auto-generated skeleton for a prefixed physical M3 schema or a landing schema normalized to the prefixed names in this catalog. Raw Data Lake property names vary with the published object: map them through Data Catalog before running this SQL. Dates are numeric YYYYMMDD (0 = none, mapped to NULL); all curated status values are decoded inline. Audit columns (RGDT/RGTM/LMDT/CHNO/CHID) omitted — see the quirks guide.
-- ============================================================
SELECT
  m.PMCONO AS "Company",
  m.PMFACI AS "Facility",
  m.PMPRNO AS "Product the structure builds",
  m.PMSTRT AS "Structure type",
  m.PMMSEQ AS "Material sequence number within the structure",
  m.PMMTNO AS "Component item — joins to the item master on ITNO",
  m.PMCNQT AS "Quantity of the component consumed per unit produced"
FROM <catalog>.<schema>.MPDMAT m
WHERE
  m.PMCONO = <company>
  -- AND m.PMFACI = '<FACI>'
ORDER BY m.PMFACI;