The latest version of
Data Transition Validation (DTV) tool is now generally available with
a brand-new feature where in, the tool can now validate custom reports. This blog would shed some light on this new feature. Starting
DTV 1.4 release, DTV tool can validate
custom reports (Z reports) with ALV output along with the
pre-delivered content (Selected SAP reports) automatically. This new feature would augment the business data validation process during
System Conversions and
SAP S/4HANA update/upgrade by allowing business users to validate business data for custom as well as SAP standard reports.
Follow DTV Central Note for DTV 1.4 release information.
3117879 - Data Transition Validation DTV Tool - Central Note - SAP for Me
One can follow the below steps to add, extract and validate business data for
custom reports using DTV tool to ensure the quality of the migrated data.
Prerequisites
- You have DTV 1.4 version in your system.
- You have Custom User role.
- Systems are defined in the Maintain Systems step of the project.
- Project Global Data is maintained for the project.
- Same version of the custom report exists in both source and target system.
- In case you are using variant for data extraction, variants must be created in the respective systems for report execution.
Follow the below steps to add, extract and validate custom report.
Adding custom report/reports to Test Specification
Go to
Define Test Specification step of the project.
In edit mode, click on button “
Add Custom Report.”
In the Add Custom Report screen add
Report Name, Report Description, Functional Area, Functional Group and Output Type.
Note: Output type ALV (List, Grid, Hierarchical) is only supported for custom report validation in DTV 1.4 release.
Click on
Continue and add the custom report to the Test Specification List.
Double click on the added custom report and start providing the input parameters such as
Split, Condition, Exclude, Variant and Output Keys etc.
Note: Simulation is not supported for custom reports.
Note: Output keys are keys using which the source and target data are compared in the evaluation. The report output fields can be specified in the Output Keys tab. If no key is specified, then the tool considers the keys mentioned in the ALV field catalogue. If keys are specified in Output Keys tab, only those shall be considered as keys for comparison.
Extracting data of the custom report/reports
Once the Test Specification is defined for the custom report, you can navigate to
Execute Data Extraction step.
You can find the custom report in the respective functional area node.
You can select the report and click on
Run Selected and run the extraction.
You can check the extraction result of the custom report.
Follow the same steps to extract the business data in the target system as well.
Evaluate data of custom report/reports
Once data extraction is done for the target system, you can run the Evaluation.
Navigate to
Evaluate Data step in the Manage Project screen.
Run the evaluation for custom report/ reports and check the business data validation results to ensure the quality of the migrated data in the target system.
Additional Blogs on DTV
An Introduction to the Data Transition Validation Tool | SAP Blogs
data transition validation the tool to validate business data after conversion | SAP Blogs