Solutions Planning integration

Your ERP data, delivered into Kinaxis, o9, Blue Yonder, SAP IBP and OMP — and back.

Lima Backbone reads planning data from SAP and Oracle through the interfaces SAP keeps open, transforms it at the volume an MRP run needs, loads it on your planning calendar, and returns approved plans to the ERP with every write acknowledged. Your first planning dataset is live in four weeks at a fixed price.

Delivered as software with a fixed scope. Your systems integrator can deliver on it; so can ours.

SYSTEMS OF RECORDPLANNING SYSTEMSSAP ECC · S/4HANAtable reads · BAPI · CDS · CDCOracle EBS · PeopleSoftJDBC · delta captureWMS · 3PL · EDIREST · webhooks · SFTPFiles · lakehouseforecasts · external demandKinaxis Maestrofirst load, then net-changeo9 · Blue Yonderhierarchy-validated loadsSAP IBP · OMPplanning cycles on a calendarBack to the ERPplanned orders · allocationsLima BackboneONE GOVERNED PLANE · CATALOG · LINEAGE · ACCESS POLICYExtractopen SAP interfaces,ECC and S/4HANA,batch or change dataTransformat MRP volume,150+ operators,Python tooLoadon the run window,counts proved,exceptions ownedExceptions to owners · Reconciliation · Deadlines keptvalid + exception records · control totals · run windowsAPPROVED PLANS RETURN TO THE ERP · EVERY WRITE ACKNOWLEDGED AND RECONCILED
The loop is the product: data goes out to the planning system on a schedule, and approved results come back to the ERP as acknowledged transactions.
8–10 weeks
from kick-off to the first full planning load on recent programs
70% lower
integration cost against a bespoke build on the same program
1,000+ tables
in the planning bridge of a $75B semiconductor manufacturer
~30 min
220M rows · 615 tables · ~30 GB end to end on 64 vCPU
performance estimate
22 days
contract to production on the platform
deployment record
Every write
acknowledged by the ERP before it counts as done
product
What the first load involves

Getting data into a planning engine is most of the program. Lima does that part as a product.

Nine in ten planning programs underestimate the integration work; data preparation is about 70% of what an APS implementation costs; only 59% of planning-system users can plan without manual work-arounds.

Every one of those numbers traces back to the same job: getting items, bills of material, routings, inventory, open orders and forecasts out of the ERP, into the shape the planning engine expects, on the day the planners need them. Lima Backbone does that job with a fixed scope and a reconciliation report at the end, so the program schedule stops depending on a one-off integration build.

In plain terms

A planning engine such as Kinaxis or o9 cannot query your SAP system directly. It needs a complete, consistent copy of the planning data, delivered in its own format, inside a fixed time window before the planning run. Lima Backbone builds and runs that delivery, checks it, and carries the approved plan back.

90%
of planning programs underestimate integration complexity
industry survey · SCI page
70%
of an APS implementation’s cost is data work
Lima field figure
59%
of APS users plan with few manual work-arounds
McKinsey
55%
of chief supply chain officers cannot state the return on their AI spend
Gartner · Aug 2026
How it works

Six steps from ERP to plan and back

Each step is a stage in the same pipeline, visible on one canvas, with an owner for anything that fails a check.

Choose the sources connectSAP ECC and S/4HANA through table reads, BAPIs, CDS views and change-data capture; Oracle EBS, PeopleSoft, warehouse and 3PL systems, forecast files and lakehouse tables. More than 40 connectors, each with a compliance note for SAP.
Consolidate reconcile many ERPs into one viewThree plants with three item masters become one planning item with one unit of measure, one calendar and one set of codes. The mapping is versioned, so a change is traceable to a person and a date.
Check quality gates before anything loadsEvery incoming record is either valid or an exception. Exceptions go to the buyer, planner or data steward who owns them, with a deadline, and are replayed once fixed. The load carries on with the valid records and reports exactly what was held back.
Capture planning master data the data the ERP never hadHierarchies, planning parameters, lead-time offsets, sourcing rules and priorities live in Lima with an owner and an effective date. The planning engine receives the same values every cycle and a change is never a surprise.
Convert and load the target’s format, on its calendarKinaxis net-change files and API calls, o9 and Blue Yonder data models, IBP key figures, OMP models. Loads run inside the run window you set, and the report shows record counts and control totals for every dataset.
Close the loop results back to the ERPPlanned orders, purchase requisitions, allocations and approved master-data corrections return through BAPI and IDoc transactions. Each one is acknowledged by the ERP and reconciled; a failed write re-queues with its reason attached.
Planning master data

