Products

Solutions

Pricing

Free Trial

Resources

Contact Us

DVW Analytics
  • Products
    • DVW Connectors for SAP >
      • Alteryx Connector
      • KNIME Connector
      • Dataiku Connector
    • DVW Flow Tool >
      • Flow Tool
      • DVW Flow Tool SAP Migration Landing
    • DVW RPA Tools for SAP >
      • Alteryx RPA Tools
      • KNIME RPA Tools
      • Flow Tool RPA Tools
  • Solutions
    • SAP Analytics
    • SAP Data Migration
    • SAP Process Automation
    • SAP Data for AI and Machine Learning
    • SAP Audit and Compliance
  • Pricing
    • DVW Connectors for SAP >
      • Alteryx Connector
      • KNIME Connector
      • Dataiku Connector
    • DVW Flow Tool >
      • Flow Tool
    • DVW RPA Tools for SAP >
      • RPA Tools
  • Free Trial
  • Resources
    • Blog
    • SAP Data Models >
      • Finance and Controlling
      • Sales and Distribution
      • Inventory Management
      • Purchasing
      • Production Planning
      • Quality Management
      • Plant Maintenance
      • Warehouse Management
      • Human Capital Management
      • Project System
    • Webinars
    • Events
    • Demos and Recordings >
      • DVW Connectors for SAP >
        • Alteryx Connector
        • KNIME Connector
        • Dataiku Connector
      • DVW Flow Tool >
        • Flow Tool
      • DVW RPA Tools for SAP >
        • RPA Tools
    • About Us
    • Customers >
      • Johnson & Johnson
      • AGC
      • Brightstar
      • Vector Logistics
      • International Bank
      • KPMG
    • Partners
    • Resellers
    • Services
    • Help Centre
    • Sample Workflows >
      • Alteryx
      • KNIME
      • Flow Tool
    • License
    • FAQ
  • Contact Us

Blog

SAP ECC to S/4HANA Migration, Step 3: Find the Gaps Before They Become Failed Loads

3/10/2026

 
Picture

Which ECC configuration will S/4HANA reject? Check it before the load: every value your vendors use, how many depend on it, and whether the new system has it. Step 3 of 6: map.

SAP's Migration Cockpit will tell you a purchasing organization is not valid in S/4HANA. It tells you after the data is in the staging tables, one value at a time as someone confirms it, and it does not say how many vendors depend on that value.

Step 1 profiled the system. Step 2 decided which vendors were worth keeping and corrected them at source. This step keeps the same running example, the vendor master, and checks the configuration each vendor carries, purchasing organization, payment method, reconciliation account and account group, against the new system, well before the load, so the gaps are decided rather than discovered.

This post covers the three questions the mapping flow answers, why the vendor counts matter, and how the replace-with column carries the decisions into the load.

Step 3 of 6: the configuration your vendors use, what S/4HANA accepts, and where the two do not line up, in one flow. Also available on YouTube.

Why map before the load

The running example is the vendor master from step 2: the vendors kept after cleansing, and the configuration each one carries. In this example the target is a greenfield S/4HANA system. Its configuration is built fresh, so every value a vendor carries has to exist there before that vendor can load: the purchasing organization, the payment method, the reconciliation account, the account group. The cleansing flows from step 2 corrected most of the data errors at source, but some were deliberately left unresolved to show what happens here.

The Migration Cockpit's Fiori app checks each target value when you confirm it. That is useful, but it only sees configuration values once the data is in the staging tables, it works one value at a time, and it does not tell you how many vendors depend on each value. Well before the load, the questions are different: what is actually in use, what will the new system accept, and where do the two not line up? With those answered, the program can decide what to configure in S/4HANA and what to map to a different value.

One flow, one lane per section of the vendor data

The DVW Flow Tool flow is laid out in lanes, one for each section of the vendor data, which makes it easy to follow, document, and work through with stakeholders. Each lane reads both systems, ECC and S/4HANA, for the latest snapshot, so the comparison is always between what is there now on both sides.

1. What is actually in use

Not what is configured in ECC, only what is used by the vendors you decided to keep and migrate. Each value comes out with the number of vendors behind it.

The counts are the point. A value used by hundreds of vendors has to exist in the new system, no discussion. A value used once might be an old mistake that should be mapped away rather than configured. Without the count, every gap looks the same size.

2. What S/4HANA accepts

The same flow reads the new system's own configuration, so the check is against what is really in S/4HANA right now, not a spreadsheet from last month. On a greenfield project the configuration moves weekly, and a mapping built against a stale extract fails for reasons that were fixed days ago.

3. Where the two do not match

Join the two and the interesting part is where there is no match. Every vendor on one of those values would be rejected during a load to S/4HANA. A few of the checks need more than a straight code lookup:

  • Payment methods are set up per country, so country and method are checked together.
  • The reconciliation account has to exist in the right company code, and be set up for vendors.
  • Account groups do not move across as they are. Each becomes a business partner grouping, so every ECC account group in use is listed for the S/4HANA team to assign.

The list the S/4HANA team works from

What comes out is one list: each value, how many vendors use it, and whether the new system has it. For every gap there are two choices. Configure the value in S/4HANA, or type what to use instead in the replace-with column. The column is only filled where there is a gap, and the answers are kept every time the flow reruns, so the decisions accumulate rather than being redone.

At load time the next flow picks up those replacements automatically. If the program would rather hold the mappings in SAP, the same targets can be set in the Migration Cockpit's own mapping screen. Both work, so use whichever you prefer.

That is mapping

