1st version: 03/05/2018
1st revision: 06/12/2018
2nd revision: 17/05/2019

Objective and scope

This OP will guide you to create E-catalog for both MDM and Punch-out e-catalog. For MDM e-catalog, you can see how to upload items in MDM import manager program until you select items in SRM7.
What you will need for creating or modifying e-catalog is Microsoft excel, MDM Data Manager, MEM Import Manager, SAP- BQ2 and SAP BP2.

Concept of E-catalog

There are 2 types of E-catalog which are MDM and Punch-out. MDM is e-catalog that you have to create items to select in SRM7. Punch-out, however, is e-catalog that vendor already has it own website (e.g. office supplies) which means once you create contract header; you can generate web service in BQ2/BP2

How to set up server

For the person who never uses MDM data manager before, you will need to set up server for MDM Data manager to access the program to do the creation or modification

MDM Data Manager

1 Data Operations > APAC - E-catalog creation and modification > worddavc492aac888092b868a9fa33267c00217.png

#	Main activities	Tips/Best practices	Key points
1	Open MDM Data manager and click

5432 Data Operations > APAC - E-catalog creation and modification > worddav2d51ee09c8ab79c26dce0b4980ae795b.png

#	Main activities	Tips/Best practices	Key points
2	Insert "mp3sapr3.ibm.be.solvay.com" in 'MDM Server' field	Recommended to type
3	Click
4	Click and select "ECATDATA_M" in 'Repository' field
5	Click

9876 Data Operations > APAC - E-catalog creation and modification > worddavc50b13a73e4736539bb842602f25f1a6.png

#	Main activities	Tips/Best practices	Key points
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="31ab38e4-84c9-422e-b892-ce2836a6f272"><ac:plain-text-body><![CDATA[	6	Click !worddavd681854c4d2639866ada8ff672952efa.png	height=27,width=28! to select "English [US]" in 'Language' field	]]></ac:plain-text-body></ac:structured-macro>
7	Insert "BO_APAC" in 'User' field
8	Insert password in 'Password' field	Please ask you team members
9	Click	If you can see the screenshot below, it means you can access to MDM data manager

MDM Data console

21 Data Operations > APAC - E-catalog creation and modification > worddav2392921c38ef3036d4a7d31b0aa95560.png

#	Main activities	Tips/Best practices	Key points
1	Open MDM Data console and click right on "SAP MDM Servers"
2	Click "Mount MDM Server"

43 Data Operations > APAC - E-catalog creation and modification > worddav087623ee4db0f7e3c3679da06c7c650a.png

#	Main activities	Tips/Best practices	Key points
3	Insert "mp3sapr3.ibm.be.solvay.com" in 'MDM Server' field
4	Click

765 Data Operations > APAC - E-catalog creation and modification > worddav55f05565821a71afe8395d7ee813b429.png

#	Main activities	Tips/Best practices	Key points
5	Click to expand 'mp3sapr3.ibm.be.solvay.com'
6	Click right on "ECATDATA_M"
7	Select "Connect to Repository"

1098 Data Operations > APAC - E-catalog creation and modification > worddavc86a3dd64925573cbd741d7f680c53e5.png

#	Main activities	Tips/Best practices	Key points
8	Insert "BO_APAC" in 'User' field
9	Insert password 'Password' field	Please ask your team members
10	Click

1211 Data Operations > APAC - E-catalog creation and modification > worddav957a65e72350aa46a804bd510b57cf8f.png

#	Main activities	Tips/Best practices	Key points
11	Click right on "SAP MDM Servers"
12	Click "Mount MDM Server"

1413 Data Operations > APAC - E-catalog creation and modification > worddave4da6a57d47736c55fc45d57e76646bd.png

#	Main activities	Tips/Best practices	Key points
13	Insert "mp4sapr3.ibm.be.solvay.com" in 'MDM Server' field
14	Click

171615 Data Operations > APAC - E-catalog creation and modification > worddavb30438bbb6dccea07a0fd2e91ef709ce.png

#	Main activities	Tips/Best practices	Key points
15	Click to expand 'mp3sapr3.ibm.be.solvay.com'
16	Click right on "ECATDATA_M"
17	Select "Connect to Repository"

201918 Data Operations > APAC - E-catalog creation and modification > worddavc86a3dd64925573cbd741d7f680c53e5.png

#	Main activities	Tips/Best practices	Key points
18	Insert "BO_APAC" in 'User' field
19	Insert "a123456" in 'Password' field
20	Click

How to check existing information in MDM data manager

Before you upload the template you will need to check data in MDM whether it is already maintained in MDM or not. If yes, you can con
66 Data Operations > APAC - E-catalog creation and modification > worddav1f9a9c6be429947d277988ea7b1eaa51.png

#	Main activities	Tips/Best practices	Key points
6	Click

Check contract number

Contract number means contract header number that you create in SAP
1 Data Operations > APAC - E-catalog creation and modification > worddavc43f7b9818a3a32d917f4f28c7d2456a.png

#	Main activities	Tips/Best practices	Key points
1	Double click on to open the program		Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

46523 Data Operations > APAC - E-catalog creation and modification > worddav5cf4fe5dcfc5b2b5c0628bb16a83d802.png

