
How Is MES–ERP Integration Done?
MES-ERP integration is the automatic transfer of planning data such as work orders, products, BOMs and routings from the ERP to the MES, and the automatic reporting back to the ERP of production, scrap, consumption and work order closure realised in the MES. The goal is to eliminate double data entry, ensure that inventory and cost information matches reality on the shop floor, and set up the Level 3–4 exchange defined by ISA-95 in a standard way.
- ERP → MES: work orders, product/material, BOM, routing, customer and order information.
- MES → ERP: production confirmation (good/scrap quantity), consumption, work order status, labour time.
- Methods: web services (REST/OData/SOAP), RFC/BAPI, IDoc, staging tables, files.
- Critical success factor: clarifying the owner of master data and code mapping at the very start.
Which Data Flows in Which Direction?
| Direction | Data object | Frequency |
|---|---|---|
| ERP → MES | Material / product master data | On change or daily |
| ERP → MES | BOM and routing (operation, work centre, standard time) | On change |
| ERP → MES | Work order (product, quantity, due date, operations) | Within minutes |
| MES → ERP | Operation confirmation (good quantity, scrap quantity, time) | At the end of the operation or periodically |
| MES → ERP | Material consumption (lot-based) | Together with the confirmation |
| MES → ERP | Work order closure / status | Event-based |
Integration Methods
- Web services (REST/OData/SOAP): Available in most modern ERPs; suitable for two-way, event-based operation.
- RFC/BAPI, IDoc (SAP): Established methods in the SAP world; BAPIs are common for confirmations and IDocs for bulk transfers.
- Staging table: A database table both systems can access; simple and often used with local ERPs, but care is needed with the pitfall of the table being emptied during a reload.
- File transfer: Periodic exchange via CSV/XML; the simplest but most delayed method.
Project Steps
- Scope and object list: Which data, in which direction, how often. This list is the contract document.
- Master data ownership: Product, BOM and routing in the ERP; machines, downtime codes and control plans in the MES. If there is overlap, it does not get resolved later.
- Code mapping: ERP work centre code ↔ MES machine; ERP scrap reason ↔ MES scrap code; ERP unit ↔ MES unit. A code that does not match silently produces a zero quantity or an empty record.
- Interface design: Method, field list, behaviour on error (retry, queue, alert).
- Test environment: An end-to-end scenario with the ERP test client: open a work order → produce in the MES → the confirmation lands in the ERP → inventory is verified.
- Parallel running: For a while it runs alongside the old method (manual entry) and differences are analysed.
- Go-live and monitoring: The transfer queue, error log and number of pending records are monitored regularly.
Common Pitfalls
- Mistaking deletion for completion: While the ERP source is being reloaded, a record temporarily disappears; an integration that interprets this as “work order closed” closes jobs that are still running. Deletion should always be handled as “cancelled” and must not cut off active production.
- Unit mismatch: If the ERP works in kilograms and the MES in metres, the conversion factor must be defined in master data.
- Unmapped scrap reasons: If the MES has 40 scrap reasons and the ERP has 5 scrap codes, a mapping table is essential.
- Silent errors: If nobody is alerted when a transfer fails, it is noticed days later. A threshold alert should be defined for the number of pending records.
- Forgetting the scheduled task: If periodic transfer depends on an operating system task, it may stop when the server restarts; a heartbeat should be monitored.
Frequently Asked Questions
Which technical method is used for MES-ERP integration?
Should integration be real-time?
When a record is deleted in the ERP, should it also be deleted in the MES?
ERP Integration in EFFIX MES
EFFIX MES offers ready-made adapters for SAP, IFS and Netsis and a generic adapter structure for other ERPs; work orders, products, BOMs and routings are taken from the ERP, and production and scrap confirmations are sent automatically from the MES to the ERP. The same adapter approach is also used for QMS and time-and-attendance connections. Thanks to unit conversion and code equivalence definitions, unit and code differences between the ERP and the shop floor are resolved in the integration layer. For details, see the EFFIX MES page or request a demo.
