M3 Reference

MPDHED

Prefix: PHmaster

The product structure header — one row per product and structure type per facility, the design-time recipe that manufacturing orders are created from

Module: ManufacturingCompany-partitioned (CONO)

Header & line

MPDHED is the header for its lines in MPDMAT.

Fields

4 fields · 4 key

Key	Field	Alias	Description	Type
Key	PHCONO	CONO	Company	numeric
Key	PHFACI	FACI	Facility the structure is defined for	alphanumeric
Key	PHPRNO	PRNO	Product the structure builds — joins to the item master on ITNO	alphanumeric
Key	PHSTRT	STRT	Structure type — distinguishes parallel recipes for the same product	alphanumeric

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading MPDHEDon 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)

Include optional filters (1)

-- ============================================================
-- Table  : MPDHED — The product structure header — one row per product and structure type per facility, the design-time recipe that manufacturing orders are created from
-- Purpose: Column-selected read of MPDHED — auto-generated from field metadata
-- Grain  : One row per company (CONO) + PHFACI + PHPRNO + PHSTRT
-- Notes  : Auto-generated skeleton for Infor Data Lake-landed M3 data. Dates are numeric YYYYMMDD (0 = none, mapped to NULL); status ladders decoded inline where verified. Audit columns (RGDT/RGTM/LMDT/CHNO/CHID) omitted — see the quirks guide.
-- ============================================================
SELECT
  m.PHCONO AS "Company",
  m.PHFACI AS "Facility the structure is defined for",
  m.PHPRNO AS "Product the structure builds — joins to the item master on ITNO",
  m.PHSTRT AS "Structure type — distinguishes parallel recipes for the same product"
FROM <catalog>.<schema>.MPDHED m
WHERE
  m.PHCONO = <company>
  -- AND m.PHFACI = '<FACI>'
ORDER BY m.PHFACI;

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

Relationships

1-hop neighbors — click a table to navigate there. CSYTAB decode edges are highlighted; they’re the joins newcomers most often get wrong.

Join details

MPDHEDMPDMATheader line · 1:N
ON MPDHED.PHPRNO = MPDMAT.PMPRNO AND MPDHED.PHFACI = MPDMAT.PMFACI AND MPDHED.PHSTRT = MPDMAT.PMSTRT AND MPDHED.PHCONO = MPDMAT.PMCONO

Programs That Use This Table

No program mappings populated for this table yet.