Master data and transaction data Conversions

[Former Member]

Hi all,

currently we have data from legacy systems to be migrated into CRM system. The options currently are

1. To use lsmw and do mapping and update the CRM online tables (I am not 100% sure how to do it. Will the output of lsmw be fed into a bapi which creates the orders if order data is migrated).

2. To use IDocs and do LSMW mapping and the output which is an IDoc is again fed into XIF adapter so that CRM middleware will take care automatically.

What is the best way and is there any other best way to do legacy system data migration..

Any idea will be greatly appreciated.

thanks

Jothi

[Former Member · Accepted solution]

Hi Jothi,

I think the Second option will be a better one. You have XIF adapters that are already available. You have to create Flat files according to the corresponding LSMW format and load the files. We have done the same thing.

Hope it helps

Take Care

Bye

Ajay Gupta

[Former Member · Accepted solution]

Hi Jothi,

do you have an XI available?

Michael.

[Former Member · Accepted solution]

Hi Michael,

Yes we have XI available and we will be using as an interface...

whats your opinion...

Jothi

[former_member927251 · Accepted solution]

Hi Jothi,

XI will speed up your work. XI will pick up data from legacy system and convert it in the IDOC format and send it to CRM.

Follow the steps:

1. Analyse the legacy data and create an IDOC for the same. Use transaction WEDI for segments and IDOC creation.

2. Maintain the ALE config for the message type of the IDOC type and assign a processing function module for the same. You can do all the settings in SALE transaction.

3. XI will create the mapping for the IDOC and legacy data. It will convert the data in IDOC and send it to CRM.

4. CRM will receive the IDOC and processing function module will create the data in the CRM system.

Processing function module:

1. Read the IDOC data.

2. Populate the standard BAPIs.

3. Call the BAPI's and handle the errors if any returned by the BAPIs

4. Call BAPI_TRANSACTION_COMMIT to commit the data.

<b>Reward points if it helps.</b>

Regards,

Amit Mishra

[Former Member · Accepted solution]

Hi Amit,

Thanks for the detail information. I understand that if I use XI then there is no need for LSMW to be used for mapping. The proccession function module encapsulated in the IDOc will read the IDoc structure, populate the BAPi's, call the BAPi and execute.

Can you provide a real example of a processing function module. Let say for orders what is the processing function module and which is the transaction where I can see all the available processing function module.

thanks

Jothi.

[former_member927251 · Accepted solution]

Hi Jothi,

Consider an example where the legacy system contains the Business Partner data and the contract data for them. Now you want to get the same in CRM.

You will design your processing function as below.

1. Read the Business partner data from the IDOC and populate the BAPI_BUPA_CREATE_FROM_DATA. This will create business partner for you. Remember create the Main Business partner as an organisation or group.

2. After creating the BP assign role to it say SOLD-TO-PARTY. For this call BAPI_BUPA_ROLE_ADD.

3. Now if you also want to create the contact person for business partner then use the BAPI_BUPA_CREATE_FROM_DATA again. But create the partner as a person this time.

4. Now assign the role Contact Person to the contact person by using the same function module BAPI_BUPA_ROLE_ADD.

5. Now establish the relationship between Main Business Partner and Contact Person using BAPI_BUPR_CONTP_CREATE.

6. Now you are ready with creating the Sales contract for the Business partner.

7. Create the HEADER data for the contract and also the Item data to populate the BAPI_BUSPROCESSND_CREATEMULTI.

8. Call BAPI_BUSPROCESSND_SAVE.

9. Call BAPI_TRANSACTION_COMMIT to commit the data.

<b>Kindly Reward points to every reply that helps.</b>

[Former Member · Accepted solution]

Hi Amit,

From the information provided below I understand there involves some amount of manual implementation required. To write a function which does the below steps.

But I guess If I use the XIF adapter then I need not write these functionalities as the XIF adapter automatically handles it.

Am i Right.....

thanks

Jothi.

[former_member927251 · Accepted solution]

Hi Jothi,

Yes you can do that. Choice is yours. Note that in XIF scenario you will have to configure your middlware.

If you want I can send you the config doc on XIF adapter. Just give me your email id.

<b>Reward points if it helps.</b>

[Former Member · Accepted solution]

Hi Amit,

please send me the config doc on XIF adapter to my id - jothianjali@yahoo.com

thanks

jothi

[former_member927251 · Accepted solution]

Hi Jothi,

I have sent you the required doc at jothianjali@yahoo.com

<b>Reward points if it helps.</b>

I am leaving for the day. Have a nice day.

[former_member927251]

Hi Jothi,

If you can get the data from the legacy system in the form of an IDOC then it's very easy to create the data in CRM. Offcourse here you will require a middlware(e.g. XI, not the CRM Middlware) which can convert the legacy data in IDOC format and send it to CRM.

Once you get the IDOC into CRM system, your inbound processing function module will create the data in the CRM system. There are a lot of BAPI's available for the same. You will have to write a bit of code where you will be reading the IDOC data and populating the BAPIs.

We have done the same in one of our implementations. It's working fine. I will be able to help you further on this.

<b>Reward points if it helps and feel free to ask further questions.</b>