Case · Equipment master data · Metals

An equipment master for maintenance at a metals plant

For a leading metals plant, Synopps built and cleansed the equipment master for its main equipment and supported its maintenance processes. We focused on data quality, links to spare parts and data readiness for the EAM system.

  • Metals
  • SAP PM
  • EAM
  • 68,000 records
  • 68,000equipment records standardised and classified
  • 43,000records completed with critical information
  • 87%of records enriched and confirmed from external sources
  • 17,300duplicates found and removed

The task

Reliable equipment data, linked to spare parts

Maintenance planning needs one equipment master that is clean, complete and linked to the spare parts in the material master. The client also needed the data ready for SAP PM.

Stage 1, 2023

Equipment in the material master

  • The Equipment field in the material master held 47,426 unique values across 271,572 records
  • From April to June 2023 we unified the values and removed duplicates
  • We checked every value against public sources and marked whether it was confirmed
  • We brought the records to one structure, equipment name plus make or model, and linked each material record to the new value
  • We worked from a data extract, with no access to client systems. This list became the basis for linking equipment to spare parts

Stage 2

Equipment master

  • One equipment master of 68,000 records, including vehicles, machines and units
  • Cleansing, standardisation and duplicate removal
  • Mapping to the material master: 270,000 spare parts and rubber goods records
  • AI-assisted decomposition, enrichment from external sources, validation against catalogues
  • Data prepared for integration with the EAM system (SAP PM)

Maintenance support

Processes and reliability

  • Recognised standards and good practice in maintenance and reliability management
  • Master data structures for planned, condition-based and run-to-failure maintenance
  • Support in building task lists and the master data structure for maintenance
  • Data preparation for EAM implementation, in particular SAP PM
  • Maintenance process models and governing documents: policies, standards and SOPs
  • RCM, RCA and FMEA used to build the equipment reliability structure

Results

Equipment data ready for maintenance and EAM

  • 68,000 equipment records standardised and classified, 43,000 completed with critical information

  • 87% of records enriched and confirmed from external sources, 17,300 duplicates found and removed

  • 47,426 equipment values in the material master checked and cleansed

Contact

Let's look at your equipment data

Tell us about your sites, equipment and EAM system. We will propose a plan and the first steps.

  1. 1
    Task and systems

    What you have now and what you need

  2. 2
    Quick assessment

    Data, processes and IT landscape

  3. 3
    Work plan

    Stages, timeline and scope

0
200000
We use your details to respond to your request. See our Privacy Policy.