#	Main activities	Tips/Best practices	Key points
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="623442b0-effc-437c-8444-d6f8a3d6bdaa"><ac:plain-text-body><![CDATA[	2	Select "ECATDATA_M [mp3sapr3.ibm.be.solvay.cpm] in 'Repository' field		]]></ac:plain-text-body></ac:structured-macro>
3	Insert "BO_APAC" in 'User' field
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="61350eaa-d106-4a74-a48d-e5f0e98034e6"><ac:plain-text-body><![CDATA[	4	Select "English [US]" in 'Language' field		]]></ac:plain-text-body></ac:structured-macro>
5	Insert password in 'Password' field	Please ask you team for password
6	Click

87 Data Operations > APAC - E-catalog creation and modification > worddav1f9a9c6be429947d277988ea7b1eaa51.png

#	Main activities	Tips/Best practices	Key points
7	Click
8	Select "Contract price"

9 Data Operations > APAC - E-catalog creation and modification > worddav280a7af7add2c0fe75bdf84457101d67.png

#	Main activities	Tips/Best practices	Key points
9	Insert contract number in 'Contract' field	If you can see contract number in 'Records' section, it means contract number is created in MDM If you see black in records section, you need to create contract in MDM

Check vendor number

Once you finish checking contract number, you can check vendor code
21 Data Operations > APAC - E-catalog creation and modification > worddav0f200bfed6a71f8250fd81d5898f0ace.png

#	Main activities	Tips/Best practices	Key points
1	Click
2	Select "Suppliers"

3 Data Operations > APAC - E-catalog creation and modification > worddav2614253b648e445d61b76caf3f2de706.png

#	Main activities	Tips/Best practices	Key points
3	Click "Free-from Search"

4 Data Operations > APAC - E-catalog creation and modification > worddav4d98ebed57c8c9ee57b82938465ac74f.png

#	Main activities	Tips/Best practices	Key points
4	Insert vendor code in 'Supplier ID' field	If you can see contract number in 'Records' section, it means contract number is created in MDM If you see black in records section, you need to create vendor code in MDM

Check E-catalog ID

1
2 Data Operations > APAC - E-catalog creation and modification > worddav70153bd030d90277cfa0b74eca4390b0.png

#	Main activities	Tips/Best practices	Key points
1	Click
2	Select "Categories"

3 Data Operations > APAC - E-catalog creation and modification > worddav3f90928ad8b1b3c14dd1a37fc7cee758.png

#	Main activities	Tips/Best practices	Key points
3	Insert catalog ID in 'Catalog ID' field	If you can see contract number in 'Records' section, it means E-catalog ID is created in MDM If you see black in records section, you need to E-catalog ID in MDM

MDM E-catalog creation

E-catalog Creation in MDM Data manager

Contract number creation

You will need to create contract number if you create new contract in SAP
1 Data Operations > APAC - E-catalog creation and modification > worddavc43f7b9818a3a32d917f4f28c7d2456a.png

#	Main activities	Tips/Best practices	Key points
1	Double click on to open the program		Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

46523 Data Operations > APAC - E-catalog creation and modification > worddav5cf4fe5dcfc5b2b5c0628bb16a83d802.png

#	Main activities	Tips/Best practices	Key points
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="781c5bb2-4289-4cd9-b43e-b805e3b9950e"><ac:plain-text-body><![CDATA[	2	Select "ECATDATA_M [mp3sapr3.ibm.be.solvay.cpm] in 'Repository' field		]]></ac:plain-text-body></ac:structured-macro>
3	Insert "BO_APAC" in 'User' field
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="b01d7230-bf02-4dfd-9bc0-7b062f05acd7"><ac:plain-text-body><![CDATA[	4	Select "English [US]" in 'Language' field		]]></ac:plain-text-body></ac:structured-macro>
5	Insert password in 'Password' field	Please ask you team for password
6	Click

9 Data Operations > APAC - E-catalog creation and modification > worddav96a8b980336823de8eb51653a5c418de.png 1078

#	Main activities	Tips/Best practices	Key points
7	Click
8	Select "Contract Price"
9	Click right on your mouse at the existing line and select "Add"
10	Insert contract number you created in SAP in 'Contract' field	Please be careful in this step because you may overwrite the existing contract price, Make sure that you insert contract number in blank field

Vendor code creation

You need to create if you are not able to find vendor code in MDM Data Manager. If can, please skip this topic.
7564321 Data Operations > APAC - E-catalog creation and modification > worddav96a8b980336823de8eb51653a5c418de.png

#	Main activities	Tips/Best practices	Key points
1	Click
2	Select "Suppliers"
3	Click right on your mouse at the existing line and select "Add"
4	Insert vendor's name from SAP	Please be careful in this step because you may overwrite the existing vendor, Make sure that you insert vendor information in blank field
5	Insert vendor's code	It must be 10 digits, if vendor's code is less than 10 digits, you can add 0 in front of vendor's code e.g. 0000123456
6	Insert DUNS code
7	Double click on line 'Remote keys' field	If you cannot click this field, please click at somewhere for program to upload first

9108 Data Operations > APAC - E-catalog creation and modification > worddav479c261c962c0a407e149c8b441c17af.png

#	Main activities	Tips/Best practices	Key points
8	Click and select target system of vendor		ERP = PF1 RCS = WP1
9	Insert vendor's name and vendor's code in 'Key' field	The format of this field is vendor's name, 10 digits of vendor code e.g. OFFICEMAX AUSTRALIA LTD, 0302315832
10	Click

E-catalog ID creation

You need to create if you are not able to find E-catalog name in MDM Data Manager. If can, please skip this topic.
4321 Data Operations > APAC - E-catalog creation and modification > worddav748c92643b803ea2383a21553978f5af.png

#	Main activities	Tips/Best practices	Key points
1	Click
2	Select "Catalogs"
3	Click right on your mouse at the existing line and select "Add"
4	Insert catalog name in Catalog ID' field	The format of catalog ID must be 2 letters of region – 2 letter of country – vendor's name or code e.g. AP-CN-ISP-08 or AP-TH-BANFAIFA	The new catalog ID will be added in the last line

Dummy line creation (optional)

You may need to create a dummy line to make sure that when you upload your new E-catalog will be there in MDM. This process is optional. You can skip this section.
21 Data Operations > APAC - E-catalog creation and modification > worddav69afc695a0f7dac379a6d8aa0eba74b3.png

#	Main activities	Tips/Best practices	Key points
1	Click
2	Select "Catalog Items"

3 Data Operations > APAC - E-catalog creation and modification > worddav3a53cf49cc636772b565640b5375dd0d.png

#	Main activities	Tips/Best practices	Key points
3	Click right on your mouse and select "Add"

6547 Data Operations > APAC - E-catalog creation and modification > worddav78178bec6a7635fe0ca585e3e02377f2.png

#	Main activities	Tips/Best practices	Key points
4	Select region
5	Select supplier catalog name
6	Select supplier (vendor)
7	Click on somewhere outside 'Record detail' tab	The new catalog will be appeared at the last line	You need to delete this line when you finish upload the actual items in this catalog

Template preparation

12 Data Operations > APAC - E-catalog creation and modification > worddav07969cf5639f26bd0a206beb240c536a.png

#	Main activities	Tips/Best practices	Key points
1	Open 'Excel' and click "Data"
2	Click

43 Data Operations > APAC - E-catalog creation and modification > worddav8704eafffa8f8ca8b09cdde2fbad8e56.png

#	Main activities	Tips/Best practices	Key points
3	Select the file		You can download from here
4	Click to import template to excel

65 Data Operations > APAC - E-catalog creation and modification > worddav8d1e6e67bd87270418c9f19fb9d97eab.png

#	Main activities	Tips/Best practices	Key points
5	Select "Delimited"
6	Click

87 Data Operations > APAC - E-catalog creation and modification > worddav8704c2dd798010368523256ba052d967.png

#	Main activities	Tips/Best practices	Key points
7	Put tick mark on "Tab"
8	Click

11109 Data Operations > APAC - E-catalog creation and modification > worddavfc14fa9fe64c3dc3505bd6edf28b919d.png

#	Main activities	Tips/Best practices	Key points
9	Select "Text" in 'Column data format'
10	Click on "Region"
11	Slide to the right until end

1312 Data Operations > APAC - E-catalog creation and modification > worddav0a2f022b994e413c92c8b85058b33ca5.png

#	Main activities	Tips/Best practices	Key points
12	Press "Ctrl + Shift" and click on "Category"
13	Click

161514 Data Operations > APAC - E-catalog creation and modification > worddav98fa0b259bf1e63634344ae29887cad1.png

#	Main activities	Tips/Best practices	Key points
14	Select "Existing worksheet"
15	Insert "=$A$1"
16	Click

17 Data Operations > APAC - E-catalog creation and modification > worddava3b2da8f1a3245578d6f46f4fe74aa47.png

#	Main activities	Tips/Best practices	Key points
17	Copy details from the templated requester provided to the official template Please see details below	The default template will help to reduce error while you are uploading to MDM For short and long description, you are recommended to use formula "Clean" to clean hidden enter line	If you find something not right in here, please contact requester

How to input data in the official template
All data must meet the below criteria in 26 fields (column) in order to be loaded in MDM. they are divided in 3 types:

Mandatory (A defined value must be filled in)
Fixed (Filled value restricted)
Optional (You can have <NULL> values)

Col.	Field/Column	Description	Example
A	Region	Code of the region in MDM (Region-Country)	AP-CN
B	Supplier Catalog Name	The catalog Name in MDM	AP-CN-ISP-08, AP-TH-BANFAIFA
C	Supplier	Name and Vendor code (10 digits) of the Vendor as defined in MDM. (Name, xxxxxxxxxx)	ZHENJIANG WASTE DISPOSAL CO.,LTD, 0000098469
D	Supplier Part Number	Vendor material/item code. Cannot be duplicated in same catalog ID	Item001
E	Supplier Item Status	Fixed (Active/Inactive)	Active
F	External Manufacturer	External Manufacturer
G	Manufacturer Part Number	Manufacturer Part Number
H	Service Item	If it is a Service Item or not (X/FALSE)	FALSE
I	Freight included	Freight included (TRUE/FALSE) Normally set to be TRUE	TRUE
J	Delivery Time in Days	Number of days for the delivery	14
K	Minimum Quantity	If there is a minimum quantity for the PO. Normally 1	1
L	Conditioning	Fixed to 1	1
M	Unit of Measure	Unit of Measure from MDM Table (Full Text)	Piece, Meter, Kilovolt, etc.
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="67cb783b-2760-4274-927a-1b0153a2687e"><ac:plain-text-body><![CDATA[	N	Contract Price [Contract ID]	Number of the contract in PF1/WP1	4700000341	]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="fbd544b2-2de7-488b-b2c7-ff4d3296932d"><ac:plain-text-body><![CDATA[	O	Amount <Contract Price> [Qual]	Price of the Item (with dot as decimal separator)	79.31	]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="6baa291e-a811-423b-8050-adde6190a59c"><ac:plain-text-body><![CDATA[	P	Contract Item ID <Contract Price> [Qual]	Contract line item number (can be different if different Product Categories or Tax codes exist)	10, 20, 30,…..etc.	]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="df655b21-20f8-414d-aec9-7a789b9c586c"><ac:plain-text-body><![CDATA[	Q	Lower bound <Contract Price> [Qual]	Fixed to 1	1	]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="bf70dd3a-f055-4c30-85a0-0a4d3ce39c98"><ac:plain-text-body><![CDATA[	R	Price Base Quantity <Contract Price> [Qual]	The number of items for the given price	1	]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="e1c5c8fe-172f-4ecf-8775-2b21e0c47d8d"><ac:plain-text-body><![CDATA[	S	Currency <Contract Price> [Qual]	Currency from MDM Table (Full Text)	Chinese Renminbi	]]></ac:plain-text-body></ac:structured-macro>
T	Short Description	Text for Short Description	01NET - PRINT EXCEPT BELGI
U	Product ID/Material	If exists must be in accordance with items code in RCS. Maintained as 18 digits format	000000000001751750
V	Long Description	Text for Long Description
W	Comments
X	Validity date	The date from which the catalog is valid. Must be <= Today. Text format (DDMMYYYY)	10012014
Y	Expiration date	Expiration date of the catalog. Must be > Today. Text format (DDMMYYYY)	31122020
Z	Category	Name and Material Group form WP1 as defined in MDM.	LABELS, 0505

18
19 Data Operations > APAC - E-catalog creation and modification > worddav2530b4982550e553b45a77d6f76830ab.png

#	Main activities	Tips/Best practices	Key points
18	Click "File"
19	Select "Save As"

23222120 Data Operations > APAC - E-catalog creation and modification > worddav86afe66fcbaf583b73e00524171f713f.png

#	Main activities	Tips/Best practices	Key points
20	Select location to save the file
21	Insert name in 'File name:' field
22	Select "Unicode Text" in 'Save as type'	Before you save as Unitcode Text, you can save it as excel in case you need to change something
23	Click

Template uploading in MDM Import Manager

1 Data Operations > APAC - E-catalog creation and modification > worddavc43f7b9818a3a32d917f4f28c7d2456a.png

#	Main activities	Tips/Best practices	Key points
1	Double click on to open the program

432 Data Operations > APAC - E-catalog creation and modification > worddavf7e7a06994467df4d0c6d31e7c2348fb.png

#	Main activities	Tips/Best practices	Key points
2	Insert "BO_APAC" in 'User' field
3	Insert password in 'Password' field	Please ask this password from your team members
4	Click	Do not click "Enter" on keyboard, otherwise you will skip a part of uploading file to MDM

765 Data Operations > APAC - E-catalog creation and modification > worddave2e7f880dbd319a72ec200a985928b6c.png

#	Main activities	Tips/Best practices	Key points
5	Click and select "Delimited Text" in 'Type' field
6	Click and select "MDM" in 'Remote System' field
7	Click in 'File Name' field

99 Data Operations > APAC - E-catalog creation and modification > worddav5e9e533db675c4a430f70281f1c4dd68.png

#	Main activities	Tips/Best practices	Key points
8	Select the template you prepared
9	Click

1110 Data Operations > APAC - E-catalog creation and modification > worddave2e7f880dbd319a72ec200a985928b6c.png

#	Main activities	Tips/Best practices	Key points
10	Insert "\t" in 'Delimiter' field
11	Click

12 Data Operations > APAC - E-catalog creation and modification > worddav8348d04debf4436f8cf35c2bb7029542.png

#	Main activities	Tips/Best practices	Key points
12	Click

1413 Data Operations > APAC - E-catalog creation and modification > worddavd2990055090df75dd34bf3ecdfd6c659.png

#	Main activities	Tips/Best practices	Key points
13	Select "Map txt DJO"
14	Click

17b17a171615 Data Operations > APAC - E-catalog creation and modification > worddav2db8fe9ae756a2d77122699ed70aef9d.png

#	Main activities	Tips/Best practices	Key points
15	Wait until all points in 'Source Hierarchy' are bold
16	Click "Map/Field /Values" tab
17	Click line by line in field map from line 2 – line 27	Check the message at the bottom right corner If you see (X of X values converted), you can click to the next line If you see (Y of X values mapped), you click (#17a) For new E-catalog, you may need to added some lines by clicking (#17b)

19a1918 Data Operations > APAC - E-catalog creation and modification > worddav188379fa44ff5f4871b4ab7bfffcb8ff.png

#	Main activities	Tips/Best practices
18	Click "Match Recodes " tab
19	Select "Create" in the first line	If the status is something else, you can click (#19a) to change

232120 Data Operations > APAC - E-catalog creation and modification > worddave81f46710524dbddd35d8be930c1be5b.png
22

#	Main activities	Tips/Best practices	Key points
20	Click "Import Status" tab
21	Check 'Action Items' It must be "Ready to import"	You may find other statuses which mean your data is not fully mapped so you need to go back to "Map Fields/Values" tab to check which field is not mapped
22	Scroll down and check "Impart Actions" Number of source Records in "Create" must be the number of items to upload
23	Click to import

254
24 Data Operations > APAC - E-catalog creation and modification > worddav31029a2a879247ee5060d1cd526896c5.png

#	Main activities	Tips/Best practices	Key points
24	Click	This means that items have been imported
25	Click to close the program

26 Data Operations > APAC - E-catalog creation and modification > worddav21cd16fde118016768ab8d4f5fdaaecb.png

#	Main activities	Tips/Best practices	Key points
26	Click	Always click "NO"

27 Data Operations > APAC - E-catalog creation and modification > worddavd40d727b652faa33226690549aa34701.png

#	Main activities	Tips/Best practices	Key points
24	Click	Always click "NO"

Named search setting

Name search is set when you finish upload the template to MDM import manager.
1 Data Operations > APAC - E-catalog creation and modification > worddavc43f7b9818a3a32d917f4f28c7d2456a.png

#	Main activities	Tips/Best practices	Key points
1	Double click on to open the program		Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

65432 Data Operations > APAC - E-catalog creation and modification > worddav5cf4fe5dcfc5b2b5c0628bb16a83d802.png

#	Main activities	Tips/Best practices	Key points
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="638902f9-b610-4d7c-ad0b-10f5e032a73c"><ac:plain-text-body><![CDATA[	2	Select "ECATDATA_M [mp3sapr3.ibm.be.solvay.cpm] in 'Repository' field		]]></ac:plain-text-body></ac:structured-macro>
3	Insert "BO_APAC" in 'User' field
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="f8839e88-13cb-412d-8a04-d09687cfdf8e"><ac:plain-text-body><![CDATA[	4	Select "English [US]" in 'Language' field		]]></ac:plain-text-body></ac:structured-macro>
5	Insert password in 'Password' field	You can ask password from your team member
6	Click

7
98 Data Operations > APAC - E-catalog creation and modification > worddavcc8a814f4bfa7518d6dfaf17df099dac.png

#	Main activities	Tips/Best practices	Key points
7	Click
8	Select "Named Searches"
	Click right on your mouse on the existing name and select "Add"

111210 Data Operations > APAC - E-catalog creation and modification > worddavbe136a2a8b8a47eb2cb4ecc7b6920539.png

#	Main activities	Tips/Best practices	Key points
10	Inset E-catalog ID in 'Name' field
11	Inset E-catalog ID without '-' in 'Code' field
12	Select "Catalog Items' in 'Main Table' field

1716151413 Data Operations > APAC - E-catalog creation and modification > worddav167a8258fdd6e73b941c2b8a44a8e080.png

#	Main activities	Tips/Best practices	Key points
13	Click
14	Select "Catalog Items"
15	Click "Search"
16	Select "Save as Named Search"
17	Selected "More…"

1918 Data Operations > APAC - E-catalog creation and modification > worddav5643e1d4cb0b03fbe7dc0d0822691ff5.png

#	Main activities	Tips/Best practices	Key points
18	Click E-catalog ID you want to set named search
19	Click

2120 Data Operations > APAC - E-catalog creation and modification > worddavec2a02de1bc7f3ff7b3cfa1ff50764da.png

#	Main activities	Tips/Best practices	Key points
20	Click "Named Searches" in Search Parameters
21	Click on the named search you just saved, you will see all items of catalog you just uploaded

Web services generating

Web services are created when you create E-catalog name in MDM Data Manager.
11a Data Operations > APAC - E-catalog creation and modification > worddav5c417a0112a99ca090a5f9c833fc3521.png

#	Main activities	Tips/Best practices	Key points
1	Double click on	If you are doing on production system, double click on (#1a) You are recommend to do it on BQ2 (Quality system) to test E-catalog in simulation system If everything is ok, you can copy this steps in BP2

2 Data Operations > APAC - E-catalog creation and modification > worddavde23f9068a780d19e35f92e16ba71c31.png

#	Main activities	Tips/Best practices	Key points
2	Click on your username

3 Data Operations > APAC - E-catalog creation and modification > worddavc537b7178530dd78fd70929fbfc13e02.png

#	Main activities	Tips/Best practices	Key points
3	Inset T-code "spro" and press "Enter" on your keyboard

4 Data Operations > APAC - E-catalog creation and modification > worddav69106473e190f92382caccfb03d80857.png

#	Main activities	Tips/Best practices	Key points
4	Click

98765 Data Operations > APAC - E-catalog creation and modification > worddavf04ecc92673975ede952d2970df698fb.png

#	Main activities	Tips/Best practices	Key points
5	Click on "SAP Supplier Relationship Management"
6	Click on "SRM Server"
7	Click on "Master Data"
8	Click on "Content Management"
9	Click "Defined External Web Services"

1110 Data Operations > APAC - E-catalog creation and modification > worddava4926da879dadaaea01a60e6ee9ad24b.png

#	Main activities	Tips/Best practices	Key points
10	Click on any line to select the whole line	If you are doing on Punch-out, please click on "_OFFICEMATE_TH" as the reference
11	Click to copy the selected line as reference

17a171615141312 Data Operations > APAC - E-catalog creation and modification > worddavb03b22be3d32dc7199da1d1c8fb8c2fe.png

#	Main activities	Tips/Best practices	Key points
12	Insert code you created in name search in 'Web Service ID' field	If you are doing on Punch-out, please insert web service ID as '' + Vendor name + '' + Country code e.g. _OFFICEMAX_AU
13	Insert description of E-catalog in 'Description' field	For MDM, you can insert region + country + vendor name e.g. AP IN NALCO WATER If you are doing on Punch-out, please insert description as Vendor name + product of catalog e.g. OFFICEMAX AUSTRALIA Office supplies
14	Select "Product Catalog" in 'Bus.Type of a WebService' field and press "Enter" on keyboard
15	Put a tick mark on "Do not Check Product"
16	Put a tick mark on "Display Product Data Again in Catalog"
17	Put a tick mark on "Validate Product Data from SAP Enterprise Buyer" and press "Enter" on keyboard	If you are doing for PF1, insert "PF1_020" in 'Logical system' field (17a) The system will pop up the message below, press "Enter" again

18 Data Operations > APAC - E-catalog creation and modification > worddavec27f6cb97ff8b3a060c5a402d1ffbfc.png

#	Main activities	Tips/Best practices	Key points
18	Click

19 Data Operations > APAC - E-catalog creation and modification > worddavcd3fdaee856f5366149a2f17ed8d84de.png

#	Main activities	Tips/Best practices	Key points
19	Press "Enter" on keyboard until the system copies all entries	Press enter until you see this window

20 Data Operations > APAC - E-catalog creation and modification > worddavca72a536585237707171840d2ce85370.png

#	Main activities	Tips/Best practices	Key points
20	Click

2120 Data Operations > APAC - E-catalog creation and modification > worddav14675523967b23facf66696d47582526.png

#	Main activities	Tips/Best practices	Key points
20	Click on the web services you just created
21	Double click on "Standard Call Structure"

2322a22a22a22 Data Operations > APAC - E-catalog creation and modification > worddavf7c848861d3c92d374909ab74e992841.png

#	Main activities	Tips/Best practices	Key points
22	Change name search to E-catalog ID	If you are doing on Punch-out, Please replace existing URL, username and password with what requester provides (22a)
23	Click	The system might pop up the message below, please press "Enter" to confirm

24 Data Operations > APAC - E-catalog creation and modification > worddavc4c05d198b868d10213190be96556e84.png

#	Main activities	Tips/Best practices	Key points
24	Once you are done, the system will show the message that data was saved

E-catalog testing (for MDM)

User assigning to E-catalog

1a1 Data Operations > APAC - E-catalog creation and modification > worddav5c417a0112a99ca090a5f9c833fc3521.png

#	Main activities	Tips/Best practices	Key points
1	Double click on	If you are doing on production system, double click on You are recommend to do it on BQ2 (Quality system) to test E-catalog in stimulation system If everything is ok, you can copy this steps in BP2

2 Data Operations > APAC - E-catalog creation and modification > worddavde23f9068a780d19e35f92e16ba71c31.png

#	Main activities	Tips/Best practices	Key points
2	Click on your username

3 Data Operations > APAC - E-catalog creation and modification > worddav25551bd1464d6d35edb604e7597b7f3f.png

#	Main activities	Tips/Best practices	Key points
3	Inset T-code "ppoma_bbp" and press "Enter" on your keyboard

4 Data Operations > APAC - E-catalog creation and modification > worddav091bfbd2a4b6b2060765a6b4adecb5f2.png

#	Main activities	Tips/Best practices	Key points
4	Click

65 Data Operations > APAC - E-catalog creation and modification > worddav0433cfdf60c93077de5c3028736709be.png

#	Main activities	Tips/Best practices	Key points
5	Insert your SAP user name		If you are doing on BP2, you will need to assign buyer not your name by insert buyer name in this field
6	Click

1110987 Data Operations > APAC - E-catalog creation and modification > worddav796fe3c8927c67fb18ccc5ebe100400b.png

#	Main activities	Tips/Best practices	Key points
7	Double click on your name in 'Hit list'
8	Double click on your name in the last line in 'Organizational Assignment		If you are doing on BP2, you will need to assign buyer
9	Click on "Attributes" tab
10	Click on
11	Select "Catalog ID"

141312 Data Operations > APAC - E-catalog creation and modification > worddavedfa82add0aa42ea320ed3cc971d31e3.png

#	Main activities	Tips/Best practices	Key points
12	Click
13	Click on blank line you just added
14	Click

15 Data Operations > APAC - E-catalog creation and modification > worddav4c78e49bbee44d6013538b80a70f930b.png

#	Main activities	Tips/Best practices	Key points
15	Double click on E-catalog you want test

1716 Data Operations > APAC - E-catalog creation and modification > worddav931aa5305e791a5a536eeee0597c905e.png

#	Main activities	Tips/Best practices	Key points
16	Click	Please note that this button will change according to the last menu you selected
17	Select "Company Code"

22
21201918 Data Operations > APAC - E-catalog creation and modification > worddav6850f7a661d9f36534aa7e87d8268538.png

#	Main activities	Tips/Best practices	Key points
18	Click
19	Insert company code you want to test
20	Click in Log.System
21	Select target system	If you are doing on BQ2 Select either QF1_020 or WQ1_400 If you are doing on BP2 Select either PF1_020 or WP1_400
22	Click "Extended Attributes"

26252423 Data Operations > APAC - E-catalog creation and modification > worddavddf8359b4812f2d136cede969bcda43e.png

#	Main activities	Tips/Best practices	Key points
23	Select "Locations"
24	Click	If your vendor is in PF1_020, select "QF1 client 020"
25	Select target system
26	Click on "Plnt"

292827 Data Operations > APAC - E-catalog creation and modification > worddav3983672e14edf48a57b030479c44d95a.png

#	Main activities	Tips/Best practices	Key points
27	Insert company code in 'Company Code' field
28	Remove "X" from 'User Attrib Search' field
29	Click

30 Data Operations > APAC - E-catalog creation and modification > worddavd5602c645cb9349bc962bd284341245c.png

#	Main activities	Tips/Best practices	Key points
30	Double click on plant you want to use	Plant code will be automatically appeared

333231 Data Operations > APAC - E-catalog creation and modification > worddavd7e53fa4981566a6a4942ac3679b39bc.png

#	Main activities	Tips/Best practices	Key points
31	Click "Attributes" tab
32	Click	Please note that this button will change according to the last menu you selected
33	Select "Local Currency"
	Click

34 Data Operations > APAC - E-catalog creation and modification > worddavf99821b478142837a501a591244ceff7.png

#	Main activities	Tips/Best practices	Key points
34	Double click on currency	Same currency as E-catalog currency

35 Data Operations > APAC - E-catalog creation and modification > worddav375ebf655e6d6574c5351d0c7edcfc54.png

#	Main activities	Tips/Best practices	Key points
35	Click

36 Data Operations > APAC - E-catalog creation and modification > worddavf192617cc9e8e0b5be1740d6d7ce75d0.png

#	Main activities	Tips/Best practices	Key points
36	The system will pop up the message that data has been saved

E-catalog testing on website

4140393837 Data Operations > APAC - E-catalog creation and modification > worddavb42591135a225c7a20d35da71dcb0414.png

#	Main activities	Tips/Best practices	Key points
37	Insert website for testing in Google Chrome	You are advised to use Google Chrome browser only	If you are doing on BQ2, use the link below http://bq2expert.ibm.be.solvay.com:8027/nwbc If you are doing on BP2, use the link below bp2sapr3.ibm.be.solvay.com/sap/bc/nwbc/
38	Insert client		Always 400
39	Insert SAP user name in 'User' field
40	Insert password
41	Click

42 Data Operations > APAC - E-catalog creation and modification > worddava1538839a171895f920bf14ac8acf45f.png

#	Main activities	Tips/Best practices	Key points
42	Click	You may or may not see this window

43 Data Operations > APAC - E-catalog creation and modification > worddavd8cdd12b487c504a9e11f969217cc6fb.png

#	Main activities	Tips/Best practices	Key points
43	Click "Shop"

44 Data Operations > APAC - E-catalog creation and modification > worddav2230a1e7706d4353e4f29de3194b06dd.png

#	Main activities	Tips/Best practices	Key points
44	Click "Change Personal Default Setting"

4645 Data Operations > APAC - E-catalog creation and modification > worddav201cb9914ada0e9c2c7cca2cf8f1f29b.png

#	Main activities	Tips/Best practices	Key points
45	Insert "DUMMY" in 'Product Category' field
46	Click on 'Company Code' field

4847 Data Operations > APAC - E-catalog creation and modification > worddav4fce14ce7bc9d44d7739c9dee16448ed.png

#	Main activities	Tips/Best practices	Key points
47	Click on the company code you want to select
48	Click	You may find that company code does not appear, please repeat step #46 - #48 again

49 Data Operations > APAC - E-catalog creation and modification > worddav820c05fc86d1f57e10fab447619c6ba1.png

#	Main activities	Tips/Best practices	Key points
49	Click

50 Data Operations > APAC - E-catalog creation and modification > worddavea17d84c83205ca19ccc8817e812830b.png

#	Main activities	Tips/Best practices	Key points
50	Click on description of E-catalog you name in 6. Web services generating step #13

535251 Data Operations > APAC - E-catalog creation and modification > worddav5a151fddd3db1d78027297d22f2eedf8.png

#	Main activities	Tips/Best practices	Key points
51	Tick on the item you want to buy
52	Click
53	Click "Check Out"

5554 Data Operations > APAC - E-catalog creation and modification > worddavdfaf7e9f03412457e4ba8f10c31dd3ff.png

#	Main activities	Tips/Best practices	Key points
54	Click on "Cost Center()"
55	Click

59585756 Data Operations > APAC - E-catalog creation and modification > worddav069dc62de1640547997abdd44b7b5fef.png

#	Main activities	Tips/Best practices	Key points
56	Insert company code
57	Click
58	Click on the first line
59	Click

60 Data Operations > APAC - E-catalog creation and modification > worddav248aa9bd3a767999df58e25905422a04.png

#	Main activities	Tips/Best practices	Key points
60	Click

6162 Data Operations > APAC - E-catalog creation and modification > worddavf6758023ca2f195038001ee05800335b.png

#	Main activities	Tips/Best practices	Key points
61	Insert name of shopping cart
62	Click

63 Data Operations > APAC - E-catalog creation and modification > worddav58288d55dbdbf5eeb88a704fa2dc138f.png

#	Main activities	Tips/Best practices	Key points
63	The system will show that you can create shopping cart successfully	This means that you create e-catalog successfully, now you can do it in BP2

Shopping cart error

1 Data Operations > APAC - E-catalog creation and modification > worddav4dec86bba655bceac7010e2285dd021f.png

#	Main activities	Tips/Best practices	Key points
1	When you test E-catalog in the website, you may find error "Business partner … does not exist"

2 Data Operations > APAC - E-catalog creation and modification > worddava066d5c4d68c74e87d896bcc58ee3a7e.png

#	Main activities	Tips/Best practices	Key points
2	Click "Strategic Purchasing"

3 Data Operations > APAC - E-catalog creation and modification > worddavaf124b7edc63c8e71f9358d3a2720c58.png

#	Main activities	Tips/Best practices	Key points
3	Click "Business Partner"

4 Data Operations > APAC - E-catalog creation and modification > worddavb3dbf0e89f5ac89511b6125c296fc3b7.png

#	Main activities	Tips/Best practices	Key points
4	Click "Supplier"	Once you finish this, please close all windows and log in again

765a5 Data Operations > APAC - E-catalog creation and modification > worddav35c15c09a7dbd0c142399e5bd6ec9a51.png

#	Main activities	Tips/Best practices	Key points
5	Insert vendor's name in 'Name1/Last Name' field	If you cannot find this field, click (#5a)
6	Click
7	Click on the correct vendor

8 Data Operations > APAC - E-catalog creation and modification > worddav56c0b9a88e95b64d1dfd2208b0a93720.png

#	Main activities	Tips/Best practices	Key points
8	Click

109 Data Operations > APAC - E-catalog creation and modification > worddav3b962461605780acd799e9408f8b1a77.png

#	Main activities	Tips/Best practices	Key points
9	Insert DUNS code in 'DUNS number' field
10	Click

11 Data Operations > APAC - E-catalog creation and modification > worddavca3a0e1bf63a926be5d89c2a2aad8d75.png

#	Main activities	Tips/Best practices	Key points
11	The system will show that you have made a change

E-catalog exporting in MDM Data Manager

You will need to check your version of Window installed in your computer whether it is Window7 or Window 10 and later

E-catalog exporting (Window 7)

1 Data Operations > APAC - E-catalog creation and modification > worddavc43f7b9818a3a32d917f4f28c7d2456a.png

#	Main activities	Tips/Best practices	Key points
1	Double click on to open the program		Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

65432 Data Operations > APAC - E-catalog creation and modification > worddav5cf4fe5dcfc5b2b5c0628bb16a83d802.png

#	Main activities	Tips/Best practices	Key points
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="c3deacd9-dee6-4a80-8dad-79d1cfba0b8e"><ac:plain-text-body><![CDATA[	2	Select "ECATDATA_M [mp3sapr3.ibm.be.solvay.cpm] in 'Repository' field		]]></ac:plain-text-body></ac:structured-macro>
3	Insert "BO_APAC" in 'User' field
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="15f4d3d8-b9ba-4f03-931c-d942fd8f7a0d"><ac:plain-text-body><![CDATA[	4	Select "English [US]" in 'Language' field		]]></ac:plain-text-body></ac:structured-macro>
5	Insert "a123456" in Password field
6	Click

7 Data Operations > APAC - E-catalog creation and modification > worddavd820a8923dd442e7d2a13f73bf91e749.png

#	Main activities	Tips/Best practices	Key points
7	Please specific you scope of E-catalog you need to export	You can select from catalog ID, contract number, vendor, etc

1098 Data Operations > APAC - E-catalog creation and modification > worddav9d298c3f00578c6e2845060b191365e6.png

#	Main activities	Tips/Best practices	Key points
8	Click "file"
9	Select "Export To"
10	Select "Excel…"

12111413 Data Operations > APAC - E-catalog creation and modification > worddav17a153582ba4ab0824764e97001747cb.png

#	Main activities	Tips/Best practices	Key points
11	Insert tick mark on "Qualifiers"
12	Select Contract Item ID <Contract Price> Amount <Contract Price> Currency <Contract Price> Per <Contract Price> Contract Item <Contract Price> Lower bound <Contract Price>
13	Click
14	Click

171615 Data Operations > APAC - E-catalog creation and modification > worddav14517cf7945294a1bd1121cc337b126d.png

#	Main activities	Tips/Best practices	Key points
15	Select location to save the file
16	Insert file's name
17	Click

18 Data Operations > APAC - E-catalog creation and modification > worddavf2bc1265bf1e493fc7b2a4db6108b803.png

#	Main activities	Tips/Best practices	Key points
18	Click	You are recommended to send the exported file to requester for creation, modification and deletion	The exported file will look like this

E-catalog exporting (Window 10 or later)

1 Data Operations > APAC - E-catalog creation and modification > worddavc43f7b9818a3a32d917f4f28c7d2456a.png

#	Main activities	Tips/Best practices	Key points
1	Double click on to open the program		Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

65432 Data Operations > APAC - E-catalog creation and modification > worddav5cf4fe5dcfc5b2b5c0628bb16a83d802.png

#	Main activities	Tips/Best practices	Key points
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="5fa159d5-1151-4a77-ae5d-492cf1c28d4b"><ac:plain-text-body><![CDATA[	2	Select "ECATDATA_M [mp3sapr3.ibm.be.solvay.cpm] in 'Repository' field		]]></ac:plain-text-body></ac:structured-macro>
3	Insert "BO_APAC" in 'User' field
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="b416dcf8-a416-4d63-9797-17f385366b27"><ac:plain-text-body><![CDATA[	4	Select "English [US]" in 'Language' field		]]></ac:plain-text-body></ac:structured-macro>
5	Insert password in 'Password' field
6	Click

7 Data Operations > APAC - E-catalog creation and modification > worddavd820a8923dd442e7d2a13f73bf91e749.png

#	Main activities	Tips/Best practices	Key points
7	Please specific you scope of E-catalog you need to export	You can select from catalog ID, contract number, vendor, etc

1098 Data Operations > APAC - E-catalog creation and modification > worddav817ea63cf19575e3411fe85edf328fcd.png

#	Main activities	Tips/Best practices	Key points
8	Click "file"
9	Select "Export To"
10	Select "Text…"

14131211 Data Operations > APAC - E-catalog creation and modification > worddav17a153582ba4ab0824764e97001747cb.png

#	Main activities	Tips/Best practices	Key points
11	Select "Qualifiers"
12	Select Contract Item ID <Contract Price> Amount <Contract Price> Currency <Contract Price> Per <Contract Price> Contract Item <Contract Price> Lower bound <Contract Price
13	Click
14	Click

171615 Data Operations > APAC - E-catalog creation and modification > worddav14517cf7945294a1bd1121cc337b126d.png

#	Main activities	Tips/Best practices	Key points
15	Select location to save the file
16	Insert file's name
17	Click

18 Data Operations > APAC - E-catalog creation and modification > worddaveadac9271d71d2fe2a3bfdb6f362d9a0.png

#	Main activities	Tips/Best practices	Key points
18	Click

212019 Data Operations > APAC - E-catalog creation and modification > worddava42192c90fd2cfcde90703eb2b505717.png

#	Main activities	Tips/Best practices	Key points
19	Open MS Excel and select "Data" tab
20	Click
21	Double click on the selected file

25242322 Data Operations > APAC - E-catalog creation and modification > worddave35fb69489058a57447f610f1d571fd8.png

#	Main activities	Tips/Best practices	Key points
22	Select "Delimited"
23	Click
24	Select "65001 : Unicode (UTF-8)
25	Click

2625 Data Operations > APAC - E-catalog creation and modification > worddavba71af08cfbde972f87d3963d94448f1.png

#	Main activities	Tips/Best practices	Key points
26	Select "Tab"
27	Click

292827 Data Operations > APAC - E-catalog creation and modification > worddav4bc5950394a3d73d5d7fcfe38b1a2804.png

#	Main activities	Tips/Best practices	Key points
27	Select "Text"
28	Click "Region"
29	Scroll to the right

3130 Data Operations > APAC - E-catalog creation and modification > worddav1be237548daaa6e81673df404a9836b0.png

#	Main activities	Tips/Best practices	Key points
30	Press "Shift" on your keyboard and click "Sort"
31	Click

343332 Data Operations > APAC - E-catalog creation and modification > worddava6b7105c2e426c357c887ecc79a3e95b.png

#	Main activities	Tips/Best practices	Key points
32	Select "Existing worksheet"
33	Insert "=$A$1"
34	Click

35 Data Operations > APAC - E-catalog creation and modification > worddav8892d1c87433ef2c0b3dd75753a71795.png

#	Main activities	Tips/Best practices	Key points
35	You will have the exported E-catalog in Excel version

MDM E-catalog deletion

Delete some line items

You may receive a request to update E-catalog by remove some line items from existing E-catalog. You can deleted specific items in MDM Data Manager directly.
1 Data Operations > APAC - E-catalog creation and modification > worddavc43f7b9818a3a32d917f4f28c7d2456a.png

#	Main activities	Tips/Best practices	Key points
1	Double click on to open the program		Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

65432 Data Operations > APAC - E-catalog creation and modification > worddav5cf4fe5dcfc5b2b5c0628bb16a83d802.png

#	Main activities	Tips/Best practices	Key points
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="e99978d1-1585-4ec7-95e6-8717035d255f"><ac:plain-text-body><![CDATA[	2	Select "ECATDATA_M [mp3sapr3.ibm.be.solvay.cpm] in 'Repository' field		]]></ac:plain-text-body></ac:structured-macro>
3	Insert "BO_APAC" in 'User' field
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="d0f43f97-30e9-43b9-93b5-cac2af088532"><ac:plain-text-body><![CDATA[	4	Select "English [US]" in 'Language' field		]]></ac:plain-text-body></ac:structured-macro>
5	Insert password in Password field
6	Click

7 Data Operations > APAC - E-catalog creation and modification > worddav80a0de4a50e038f22211e2f57eb186dc.png

#	Main activities	Tips/Best practices	Key points
7	Click on E-catalog ID that you want delete items

98 Data Operations > APAC - E-catalog creation and modification > worddav9d686045c452fdd36ae9c555b09a579e.png

#	Main activities	Tips/Best practices	Key points
8	Click on line item you want to delete	If you want to delete more than one line, press "Ctrl" on keyboard and then click another line
9	Click right on your mouse on item you want to delete and select "Delete"

10 Data Operations > APAC - E-catalog creation and modification > worddav21158a213c81d75c6199400a3861f0da.png

#	Main activities	Tips/Best practices	Key points
10	Click	You are recommended to export new data to requester, please see 5. E-catalog exporting in MDM Data Manager	There is no back up in MDM, please be careful when you change or delete something

Delete the entire contract

1 Data Operations > APAC - E-catalog creation and modification > worddavc43f7b9818a3a32d917f4f28c7d2456a.png

#	Main activities	Tips/Best practices	Key points
11	Double click on to open the program		Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

65432 Data Operations > APAC - E-catalog creation and modification > worddav5cf4fe5dcfc5b2b5c0628bb16a83d802.png

#	Main activities	Tips/Best practices	Key points
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="5bb68fa5-b638-423f-8cba-76331f6bc851"><ac:plain-text-body><![CDATA[	2	Select "ECATDATA_M [mp3sapr3.ibm.be.solvay.cpm] in 'Repository' field		]]></ac:plain-text-body></ac:structured-macro>
3	Insert "BO_APAC" in 'User' field
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="80f70a3d-a544-4dd3-b1cd-3c44f2e66ca3"><ac:plain-text-body><![CDATA[	4	Select "English [US]" in 'Language' field		]]></ac:plain-text-body></ac:structured-macro>
5	Insert password in 'Password' field
6	Click

7 Data Operations > APAC - E-catalog creation and modification > worddav80a0de4a50e038f22211e2f57eb186dc.png

#	Main activities	Tips/Best practices	Key points
7	Click on E-catalog ID that you want delete items

98 Data Operations > APAC - E-catalog creation and modification > worddav9d686045c452fdd36ae9c555b09a579e.png

#	Main activities	Tips/Best practices	Key points
8	Click on all line items of the catalog you want to delete	If you want to delete more than one line, press "Ctrl" on keyboard and then click another line
9	Click right on your mouse and select "Delete"

10 Data Operations > APAC - E-catalog creation and modification > worddav21158a213c81d75c6199400a3861f0da.png

#	Main activities	Tips/Best practices	Key points
	Click		There is no back up in MDM, please be careful when you change or delete something

MDM E-catalog modification

Modification in MDM Data Manager (For minor changes)

You may receive a request to update price in existing items that you consider you can do it manually so you can update data directly on MDM Data Manager.
1 Data Operations > APAC - E-catalog creation and modification > worddavc43f7b9818a3a32d917f4f28c7d2456a.png

#	Main activities	Tips/Best practices	Key points
1	Double click on to open the program		Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

46532 Data Operations > APAC - E-catalog creation and modification > worddav5cf4fe5dcfc5b2b5c0628bb16a83d802.png

#	Main activities	Tips/Best practices	Key points
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="150a99b3-77e5-43ab-8408-719f98942a09"><ac:plain-text-body><![CDATA[	2	Select "ECATDATA_M [mp3sapr3.ibm.be.solvay.cpm] in 'Repository' field		]]></ac:plain-text-body></ac:structured-macro>
3	Insert "BO_APAC" in 'User' field
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="005326e1-d890-4686-ad94-fc03fe6f72f2"><ac:plain-text-body><![CDATA[	4	Select "English [US]" in 'Language' field		]]></ac:plain-text-body></ac:structured-macro>
5	Insert "a123456" in Password field
6	Click

987 Data Operations > APAC - E-catalog creation and modification > worddavad8637c3561230872719f4ec0724b718.png

#	Main activities	Tips/Best practices	Key points
7	Double click on field you want to modify and change it	Once you change, new data will be saved automatically If you want to change price to step #8	You can change details in RED box
8	For price, you need to click right on your mouse
9	Select "View/Edit Detail…"

121110 Data Operations > APAC - E-catalog creation and modification > worddav4baa91d8c9a37ab03de5dd4e64e485df.png

#	Main activities	Tips/Best practices	Key points
10	Click
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="9e63dd6b-34c8-4017-a3c8-c778d097f8f3"><ac:plain-text-body><![CDATA[	11	Double click on "[Amount]" and change the price	Once you change, new data will be saved automatically	]]></ac:plain-text-body></ac:structured-macro>
12	Click	You are recommended to export new data to requester, please see 5. E-catalog exporting in MDM Data Manager

Modification in MDM Import manager (For adding or replacing items)

Add new items in the existing E-catalog

Data Operations > APAC - E-catalog creation and modification > worddavbd45a762e3fb615120da51246bf354d7.png
1

#	Main activities	Tips/Best practices	Key points
1	Please see how to upload the file in 3.3 Template uploading in MDM Import Manager When you are in step #73 you need to select "Update (All Mapped Fields)" in Default Import Action	For added new items, you are recommended to prepare template with only new items You are also advised to export list of existing items in case something goes wrong, please see 5. E-catalog exporting in MDM Data Manager

Replace ALL items in the existing E-catalog

1 Data Operations > APAC - E-catalog creation and modification > worddav2affd8c388bc58aab69316d092bad294.png

#	Main activities	Tips/Best practices	Key points
1	Please see how to delete line items in 8.1 Delete some line items You need to delete most of item and leave one line item to keep E-catalog ID exists MDM	If you delete all line items, E-catalog ID will be removed from MDM

2 Data Operations > APAC - E-catalog creation and modification > worddav1c011ded81283f047b09086c741d3334.png

#	Main activities	Tips/Best practices	Key points
2	Please see how to upload the file in 3.3 Template uploading in MDM Import Manager When you are in step #73 you need to select "Replace" in Default Import Action

3 Data Operations > APAC - E-catalog creation and modification > worddav9d686045c452fdd36ae9c555b09a579e.png

#	Main activities	Tips/Best practices	Key points
3	Go back to MDM Data Manager and delete the line you left	You are recommended to export new data to requester, please see 5. E-catalog exporting in MDM Data Manager

Remove exiting items and add new items in the existing E-catalog

1 Data Operations > APAC - E-catalog creation and modification > worddav2affd8c388bc58aab69316d092bad294.png

#	Main activities	Tips/Best practices	Key points
	Please see how to delete line items in 8.1 Delete some line items You need to delete most of item and leave one line item to keep E-catalog ID exists MDM	If you delete all line items, E-catalog ID will be removed from MDM You are recommended to export new data to use as the reference file to check against the template requester send, please see 5. E-catalog exporting in MDM Data Manager

2 Data Operations > APAC - E-catalog creation and modification > worddav1c011ded81283f047b09086c741d3334.png

#	Main activities	Tips/Best practices	Key points
2	Please see how to upload the file in 3.3 Template uploading in MDM Import Manager When you are in step #73 you need to select "Replace" in Default Import Action

4 Data Operations > APAC - E-catalog creation and modification > worddav9d686045c452fdd36ae9c555b09a579e.png

#	Main activities	Tips/Best practices	Key points
4	Go back to MDM Data Manager and delete the line you left	You are recommended to export new data to requester, please see 5. E-catalog exporting in MDM Data Manager

Appendix

The current flow to E-catalog

Data Operations > APAC - E-catalog creation and modification > worddava41df62aea5e490c3ba2a14466585c87.png

MDM System Architecture

Data Operations > APAC - E-catalog creation and modification > worddav2b38bf0ded9b69dc06d483874c811db8.png

MDM funtions

Data Operations > APAC - E-catalog creation and modification > worddavad2691a9ec8596cf0b8d048d36a851bf.png