Domain catalogue Products

Bill of materials

One governed structure per product per plant: components, quantities, effectivity, alternates and phantoms, consistent with the golden materials.

SOURCES, READ IN PLACESAP S/4HANAERPOracle Fusion CloudERPSnowflakelakehouseDatabrickslakehouseASSEMBLED1 · standardise2 · match on the domain keys3 · survive field by field4 · place in the hierarchies5 · run the column and row rules6 · publish the golden viewGOLDEN BILL OF MATERIALSBill of materialsone id · every source key keptREAD BYGrids, pivots and drill-downswith the transactionsAPIs, SQL and agentsone policyWrite-back to the systemsacknowledged
Where the bill of materials record comes from, how it is assembled, and who reads it. Other systems have their own page.
5 days
of configuration to a production-grade version
estimate
4
attribute groups in the golden record
catalogue
3
match keys
catalogue
2
hierarchies the record sits in
catalogue
3
kinds of transactions that refer to it
catalogue
What it is

Today, and with the golden record

Today engineering's BOM, the ERP BOM and the plant's spreadsheet disagree on quantities and effectivity dates, and a costing run finds out last.

With Lima the bills of materials are read where they live, matched on parent item + plant + usage + alternative and component item + position, assembled field by field and published as one golden record per real bill of materials, with every source key underneath. The explosion to every level, the where-used tree, the production orders that consumed the structure, and the change records behind each effectivity date are one click away, because the transactions sit in the same bed.

The golden record

4 attribute groups, and which source usually wins each

Survivorship is per field; the winning source below is the usual one, and a steward's verified edit outranks it.

Headerparent item, plant, usage, alternative, base quantity, status
wins: ERP and PLM
Componentscomponent item (golden), quantity, unit, scrap, phantom flag, sort
wins: PLM for design, ERP for manufacturing
Effectivityvalid-from and valid-to dates, change numbers, serial ranges
wins: PLM change management
Alternatesalternative items, priority, usage probability
wins: ERP and planners
How records match

The keys, in order

parent item + plant + usage + alternativecomponent item + positionchange number

Components resolve to golden materials first, so every component points at the golden item.

Pairs above the merge line merge; pairs between the lines go to the steward with the two records side by side and the transactions of each; the rest stay apart. Every merge can be undone. The golden records page explains the steps.

Where it sits

2 hierarchies

Several structures for the same record, each kept as versions with dates.

HierarchyLevels and use
Structuremulti-level explosion, up to 20 levels on the showcase estate
Where-usedthe reverse tree from any component

A pivot can roll the record's measures up any of them; a draft version is validated against the facts before it goes live. See hierarchies.

Rules at three levels

Sample rules from the template

Written in one language, tested on live rows before they are saved.

LevelRules
Columnquantity is greater than zero
unit is convertible to the component's base unit
valid-to is after valid-from
Rowa phantom assembly has its own BOM
an active BOM has an active parent at that plant
a component with scrap has a percentage under 100
Businessthe sum of by-product quantities stays under the base quantity
no component is its own ancestor
every active made item has exactly one production BOM per plant and alternative
What refers to it

Transactions, measures and drill-downs

Transactions in the bedRead from
Production ordersSAP AFKO · RESB; Oracle work orders and material requirements
Costing runsSAP CK11N results
Engineering changesPLM change records
component count by levelcost roll-up by versionchanges per monthorders affected by a change

Measures above are available in the pivot on any hierarchy level, by month or week, with calculated measures beside them. Drill-down opens the explosion to every level, the where-used tree, the production orders that consumed the structure, and the change records behind each effectivity date.

Security pattern

What is masked, who edits, who reads

Default policy for the domain

Engineering edits the design BOM; the plant edits quantities and alternates for its plant; costing sees all, edits none. The twelve layers apply on every door; see security.

The lookup API

Pass the keys you know, get the golden record

request
POST /api/v1/golden/bom/explode
{
  "item": "M-1183920",
  "plant": "1000",
  "levels": 3,
  "as_of": "2026-10-01"
}
response
200 OK
{
  "levels": 3,
  "components": 142,
  "phantoms": 6,
  "version": "v41",
  "changes_since": "2026-08-12"
}

The same call creates the record when nothing matches; related facts are expanded through the cross-reference; page sizes and limits are published per endpoint. See the headless API.

On your systems

One page per system

The objects with their real names, the keys in that system's fields, the write interface and what to set up first.

A day with it

Illustrative

Names, places and figures are illustrative or anonymised; the pattern is the catalogue's.

An industrial group compared PLM and ERP BOMs for 18,000 products and found 2,900 quantity differences. The rule that flags them now runs on every change, and costing runs stopped surprising the plants.

illustrative scenario · Bill of materials
Terms on this page

EffectivityThe date or serial range from which a component belongs to the structure.
PhantomAn assembly that exists in the design and is passed through in production; its components explode straight through.
Where-usedEvery structure a component appears in, read upwards.
Golden recordThe one record for a real bill of materials, assembled from the source records, with every value carrying its source, rule and time.
Cross-referenceThe list of source keys that belong to one golden record.
Questions

Does this domain copy data out of the systems?

The golden record is a governed view over rows read in place; a governed replica in your lake is used only where a source is too slow or too limited to query live, and the column says so.

How long to the first golden view?

One working day for the first two sources; 5 working days to a production-grade version with rules, hierarchies, security and write-back tested.

Which industries use it most?

High-tech and semiconductor, Industrial manufacturing, Life sciences. The industry pages show the domains each starts with.

See your first domain built on your data

Bring two systems that hold the same customers, suppliers or materials. In one working day we connect them, run the match on live rows, review the queue with your steward and publish the first golden view with its API.