SAP S/4HANA DATA MIGRATION

    SAP S/4HANA Data Migration to Oracle Fusion — Reconciliation-First

    Pre-built SAP S/4HANA data conversion for every Finance, SCM, PPM, and EAM module. HANA SQL, CDS view and OData extraction, ACDOCA universal-journal targeting, SAP COA → Fusion 6-segment crosswalks, FBDI/HDL emitters, row-level reconciliation. Audit-ready evidence at every load.

    100%
    Row-level reconciliation
    3
    Output formats (FBDI/HDL/REST)
    ACDOCA
    Universal journal targeted natively
    4.2 B
    Largest single-table extract

    What SAP S/4HANA data migration to Oracle Fusion actually requires

    The hard part isn't moving rows. It's translating SAP's account-assignment model into Fusion's fixed COA without losing analytical meaning.

    SAP S/4HANA and Oracle Fusion both descend from the same enterprise-software lineage, but their data models diverged decades ago. S/4HANA uses the universal journal ACDOCA with rich account-assignment dimensions (cost centre, profit centre, WBS, internal order, functional area), CDS views as the strategic data layer, and a delivered schema with tens of thousands of HANA tables. Fusion uses a fixed 6-segment COA, business-unit-driven security, reference-data sets, and a Cloud-native interface accessed through FBDI/HDL/REST.

    Every SAP S/4HANA data migration to Oracle Fusion has to bridge these gaps — and the bridging is where projects slip from quarters into years. Custom ABAP downloads paired with hand-written FBDI templates can do it, but each table is a multi-week negotiation between functional, technical, and audit teams. Syntra ETL replaces that with pre-built crosswalks refined across SAP conversions covering both on-prem S/4HANA and RISE with SAP Cloud Private Edition.

    The same engine handles three deployment scenarios: full S/4HANA replacement (Finance + SCM + PPM + EAM → Fusion), single-pillar migration (Finance-only is common when SuccessFactors stays for HCM), and the hybrid pattern where SAP remains for shop-floor / MES integration while Finance and Procurement move to Fusion.

    Data domains covered out of the box

    1
    Finance master & ACDOCA
    GL accounts (SKA1/SKAT), cost centres (CSKS), profit centres (CEPC), business areas, segments — remapped to Fusion's 6-segment COA. ACDOCA universal journal targeted natively.
    2
    Vendors & customers
    LFA1/LFB1 vendor master, KNA1/KNB1 customer master, bank data, withholding tax setup — with fuzzy-match de-duplication and address normalisation into Fusion supplier/customer model.
    3
    Materials & open transactions
    MARA/MARC/MBEW material master + valuation, EKKO/EKPO open POs, VBAK/VBAP open sales orders, asset CIP — migrated with full lifecycle and approval-state context.
    4
    Historical archive
    Years of closed-period BKPF/BSEG and ACDOCA detail — either loaded to Fusion or routed to long-term cloud archive with German HGB/AO 10-year retention.

    The SAP S/4HANA data conversion engine — six core capabilities

    The transformations Syntra ETL ships pre-built. No custom ABAP downloads, no multi-month bespoke development.

    🧮

    Account assignment collapse

    SAP's GL + cost centre + profit centre + WBS + internal order + functional area + segment model collapsed into Fusion's 6-segment COA. Assignment-usage analyser identifies material splits; non-material fields route to DFFs or PPM dimensions.

    🏭

    ACDOCA universal journal

    Direct extraction from the S/4HANA universal journal (or I_JournalEntryItem CDS view on RISE). Multi-ledger, multi-currency, parallel-accounting (IFRS + local GAAP) all handled natively.

    🔐

    Org structure → BU model

    BUKRS company codes, WERKS plants, VKORG sales orgs, EKORG purchasing orgs translated to Fusion BU + Inventory Org + Selling BU + Procurement BU with analytical and security intent preserved.

    🧾

    Vendor / customer de-dup

    Fuzzy-match de-duplication across LFA1/LFB1/LFM1 and KNA1/KNB1/KNVV. Hierarchical relationships preserved, payment terms migrated, withholding-tax setup remapped to Fusion's tax configuration.

    📦

    Material master normalisation

    MARA/MARC normalised to Fusion's item-class structure, MM03 views translated to Fusion item attributes, MBEW valuation methods migrated with full history per inventory org.

    💵

    Multi-ledger & parallel accounting

    T001/T001A/RFLEDGER multi-ledger setups translated to Fusion's primary + reporting ledger model. IFRS-on-leading + local-GAAP parallel ledgers preserved for dual-reporting customers.

    SAP S/4HANA data migration to Oracle Fusion — the load sequence

    A repeatable load order that respects Fusion's data dependencies. Skip a step and your AP load fails on missing vendors.

    1

    Foundation (Setup) — Day 1

    Fusion enterprise structures, ledgers, BUs, COA segments, value sets, calendars configured. Loaded via FSM tasks or migration utility — not user-facing data, but everything downstream depends on it.

    2

    COA & Value Sets — Day 2

    Chart of Accounts segment values, value sets, account hierarchies loaded via FBDI ChartOfAccounts and Value Set FBDI templates. Validated against S/4HANA trial balance per RBUKRS for parent-child integrity.

    3

    Master Data — Days 3–8

    Suppliers (FBDI Supplier Import from LFA1/LFB1), customers (FBDI Customer Import from KNA1/KNB1), items (FBDI Item Import from MARA), employees + jobs (HDL Worker.dat + Assignment.dat). Dependency order respected.

    4

    Balances & Open Transactions — Days 9–16

    GL period balances from ACDOCA (FBDI Journal Import), AP open invoices (FBDI AP Invoice Import), AR open items (FBDI AutoInvoice), open POs from EKKO/EKPO, asset CIP and in-service balances. Each load reconciled to S/4HANA before next stage.

    5

    Historical Periods — Days 17–32

    Closed-period historical data loaded if Fusion is the target archive, or routed to Syntra archive if cold-data lifecycle dictates. Either way, queryable for audit during the full German HGB/AO 10-year retention window.

    6

    Cutover & Sign-off — Days 33–42

    Final delta replay via CDPOS/CDHDR or SLT, parallel-close reconciliation, sign-off pack generation (trial balance, aging, asset register — S/4HANA vs Fusion to the cent). Production cut to Fusion; HANA licence wind-down begins.

    Reconciliation evidence that satisfies finance, SCM, and audit

    Every SAP S/4HANA data migration to Oracle Fusion load produces signed, drill-downable reconciliation reports.

    🔢

    Row counts

    Source S/4HANA row count vs Fusion-loaded row count per table, per period, per company code. Variance threshold zero for GL; configurable for archival domains.

    ⚖️

    Sum totals

    Debit, credit, amount, quantity, and balance sums reconciled per period per ledger per company code. Variance flags surfaced before any subsequent load is allowed to proceed.

    🔏

    Hash totals

    Each record content-hashed at HANA source and re-hashed post-Fusion-load. Hash drift indicates transformation bug or corruption — surfaced with row-level diff.

    📊

    Trial balance

    S/4HANA trial balance per ledger per period (from ACDOCA) vs Fusion trial balance, drillable to journal line, sub-ledger source, and originating SAP document.

    🧾

    AP / AR aging

    Open AP item aging in S/4HANA (BSIK) vs open AP invoice aging in Fusion, bucketed and reconciled by vendor; same for AR (BSID) by customer. Internal audit signs the pack directly.

    🏭

    Material & asset register

    Material master counts and valuation per plant in S/4HANA vs Fusion item / inventory org. Asset register reconciliation per ANLA book vs Fusion asset book. SOX, IFRS, German HGB grade evidence.

    Frequently asked questions

    What is SAP S/4HANA data migration to Oracle Fusion?+

    SAP S/4HANA data migration is the technical workstream that moves master data, open transactions, and historical records from S/4HANA into Oracle Fusion Cloud. The work spans extraction (HANA SQL, CDS views, OData services, BAPI/RFC), transformation (SAP account-assignment model → Fusion 6-segment COA, KNA1/LFA1 customer-vendor de-duplication, MARA item normalisation, effective-dated history reshaping), and loading (FBDI for Financials, HDL for HCM, REST APIs for incremental deltas). The hardest step is schema transformation: ACDOCA universal journal entries with their cost centre + profit centre + WBS dimensions have to collapse into Fusion's fixed 6-segment GL_INTERFACE rows. Syntra ETL handles every transformation with governed crosswalks and Oracle-validated FBDI/HDL output.

    How does SAP S/4HANA data migration differ from classic SAP ECC migration?+

    S/4HANA simplified some areas (the universal journal ACDOCA replaced BKPF/BSEG/COEP/FAGLFLEXA in classic ECC) but added complexity in others (CDS views as the strategic data-access layer, OData services on RISE, restricted direct-DB access in S/4HANA Cloud). For data migration to Oracle Fusion, the practical implications: ACDOCA is the new strategic source for FI/CO data and Syntra ETL targets it natively, while still being able to read legacy BKPF/BSEG for customers mid-migration; CDS views provide a cleaner extraction surface for RISE-hosted S/4HANA where DB access is locked down; and HANA in-memory columnar storage means extraction is faster than ECC on Oracle/DB2 was, but every read still bills against the HANA in-memory footprint.

    How does Syntra ETL handle the SAP universal journal (ACDOCA) extraction?+

    ACDOCA is S/4HANA's universal journal — a single fact table replacing the FI/CO/COPA splits of classic ECC. Syntra ETL extracts ACDOCA via HANA SQL where direct DB access exists, or via the I_JournalEntryItem CDS view where access is restricted (typically RISE with SAP Cloud Private Edition). Extraction is partitioned by RBUKRS (company code), RYEAR (fiscal year), POPER (period), and RACCT (account) for parallelism. Account-assignment dimensions (KOSTL cost centre, PRCTR profit centre, PS_PSP_PNR WBS, AUFNR internal order, RFAREA functional area) are preserved during extract and then collapsed to Fusion's 6-segment COA during transformation, with non-COA dimensions routed to DFFs or PPM analytical attributes.

    Can Syntra ETL extract from RISE with SAP / S/4HANA Cloud Private Edition where DB access is restricted?+

    Yes. RISE with SAP Cloud Private Edition typically does not grant customers direct HANA DB access — extraction has to happen through approved interfaces. Syntra ETL supports three: CDS views (the strategic SAP-blessed access layer, with thousands of pre-defined I_* and C_* views covering every business object), OData services (for cloud-friendly RESTful extraction, supported by the SAP Gateway), and BAPI/RFC calls (for legacy access patterns). Throughput is lower than direct HANA SQL but still production-viable: typical billion-row CDS extracts complete in 8–14 hours versus 5–8 hours direct. For S/4HANA Cloud Public Edition, only OData and CDS API access is supported — Syntra ETL works natively against both.

    What output formats does Syntra ETL produce for Oracle Fusion data loading?+

    Syntra ETL emits all three Fusion-native load formats: FBDI (File-Based Data Import) ZIPs for Financials and SCM — GL_INTERFACE, AP_INVOICES_INTERFACE, AR_INTERFACE_LINES, PO_HEADERS_INTERFACE, INV_TXN_INTERFACE, etc.; HDL (HCM Data Loader) bundles for HCM — Worker.dat, Assignment.dat, Salary.dat, Element.dat; and REST API payloads for incremental delta loads, supplier portal updates, and real-time integration. Each format is validated against the current Oracle Fusion 26x release schema before submission, so validation errors are caught locally — not in a 4-hour Fusion ESS job that fails on row 47,000 because of a missing DFF mapping or invalid lookup.

    How does the row-level reconciliation work for SAP S/4HANA to Fusion loads?+

    Every record extracted from S/4HANA is hashed at the source. Every record loaded into Fusion is re-hashed post-load. The reconciliation engine compares counts, sum totals (debits, credits, amounts, quantities), and hash signatures per table, per period, per company code. Any record that fails Fusion validation is captured in an error report with the exact field-level reason — ready for bulk fix or escalation. The output is a signed, timestamped reconciliation pack: S/4HANA trial balance vs Fusion trial balance to the cent, AP aging vs AP aging, asset register vs asset register. Internal audit signs off on the pack directly. This is the evidence base German HGB/AO regulators, SOX auditors, and IFRS attesters look for during cutover.

    Can we run SAP S/4HANA and Oracle Fusion in parallel during cutover?+

    Yes. After the initial bulk load, Syntra ETL captures S/4HANA deltas via standard change-data techniques: CDPOS/CDHDR change documents, ACDOCA timestamp watermarks, or SLT (SAP Landscape Transformation) replication where it's already deployed. Deltas are replayed into Fusion through REST APIs. This supports the standard parallel-run pattern: S/4HANA continues taking production traffic for 1–2 close cycles while Fusion is validated against S/4HANA to the cent. Once finance and audit are comfortable, traffic cuts to Fusion and S/4HANA moves to archive-only — at which point the HANA licence consumption can be wound down.

    How does the data migration handle SAP organisational structure (company code, plant, sales org)?+

    SAP's enterprise structure (BUKRS company code, WERKS plant, VKORG sales organisation, VTWEG distribution channel, SPART division, EKORG purchasing organisation) maps onto Fusion's Business Unit + Inventory Org + Selling BU + Procurement BU model — but not 1:1. Syntra ETL's converter analyses the S/4HANA organisational structure, recommends a Fusion enterprise-structure design that preserves the analytical and security intent of the SAP model, and applies it during transformation so postings to SAP BUKRS '1000' land in the correctly-configured Fusion BU. The mapping is reviewed and signed off by finance, SCM, and security leads before any load. Multi-ledger and multi-currency (RFLEDGER, T001A) handling is built in for IFRS / local-GAAP dual ledger setups.

    Plan your SAP S/4HANA data migration to Oracle Fusion

    30-minute call. Walk through your S/4HANA data volumes, ACDOCA depth, account-assignment design, and target Fusion pillars — leave with a concrete data-migration plan.