Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2005 at 01:50 AM

    Hi Gurus,

    Can someone please reply to my questions.

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

    Regards,

    Manoj Tiwari

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2005 at 08:10 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.