Connectors SAP S/4HANA

SAP S/4HANA data integration with Lima, in both directions.

SAP S/4HANA is SAP's current ERP, run on-premise, in a private cloud or as RISE with SAP. Lima reads it through CDS views that SAP has released for extraction, through table reads of the underlying tables and through BAPIs, and writes results back with every write confirmed. Change capture keeps the daily volume small.

SOURCESAP S/4HANAReleased CDS views · Table reads throug…LIMA BACKBONEExtractfull · incremental · change captureCheckevery row valid, or an exception with a…Transform and load150+ operators · Python · loads on the…TARGETSPlanning applicationsKinaxis · o9 · Blue Yonder · IBP · OMPWarehouses and lakehousesSnowflake · Databricks · Fabric · S3 …Reporting and partnersPower BI · Tableau · EDI · filesRESULTS RETURN TO SAP S/4HANA · EACH WRITE CONFIRMED
How SAP S/4HANA fits the six Backbone steps. It is a source and a target: data comes out through the methods below, and results go back in with confirmation.
32 GB/day
changed rows across 4,218 tables; change feed 1m 48s behind
showcase estate
5
ways to read or write it
this connector
4
patterns supported
this connector
3
ways to run: SaaS, private cloud, on-premise
product
22 days
from contract to production
showcase estate
How Lima reads and writes SAP S/4HANA

Method by method.

Each method has a job. The first load uses the bulk method; the daily run uses the incremental or change-capture method; write-back uses the interface the system itself uses.

MethodWhat it doesWhen it is used
Released CDS viewsReads SAP-defined database views, including delta-enabled views that return only changed rows.Standard business data with SAP's semantics applied.
Table reads through a released function moduleReads application tables in partitions inside an agreed session cap.First loads and history.
BAPIs and function modulesReads and writes business objects with business logic applied.Every write-back.
Change pointers and table-level change captureReturns only rows that changed.Nightly and intraday deltas.
SAP APIs on BTPCalls released OData APIs where the estate exposes them.RISE and public-cloud editions.
Compliance statement for this connector

Released CDS views, table reads through a named function module, BAPIs, change pointers and extractor delta queues. No ODP RFC (SAP Note 3255746), no RFC_READ_TABLE in production (SAP Note 382318), no reading of the HANA database log (SAP Note 2971304). No add-on is installed in SAP.

Dated draft, pending sign-off by engineering and legal. The full statement, with the named function module, is on the trust center.

What it covers

Objects and patterns.

The objects are the tables, views or records Lima reaches through the methods above. The patterns say how a copy is made and kept current.

ObjectPlain meaning
I_Product · I_Plant (CDS)product and plant master views
MARA · MARC · MATDOCmaterial master and the single material document table
STKO · STPO · PLKO · PLPObills of material and routings
EKKO · EKPO · VBAK · VBAPpurchase and sales orders
ACDOCAthe universal journal
AFKO · AFPOproduction orders
PRCD_ELEMENTSpricing conditions (replaces KONV)
MBEW · CKMLCRvaluation
PatternSupported
Full loadYes
IncrementalYes
Change capturedelta-enabled CDS views, change pointers, table-level change capture
Streaming—
Write-backBAPIs, IDocs and released OData APIs, each write confirmed
What a planning application needs from SAP S/4HANA

The objects a first load is built from.

A planning dataset is assembled from these objects. The pair pages show how each planning application shapes them.

Planning objectSource objects in SAP S/4HANA
ItemsI_Product · MARA · MARC
Bills of materialSTKO · STPO · MAST
Routings and production versionsPLKO · PLPO · MKAL
Stock by statusMATDOC · MARD
Open purchase ordersEKKO · EKPO · EKET
Open sales ordersVBAK · VBAP · VBEP
Production ordersAFKO · AFPO
Planned independent requirementsPBIM · PBED
Customers and suppliersKNA1 · LFA1 · BUT000
CalendarsTFACD · T001W
Before you start

Prerequisites, then four steps.

The prerequisites are what the team that runs SAP S/4HANA grants. The four steps are the same for every connector.

  • A communication user with authorisation on the CDS views, tables and BAPIs in scope
  • PrivateLink, VPN or a BTP route agreed with Basis
  • Session cap and run windows agreed with Basis
  • For RISE: the released API set for the edition
Register the connectionEndpoint, credentials from the vault, and the method. The connection is tested and a failed test names the cause.
Choose the objects and the patternPick tables or objects from the discovered schema, and the pattern: full, incremental, change capture or streaming.
Run the first load with checks onEvery row is valid or becomes an exception with an owner. The run ends with a count and a control total per table.
Schedule it on the business calendarA run window with a deadline; pause, resume and replay if a check trips; the report after every run.
What happens to a bad record

