Data Migration Validation Approach

[Former Member]

Dear all,

I am rather new to the SAP world so some patience and clear explanations might be required. Currently I have to find some approaches to validate migrated data (like for instance take random employee and check whether data is moved correctly), but in our company we have no common practices for that kind of things. Can I ask you to help me out and give me some tips (or maybe describe some practices from your experience) on different approaches to validate migrated data.

Thank you all in advance!

[Former Member · Accepted solution]

Hi,

There are a couple of resources you can use to audit employee master data. The quickest action for you is probably to use SAP standard reports, rather than using SAP Query / Ad Hoc query. You certainly could use either of the reporting tools but if you're really new to SAP and are working on a deadline to audit your master data, I think the learning curve might be too high.

Some helpful standard reports are:

PC00_M02_LINF0 - Robust infotype overview per employee, but requires some drill-down.

S_AHR_61016360 - You might need to play with the selection screen a bit but this can be useful. Canned Ad Hoc Query report.

You may have to resort to looking up your employees at the infotype table level using transaction SE16. This takes longer but it's also a good exercise for some one who is just starting out in SAP HR.

Honestly, if you're looking to perform an audit of multiple employees at once, then SAP Query or Ad Hoc Query are much more robust tools. If you're going to be working with master data in SAP beyond the go-live, then it would benefit you greatly to take the time to learn them both. Ad Hoc Query is a simpler but less powerful reporting tool that is useful if you want to slap together a data overview very quickly. Unfortunately I don't know of a good resource for Ad Hoc query off the top of my head. [Here|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10eab7af-0e54-2c10-28a5-87b47adbe1a5?quicklink=index&overridelayout=true] is a fairly useful tutorial to SAP Query, which is a more robust - and more complicated - reporting tool.

I hope this helps!

-Matthew

[Former Member · Accepted solution]

Hi Matthew,

Thank you for your answer, it was very helpful. Are there any other ways to validate data? Maybe there are some statistical methods or some other exotic methods? If you can remember something or point me in the direction where to look, it would be very helpful as well.

[Former Member · Accepted solution]

Hi again,

In my honest opinion, you'll probably want to create a set of SAP Query reports for auditing your master data. SAP Query is a really indispensable tool for an analyst. Danielle Larocca has a pretty good book on the subject titled SAP Query Reporting that you may want to check out. There's also some useful guides available here on SDN. Ad Hoc query might work for you as well, just keep in mind it's a little simpler and definitely less robust than SAP Query reporting. Otherwise, you're going to be stuck pulling your data from infotype tables manually and dumping it into Excel for vlookups and comparisons.

I hope this helps - sorry there are no silver bullets here.

-Matthew

[Former Member · Accepted solution]

Dear all,

Thank you very much for your help, I think I can start from here for sure.

Pavel