Running Data Validation

Objective

After completing this lesson, you will be able to perform data validation

Data Validation

You can run data validation at three points in the process:

  1. Reported Data Validation: Run after data collection.
  2. Standardized Data Validation: Run after currency translation.
  3. Consolidated Data Validation: Run after eliminations.

When you run the reported, standardized, and consolidated data validation tasks, you can view the results of the validation.

The image shows the SAP Data Monitor interface for managing data validation tasks and the Validation Results screen.

On the Validation Result page, you can do the following:

  1. Re-validate
  2. View the Rule Group
  3. View the Validation Rule
  4. Add Comments
  5. Download to Microsoft Excel

If you open the Details for one validation rule you can see the calculated left side value and right side value of your validation rule. You can also switch to the Tolerance Currency and also add comments.

The figure shows the Validation Result for a selected validation rule.

Note

If a difference/variances occurs when the data validation is executed, consider these steps to identify the root cause of the issue:
  • Switch to the tolerance currency (if configured).
  • If the consolidation unit is integrated into SAP S/4HANA Finance, run the Data Release Task and check the totals report.
  • Run a report by consolidation unit, FS item, posting level, and document type to identify where the difference is coming from.

Run Data Validation

Business Scenario

Now that you've released and imported data into group reporting, you need to run data validation integrity of the reported financial data.

What skills will you develop in this practice exercise?

  • Set your global parameters if necessary
  • Run reported data validation
  • Analyze the results in the log
ExerciseStart Exercise
Business scenario

Now that you've released and imported data into group reporting, you need to run data validation to check the integrity of the reported financial data.

Note

In this exercise, when you see ##, replace the characters with your group number.

In this exercise, you'll complete the following tasks:

  • Set your global parameters if necessary
  • Run reported data validation
Learning
SAP FacebookSAP YoutubeSAP LinkedIn