-
Products
- Solutions
- Pricing
- Free Trial
-
Resources
-
Insights
- Blog
-
SAP Data Models
>
- SAP FI/CO Table Relationships - Interactive Data Model Diagram
- SAP SD Table Relationships - Interactive Data Model Diagram
- SAP Inventory Management Table Relationships - Interactive Data Model Diagram
- SAP Purchasing Table Relationships - Interactive Data Model Diagram
- SAP PP Table Relationships - Interactive Data Model Diagram
- SAP QM Table Relationships - Interactive Data Model Diagram
- SAP PM Table Relationships - Interactive Data Model Diagram
- SAP WM Table Relationships - Interactive Data Model Diagram
- SAP HCM Table Relationships - Interactive Data Model Diagram
- SAP PS Table Relationships - Interactive Data Model Diagram
- Demos & Recordings >
- Webinars
- Events
- Contact Us
SAP Data Migration
Extract, transform, validate, load, and reconcile SAP data across migration projects. No ABAP development required.
SAP data migration projects, whether moving from SAP ECC to SAP S/4HANA, consolidating SAP systems, or migrating master and transactional data between SAP environments, require fast, reliable access to SAP data at scale. DVW Analytics products provide the SAP read, write, and reconciliation capabilities that migration teams need, without requiring ABAP development.
Free 30-day trial. Full functionality. No commitment.
This demo shows SAP migration reconciliation using the DVW Alteryx Connector for SAP. The DVW KNIME Connector for SAP and DVW Flow Tool support equivalent migration extraction and reconciliation workflows. See all products below.
Why this matters now
SAP has put a firm clock on ECC. Mainstream maintenance for SAP ECC 6.0 ends on 31 December 2027. Optional extended maintenance runs to the end of 2030 at a premium, and after that the system is effectively unsupported. SAP S/4HANA, the destination, is committed for support to at least 2040.
31 December 2027 Mainstream maintenance for SAP ECC 6.0 ends
31 December 2030 Optional extended maintenance ends
2040 SAP support commitment for SAP S/4HANA
End of support does not mean ECC stops working. What stops is SAP shipping the fixes, security patches, and legal and tax updates that finance and compliance teams depend on. Close to half the installed base is expected to still be running ECC when the 2027 deadline arrives.
Whether you are migrating to SAP S/4HANA now or staying on SAP ECC for years yet, DVW connects to both with the same connection. You can read and write SAP data from any analytics or data platform, so the profiling, controls, and automation you build today carry straight over when you eventually move.
Read the Primer: SAP ECC End of Support
SAP ECC to SAP S/4HANA migration
The migration from SAP ECC to SAP S/4HANA is the most common and most complex SAP migration project underway across the SAP customer base. DVW Analytics products are used by migration teams to support the full data workstream of an ECC to S/4HANA program.
Typical use cases on an ECC to S/4HANA migration program include:
- Extracting master data (materials, customers, vendors, cost centers, profit centers) from SAP ECC for validation and cleansing before load to S/4HANA
- Extracting open items and transactional data from SAP ECC financial and logistics modules for migration
- Reconciling extracted ECC data against S/4HANA after load to confirm completeness and accuracy
- Extracting custom table data and Z-table content from SAP ECC for assessment and migration
- Automating the reconciliation of cutover data volumes across multiple migration runs
- Generating sign-off ready reconciliation reports for business and audit stakeholders
The DVW Alteryx Connector for SAP has a dedicated migration reconciliation demo showing end-to-end automation of the reconciliation process across SAP ECC and SAP S/4HANA. See the Demos section below.
DVW Analytics products let you read and write SAP data from any analytics or data platform. Data can be extracted from a wide range of SAP sources, transformed and validated outside SAP, and written back to SAP target systems. This covers the full migration data lifecycle: extraction from the source system, preparation and validation in an analytics platform, reconciliation between source and target, and load to the target system.
Key capabilities
Data extraction from SAP source systems
- Extract data from SAP ECC, SAP S/4HANA, SAP BW, SAP BW/4HANA, SAP Analytics Cloud, and more
- Read SAP Tables, T-Codes and ABAP Reports, SAP Queries, SAP BAPIs, SAP OData services, SAP BW Queries and InfoProviders, SAP HANA Views, and more
- Support for 25+ SAP Industry Solutions including SAP Oil & Gas, SAP Utilities, SAP Telecommunications and SAP Retail
- Delta load support for incremental extraction during migration runs
- Multiple SAP systems in a single workflow: extract from source ECC and target S/4HANA in the same process
Data transformation and validation
- Over 100 built-in transformation and cleansing operations available in DVW Flow Tool
- Apply consistent data preparation rules, field mapping, and validation logic before load
- Join and reconcile data from SAP and non-SAP sources in a single workflow
- AI-based data cleansing available in DVW Flow Tool, including address validation for master data migration
- Preview and validate output before loading to the SAP target system
Reconciliation between source and target
- Extract equivalent data sets from both source SAP ECC and target SAP S/4HANA systems simultaneously
- Reconcile record counts, field values, and aggregated totals between systems
- Generate audit-ready reconciliation outputs in Excel, PDF, or dashboard format
- Automate reconciliation workflows for repeatable execution across migration sprints
- KPI dashboards for migration readiness tracking across teams and workstreams
Data load to SAP target systems
- Write data to SAP S/4HANA and SAP ECC using SAP BAPIs and RFC-enabled Function Modules (Add-On)
- Load master data and transactional data using SAP IDoc technology (Add-On)
- Write to SAP S/4HANA Cloud via SAP OData services (Add-On)
- Write confirmations and status back to the source system for reconciliation and audit
Automation and scheduling
- Schedule migration extraction and reconciliation workflows with DVW Flow Tool Server
- Run unattended migration workflows for large-volume, repeatable extraction runs
- Trigger workflows from external systems or run on a defined schedule
DVW Analytics products for SAP Data Migration
DVW Alteryx Connector for SAP
The primary DVW product for migration reconciliation workstreams. Installed as an Alteryx plug-in, it provides direct read and write access to SAP ECC, S/4HANA, BW, and HANA. Supports the full range of SAP read sources and write-back using BAPI, IDoc, OData and SAP BW write Add-Ons.
DVW KNIME Connector for SAP
Read and write SAP data directly within KNIME Analytics Platform and KNIME Hub. Suitable for migration teams using KNIME for data science and analytics workflows. Supports extraction from SAP ECC and S/4HANA tables, T-codes, BW, and HANA.
DVW Dataiku Connector for SAP
Integrates SAP data into Dataiku projects for advanced analytics and data science. Read and write SAP data within Dataiku workflows.
DVW Flow Tool
A standalone orchestration platform that connects to multiple SAP systems in a single workflow. Particularly well suited to large-volume migration extraction runs and scenarios where SAP data needs to be delivered to a staging platform such as Microsoft Fabric, Databricks, Snowflake, or Azure Data Lake as part of the migration process. Flow Tool Server supports scheduled, unattended migration runs. BAPI, IDoc, and OData write Add-Ons are available for load to SAP target systems.
Relevant demos
How to Automate SAP Data Migration Reconciliation with Alteryx and DVW Analytics
Demonstrates end-to-end automation of the SAP migration reconciliation process. Covers reading from SAP ECC and S/4HANA simultaneously, instant reconciliation of SAP tables, automated reporting, owner notifications, and KPI dashboards for migration readiness.
SAP Asset and Liability Reconciliation using Alteryx and DVW Analytics
Shows how to pull asset and liability data from SAP using T-codes, preserving SAP's inbuilt business logic, and reconcile against an external validation source, and output audit-ready results. Directly applicable to balance sheet data validation during an ECC to S/4HANA migration.
Ready to accelerate your SAP data migration?
Free 30-day trial. Full functionality. No commitment.
|
Products
|
Resources & Insights
Solutions
|
Company
|
Get started
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.
|
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.