Skip to Content
User Experience Insights
Author's profile photo Sheldon Edelstein

An Introduction to the Data Transition Validation Tool


The Data Transition Validation (DTV) Tool is a new tool available for SAP S/4HANA conversion projects targeting S/4HANA 2021:  DTV allows the establishment of a project that spans the entire conversion process.  Within the DTV project specific reports can be identified and configured to capture key financial data before and after system conversion.  The pre- and post-system conversion data is then compared by DTV to help determine if the conversion was successful.  A successful conversion (from a finance perspective) has the pre- and post-system conversion data matching.


Historically, system conversion to SAP S/4HANA has required a significant amount of time and effort for the Finance team to reconcile financial balances before and after the conversion process.  The reconciliation process is an important step to be able to determine the correctness of the conversion (from a financial perspective).   Only after the reconciliation is completed and found to be adequate should the signal to reopen the newly converted S/4HANA system be announced.  Once the S/4HANA system is reopened, business users may restart normal business operations.

Several SAP pre-delivered reports are recommended by SAP (see SAP Note 2332030 – Conversion of accounting to SAP S/4HANA, section 6.3 Document Your Posting Data) to “snapshot” key financial positions before and after conversion. Historically the comparison of before/after conversion reports had to be performed through manual processes.  Companies with many company codes, customers, and/or vendors may be required to generate hundreds of reports to adequately document the financial data in the system.   The level of effort required to compare each of the pre- and post-system conversion reports with each other is typically a major effort requiring days and sometimes weeks to accomplish.

The Data Transition Validation (DTV) Tool is available as of the SAP S/4HANA 2021 release (it cannot currently be used for target releases prior to S/4HANA 2021).  DTV Tool (accessed via t-code DVF) allows you to automate the comparison of financial data before and after a system conversion from SAP ECC to SAP S/4HANA.

The validation tool offers following key capabilities:

    • Identify which reports are relevant for conversion validation.  Standard SAP reports are pre-loaded into the tool and may be selectively imported into an active validation project.
    • Global Parameters may be defined and automatically applied to all reports.
    • Test specifications may be defined for each report. The test specification defines key report parameters (such as Company Code, Key Dates, GL Accounts, etc.).  Individual parameter fields can be defined as values ranges, specific values, or even exclusion values for each report selection.
    • Optional report variants may be defined and used as well.
    • All test specifications can be simulated to determine anticipated output.  View up to the first 100 rows of generated data in the Simulation option.
    • Full control on when and how (simulation or actual execution) each report is executed to extract the results of the source and target systems. Compare the source and target release data and analyze the comparison (before conversion and after conversion) results.
    • Project level statuses and individual steps statuses provide high level project management

The following blog describes the data transition validation in additional detail, and provides valuable links to key documents:

To help you get started using this tool I’ve prepared the following guide for a simple DTV project.  Please note that significantly more complex scenarios can be developed.   This quick project is presented to show a very simple use case.

Key configuration steps to implement a simple DTV project:

  1. Establish a project to contain the definition of the overall process


  1. Enter a description and Save to initialize the process

  1. Double click on “Maintain System” step to establish source and target (receiver) system naming

(for this project source system is named ERP and target system is S/4HANA)


Save settings.

Mark Step as Completed

Return to project overview screen.

Note that status of the Maintain Systems step is now identified as “Completed” and project Status is “In Progress”.


  1. Click on “Pre-Delivered Content” step to identify which reports should be executed for the comparisons:


A list of all available delivered reports is displayed (for this quick project I selected only one report and then imported the specification into the project)


System will message when import is complete.

Exit and return to main project overview screen:


  1. Select Define Test Specifications and select one the imported report:

