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 All,

Thanks for giving informatiom ..

Regards,

Surendar

[Former Member]

Hi All,

Continuation of Original post,  Before start Migration we do need Validation, In validation stage Normally we take download from System and do checks which are the data needs to migrate to new company code or Plant.. So now what my question is how do we do validation like For example Material master(1000- materials are in System), now we will not migrate all materials which are exist in source system,how do we do validations in this stage to reduce the material list. what are the checks need to do? Do we need to check Sales order and Purchase order list to get Material master data list? Need to check historical data(How do we do?)

Much appreciated to give info ASAP.

Regards,

Surendar

[Former Member]

Hi Surendar,

          As per my understanding from the above post i assume that you want to reduce the no of records from 1000 to say 600. I don't think validation will help you to reduce the no of records.

It will check a certain condition, if it passes it will show success or failure message if it fails.

But you can filter the no of records from Free form search itself or using expressions.

This filter criteria is based on the ECC system requirement,

Say you've an filed called currency and different values are available but ECC requires only USD currency, you can filter it through Free form search or using expressions.

I hope i understood and answered your issue. If this is not the issue please let me know how i can be helpful.

Best Regards,

Santhakumar

[Former Member]

Hi,

most of the points already mentioned are absolutely correct.

To add some more details:

• You do not have to export the data into flat files as Vikrant told above. But you can access the data directly via LSMW coding where you select the data from the database directly. Then you can also easily add some rules to exclude data records.
• You can perform the upload via Idoc. However especially for master data it is sufficient to add new company code information to the data record. For example you can use a simple batch recording to copy the company code data of a customer. This can be more efficient than using Idocs. 
• It could be necessary that you block the old master data records via mass update. This can also be easily done via migration.

Hope my addition is helpful.

For transactional data I cannot give general advises. The process is mostly more complex than for master data and depends from the object and environment.

Regards, Mark

[JasonLax]

Discussion moved from 主数据管理 (Master Data Management) to Master Data Management (SAP MDM)

主数据管理 (Master Data Management) is the Chinese version of the MDM space!

[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