Verifying data consistency in production SAP FI/CO system when restoring a backup

Verifying data consistency in production SAP FI/CO system when restoring a backup

During a recent change freeze, and after a full offline backup, I am restoring a backup of my current production FICO system onto another server to act as a system reference. I'll do this before making major changes to my live production system.

How do I prove to my colleagues that the restored (reference) copy of the FICO system is a true and accurate copy of actual production before I make the changes to my production system? In other words, how do I prove that the backup is good, and the restored system and business data in both systems is identical?

I have written an ABAP tool to reconcile between my production and reference systems, as well as between all companies and FICO ledgers over an eight-year period. The current signoff is that if they both come out the same after reconciliation then this is good proof that they are identical.

    Requires Free Membership to View

    When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Your procedure is correct. Running business reports before and after the migration, in the source and target systems, is the only way to verify data consistency. There is no need to say that the results should be the same in both systems.

You should, however, consult with your business users. I have several customers who run a set of reports to verify data consistency. These reports take about 30 minutes, as they verify a specific set of data. It makes no sense to verify eight years of business data.

This was first published in January 2009