The data the ERP never had, kept where planners can see it

Planning engines depend on data that lives in spreadsheets in most companies: product families, regional roll-ups, safety-stock policies, minimum order quantities, lot sizes, lead-time overrides, sourcing priorities. Lima keeps these as governed records.

Every parameter has an owner and an effective date

A planner changes a safety-stock policy in Lima; the change is versioned, reviewed where your policy requires it, and reaches the planning engine on the next load.

PRODUCT

Hierarchies are checked before they load

Orphan nodes, duplicate codes and broken roll-ups are caught as exceptions with an owner, which is why the planning graph stays consistent cycle after cycle.

PRODUCT

The same values reach every planning system

One set of planning master data feeds Kinaxis, IBP and the S&OP model alike, so the numbers in each system reconcile.

PRODUCT
Reconciliation

A report at the end of every run

Counts and control totals per dataset, compared with the source, with any variance routed to an owner. The sample below shows the structure of the report; the figures are illustrative.

DatasetSource rowsLoadedVarianceControl totalStatus
Item master MARA · MARC2,914,2202,914,2200—Reconciled
BOM components STPO · STKO18,406,11318,406,1130qty 1.20 × 10⁹Reconciled
Open purchase orders EKKO · EKPO1,204,8811,204,8783 → ownersvalue matched3 exceptions
Sales orders VBAK · VBAP6,102,4476,102,4470qty matchedReconciled
Forecast external file412,006412,0060—Reconciled
Planned orders returned BAPI_PLANNEDORDER_CREATE41,20741,207 acknowledged0—Acknowledged

Illustrative sample. Record counts and control totals are compared per dataset on every run; the three held-back purchase-order lines were routed to their buyers and replayed on the next run.

Run windows

Loads that keep the planning calendar

A planning load has a deadline that belongs to the business: the MRP run at 06:00, the weekly S&OP cut-off, the month-end close. Lima treats that deadline as the promise the pipeline exists to keep. The figure shows one night from the showcase estate.

RUN WINDOW 01:00 – 05:3000:0001:0002:0003:0004:0005:0006:0007:0001:00Net-change load starts02:14Anomaly on an inbound feed · 3 pipelines held · deadline clock paused02:51Root cause found02:58Resumed from checkpoint · 841K events replayed in order06:00MRP run · deadline met with 3h 32m to spareThe deadline belongs to the business (the 06:00 MRP run). A tripped check pauses the run and the clock;the run resumes where it stopped, and nobody restarts anything by hand.SHOWCASE ESTATE · TIME TO RESOLUTION 44 MINUTES · ZERO MANUAL RESTARTS
One night: the load starts at 01:00, an anomaly at 02:14 holds three pipelines and pauses the clock, the run resumes from its checkpoint at 02:58 and replays 841,000 events in order, and the 06:00 MRP run gets its data with 3 hours 32 minutes to spare.

The clock is the planning cycle

Each pipeline carries its run window and deadline. A dashboard shows how much margin is left, and alerts go to Slack, Teams or PagerDuty before the deadline is at risk.

A tripped quality gate pauses the run

When a check fails, the pipeline holds its place and the deadline clock pauses with it. Once the fix lands, the run resumes from its checkpoint and replays events in order. Nobody restarts anything by hand.

Runs on Apache Airflow

Lima’s DAGs are standard Airflow DAGs. Your enterprise scheduler can trigger them, and your engineers can read them.

Orchestration on the platform →
A worked example from the showcase estate

02:14 — an anomaly fires on an inbound feed; three dependent pipelines are held automatically. 02:51 — root cause found. 02:58 — the pipelines resume from their checkpoints and replay 841,000 events in order. 06:30 — the deadline is met with 3 hours 32 minutes to spare. Time to resolution: 44 minutes, with no manual restart. Showcase estate figures.

Planning systems

Works beside every major planning system

KINAXIS MAESTRO

First load, then net-change on the planning calendar

Items, BOMs, sources, inventory, open orders and forecasts in; planned orders and allocations back through acknowledged BAPI calls. The closed loop Lima has run since 2021.

Lima for Kinaxis →
O9

Hierarchy-validated loads into the knowledge graph

