Lesson 2 of 6
SAP validation tools: LTVF, DTV and Central Finance comparison reports
9 min
Listen to this lesson
This course discusses ACCELQ by name. Matt Angerer, who runs The Sign-Off Table, works at ACCELQ. Disclosure
SAP ships three families of tools that compare data before and after a transformation. Each was built for a different kind of move, and each has limits that matter on a go-live weekend. Knowing which one fits saves weeks of building spreadsheets, and knowing which one does not fit stops a team from promising evidence it cannot produce. Scope, availability and commercial terms vary by release and contract, so confirm each one for your landscape.
| Tool | Built for | Compares | How it is provided |
|---|---|---|---|
| LTVF (Landscape Transformation Validation Framework) | SAP-to-SAP transformations: consolidations, carve-outs, company code moves, selective data transition | Record counts, G/L and other balances, field-level values, aggregates, missing and unexpected records, with sign-off logs | Through SAP's DMLT business data validation service; check the SAP Notes referenced by SAP for your scope |
DTV (Data Transition Validation, transaction DVF) | System conversions and upgrades, including SAP ECC to SAP S/4HANA and S/4HANA release changes | Output of business reports or transactions, extracted before and after, compared field by field | Standard SAP tool; central SAP Note 3117879; source-side parts delivered by note |
| Central Finance comparison reports | Replication from source systems into Central Finance | Document counts, then G/L and cost element balances, then line items, per source system | Delivered with Central Finance (from SAP S/4HANA 1709; earlier releases per SAP Note 2352483) |
SAP's three comparison tool families and what each was built for.
LTVF: validation for SAP-to-SAP moves
SAP describes LTVF as a framework for validating business data in landscape transformations such as consolidations, carve-outs and selective data transition. It compares source and target at several levels: record counts per table or object, G/L and receivables or payables totals, field-level values and aggregates, and lists of missing or unexpected records. Its rules are reusable, so the same validation runs in every test cycle, the dress rehearsal and the production cutover, and its results carry an audit trail with formal acceptance of differences. That reuse is the main reason to adopt it: a hand-built query that changes between mocks produces evidence nobody can compare.
LTVF needs SAP on both sides. It fits a DMLT company code merge, a client transfer, a carve-out by clone and delete, or an SDT program. It does not fit Contoso's Wave 2, whose source is a non-SAP legacy ERP.
DTV: before-and-after reports for conversions
Data Transition Validation compares the output of business reports or transactions, such as balance and line-item reports, before and after a conversion or upgrade. In a validation project you choose the reports, write test specifications with selection criteria and splits (for example by company code) and exclude fields that legitimately change, simulate, extract the before snapshot shortly before downtime, extract the after snapshot on the target, and evaluate the differences. Once signed, results stay unchanged, which supports audit. SAP's own material calls it a validation tool, not a reconciliation tool: it tells you what differs, and people still explain why.
Contoso used DTV in its 2026 conversion, with Dan reviewing the results on the go-live weekend. For Wave 2 it does not apply directly: DTV is built for conversions and upgrades of the same system, not for a Migration Cockpit load from another ERP. Its pattern still applies to the untouched check from lesson 1: the same saved report variants for 1710 and 1810, run before and after each W2 mock load, compared line by line.
Central Finance comparison reports
When a buyer uses Central Finance as its Day 1 integration, the comparison reports reconcile each source system against the central system in three levels: the number of FI and CO documents, then balances per G/L account and cost element, then line items per document and account. They work one source system at a time. Contoso evaluated Central Finance during its conversion strategy and rejected it, so for Contoso this is a what-if; for an acquirer that keeps the target on its own ERP for a year, these reports are the monthly reconciliation evidence.
- Is the source an SAP system and the target SAP S/4HANA?No → report-based reconciliation with frozen source reports (Contoso Wave 2) · Yes → next question
- Is it a conversion or upgrade of the same system?Yes → DTV · No → next question
- Is it a merge, transfer, carve-out or SDT?Yes → LTVF through SAP's DMLT service · No → next question
- Is finance replicated into Central Finance?Yes → Central Finance comparison reports, per source system
Where test automation fits, and where it does not
None of these tools runs your business processes. Reconciliation proves the data; regression proves that people can still sell, buy, pay and close with it. This course uses ACCELQ as the worked example for the automation layer, because it is documented for SAP GUI for Windows (ECC 6.0 and higher), works on web UIs through its general web recorder, runs data-driven test cases, calls REST APIs, can query databases it connects to, and can be triggered from CI pipelines or its REST API on every mock. ACCELQ does not reconcile ledgers. It can run a saved report variant in SAP GUI and capture values for comparison, but the balance reconciliation and its sign-off belong to SAP's tools and to the finance owner. Matt Angerer, who runs the Academy, works at ACCELQ; that is why this course carries a disclosure.
What would you do?
A consultant proposes using DTV to reconcile the Wave 2 load: extract the legacy ERP's reports before and Contoso's reports after. What should Priya answer?
- LTVF validates SAP-to-SAP transformations with reusable rules and sign-off logs, through SAP's DMLT service.
- DTV (transaction DVF, SAP Note 3117879) compares report output before and after conversions and upgrades; it is a validation tool, not a reconciliation tool.
- Central Finance comparison reports check counts, balances and line items per source system.
- Automation runs processes and captures values; it does not reconcile ledgers. ACCELQ is the course's worked example for that layer.
Check your understanding · not graded
Lesson check
1. Which tool fits a DMLT company code merge between two SAP S/4HANA company codes?
2. What does DTV compare?
3. What are the three levels of Central Finance comparison reports?
4. What is the right role for test automation in a consolidation?