Sap data migration: Post data upload validation

[Former Member]

Hi,

When we upload data into SAP using LSMW or MDM, how do we compare the data uploaded is done correctly?

How can we compare record by record if the uploaded data is done as per the contents of your uploaded file?

Regards,

Revanth

[Former Member]

Hi Revanth,

There are multiple methods for this and it will depend on which technique you are using for loading.

Say, if you are using lsmw, direct input/recording/IDoc, then we have to cross check the number of records in table.

If you are using program, in background then we have to generate a notepad with a success or error message.

If it is a mass uload using IDoc, the only way is to cross check records one by one, in MM90(Ckeck the records with red) , WE02 etc

If you are using direct input method, it is easy to collect the details and you can download the spool.

Suppose you are loading material master, which is having internal number assignment, then these techniques will not help.

You have to load the field 'old material number' and then you need to do a cross check in the table.

Regards,

Nivedita

[Former Member]

Hi Nivedita,

Irrespective of the data load method whether it is IDOC, BAPI, Direct input. I am not asking how to track how many records are loaded and how many or not. The requirement is:

By using any of the above methods i uploaded say 100 records using a flat file.

I need to extract the uploaded records from the table and compare with my flat file record by record.

So that we can be sure if all the records are uploaded as per my file.

This is simple if we have data uploaded in a single table, But incase if the data is in multiple tables, for example inspection plan, BOM , Master recipe etc., its difficult to extract the uploaded 100 records.

So do we have any tools or reports to extract the data and then to compare the data?

Thanks for your response.

regards,

Revanth

[Former Member]

As far as I know, there is no other method to check the records that are loaded as I 've explained above.

Like you said if data is loaded to multiple tables, (same happens in IDoc loading) you need to check the log in WE02 or MM90. In MM90 you will get the number of records and error message.

Else you can prevent wrong data from loading , but there is no easy way to check whether it is loaded or not.

[vamsixk]

HI Revanth,

As Nivedita Correctly pointed out,

there are no specific functions ins R/3 for validating your data that has been loaded. AS far as i know.

It is up to the data migration team to generate these reconciliation reports.

You can of course build your own reports or tools for objects involving multiple tables.

And carry out the the said reconciliation.

One process we followed for material master load was that we used the 'description" as a unique identifier to map each record from the flat file to the SAP table.

Regards