M3 Reference
MMS080
InteractiveMaterial plan — the per-item, per-warehouse view over MITPLO where planners work supply and demand
Tables vs APIs
This program works over the tables below. For analytics at scale, land the raw tables — the SQL further down reads them directly, joined on their keys and CONO. When to land tables vs call MI APIs
Boilerplate SQL
Databricks SQLStarting point for reading the tables behind MMS080 from landed data — the backing tables joined on their keys and CONO. Set your Unity Catalog location, company, and filter values below.
Query parameters
3 parameters not filled: <catalog>, <schema>, <company>
-- ============================================================
-- Program: MMS080 — Material plan — the per-item, per-warehouse view over MITPLO where planners work supply and demand
-- Purpose: Read the tables behind program MMS080 — auto-generated from program-table-map
-- Grain : MITPLO × MITBAL — 1:N joins yield one row per line
-- Tables : MITPLO, MITBAL
-- 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; company-partitioned tables are joined on CONO to prevent cross-company fan-out. Audit columns (RGDT/RGTM/LMDT/CHNO/CHID) omitted — see the quirks guide.
-- ============================================================
SELECT
h.MOCONO AS "Company",
h.MOWHLO AS "Warehouse",
h.MOITNO AS "Item number",
CASE WHEN h.MOPLDT = 0 THEN NULL ELSE TO_DATE(CAST(CAST(h.MOPLDT AS BIGINT) AS STRING), 'yyyyMMdd') END AS "Planning date the transaction is scheduled on", -- YYYYMMDD, 0 → NULL
h.MOTRQT AS "Planned quantity, signed by direction (demand negative, supply positive)",
ib.MBSTAT AS "Item/warehouse status — whether the item is active in this warehouse", -- status: decode ib.MBSTAT against your configuration — see quirks guide #statuses
ib.MBSTQT AS "On-hand balance in the warehouse, in the basic unit"
FROM <catalog>.<schema>.MITPLO h
LEFT JOIN <catalog>.<schema>.MITBAL ib
ON ib.MBWHLO = h.MOWHLO
AND ib.MBITNO = h.MOITNO
AND ib.MBCONO = h.MOCONO
WHERE
h.MOCONO = <company>
ORDER BY h.MOWHLO;