Question Re: Data Migration procedure in Technology Q&A

Data Migration procedure

Former Member — Tue, 12 Mar 2013 13:41:00 GMT

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

Re: Data Migration procedure

Former Member — Wed, 27 Mar 2013 10:48:59 GMT

HI Expert,

Can any body give th eexplanation about migration.?

Regards,

Surendar

Re: Data Migration procedure

JasonLax — Tue, 23 Apr 2013 14:21:51 GMT

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

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

Re: Data Migration procedure

Former Member — Wed, 01 May 2013 00:08:31 GMT

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

Re: Data Migration procedure

former_member1357839 — Fri, 03 May 2013 10:07:15 GMT

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.

Re: Data Migration procedure

Former Member — Mon, 06 May 2013 09:37:46 GMT

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

Re: Data Migration procedure

Former Member — Mon, 06 May 2013 22:32:11 GMT

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

Re: Data Migration procedure

Former Member — Wed, 22 May 2013 11:07:34 GMT

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

Re: Data Migration procedure

Former Member — Fri, 31 May 2013 06:16:38 GMT

Hi All,

Thanks for giving informatiom ..

Regards,

Surendar

Re: Data Migration procedure

Former Member — Fri, 06 Dec 2013 13:21:17 GMT

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

Re: Data Migration procedure

Former Member — Tue, 10 Dec 2013 15:24:10 GMT

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