Product upload in CRM

[Former Member]

Hello,

I am doing data uploading of records from excel (*.csv) file for products in CRM. Could you please help me in finding which function module is best used for uploading of Basic data, General data, Sales and Distribution data, Conditions data. Is there only one or do I have to use more than one F.M for this requirement?

I have found one - CRMXIF_PRODUCT_MATERIAL_SAVE. But this requires a site to be created and partner profile to be maintained. But I assume this is required if we get data from ECC. But my requirement is from a file present on the presentation server. Please help. Also, let me know if we have created set types and it is visible in transaction COMMPR01, how do we upload data into it.

Thanks.

[pallavi_an]

Hi Himanshu,

I am new to CRM. I have same requirement as yours I.E. uploading product data from flat file to SAP CRM7.0. I have least knowledge on IDOC and BDOC. In our project we are using BODS tool for data transfer. We have created custom settypes. How can i proceed with the requirement. Please provide me steps to go ahead. I have to finalise the approach in 2 days. It will be great if you help me soon.

Thanks and Regards,

Pallavi

[Former Member]

Thank you

[Former Member]

Hi himanshu,

When I give various parameters it throws me an error...

T ID NUM MESSAGE

E COM_PRODUCT 004 No corresponding product found

What will be Status for creating a material.

Can you please tell me all the parameters which you have passed in BAPI....

Please suggest.

Regards.

Supriya

[Former Member]

Hi Himanshu,

I have successfully created products using-CRMXIF_PRODUCT_MATERIAL_SAVE and BAPI_TRANSACTION_COMMIT. But I am facing some issue in defaulting-Base Unit Of Measure.

I believe we need to fill the parameter-COMMON_MATERIAL of the structure-COMXIF_PRODUCT_MATERIAL.

But somehow its not working.

Can you please provide your inputs on this?

Thanks and Regards,

Rohit

[Former Member]

Hello Rohit,

There is a structure named unit. You would need to fill in the values in it.

For example:

wa_unit-data-unit = 'EA'.

wa_unit-data-numerator = '1'.

wa_unit-data-denominator = '1'.

append wa_unit to wa_data-unit.

And in common_material you will need to pass base unit of measure.

wa_material-data-base_uom = 'EA'.

Regards,

Himanshu Bhandari

[Former Member]

Hello Supriya,

The best way to check if your mapping is correct, is to do one entry and run it, if it is successful.

Also, when you create a product, it is by default in Active status. If yo want to make it Locked, you should pass the following values.

For example.

wa_status-data-status = 'I1103'. "Locked

wa_status-data-active = 'X'.

append wa_status to wa_data-status.

Regards,

Himanshu Bhandari

[Former Member]

Hi Himanshu,

Thanks for the inputs. I tried your methods, but I am getting following errors:-

RRF123 : Data may not be changed for set COMM_PR_UNIT

RRF123 : Enter a base unit of measure

Validation error occurred: Module COM_PRODUCT_MAT_VALIDATE, BDoc type PRODUCT_MAT.

Error status 'A' calling validation service

I am not able to create the product. Can you please provide your inputs if you have any idea why there errors are coming. One thing I oberved was-Previously when I was creating the product without defaulting base unit of measure, it was being created properly, but after creation, Base Unit of measure field was coming as disabled. What I mean to say is after creating the product, i was not allowed to enter base unit of measure.

Thanks and Regards,

Rohit

[Former Member]

Hi Himanshu,

Thanks for replying.

Some of the parametrs I have filled and Return Sucess.I am checking one by one.

Now I want to enter velow data also:

1. Relationships data: Original product and Cross Selling.

2. Atributes and set type that are assigned to product.

But not able to finf those parametrs where I can fill the same.

Regards.

Supriya.

[Former Member]

Hello Rohit,

For the error which you are getting, you would have to create a implementation for BADI COMXIF_PROD_MAT_MAP. There write the following piece of code in te method MAP_FROM.

loop at cs_product_int-data-comm_pr_unit into wa.

wa-data-is_base_unit = 'X'.

wa-data-comm_pr_unit = 'X'.

modify cs_product_int-data-comm_pr_unit from wa.

endloop.

Regards,

Himanshu

[Former Member]

Hello Supriya,

For the attributes and set types which are custom created use the CUSTOMER_SET_DATA structure.

Example:

wa_cust_set-settyp_id = 'ZHIGHLVLPROD'.

wa_cust_set-s_admin-task = 'I'.

wa_cust_set-s_admin-logsys = lv_logsys.

wa_attributes-attr_id = 'ZCRM_COMP_TYPE'.

wa_attributes-value = 'PM'.

append wa_attributes to wa_cust_set-attributes.

append wa_cust_set to wa_data-customer_set_data.

Regards,

Himanshu

[jothivenkatesh_m]

Hi,

I have looked into your query.

Kindly take a look at the below link which will explain the settings of XIF exchange scenarios in terms of Inbound. When you are sending the data from CRM system, then only site will be relevant for the fact that you are going to send the data to other

system.

But since Inbound comprises of the fact that either the data can be sent from an external system or by external files. So in your case you can register inbound parameters for your CRM system and use LSMW tool to extract data into CRM system using the files you are having with you.

The Idoc settings link is as follows:

[Idoc Settings|https://wiki.sdn.sap.com/wiki/display/HOME/BasicDataexchangesetupforALE+IDocs]

LSMW tool information is as follows:

[LSMW tool Info|http://help.sap.com/erp2005_ehp_03/helpdata/EN/4d/455035082e2271e10000009b38f889/frameset.htm]

I hope this helps.

Regards,

Venkat

[Former Member]

Hello Venkat,

Thank you very much for the information.

I have one more query regarding uploading data into CRM products. I want to upload data into conditions tab. Does it have a settype associated with it, and if yes could you tell me what it is. Or do I have to call a BADI and migrate data for conditions tab.

[Former Member]

Hello Himanshu,

Conditions do not have any set-type associated with it,data directly gets updated in condition tables.

In order to populate the condition data,you need to call the BADI.

Hope this helps!

Regards,

Shanthala Kudva.

[Former Member]

Hello Himanshu,

have you solve your problem.

We have also the same query how to upload Product attribute in transation COMMPR01.

please help and suggest..

Regards.

[Former Member]

Hi ,

You want to upload data from ECC or Directly you want to upload data in CRM system ??

Regds,

Sunil Nair

[Former Member]

Hi,

We have data in EXCEL Sheet and directly want to upload in CRM system. So how can I do the same.BDC of T-Code 'COMMPR01' not posssible. So what can be another way!

Please suggest!

Edited by: Supriya Bhatt on Jul 8, 2009 6:09 AM

[Former Member]

Please suggest.

How can I do the same.

[Former Member]

Hi ,

It is basically depend on your business requirement .I dont have details of your scenario.I would suggest write BDC/Program and Upload .

Regds,

Sunil Nair

[Former Member]

Hi,

When I record BDC it fails after first screen

Suggest other way!

[Former Member]

Hello,

I have successfully done the product upload of basic materials, custom settypes and conditions in COMMPR01. For the basic materials and custom settypes, use function module CRMXIF_PRODUCT_MATERIAL_SAVE and BAPI_TRANSACTION_COMMIT. The idea is to map your excel data into the bapi structures. Try to fill in Category, Short Description, Unit, Common material, Distr Chian, Status and for custom settypes Customer Set data. I would suggest try to fill one by one and test.

Regards,

Himanshu Bhandari