MITMAS

-- ============================================================
-- Table  : MITMAS — The item master — one row per item per company, carrying the item's identity, status, grouping codes, basic unit of measure, and physical attributes; every balance, order line, and stock movement joins back to it on ITNO
-- Purpose: Column-selected read of MITMAS — auto-generated from field metadata
-- Grain  : One row per company (CONO) + MMITNO
-- 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
  im.MMCONO AS "Company",
  im.MMITNO AS "Item number — the natural key every balance, order line, and movement joins on",
  CASE im.MMSTAT WHEN '00' THEN 'Created, basic data incomplete' WHEN '05' THEN 'Basic data specified' WHEN '10' THEN 'Preliminarily released — purchasable, not usable' WHEN '15' THEN 'To be replaced by another item' WHEN '20' THEN 'Released' WHEN '30' THEN 'Alternate items exist' WHEN '50' THEN 'Use then discontinue' WHEN '80' THEN 'Discontinued — stock transactions still permitted' WHEN '90' THEN 'Discontinued — set manually' WHEN '99' THEN 'Discontinued through item-number change' ELSE im.MMSTAT END AS "Item status — a two-char lifecycle ladder from created through released to discontinued",  -- status: ITEM_STAT (all 10 curated values)
  im.MMITDS AS "Item name (short description)",
  im.MMFUDS AS "Item description (full)",
  im.MMITTY AS "Item type — the code that controls how the item behaves across modules",
  im.MMITGR AS "Item group — the primary reporting and posting bucket for the item",
  im.MMITCL AS "Product group — a second classification slice alongside the item group",
  im.MMBUAR AS "Business area — the broadest reporting classification on the item",
  im.MMUNMS AS "Basic unit of measure — the unit balances and movements are stored in",
  im.MMNEWE AS "Net weight of one basic unit",
  im.MMGRWE AS "Gross weight of one basic unit",
  im.MMVOL3 AS "Volume of one basic unit — with weight, the basis for load and freight math",
  im.MMRESP AS "Responsible — the user accountable for the item's master data"
FROM <catalog>.<schema>.MITMAS im
WHERE
  im.MMCONO = <company>
  -- AND im.MMITNO = '<ITNO>'
ORDER BY im.MMITNO;