How to upload the product master data in CRM from excel file

[Former Member]

Hi Gurus,

I have to upload the product master data using excel file data into CRM system using XIF adapter inbound interface.

i have studied some of the documents and forum thread on the same topic.I have couple of doubts here which i am listing down below , please answer me.

1. Data mapping can be done by using LSMW that i understood but if i go for setting ---> idoc inbound processing in that screen i have to enter some of the required field like "file port", "partner type" and "partner number".

My question is when i am using a flat file in that case as a partner type and partner number what should i give??

2. is there any role here for data transfer workbench??

3. instead of application server, can i take the excel file data from presentation server??

4. I know LSMW and i have used it couple of time to upload the data in R3, assume i have created the a structure in lsmw and run a test upload after doing the mapping and conversion rule, but how will i relate/map it to crmxif adapter??

Thanks in Advance.

Regards,

Manoj Tiwari

[Former Member]

Hi,

just to be clear on the difference:

XIF = External systems interface: this is an adapter that was written to access CRM from an external system. You can either use XML or idoc for this. In the XML case, the data is directly mapped to a virtual inbound Bdoc which is processed in the standard CRM flows. In the Idoc case, the inbound XIF-idoc is processed with the XIF functions and mapped from there to the flow.

LSMW = migration workbench: a SAP-tool which has been around for some time to upload legacy data into a SAP system. It can use multiple filetypes to map data from a file to inbound idocs or processing functions. Eventually, this tool will be rendered obsolete by SAP XI, which at the moment already has far more possibilties.

1. The port/ partner type/ partner number/ partner profile / ... are part of the standard setup of inbound idocs. Take a look at the idoc information for this. It's pretty straightforward, use transaction WEDI as a starting point.

--> the flat file should be mapped to an idoc type, the partner type (...) definitions are there to handle the processing of these idocs.

3. I always convert an excel sheets to a txt-file and put them on the application server. It's the easiest, and this way you can run the upload in background.

Hope this helps,

Michael.

[Former Member]

Hi Michael,

Thanks for your reply.I am explaining you once again where exactly i am facing problem.

I am developing inbound interface using lsmw for product master upload in CRM system, In CRMXIF_Product_material_m01 idoc type the segments that needs to be map with Source structure are

E101COMXIF_PRODUCT_MATERIAL

E101COMXIF_PR_S_COMM_PR_MAT

E116COMXIF_PRODUCT_S_ADMIN

E101OMXIF_PRD_S_COMM_PR_MAT

E101MXIF_PRD_SX_COMM_PR_MAT

E101COMXIF_PR_S_CATEGORIES

E101COMXIF_PRODUCT_S_ADMIN

E101COMXIF_PRD_S_CATEGORIES

E101COMXIF_PR_S_SHORT_TEXT

E102COMXIF_PRODUCT_S_ADMIN

E101COMXIF_PRD_S_SHORT_TEXT

E101COMXIF_PR_S_UNIT

E103COMXIF_PRODUCT_S_ADMIN

E101MXIF_PRD_S_COMM_PR_UNIT

E101XIF_PRD_SX_COMM_PR_UNIT

Assume in my flat file i have only Product number, Unit of Measurement and Description .I am creating a flat source structure for these 3 fields in lsmw as a flat and simple source structure, How will i map this source structure to target structure which is very complex since it is all set of segments.

Thanks & Regards,

Manoj Tiwari

[Former Member]

Hi,

The typical point about using idocs for inbound processing is that it requires a lot of testing to get everything mapped correctly. It is not necessary to use all the idoc segments, but probably there are some mandatory & necessary fields to create/change the product.

Use the SAP Idoc type documentation to find the location of your fields in the segments, and use transaction WE19 to test the inbound idoc process. You can simply use the idoctype, fill the fields and try to process it. The idoc-errormessages will guide you through the missing data or incomplete setup.

Michael.

[Former Member]

Hi Michael,

Simply Great.

Thanks for your guidance.

Now i know what i have to do.

Thank you very much.

Regards,

Manoj Tiwari

[Former Member]

Hi Gurus,

Can someone please reply to my questions.

My special request to Stephen, Michael, Sousa, Bhusan, Tiest and Bhuvan.

Regards,

Manoj Tiwari