M3 Reference

CMNDIV

Prefix: CCmasterDivision-level

The division master — one row per division within a company; the DIVI that financial and divisional tables carry resolves here

Module: FoundationCompany-partitioned (CONO)

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

Fields

3 fields · 2 key

3 fields.

Table fields: key flag, field name, column alias, description, data type, length, and decode flags. 3 fields.
Key	Field	Alias	Description	Type
Key	CCCONO	CONO	Company	numeric
Key	CCDIVI	DIVI	Division — the code divisional and financial tables carry	alphanumeric
	CCTX40	TX40	Division name	alphanumeric

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading CMNDIV 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)Division (DIVI)

Include optional filters (1)

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

-- ============================================================
-- Table  : CMNDIV — The division master — one row per division within a company; the DIVI that financial and divisional tables carry resolves here
-- Purpose: Column-selected read of CMNDIV — auto-generated from field metadata
-- Grain  : One row per company (CONO) + CCDIVI
-- 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
  c.CCCONO AS "Company",
  c.CCDIVI AS "Division — the code divisional and financial tables carry",
  c.CCTX40 AS "Division name"
FROM <catalog>.<schema>.CMNDIV c
WHERE
  c.CCCONO = <company>
  -- AND c.CCDIVI = '<DIVI>'
ORDER BY c.CCCONO;

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

CFACILCMNDIVforeign key · N:1
-- Uses this catalog's prefixed M3 column names; map raw Data Lake properties through Data Catalog first. ON CFACIL.CFDIVI = CMNDIV.CCDIVI AND CFACIL.CFCONO = CMNDIV.CCCONO

Programs That Use This Table

MNS100 — Company — connect division: where the CMNDIV divisions under a company are created and maintained
Primary sourceInteractive