Data Migration procedure

[Former Member]

Hi Expert,

I am MDM Consultant on R/3  system,, Currently i am for Migration project that is Moving or merging data from Old plant or company code XXXX to YYYY plant or company code. I would like to know before moving or merging what are the major activities need to follow like validation checks etc.

Please help on this project ASAP.

Thanks and Regards,

Surendar

[Former Member]

HI Expert,

Can any body give th eexplanation about migration.?

Regards,

Surendar

[Former Member]

Hi Surendar,

Do you need information on SAP MDM or ECC Data migration?

First of all you would need to identify the Data objects ,Master and Transactional .

Master Data objects e.g. Vendor ,Material,Customer etc.

Transactional Data Objects e.g. PO's ,Sales Order,etc.

If you are migrating the dat from flat files into ECC directly then you can use the LSMW and code (map) it to transformn the change old to new company code ,old to new plant code etc .

Let me know if you need more information

Cheers

Vikrant

[former_member1357839]

Hi,

     I did a migration years ago from one company code to another. Below are the activities as far as I can remember :-

1. Identify the Master Data that is to be migrated.

2. Identify the transaction data.

3. Check if there are any inconsistencies in Maser Data.

   This can occur due to many things like 'Changing mandatory fields in master data in course of time'.

If this is the case, I suggest you use IDOCS to migrate data.

I did with Idocs (both Master & Transaction data for lakhs of records).

4. Repeat the same process(step 3) for transactional data.

5. For each different idoc, try posting 10 records first and do testing. Once you are sure that the results are ok, you may proceed with the bulk transactions.

[Former Member]

Hi Vikrant,

This is ECC data migration...

As a MDM consultant how do we filter master data like (for ex: materials we have 2000 materials but we are not going to migrate all to new company code or plant) what are the checks need to do?

Regards,

Surendar

Message was edited by: Surendar Reddy

[Former Member]

Hi Surendar,

This can be controlled by the middleware- SAP PI or Webservices .

What you need to do is create a field ( Could be a text and name it as, for e.g. "To Be syndicated :- X" ) in the  Main table (if the whole record is not required) OR Create this field in the Qualified table (if only a part information is required)

Map this field (In Syndication Manager) to your output file (XML or Text) and now in PI you can create a rule ( If the value of field -To Be Syndicated is = X then Syndicate or DONOT Syndicate) to  restrict it from going to ECC or any third party system.

I hope this helps.

Let me know if any issues

Cheers

Vikkrant