Validating SAP Data post migration

[Former Member]

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.

[Former Member]

Any Suggestions?

[Former Member]

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

[Former Member]

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.

[Former Member]

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

regards

[Former Member]

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

[Former Member]

u need to write a small abap program for this

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

Few final comments and suggestions are most welcome.