How to change an existing line item in CCM catalog using CSV file?

[Former Member]

Dear All,

We are using SRM5.0 and CCM 2.0

We have uploaded the material and service master to CCM as supplier catalog from R/3.

The initial Upload was doen successfully.

My query is how to reflect the delta changes in CCM happening in R/3?

If I can generate a CSV file with all those items wich has been changed (Changes can be in description, Plant, status etc) and upload the same file in CCM, will it update the existing line in CCM or create a new line item?

How do i update an existing line item in CCM catalog using a CSV file?

Thanks

Abhishek

[Former Member]

Hi,

you may not need this but just an additional info.

You can also go via EBP to upload products from R/3.

download products from R/3 to EBP with R3AS txn.

schedule delta download from R/3 to EBP.with R3AR4

use report BBP_CCM_TRANSFER_CATALOG

this report generates SRM_EXTRACTED_CATALOG

the report BBP_CCM_TRANSFER_CATALOG has a update facilty.

But this may be a longer route to you comparitively your current process.

Alternatively there is a standard chargeble add on available from SAP for CSV creation from R/3 called as CATEXPORT.

BR

Dinesh

[former_member544585]

Abhishek: to update an existing catalog item, all you need to do is to include the same ItemValuation (Item ID) in your update csv file. The Item ID is always in the first column of your csv file.

For example, if this was your original file...

ItemValuation;Category ID;/CCM/SHORT_DESCRIPTION 00001;14111500;Product 1 00002;14111500;Product 2 ...then the update for Product 2 will look like this: ItemValuation;Category ID;/CCM/SHORT_DESCRIPTION

00002;14111500;Product 2 - updated text

Cheers,

Serguei

[Former Member]

Hi

I think this CSV file will create new entreies instaed of updating the old ones.

Are you using the program

/CCM/FILE_UPLOAD to accomplish the job ?

Regards

- Atul

[Former Member]

Hi Atul,

I am using CCM 2.0 and SRM 5.0 (EBP5.5).

We are not using XI, so i guess we cant use the program "/ccm/file_upload".

we have migrated the product master data from R/3.

We have developed a report which takes product category as input and gives out flat file in csv format containg all the items in that prod category.

Then we upload the file in CCM by logging thro the brpwser.

Similarly, i can develop another program which will give me a CSV file foll all those items changed in R/3 in a day.

Then we can upload that file in CCM.

But i have doubt if it will update the existing items in catalog.

Hope I could make myself clear.

Thanks

Abhishek

[Former Member]

Hi

Which program you are using to update the CCM Catalogs ?

Is it this program ->

/CCM/CL_RULE_MNGR=============CP

Please elaborate with the details.

Your system configuartion + versions.

Regards

- Atul