Product, location and customer hierarchies checked for gaps and duplicates before they reach o9, so the planning graph stays consistent cycle after cycle.

Lima for o9 →
BLUE YONDER

Planning data model loads, execution data read back

Planning objects loaded on the calendar; warehouse and transport data read live for the control tower.

Lima for Blue Yonder →
SAP IBP

Key figures and master data from ECC, S/4HANA and everything beside them

The multi-ERP and non-SAP sources SAP’s own integration leaves out, delivered in IBP’s format on the planning cycle.

Lima for SAP IBP →
OMP

Master-data-heavy loads for process industries

Recipes, resources, calendars and demand streams shaped for OMP’s model, with counts proved on every run.

Lima for OMP →
The First Load offer

One planning dataset, four weeks, fixed price

The trial planning teams ask for, with a number at the end of it.

Week 1
connect
Connect and inventorySources connected on open interfaces; the planning dataset scoped (for example the MRP set: items, BOMs, sources, inventory, open orders); run window and deadline agreed.
Week 2
extract + transform
First extraction and transformationFull extraction with counts; consolidation and planning master data captured; exceptions routed to named owners for the first time.
Week 3
load
First full load, reconciledThe dataset lands in your planning system with the reconciliation report; variances resolved with the owners.
Week 4
rehearse
Run-window rehearsal and hand-overNet-change loads run inside the window for a week; adherence measured; one write-back object demonstrated end to end. Converts into a subscription when you are ready.
After go-live

The bridge becomes the control tower

Once the planning loads run on their calendar, the same governed data serves the AI control tower: KPI library, exception management, agents that act across the estate with earned autonomy.

Next step on the platform

The AI Control Tower on your SAP estate runs on the fabric and the backbone you already have in place after the first load.

Where this sits

A planning integration uses every stage, and the sixth — Return — is the one most integrations leave out.

Any source.Any target.Any pattern.Any volume.Priced by capacity.THE BACKBONE HUB → /platform/backbone

One engine underneath every page in this family. It reads from any source and writes to any target, runs batch loads or change-data streams, handles a nightly delta or a multi-terabyte migration, and is licensed by capacity, so the bill stays the same however many rows move. Lima’s fabric answers questions on data in place; Lima Backbone moves, transforms and returns data on a deadline. When to federate and when to pipeline · The Backbone hub.

Terms on this page

Plain definitions.

APSAdvanced planning system — Kinaxis, o9, Blue Yonder, SAP IBP, OMP and similar engines that compute plans from a copy of ERP data.
MRPMaterial requirements planning — the run that turns demand and bills of material into planned orders; usually nightly.
Net-changeA load that carries only what changed since the last one, so the planning engine stays current between full loads.
BAPI / IDocSAP’s supported interfaces for posting transactions (BAPI) and exchanging documents (IDoc). Lima uses them for write-back.
Control totalA sum (quantity, value) computed on the source and on the target and compared, alongside record counts.
Run windowThe time span in which a load must complete; the deadline the pipeline is measured against.
Questions we hear

Asked before the first load.

Do we need an ABAP add-on or a Datasphere licence?

Neither. Lima reads SAP through table reads, BAPIs, CDS views and change-data capture, which SAP keeps open to partners, and it writes back through BAPIs and IDocs. There is no add-on to install and no additional SAP licence line.

We already have a systems integrator building this.

Lima is the software they can deliver with. The first-load offer gives you the reconciliation report and the run-window measurement either way, and the pipelines are readable Airflow DAGs your team can maintain.

What happens when the source data is wrong?

Records that fail a check become exceptions with a named owner and a deadline. The load continues with the valid records, the report shows what was held back, and the exceptions are replayed once fixed.

How does write-back work?

Approved planning results are posted to the ERP through BAPI or IDoc transactions. Each write carries a unique reference so a retry never posts twice, is acknowledged by the ERP, and is reconciled against what was sent. A failed write re-queues with its reason.

Which planning systems are covered?

Kinaxis Maestro, o9, Blue Yonder, SAP IBP and OMP have dedicated pages. Other engines are loaded through their API or file interfaces with the same reconciliation.

What does it cost?

The first load is a fixed-price engagement. The platform is a subscription sized by capacity tier, with everything included and no charge per row, per connector or per question. Pricing principles.

Run your first load in four weeks

One planning dataset from your ERP into your planning system, with a reconciliation report and run-window measurement at the end. Fixed price.