M3 Reference

MWOMAT

Prefix: VMtransaction

Manufacturing order materials — one row per component line on an order, with required and reported quantities; copied from the product structure at order creation and then consumed against, joined to its header by MFNO

Module: ManufacturingCompany-partitioned (CONO)Header: MWOHED

What the badges mean

Prefix: MM: Prefix: the table’s 2-character physical-column prefix (e.g. MM on MITMAS) — every field alias on the table carries it. Join by matching aliases across tables, not full column names (see the quirks guide).
master: Data class: what the table holds — master data, balances, transaction documents, code/reference tables, or history.
Shared across companies: The table carries no CONO — rows aren’t partitioned per company (see the quirks guide).
Division-level: The table carries DIVI — rows are scoped below company to a division, one layer more granular than CONO alone (see the quirks guide).

Used in the library

KPI definitions

K-08Schedule Attainment

K-13First Pass Yield

Dashboard patterns

D-06Production Schedule Performance

Header & line

MWOMAT lines join back to their header MWOHED — and the CONO — so a line never fans out across companies.

Fields

8 fields · 4 key

8 fields.

Table fields: key flag, field name, column alias, description, data type, length, and decode flags. 8 fields.
Key	Field	Alias	Description	Type
Key	VMCONO	CONO	Company	numeric
Key	VMFACI	FACI	Facility	alphanumeric
Key	VMMFNO	MFNO	Manufacturing order number	alphanumeric
Key	VMMSEQ	MSEQ	Material sequence number within the order	numeric
	VMMTNO	MTNO	Component item consumed — joins to the item master on ITNO	alphanumeric
	VMREQT	REQT	Required quantity of the component for the order	numeric
	VMRPQT	RPQT	Reported (issued) quantity of the component so far	numeric
	VMWHLO	WHLO	Warehouse the component is issued from	alphanumeric

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading MWOMAT on Databricks — numeric YYYYMMDD dates are wrapped to NULL, verified status ladders are decoded, and the CONO anchor is in place. Set your Unity Catalog location, company, and filter values below; they’re substituted into the SQL and the copy button.

Query parameters

CatalogSchemaCompany (CONO)Facility (FACI)Manufacturing order (MFNO)

Include optional filters (2)

5 parameters not filled: <catalog>, <schema>, <company>, <FACI>, <MFNO>

-- ============================================================
-- Table  : MWOMAT — Manufacturing order materials — one row per component line on an order, with required and reported quantities; copied from the product structure at order creation and then consumed against, joined to its header by MFNO
-- Purpose: Column-selected read of MWOMAT — auto-generated from field metadata
-- Grain  : One row per company (CONO) + VMFACI + VMMFNO + VMMSEQ
-- 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.VMCONO AS "Company",
  m.VMFACI AS "Facility",
  m.VMMFNO AS "Manufacturing order number",
  m.VMMSEQ AS "Material sequence number within the order",
  m.VMMTNO AS "Component item consumed — joins to the item master on ITNO",
  m.VMREQT AS "Required quantity of the component for the order",
  m.VMRPQT AS "Reported (issued) quantity of the component so far",
  m.VMWHLO AS "Warehouse the component is issued from"
FROM <catalog>.<schema>.MWOMAT m
WHERE
  m.VMCONO = <company>
  -- AND m.VMFACI = '<FACI>'
  -- AND m.VMMFNO = '<MFNO>'
ORDER BY m.VMFACI;

Verified September 2026

Relationships

Diagram of 1-hop neighbors — join details below. CSYTAB decode edges are highlighted; they’re the joins newcomers most often get wrong.

Join details

MWOHEDMWOMATheader line · 1:N
-- Uses this catalog's prefixed M3 column names; map raw Data Lake properties through Data Catalog first. ON MWOHED.VHMFNO = MWOMAT.VMMFNO AND MWOHED.VHFACI = MWOMAT.VMFACI AND MWOHED.VHCONO = MWOMAT.VMCONO