Incoming data = valid records + exception records. A row that fails a check is kept, routed to the person who owns it with a deadline, and replayed once fixed. The load carries on with the valid rows and the report says exactly what was held back. How exceptions work →

Pair pages

SAP S/4HANA in a source-to-target path.

Each pair page covers one path end to end: objects out, model in, checks, cadence and the offer.

/connectors/sap-s4hana-to-kinaxis-maestro

SAP S/4HANA to Kinaxis Maestro

Planning integration: first load, then net change on the planning calendar; the plan returns to the ERP.

Open the pair page →
/connectors/sap-s4hana-to-o9

SAP S/4HANA to o9 Solutions

Planning integration: first load, then net change on the planning calendar; the plan returns to the ERP.

Open the pair page →
/connectors/sap-s4hana-to-blue-yonder

SAP S/4HANA to Blue Yonder Planning

Planning integration: first load, then net change on the planning calendar; the plan returns to the ERP.

Open the pair page →
/connectors/sap-s4hana-to-sap-ibp

SAP S/4HANA to SAP Integrated Business Planning

Planning integration: first load, then net change on the planning calendar; the plan returns to the ERP.

Open the pair page →
/connectors/sap-s4hana-to-omp

SAP S/4HANA to OMP

Planning integration: first load, then net change on the planning calendar; the plan returns to the ERP.

Open the pair page →
/connectors/sap-s4hana-to-anaplan

SAP S/4HANA to Anaplan

Planning integration: first load, then net change on the planning calendar; the plan returns to the ERP.

Open the pair page →
/connectors/sap-s4hana-to-snowflake

SAP S/4HANA to Snowflake

Landing and history: full history landed with a count check per table, then kept current.

Open the pair page →
/connectors/sap-s4hana-to-databricks

SAP S/4HANA to Databricks

Landing and history: full history landed with a count check per table, then kept current.

Open the pair page →
/connectors/sap-s4hana-to-microsoft-fabric

SAP S/4HANA to Microsoft Fabric

Landing and history: full history landed with a count check per table, then kept current.

Open the pair page →
/connectors/sap-s4hana-to-bigquery

SAP S/4HANA to Google BigQuery

Landing and history: full history landed with a count check per table, then kept current.

Open the pair page →
/connectors/sap-s4hana-to-amazon-redshift

SAP S/4HANA to Amazon Redshift

Landing and history: full history landed with a count check per table, then kept current.

Open the pair page →
/connectors/sap-s4hana-to-azure-synapse

SAP S/4HANA to Azure Synapse Analytics

Landing and history: full history landed with a count check per table, then kept current.

Open the pair page →

3 more pair pages for SAP S/4HANA are listed in the directory.

Status and evidence

Stated plainly, with dates.

SAP compliance statement: dated draft, pending sign-offSAP certification tier: decision Q4 2026
Terms on this page

Plain meanings.

ConnectorA packaged way to read or write one kind of system, with its authentication, methods and prerequisites described.
Full, incremental, change capture, streamingFour ways to make and keep a copy: read everything; read what changed since last time; read changes from a log as they happen; consume events in small batches.
Write-backWriting a result into the system that owns it through its released interface; the system's response is the confirmation.
Control totalThe sum of a key amount column compared between source and target, along with the row count, at the end of a run.
Exception recordA row that failed a check: kept, routed to an owner, replayed once fixed.
Released interfaceAn SAP interface SAP documents and supports for external use: BAPIs, released function modules, released CDS views, IDocs. The ODP RFC path is the one SAP restricts.
Questions

Asked about this connector.

Does Lima install anything in SAP S/4HANA?

No add-on is installed. Lima connects from outside through the interfaces listed above, with a user and authorisations your administrators grant.

How is load on SAP S/4HANA kept in check?

Parallel reads are capped and the cap is agreed with the team that runs the system. Large reads run inside an agreed run window. Change capture keeps the daily volume small.

What do we see when a run finishes?

A report per run: rows in, rows out, control totals and variance per table, the exceptions held back and who owns them, and whether the deadline was met.

Can we start small?

Yes. Most estates start with one source, one target and one dataset, then add tables and patterns on the same connection.

Try SAP S/4HANA on your own estate.

A trial connects this system, runs a first load and ends with a reconciliation report. Your administrators see the prerequisites before anything is installed.