Connectors SAP ECC to Microsoft Fabric

SAP ECC to Microsoft Fabric: full history landed and reconciled, then kept current.

Lima Backbone reads SAP ECC through table reads through a released function module, types the data correctly on landing, writes it into Microsoft Fabric as lakehouse delta tables in onelake (raw, conformed, history), v-ordered for direct lake, and keeps it current from the source’s changes. Every run ends with a row count and a control total per table.

OUT OF SAP ECCItemsMARA · MARC · MARD · MBEWBills of materialSTKO · STPO · MAST · STASRoutings and production versionsPLKO · PLPO · MKALStock by status and dateMARD · MSKA · MSLB · MCHBLIMA BACKBONEExtractTable reads through a released function…Checknine checks before anything loadsShapetypes, keys, deletes, partitionsLoadDelta writes to OneLake, MERGE for curre…INTO MICROSOFT FABRICMicrosoft FabricLakehouse Delta tables in OneLake (raw,…
The path from SAP ECC to Microsoft Fabric. Objects come out through the source's methods, are typed and checked, land in Microsoft Fabric and are kept current from the source's changes.
220M rows
615 tables · ~30 GB in ~30 min on 64 vCPU
performance estimate
80 GB/day
moved and transformed every day
production · semiconductor enterprise
2021
SAP to Kinaxis and back, in production since
production
8
checks on landing
product
1
count and control total per table per run
product
What Microsoft Fabric expects

The model the load has to fit.

ModelLakehouse Delta tables in OneLake (raw, conformed, history), V-Ordered for Direct Lake; or a Warehouse loaded with COPY INTO.LoadDelta writes to OneLake, MERGE for current state, V-Order applied, semantic model refresh signalled; counts and control totals per table.BackResults in Fabric can be written back to the ERP by Lima with confirmation.
The hardest part of this path

Sizing loads against Fabric capacity so a large landing does not slow reporting.

The Microsoft Fabric connector page →

What comes out of SAP ECC

Objects and where they go.

The first load is assembled from these objects through table reads through a released function module. Change capture (change pointers, table-level change capture, extractor deltas) keeps the daily volume small afterwards.

Planning objectSource objectsDestination in Microsoft Fabric
ItemsMARA · MARC · MARD · MBEWLakehouse raw Delta → conformed Delta, V-Ordered
Bills of materialSTKO · STPO · MAST · STASLakehouse raw Delta → conformed Delta, V-Ordered
Routings and production versionsPLKO · PLPO · MKALLakehouse raw Delta → conformed Delta, V-Ordered
Stock by status and dateMARD · MSKA · MSLB · MCHBLakehouse raw Delta → conformed Delta, V-Ordered
Open purchase ordersEKKO · EKPO · EKET · EKBELakehouse raw Delta → conformed Delta, V-Ordered
Open sales ordersVBAK · VBAP · VBEP · VBUPLakehouse raw Delta → conformed Delta, V-Ordered
Production ordersAFKO · AFPO · AFRULakehouse raw Delta → conformed Delta, V-Ordered
Forecast and planned independent requirementsPBIM · PBEDLakehouse raw Delta → conformed Delta, V-Ordered
Customers and suppliersKNA1 · KNVV · LFA1 · LFM1Lakehouse raw Delta → conformed Delta, V-Ordered
CalendarsTFACD · TFACS · T001WLakehouse raw Delta → conformed Delta, V-Ordered
How SAP ECC is read

Lima reads SAP through released interfaces: table reads through a named function module, BAPIs, CDS views where available, change pointers and extractor delta queues. It does not use the ODP RFC interface that SAP Note 3255746 restricts, it does not use RFC_READ_TABLE in production (SAP Note 382318), and it does not read the HANA database log (SAP Note 2971304). No add-on is installed in SAP.

The path, step by step

Six steps, one report at the end.

ConnectRegister SAP ECC and Microsoft Fabric with credentials from the vault; test both connections.
ExtractFirst load through table reads through a released function module; then change pointers, table-level change capture, extractor deltas.
CheckNine checks run before anything loads; a failed row becomes an exception with an owner and the load continues with the valid rows.
ShapeTypes are set from the source, keys kept complete, deletes and late changes applied in order.
LoadDelta writes to OneLake, MERGE for current state, V-Order applied, semantic model refresh signalled; counts and control totals per table.
Keep currentChanges from SAP ECC are applied on the schedule you set; every run ends with the same report.
The checks that run before anything loads

8 checks, each with a plain example.

Every check either passes a row or turns it into an exception record with an owner. Nothing is dropped silently.

CheckKindWhat it catches, with an example
Types set from the sourcetypingSAP dates and times stored as text become dates and times; currency decimals shifted by the currency's rule
Keys complete and uniquekeysclient or organisation columns kept in the key; zero-padded keys preserved
Deletes appliedconsistencyrows deleted in the source are marked or removed in the copy
Late changes land in orderconsistencya change that arrives after a later one is applied by its source timestamp
Wide and cluster tables completecompletenessevery column of a wide table lands; cluster tables read through the released module
Partitions cover the rangecompletenessevery date partition present; gaps reported
Counts and control totals matchreconciliationrows and amounts per table compared between source and target
Schema changes noticeddrifta new or changed column is flagged before it breaks a downstream query
Cadence and offer

How the copy stays current, and how the work is priced.

After the first landing, Microsoft Fabric receives the source's changes: change pointers, table-level change capture, extractor deltas. A migration month costs the same as a quiet month on the same tier.

Terms on this page

Plain meanings.

LandingWriting rows into the target's raw layer as they arrived, typed, before any business transformation.
Referential orderLoading parents before children so every row finds what it refers to.
Control totalThe sum of a key amount column compared between source and target, along with the row count.
Exception recordA row that failed a check: kept, routed to an owner, replayed once fixed.
Change captureReading only the rows that changed, from a log, change pointers or timestamps.
Questions

Asked about this path.

How long until the first load is live?

Days for the first tables; a full-history migration is sized by table count and volume, and read in partitions inside the run windows your administrators allow.

What does the data team see?

Counts per step, the check that stopped a row, the owner and the replay point, and the lineage of any number back to its source column.

Who runs it after go-live?

Your team, on the schedule you set, with the same report after every run; or your systems integrator; or Lima's team under the subscription.

Land your first tables in Microsoft Fabric.

One call scopes the dataset, the run window and the tier. The reconciliation report at the end is the acceptance test.