topic Re: Validating SAP Data post migration in Application Development and Automation Discussions

Validating SAP Data post migration

Former Member — Fri, 12 Jun 2009 08:03:14 GMT

Need your suggestions, ideas.

Situation:

We are doing the testing for SAP BP.

There is a legacy system which stores the customer information (CIS).

All of the Data from CIS have to be move to SAP BP after migration.

Lets Say that after the migration is complete then

100% record in CIS (legacy) should be equal to 100% record in SAP BP (new system).

But then we found that only the 90% of data is moved to SAP BP and 10% went missing,

Now we have this SAP BP database with 90% accurate data and lets name it Database 1.

Again the migration is done (which should be 100% of CIS record = 100% of BP records)

Lets say this as Database 2.

Now i want to compare the data between database 1 and database 2 just to validate if the 10% data

which went missing in Database 1 is present in database 2.

What are the ways i can do it.

Is there a utility which we can use to do this.

@@@ How is this usually done in other SAP (or other) projects @@@@

Please suggest.

There might be a chance that the 10% data would have migrated correctly to database 2 but some othe recors which were earlier migrated correctly may have been wrong this time.***

How do i do this.

Let me know if you need more explaintation.

Re: Validating SAP Data post migration

Former Member — Fri, 12 Jun 2009 19:16:26 GMT

Any Suggestions?

Re: Validating SAP Data post migration

Former Member — Fri, 12 Jun 2009 19:26:30 GMT

Even if the data is 100% migrated, how do you know it is 100% correct? 80% any % ?

This is really an end user problem. After the migration, they have to check and sign off.

Rob

Re: Validating SAP Data post migration

Former Member — Sat, 13 Jun 2009 10:46:40 GMT

Thanks for your response.

How do end users do the validation.

Does it have to be done manually.

Typically what are the ways available in SAP.

How do other projects handle the same situation.

Even if end users do the manual match.. this may not be possible for very big data size.

Is there a tool, utility available which addresses such issues.

Re: Validating SAP Data post migration

Former Member — Sat, 13 Jun 2009 22:20:31 GMT

import data from both systems in excel and apply vlookup technique to find mismatches..

regards

Re: Validating SAP Data post migration

Former Member — Sun, 14 Jun 2009 00:05:09 GMT

Thanks.

Is there any specific tool which comes for this purpose.

Is there any functionality in SAP which can be used for such purpose.

Edited by: Rajesh Sharma on Jun 14, 2009 1:05 AM

Re: Validating SAP Data post migration

Former Member — Sun, 14 Jun 2009 01:29:26 GMT

u need to write a small abap program for this

Re: Validating SAP Data post migration

Former Member — Mon, 15 Jun 2009 09:27:48 GMT

Can you please share more details on ABAP program.

What does it contains.

DO i have to write the program once and run it in both the schema.

How do i validate the result.

Re: Validating SAP Data post migration

Former Member — Mon, 15 Jun 2009 10:05:06 GMT

Hi Rajesh,

A loaded question indeed I don't know of a quick way around it.

I would do this check at database level with the use of queries. It would be a lengthy procedure because you would need to compare contents of each table (there could be hundreds) against each other in the 2 databases draw an exception report(Compare DB1 to DB2). Then you would need to reverse the queries to compare them the other way around (DB2 to DB1) to get another exception report. Then decide how you are going to handle the exceptions both ways.

The may be some shortcuts if your DB's are SQL. I've done this kind of exercise before & it didn't take as long as I expected A tool for this? I haven't seen one yet but they may be lurking out there, this is an age old problem. Tx.

Regards, Trevor

Re: Validating SAP Data post migration

Former Member — Mon, 15 Jun 2009 12:41:50 GMT

Thanks Naidoo.

How does this kind of situation (where u have to analyze and validate 2 databases)

- in SAP Projects

- Non SAP Projects

There must be some tool or utility which we are yet to indentify.

Edited by: Rajesh Sharma on Jun 15, 2009 4:23 PM

Re: Validating SAP Data post migration

Former Member — Tue, 16 Jun 2009 08:54:03 GMT

Few final comments and suggestions are most welcome.