Find out what is in use, check it against the new system, and get the gaps decided before they become failed loads. Next in the series is the mock load, where the Flow Tool fills SAP's own migration templates straight from ECC data. For the wider picture see the SAP data migration solution page.

In this series

  1. Discovery and profiling: what is actually in the system
  2. Cleanse: fix duplicates, gaps and dead records at source
  3. Map: translate old values to the new structure (this post)
  4. Mock load: dry run into the target, capture every rejection
  5. Reconcile: prove source matches target on every cycle
  6. Parallel run: keep both systems in step until cutover

Find your own mapping gaps before the load

Read and write SAP data from any analytics or data platform. Free 30-day trial, full functionality, no commitment.

Start Free Trial Book a Demo Flow Tool for SAP Migration

Trusted by 500+ enterprises.


Comments are closed.

    Guides

    Reference posts that stay useful.

    SAP table guides

    Finance and Controlling

    Tables | Diagram

    Sales and Distribution

    Tables | Diagram

    Purchasing

    Tables | Diagram

    Inventory Management

    Tables | Diagram

    Production Planning

    Tables | Diagram

    Quality Management

    Tables | Diagram

    Plant Maintenance

    Tables | Diagram

    Warehouse Management

    Tables | Diagram

    Human Capital Management

    Tables | Diagram

    Project System

    Tables | Diagram

    SAP finance in KNIME

    Explore your SAP general ledger

    Read BKPF and BSEG into KNIME

    Explore SAP financial documents

    Explore SAP customer line items

    Explore SAP cost center actuals

    Post journal entries to SAP

    SAP data by platform

    Databricks

    Post | Platform page

    Snowflake

    Post | Platform page

    Power BI

    Post | Platform page

    Excel

    Post | Platform page

    Microsoft Fabric

    Platform page

    Start here

    SAP ECC end of support primer

    What makes SAP data AI-ready

    Categories

    Browse every post by product or by topic.

    By product

    Alteryx Connector

    KNIME Connector

    Dataiku Connector

    Flow Tool

    RPA Tools for SAP

    By topic

    Reporting and analytics

    Audit

    Data migration

    Process automation

    AI and machine learning

    SAP S/4HANA

    SAP data extraction

    SAP tables

    Use cases

    Product updates

    Webinar recordings

Products​
​SAP Connectors
DVW Alteryx Connector for SAP
DVW KNIME Connector for SAP
​DVW Dataiku Connector for SAP

DVW Flow Tool
DVW Flow Tool
S/4HANA Migration with Flow Tool

RPA Tools for SAP
DVW Alteryx RPA Tools for SAP
DVW KNIME RPA Tools for SAP
DVW Flow Tool RPA Tools for SAP
Resources
Blog
Watch Demos
Webinars
​
​Events
​Customers
Services
Solutions
SAP Analytics
SAP Data Migration
SAP Process Automation
SAP Data for AI and ML
​SAP Audit and Compliance
Company
About Us
Contact Us
Pricing
Free Trial

[email protected]
Get started
​Start Free Trial
View Pricing
Book a Demo
​DVW Analytics gives business users and technical teams direct access to SAP data from Alteryx, KNIME, Dataiku, Power BI, Databricks, Snowflake, and more. Trusted by 500+ enterprises worldwide.
© COPYRIGHT 2003 - 2026 DE VILLIERS WALTON LIMITED. ALL RIGHTS RESERVED.
Privacy Policy
Cookie Policy
De Villiers Walton Limited. Registered in England and Wales. Company No. 04638006. VAT No. GB 807714429. Registered Office:  Ground Floor Marlborough House, 298 Regents Park Road, London, N3 2SZ, United Kingdom

SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. Alteryx is a registered trademark of Alteryx, Inc. KNIME is a registered trademark of KNIME AG. Dataiku is a registered trademark of Dataiku SAS. All other product, company, and brand names mentioned herein are the trademarks or registered trademarks of their respective owners and are used for identification purposes only.
  • Products
    • DVW Connectors for SAP >
      • Alteryx Connector
      • KNIME Connector
      • Dataiku Connector
    • DVW Flow Tool >
      • Flow Tool
      • DVW Flow Tool SAP Migration Landing
    • DVW RPA Tools for SAP >
      • Alteryx RPA Tools
      • KNIME RPA Tools
      • Flow Tool RPA Tools
  • Solutions
    • SAP Analytics
    • SAP Data Migration
    • SAP Process Automation
    • SAP Data for AI and Machine Learning
    • SAP Audit and Compliance
  • Pricing
    • DVW Connectors for SAP >
      • Alteryx Connector
      • KNIME Connector
      • Dataiku Connector
    • DVW Flow Tool >
      • Flow Tool
    • DVW RPA Tools for SAP >
      • RPA Tools
  • Free Trial
  • Resources
    • Blog
    • SAP Data Models >
      • Finance and Controlling
      • Sales and Distribution
      • Inventory Management
      • Purchasing
      • Production Planning
      • Quality Management
      • Plant Maintenance
      • Warehouse Management
      • Human Capital Management
      • Project System
    • Webinars
    • Events
    • Demos and Recordings >
      • DVW Connectors for SAP >
        • Alteryx Connector
        • KNIME Connector
        • Dataiku Connector
      • DVW Flow Tool >
        • Flow Tool
      • DVW RPA Tools for SAP >
        • RPA Tools
    • About Us
    • Customers >
      • Johnson & Johnson
      • AGC
      • Brightstar
      • Vector Logistics
      • International Bank
      • KPMG
    • Partners
    • Resellers
    • Services
    • Help Centre
    • Sample Workflows >
      • Alteryx
      • KNIME
      • Flow Tool
    • License
    • FAQ
  • Contact Us