M3 Reference

MITAUN

Prefix: MUmaster

Alternate units of measure — one row per item, unit type, and alternate unit, carrying the conversion factor between the alternate unit and the item's basic unit; the table that answers 'how many eaches in a case'

Module: Items & Product DataCompany-partitioned (CONO)Parent: MITMAS

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).

Parent & satellites

MITAUN is a satellite of MITMAS — many rows here per MITMAS row; join on ITNO plus the CONO (exact ON clause under Join details below).

Fields

6 fields · 4 key

6 fields.

Table fields: key flag, field name, column alias, description, data type, length, and decode flags. 6 fields.
Key	Field	Alias	Description	Type
Key	MUCONO	CONO	Company	numeric
Key	MUITNO	ITNO	Item number	alphanumeric
Key	MUAUTP	AUTP	Alternate unit type — which contexts (quantity, price) the alternate unit applies to	numeric
Key	MUALUN	ALUN	Alternate unit of measure	alphanumeric
	MUCOFA	COFA	Conversion factor between the alternate unit and the item's basic unit	numeric
	MUDMCF	DMCF	Conversion form — whether quantities multiply or divide by the factor when converting	numeric

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading MITAUN 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)Item number (ITNO)

Include optional filters (1)

4 parameters not filled: <catalog>, <schema>, <company>, <ITNO>

-- ============================================================
-- Table  : MITAUN — Alternate units of measure — one row per item, unit type, and alternate unit, carrying the conversion factor between the alternate unit and the item's basic unit; the table that answers 'how many eaches in a case'
-- Purpose: Column-selected read of MITAUN — auto-generated from field metadata
-- Grain  : One row per company (CONO) + MUITNO + MUAUTP + MUALUN
-- 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.MUCONO AS "Company",
  m.MUITNO AS "Item number",
  m.MUAUTP AS "Alternate unit type — which contexts (quantity, price) the alternate unit applies to",
  m.MUALUN AS "Alternate unit of measure",
  m.MUCOFA AS "Conversion factor between the alternate unit and the item's basic unit",
  m.MUDMCF AS "Conversion form — whether quantities multiply or divide by the factor when converting"
FROM <catalog>.<schema>.MITAUN m
WHERE
  m.MUCONO = <company>
  -- AND m.MUITNO = '<ITNO>'
ORDER BY m.MUITNO;

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

MITAUNMITMASforeign key · N:1
-- Uses this catalog's prefixed M3 column names; map raw Data Lake properties through Data Catalog first. ON MITAUN.MUITNO = MITMAS.MMITNO AND MITAUN.MUCONO = MITMAS.MMCONO

Programs That Use This Table

No program mappings populated for this table yet.

Browse more Items & Product Data tables