Skip to Content
Author's profile photo Jothivenkatesh M

LSMW and XIF – Idoc method

Some times when the Master data are to be uploaded from a legacy system or from any other non connected, non SAP systems LSMW will come to the rescue. LSMW can be expanded as Legacy System Migration Workbench. This is to migrate the business entities into the CRM system. This tool actually contains following methods in which we can import data to CRM system:

  • Standard Batch / Direct Input
  • Batch Input Recording    
  • BAPI
  • IDOC.

Out of these methods we will have a look into the steps of the importing business partners using Idoc method.

Step 1: Create project using transaction LSMW

LSMW1.jpg

Step 2: Select Maintain Attributes Radio Button:

LSMW2.jpg

Step 3: Maintain Attributes

Select Idoc Radio button and give “Message Type and Basic Type”.

LSMW3.jpg

Click on Save.

Step 4: Activate Inbound processing.

The following screenshots explain the activation of Idoc Inbound processing.

LSMW4.jpg

Click “Idoc inbound processings” under settings.

LSMW5.jpg

Here maintain “Port” and “Partner type” and Partner number here and Press Activate Idoc Inbound processing.

Step 5: Maintain Source attributes

LSMW6.jpg

Click on “Maintain source structures” radio button. Click on Source attributes and then click on create.

LSMW7.jpg

Step 6: Maintain source fields

LSMW8.jpg

LSMW9.jpg

Step 7: Maintain structure relations

LSMW1_0.jpg

LSMW1_1.jpg

Click on structure relation and click on relationship as shown above to maintain relationship.

Step 8: Maintain field mapping

LSMW1_2.jpg

And press F8.

LSMW1_3.jpg

Extras ==> Auto field mapping. Press Enter until you get a popup message field mapping completed.

Step 9: Specify files

LSMW1_4.jpg

LSMW1_5.jpg

Click on the Legacy data while taking file from presentation server and click create.

Step 10: Assign files

LSMW1_6.jpg

LSMW1_7.jpg

Step 11: Read data

LSMW1_8.jpg

LSMW2_2.jpg

Step 12: Display Read data

LSMW2_0.jpg

Step 13: Convert Data

LSMW2_1.jpg

LSMW2_2.jpg

Step 14: Start Idoc generation

LSMW2_3.jpg

We will get popup like this:

LSMW2_4.jpg

Click Ok.

Step 15: Create Idoc overview

LSMW2_5.jpg

After this step, idocs will be created which can be viewed in transaction WE05. I hope this might help who try to import the Business objects using Idoc method of LSMW. For illustration purposes i have combined partners and orders in few places. This is a guideline for LSMW Idoc input method.

Assigned Tags

      15 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Luís Pérez Grau
      Luís Pérez Grau

      Hi,

      Nice introducction. this Link I belive also will help a lot:

      http://help.sap.com/saphelp_nw04s/helpdata/en/87/f3ae74e68111d1b3ff006094b944c8/frameset.htm

      And I hope this too 😉

      http://scn.sap.com/thread/3341140

      http://scn.sap.com/message/14188308#14188308

      Mixing SXDA + LSMW is a cool stuff, once you get rid off the basics.

      Cheers!

      Luis

      Author's profile photo Former Member
      Former Member

      Hi Jothivenkatesh

      Very good posting.

      Also I was wondering if you could create a similarly detailed blog about ALE/IDoc mechnism? Especially I'm interested in delta load. Is there similar mechnism for ALE/IDoc to send data in a delta way like CRM middleware?

      Author's profile photo Jothivenkatesh M
      Jothivenkatesh M
      Blog Post Author

      Thanks. I will try and publish one in that front. CRM middleware always get involved atleast in terms of XIF Idoc processing. But if the Idoc is originating from CRM system middleware will take part in it.

      Regards,

      Venkat

      Author's profile photo Former Member
      Former Member

      Hi

      Decent post!

      Can you please also let me know the basic difference between XIF and crm middleware?

      eg. you can send data from ecc to crm both with crm middleware and XIF. With crm middleware, ecc will use QRFC to call crm_bapi_save in crm and send the bapimtcs structures. But i'm not familar with XIF. With XIF, how the ecc will send the data with idoc? and how crm will take and handle the data?

      Author's profile photo Jothivenkatesh M
      Jothivenkatesh M
      Blog Post Author

      Hi,

      Thanks. When the Bdoc got generated, in the scheduler, middleware decides whether there is a XIF site connected to the CRM system. If connected, then the data which is created in Bdoc, will be transferred on to the XIF related modules to get it carried to the connected system. Connected systems can be another CRM system itself or any other external systems.

      I am not sure of the fact where XIF is used to connect with ECC, because ECC will always be a R/3 site.

      Regards,

      Venkat

      Author's profile photo Former Member
      Former Member

      Hi Venkat

      It's really excellent post! Hope to see more XIF blogs or documents.

      Best Regards

      James

      Author's profile photo Jothivenkatesh M
      Jothivenkatesh M
      Blog Post Author

      Hi James,

      Thanks. I will try and share more information in that front.

      Regards,

      Venkat

      Author's profile photo Former Member
      Former Member

      Great post. Gave your 5 stars rating. Hope to see more XIF articles from you!

      Author's profile photo Jothivenkatesh M
      Jothivenkatesh M
      Blog Post Author

      Thanks Kelly. I will target more articles soon.

      Author's profile photo Former Member
      Former Member

      Terrific. XIF doc is so rare. Hope to see more.

      Author's profile photo Jothivenkatesh M
      Jothivenkatesh M
      Blog Post Author

      Thanks Juan. Will try to write more.

      Author's profile photo Former Member
      Former Member

      Just one question. In the beginning of your blog "Some times when the Master data are to be uploaded from a legacy system...", could you please let me know, what exactly 'legacy system' means? Can a CRM system be a legacy system? Or, is it that a legacy system has to be an ECC system?   

      Author's profile photo Luís Pérez Grau
      Luís Pérez Grau

      Hi Juan,

      Legacy system in this context means old system, an example, imagine your company has another CRM like Siebel and now they want to replace Siebel with SAP CRM, the legacy system will be Siebel.

      Cheers!

      Luis

      Author's profile photo Former Member
      Former Member

      Thanks. Very very helpful.

      Author's profile photo Jothivenkatesh M
      Jothivenkatesh M
      Blog Post Author

      Thanks Chris.