I recently got an enhancement which is for Catalog Options. We are working on SRM 5.0 System. I haven't dealt with CCM before and I would like to know the process for it.
I need to create a CSV file. I got a list of the fields like /CCM/ORDER_UNIT, /CCM/PRICE, /CCM/PRODUCT_GROUP and some others. I am told to get these fields out of table: MARA. I will be doing an extract from R/3. The material types used are: HAWA and NLAG and I'll be loading the deltas.
In addition to these fields, I also need a few where the values will be generated programatically. For example, there should be a PICTURE field where the value is a fixed URL, followed by the material ID, followed by a ".jpg" something like this: www.yahoo.com/pictures/xyzpdq.jpg
And the Category ID which will be of the form material ID followed by a "#" and a string that will be given by the Functional person, something like this: xyzpdq#ccsd06
Pleasee gurus, can anyone explain to me the process and how to go about doing it.
I will really appreciate it.
I'm not sure to really understand your request, but if you need more info on CCM CSV 2.0 file format, please have a look here:<a href="http://help.sap.com/saphelp_ccm20/helpdata/en/e1/eddebb4b63453cbf209027e0816b8c/content.htm">CCM CSV 2.0 file format</a>.
A point is that a standard function in the CCM 2.0 allows the upload of SRM products in CCM. You may have a look in this function (may be you can copy the standard program to get values from the R/3 system) which is described here <a href="http://help.sap.com/saphelp_ccm20/helpdata/en/a3/372a3f40bd4b8c9b127656db9ea23e/content.htm">Transfer Product Master Data to Catalog</a>.