ItemValuation lines CCM CSV are not uploaded

[Former Member]

Dear group,

I want to use a CSV 2.0 file to upload my master catalog.

The code is as follows:

SAP CATALOG CSV 2.0 <;> full

Defaults;NL

1. catalog import test Leon Hoeneveld

Model

1. Catalog ; CatalogID ; CatalogType ; Catalog Characteristic(s) ; Catalog short text(s)

Catalog;TEST3;01;

1. Schema ; SchemaID ; Schema characteristic(s) ; Schema short text(s)

TNO catalogus Schema;ZS01;Schema

1. Category ; CategoryID ; ParentCategoryID(opt) ; CategoryTypeID(opt) ; Category characteristic(s) ; Category short text(s)

Category;ADV;;;Adviseurs Content #Create Positions for the category ADV ItemValuation;CategoryID;/ccm/supplier_part_no;/ccm/amount;/ccm/currency_code;/ccm/order_unit;/ccm/short_description;/ccm/long_description;/ccm/product_group;

000001;ADV#ZS01;15842;100;EUR;H;Willy Schutte;specialist SRM;ADV;

---

But the item is not visible after upload. Am I doing something wrong???

[Former Member · Accepted solution]

Hi Leon,

I think that /CCM/Amount and /CCM/CURRENCY_CODE characteristic doesn't exist. They are sub_characteristic and they have to be reference Characteristic#sub_characteristic.

I hope this help you.

Regards

[Former Member · Accepted solution]

Jorge is right. The correct way to reference these is as follows:

/ccm/price[1]#/ccm/amount

/ccm/price[1]#/ccm/currency_code

The following characteristics might come in handy as well:

/ccm/supplier_name

/ccm/base_uom

/ccm/lead_time

[Former Member · Accepted solution]

I will reward you both 2 points, but my items still don't show up.

[Former Member · Accepted solution]

Mandatory fields are:

Item Valuation

CategoryID

Productgroep

Supplier number

Supplier name

Price

Currency

Unit of Measurement

Base Unit of Measurement

Short Description

Hmm I just noticed that you said you uploaded to the master catalog?

This is not possible only a schema can be uploaded. You have to upload your items to a supplier catalog and then map your items to the master.

Message was edited by:

Robin Janke

[Former Member · Accepted solution]

I've been trying to upload to a separate procurement catalog and not the master, because i thought this might be the problem. My code is now:

#Create Positions for the category ADV

ItemValuation;CategoryID;/CCM/PRODUCT_ID;/CCM/SUPPLIER_PART_NO;/CCM/PRICE[1]#/CCM/AMOUNT;/CCM/PRICE[1]#/CCM/CURRENCY_CODE;/CC/ORDER_UNIT;/CCM/SHORT_DESCRIPTION;/CCM/PRODUCT_GROUP;/CCM/BASE_UOM;/CCM/LEAD_TIME;/CCM/SUPPLIER_NAME;

000002;ADV#ZS01; ;15842;100;EUR;H;Willy Schutte;ADV;H;5;test;

I don't want to use a product_id. When I make an item manually only product_id or supplier part no (one should be filled) is mandatory and price is mandatory.

Regards, Léon

[Former Member · Accepted solution]

Again, this is not possible. You fill a procurement catalog from the master catalog with a mapping.

[Former Member · Accepted solution]

Succes! My items show up in a supplier catalog. Now I only have to solve the warning that SAP doesn't know the ISO code H (hours). Does anyone know where I can find a list of ISO-codes?

[Former Member · Accepted solution]

In transaction CUNI you can find a list of available ISO codes in your system. However I thought HUR was the correct ISO code for hour.

[Former Member · Accepted solution]

Thank you. I already found transaction CUNI with a search on SDN.

I rewarded you the full 10 points and marked the question as answered.

[Former Member]

Hi Leon,

Can you give the log information. Log in CCM and SLG1 message?

Thanks

Regards

[Former Member]

SLG1 says:

Uploading catalog TEST3

Name of file that was uploaded: C:\Documents and Settings\hoeneveldl\My Documents\export.csv

24.04.2007 17:43:27 (CET): Starting CSV import for catalog TEST3

24.04.2007 17:43:27 (CET): 0001 package(s) were processed OK

24.04.2007 17:43:27 (CET): Package 0001 received and saved

24.04.2007 17:43:50 (CET): processing of package 0001 started

24.04.2007 17:43:51 (CET): catalog header data updated

24.04.2007 17:43:52 (CET): categories updated; 1 updated/created; 0 deleted

24.04.2007 17:43:52 (CET): schemas updated; 1 updated/created; 0 deleted

24.04.2007 17:43:52 (CET): catalog model data updated

24.04.2007 17:43:52 (CET): Package 0001 was processed

24.04.2007 17:43:52 (CET): preparations were started for catalog activation

24.04.2007 17:43:53 (CET): preparation for catalog activation completed OK

24.04.2007 17:43:53 (CET): start catalog activation

24.04.2007 17:43:53 (CET): catalog activated OK

24.04.2007 17:43:53 (CET): Catalog was successfully updated; total duration 00:00:26

after wich an extra message comes:

24.04.2007 17:43:53 (CET):Catalog TEST3 (proces AI versie 1) deleted

These messages are similar in CCM