Enter report variant for each system (note using a variant is only one way to specify the report conditions, other options include:

  • Global Variables (to specify conditions across all reports in project),
  • Identify specific value and value ranges for specific value fields in the Condition tab
  • Identify specific value and value ranges for specific value fields that should be excluded from the report


Note the warnings if using a variant, system will ignore some report conditions in favor of a variant definition:

If using a variant, you may need to remove all Split, Condition, and Exclusion conditions to allow system to display data correctly.

Acknowledge warnings and Save.

  1. Test report operation by selecting the Simulation option:

View simulated report results by scrolling to the far right of the selected report line.  The initial state will indicate that no simulation has been executed with a clear flag and the Simulation Link will be non-functional:

After executing the Simulation, the flag will appear dark and the resulting Link will hyperlink to open simulation results:

Simulation Result Link provides a summary view (up to a maximum of 100 rows) of the data generated (in this simple case four records were generated by the report execution in the pre-converted system, ERP):


  1. Exit Define Test Specification and return to the project overview page



  1. Enter the “Execute Data Extraction” step


Highlight specific report and system to “Run Selected” data extraction

View data extraction results:


Scroll down to visualize up to 100 rows generated by the report:


  1. Perform the system conversion to S/4HANA. The DVT project and all associated data is preserved during the conversion process.  After system conversion to S/4HANA and the subsequent Financial data conversion process has been completed, the same DVT project started before the conversion will still be available in the newly converted S/4HANA system.


  1. Return to the DVT project, adjust the parameters for the report execution if necessary, and execute the data extraction for the converted (S/4HANA) system


Scroll down to see first 100 rows generated:

Exit and return to main display

Mark Step as “Completed”  –  notice project status changes to “Extracted”.


  1. Enter the “Evaluate Data” step

Upon completion of the evaluation view the evaluation results:

The Result tab identifies differences, equal, missing, and other unexpected results observed during the comparison of the before and after conversion reports.


In this simple project, all results were the same (equal).

Check results and Sign-Off test item results.

Mark Step As “Completed”

Exit and return to main display.  Note that project status is now “Evaluated”.


  1. View project “Summary”

  1. Once all project steps are marked as complete, the entire project status is set to Completed.



This blog is intended to be an introduction to the DVT tool.  Additional deeper dives into the tool’s capabilities can be expected in future blogs.




The Data Validation Tool in its initial release is currently focused on financial data.  Even in this limited capacity, it provides a much-needed automation of proof that a system conversion has been successfully executed.


Additional blogs on this topic:

Relevant SAP Notes:

3117879 – DTV Tool – Central Note

3103342 – DTV Tool Initial Delivery


Please “like” if you found this blog post interesting!

Please add in the comment section any additional topics you think are valuable to have included in this and future blog posts.

– Brought to you by the S/4HANA RIG

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Ajeet Kumar Agarwal
      Ajeet Kumar Agarwal

      Very nice blog Sheldon, this would be very useful tool for customers who are planning to convert their system from SAP ECC to SAP S/4HANA

      Author's profile photo Divya Usha Vidyadharan
      Divya Usha Vidyadharan

      Great blog Sheldon.This solution is indeed need of the hour for customers transitioning from ECC to S/4HANA with limited downtime. Is this available for both on-prem and private cloud transition scenarios?

      Author's profile photo Sheldon Edelstein
      Sheldon Edelstein
      Blog Post Author

      The DTV tool is available only for the S/4HANA conversion scenario.  This would include ON Prem and Private Cloud edition, but excludes public cloud (no conversion to private cloud currently exists).

      Author's profile photo Christopher Faust
      Christopher Faust

      Is there any possibility for a data transformation between the source system extraction and comparison with the target?  All of my S/4 projects have taken the opportunity to redefine their Chart of Accounts, Profit Centers, etc., although we still need to reconcile back to the old financials.  The ability to configure some sort of mapping logic (perhaps leveraging some AIF functionality?) or to implement ourselves via BADI would be really useful, too.


      Author's profile photo Sheldon Edelstein
      Sheldon Edelstein
      Blog Post Author

      The DTV tool's purpose is to to confirm a successful conversion transformation.  Conversion projects typically accept the same organizational configuration from the source system.  As a result,  the DTV tool does not have mapping capabilities.

      Author's profile photo Dhruvkumar Thakkar
      Dhruvkumar Thakkar

      Hi Christopher,

      I wonder if your requirement got fulfil or you are still in search for the same.

      There is one service in SAP with name BDV( Business Data Validation ) Which also as LTVF as tool other than DTV and I thing that can be helpful for your requirement.

      Please explore around the same and you can also reach out SAP in the same case at




      Author's profile photo Jan Lemmens
      Jan Lemmens

      Hi Sheldon,

      thx for this very useful blog!

      I have some Questions. Can you answer them?

      1. can the tool be used if an "In place" Conversion is done? The Source System is already on HANA DB, and the target system is the same system(HW)?
      2. Is it planned to extend the content with none financial Data like Inventory, Sales orders, etc...?
      3. Can the tool be extended with own content?

      Thx a lot and Best Regards, Jan

      Author's profile photo Sheldon Edelstein
      Sheldon Edelstein
      Blog Post Author
      1. The DTV tool is specifically designed for "in-place" conversion transitions to S/4HANA.
      2. SAP Product Management has recently expanded the reporting selection of the DVT tool, which now includes a number of other functional areas such as Material Management and Inventory Management.  Please see SAP Note: 3117879 - DTV Tool - Central Note  for additional details.
      3. Using custom reports in DTV has been reported to be on the tool's roadmap, but timeline for delivery has not yet be defined.
      Author's profile photo Amit Hiremath
      Amit Hiremath


      Thank you for a great blog on DVF, one question. Can we use this tool to compare two remote systems, we have two systems one on ERP and the other one on S/4 HANA where we are migrating the data and we want to see if we can use this tool for data validation.

      Appreciate your help here



      Author's profile photo Sheldon Edelstein
      Sheldon Edelstein
      Blog Post Author

      The DTV tool's purpose is to to confirm a successful (in-place) conversion transformation.  There are no provisions for connecting two separate remote systems into the tool.

      Author's profile photo Dhruvkumar Thakkar
      Dhruvkumar Thakkar

      Hi Amit,


      I wonder if your requirement got fulfil or you are still in search for the same.

      There is one service in SAP with name BDV( Business Data Validation ) Which also as LTVF as tool other than DTV and I thing that can be helpful for your requirement.

      Please explore around the same and you can also reach out SAP in the same case at




      Author's profile photo Jan Lemmens
      Jan Lemmens

      Hi Chris,

      this sound like it is a Use Case for a Selective Data Transition Approach. There are SAP Tools and Partner (Natuvion, SNP, CBS) for this. See

      Best, Jan


      Author's profile photo Nash Tejani
      Nash Tejani

      Hi Sheldon,

      Excellent Blog.

      Do you know if something similar exists for HR data ?



      Author's profile photo Shiv P
      Shiv P

      Hi Sheldon,

      Great blog on DVF. One question - I see custom reports are not supported currently by DVF but do you know by when this functionality will be supported?




      Author's profile photo Thyge Friis
      Thyge Friis

      Hi Sheldon,

      Really nice step-by-step walk-through of DTV, which is recently available in version 1.3.
      A few questions:

      1. The step 'Table Analysis' was removed in version 1.2.
        What is now the suggested way to easily compare number-of-records in a ECC to S/4HANA scenario? This is for master data purposes.
      2. Under 'Maintain Systems' it is possible to register a system role as 'Control System'.
        What is the intended use of doing this?


      For info:
      To understand the DTV tool end-to-end from a source to receiver system, while still on ECC, you can do the following:

      • Under 'Maintain Systems' define ECC1 as source, and ECC2 as receiver
      • Under 'Execute Data Extraction' run the selected report first on ECC1;
        then do a posting to ensure the next report run will detect some "difference" (= negative test);
        then run the selected report on ECC2
      • Under 'Evaluate Data' you will now have a positive (and negative) illustration of the tool

      Best regards Thyge

      Author's profile photo Sagar Karale
      Sagar Karale

      Hi Sheldon,

      After system conversion when can we execute DTV reports ? immediately after system conversion (SUM) or after Finance Data Migration is completed ?




      Author's profile photo Debraj Pal
      Debraj Pal

      Hi Sheldon,


      Very useful blog. Thanks to you.

      And the tool is great, helps to eliminate the pain of manual validation.

      I have a query on DTV mechanism. How SAP storing or preserving ECC data ? Even S4 data ?

      Is it stored in any backend tables ? When ECC system goes away after conversion , from where its pulling the ECC data ?