#

Main activities

Tips/Best practices

Key points

1

#

Main activities

Tips/Best practices

Key points

2

Insert "mp3sapr3.ibm.be.solvay.com" in 'MDM Server' field

Recommended to type

3

4

5

#

Main activities

Tips/Best practices

Key points

6

7

Insert “BO_APAC” in ‘User’ field

8

Insert password in ‘Password’ field

Please ask you team members

9

#

Main activities

Tips/Best practices

Key points

1

Open MDM Data console and click right on "SAP MDM Servers"

2

Click "Mount MDM Server"

#

Main activities

Tips/Best practices

Key points

3

Insert "mp3sapr3.ibm.be.solvay.com" in 'MDM Server' field

4

#

Main activities

Tips/Best practices

Key points

5

6

Click right on "ECATDATA_M"

7

Select "Connect to Repository"

#

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

#

Main activities

Tips/Best practices

Key points

11

Click right on "SAP MDM Servers"

12

Click "Mount MDM Server"

#

Main activities

Tips/Best practices

Key points

13

Insert "mp4sapr3.ibm.be.solvay.com" in 'MDM Server' field

14

#

Main activities

Tips/Best practices

Key points

15

16

Click right on "ECATDATA_M"

17

Select "Connect to Repository"

#

Main activities

Tips/Best practices

Key points

18

Insert "BO_APAC" in 'User' field

19

Insert password in 'Password' field

20

#

Main activities

Tips/Best practices

Key points

1

Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

#

Main activities

Tips/Best practices

Key points

2

Select “ECATDATA_M [mp3sapr3.ibm.be.solvay.com] in ‘Repository’ field

3

Insert “BO_APAC” in ‘User’ field

4

Select “English [US]” in ‘Language’ field

5

Insert password in ‘password’ field

Please ask you team for password

6

#

Main activities

Tips/Best practices

Key points

7

8

Select "Contract price"

#

Main activities

Tips/Best practices

Key points

9

Insert contract number in 'Contract' field

#

Main activities

Tips/Best practices

Key points

1

2

Select "Suppliers"

#

Main activities

Tips/Best practices

Key points

3

Click "Free-from Search"

#

Main activities

Tips/Best practices

Key points

4

Insert vendor code in 'Supplier ID' field

#

Main activities

Tips/Best practices

Key points

1

2

Select "Categories"

#

Main activities

Tips/Best practices

Key points

3

Insert catalog ID in 'Catalog ID' field

#

Main activities

Tips/Best practices

Key points

1

Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

#

Main activities

Tips/Best practices

Key points

2

Select “ECATDATA_M [mp3sapr3.ibm.be.solvay.com] in ‘Repository’ field

3

Insert “BO_APAC” in ‘User’ field

4

Select “English [US]” in ‘Language’ field

5

Insert password in ‘Password’ field

Please ask you team for password

6

#

Main activities

Tips/Best practices

Key points

7

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

#

Main activities

Tips/Best practices

Key points

1

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

#

Main activities

Tips/Best practices

Key points

8

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

#

Main activities

Tips/Best practices

Key points

1

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

#

Main activities

Tips/Best practices

Key points

1

2

Select "Catalog Items"

#

Main activities

Tips/Best practices

Key points

3

Click right on your mouse and select "Add"

#

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

#

Main activities

Tips/Best practices

Key points

1

Open 'Excel' and click "Data"

2

#

Main activities

Tips/Best practices

Key points

3

Select the file

4

#

Main activities

Tips/Best practices

Key points

5

Select "Delimited"

6

#

Main activities

Tips/Best practices

Key points

7

Put tick mark on "Tab"

8

#

Main activities

Tips/Best practices

Key points

9

Select "Text" in 'Column data format'

10

Click on "Region"

11

#

Main activities

Tips/Best practices

Key points

12

Press "Ctrl + Shift" and click on "Category"

13

#

Main activities

Tips/Best practices

Key points

14

Select "Existing worksheet"

15

Insert "=$A$1"

16

#

Main activities

Tips/Best practices

Key points

17

Copy details from the template 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

#

Main activities

Tips/Best practices

Key points

18

Click "File"

19

Select "Save As"

#

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

#

Main activities

Tips/Best practices

Key points

1

#

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

Do not click "Enter" on keyboard, otherwise you will skip a part of uploading file to MDM

#

Main activities

Tips/Best practices

Key points

5

6

7

#

Main activities

Tips/Best practices

Key points

8

Select the template you prepared

9

#

Main activities

Tips/Best practices

Key points

10

Insert "\t" in 'Delimiter' field

11

#

Main activities

Tips/Best practices

Key points

12

#

Main activities

Tips/Best practices

Key points

13

Select "Map txt DJO"

14

#

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

#

Main activities

Tips/Best practices

18

Click "Match Records " tab

19

Select "Create" in the first line

#

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

#

Main activities

Tips/Best practices

Key points

24

This means that items have been imported

25

#

Main activities

Tips/Best practices

Key points

26

Always click "NO"

#

Main activities

Tips/Best practices

Key points

27

Always click "NO"

#

Main activities

Tips/Best practices

Key points

1

Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

#

Main activities

Tips/Best practices

Key points

2

Select “ECATDATA_M [mp3sapr3.ibm.be.solvay.com] in ‘Repository’ field

3

Insert “BO_APAC” in ‘User’ field

4

Select “English [US]” in ‘Language’ field

5

Insert  in ‘’ field

You can ask  from your team member

6

#

Main activities

Tips/Best practices

Key points

7

8

Select "Named Searches"

 9

Click right on your mouse on the existing name and select "Add"

#

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

#

Main activities

Tips/Best practices

Key points

13

14

Select "Catalog Items"

15

Click "Search"

16

Select "Save as Named Search"

17

Selected "More…"

#

Main activities

Tips/Best practices

Key points

18

Click E-catalog ID you want to set named search

19

#

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

#

Main activities

Tips/Best practices

Key points

1

#

Main activities

Tips/Best practices

Key points

2

Click on your username

#

Main activities

Tips/Best practices

Key points

3

Inset T-code "spro" and press "Enter" on your keyboard

#

Main activities

Tips/Best practices

Key points

4

#

Main activities

Tips/Best practices

Key points

5

6

7

8

9

#

Main activities

Tips/Best practices

Key points

10

If you are doing on Punch-out, please click on "_OFFICEMATE_TH" as the reference

11

#

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

#

Main activities

Tips/Best practices

Key points

18

#

Main activities

Tips/Best practices

Key points

19

Press "Enter" on keyboard until the system copies all entries

#

Main activities

Tips/Best practices

Key points

20

#

Main activities

Tips/Best practices

Key points

21

22

Double click on "Standard Call Structure"

#

Main activities

Tips/Best practices

Key points

23

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 (23a)

24

#

Main activities

Tips/Best practices

Key points

25

Once you are done, the system will show the message that data was saved

#

Main activities

Tips/Best practices

Key points

1

#

Main activities

Tips/Best practices

Key points

2

Click on your username

#

Main activities

Tips/Best practices

Key points

3

Inset T-code "ppoma_bbp" and press "Enter" on your keyboard

#

Main activities

Tips/Best practices

Key points

4

#

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

#

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 buyers' users

9

Click on "Attributes" tab

10

11

Select "Catalog ID"

#

Main activities

Tips/Best practices

Key points

12

13

Click on blank line you just added

14

#

Main activities

Tips/Best practices

Key points

15

Double click on E-catalog you want test

#

Main activities

Tips/Best practices

Key points

16

Please note that this button will change according to the last menu you selected

17

Select "Company Code"

#

Main activities

Tips/Best practices

Key points

18

19

Insert company code you want to test

20

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"

#

Main activities

Tips/Best practices

Key points

23

Select "Locations"

24

If your vendor is in PF1_020, select "QF1 client 020"

25

Select target system

26

#

Main activities

Tips/Best practices

Key points

27

Insert company code in 'Company Code' field

28

Remove "X" from 'User Attrib Search' field

29

#

Main activities

Tips/Best practices

Key points

30

Double click on plant you want to use

Plant code will be automatically appeared

#

Main activities

Tips/Best practices

Key points

31

Click "Attributes" tab

32

Please note that this button will change according to the last menu you selected

33

Select "Local Currency"

#

Main activities

Tips/Best practices

Key points

34

Double click on currency

Same currency as E-catalog currency

#

Main activities

Tips/Best practices

Key points

35

#

Main activities

Tips/Best practices

Key points

36

The system will pop up the message that data has been saved

#

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

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

#

Main activities

Tips/Best practices

Key points

42

You may or may not see this window

#

Main activities

Tips/Best practices

Key points

43

Click "Shop"

#

Main activities

Tips/Best practices

Key points

44

Click "Change Personal Default Setting"

#

Main activities

Tips/Best practices

Key points

45

Insert "DUMMY" in 'Product Category' field

46

#

Main activities

Tips/Best practices

Key points

47

48

You may find that company code does not appear, please repeat step #46 - #48 again

#

Main activities

Tips/Best practices

Key points

49

#

Main activities

Tips/Best practices

Key points

50

Click on description of E-catalog you name in Section 6. Web services generating step #13

#

Main activities

Tips/Best practices

Key points

51

Tick on the item you want to buy

52

53

Click "Check Out"

#

Main activities

Tips/Best practices

Key points

54

Click on "Cost Center()"

55

#

Main activities

Tips/Best practices

Key points

56

Insert company code

57

58

59

#

Main activities

Tips/Best practices

Key points

60

#

Main activities

Tips/Best practices

Key points

61

Insert name of shopping cart

62

#

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

#

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"

#

Main activities

Tips/Best practices

Key points

2

Click "Strategic Purchasing"

#

Main activities

Tips/Best practices

Key points

3

Click "Business Partner"

#

Main activities

Tips/Best practices

Key points

4

Click "Supplier"

Once you finish this, please close all windows and log in again

#

Main activities

Tips/Best practices

Key points

5

Insert vendor's name in 'Name1/Last Name' field

6

7

Click on the correct vendor

#

Main activities

Tips/Best practices

Key points

8

#

Main activities

Tips/Best practices

Key points

9

Insert DUNS code in 'DUNS number' field

10

#

Main activities

Tips/Best practices

Key points

11

The system will show that you have made a change

#

Main activities

Tips/Best practices

Key points

1

Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

#

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

#

Main activities

Tips/Best practices

Key points

8

Click "file"

9

Select "Export To"

10

Select "Excel…"

#

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

14

#

Main activities

Tips/Best practices

Key points

15

Select location to save the file

16

Insert file's name

17

#

Main activities

Tips/Best practices

Key points

18

You are recommended to send the exported file to requester for creation, modification and deletion

#

Main activities

Tips/Best practices

Key points

1

Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

#

Main activities

Tips/Best practices

Key points

2

Select “ECATDATA_M [mp3sapr3.ibm.be.solvay.com] in ‘Repository’ field

3

Insert “BO_APAC” in ‘User’ field

4

Select “English [US]” in ‘Language’ field

5

Insert password in ‘Password’ field

6

#

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.

#

Main activities

Tips/Best practices

Key points

8

Click "file"

9

Select "Export To"

10

Select "Text…"

#

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

14

#

Main activities

Tips/Best practices

Key points

15

Select location to save the file

16

Insert file's name

17

#

Main activities

Tips/Best practices

Key points

18

#

Main activities

Tips/Best practices

Key points

19

Open MS Excel and select "Data" tab

20

21

Double click on the selected file

#

Main activities

Tips/Best practices

Key points

22

Select "Delimited"

23

24

Select "65001 : Unicode (UTF-8)

25

#

Main activities

Tips/Best practices

Key points

26

Select "Tab"

27

#

Main activities

Tips/Best practices

Key points

28

Select "Text"

29

Click "Region"

30

Scroll to the right

#

Main activities

Tips/Best practices

Key points

31

Press "Shift" on your keyboard and click "Sort"

32

#

Main activities

Tips/Best practices

Key points

33

Select "Existing worksheet"

34

Insert "=$A$1"

35

#

Main activities

Tips/Best practices

Key points

36

You will have the exported E-catalog in Excel version

#

Main activities

Tips/Best practices

Key points

1

Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

#

Main activities

Tips/Best practices

Key points

2

Select “ECATDATA_M [mp3sapr3.ibm.be.solvay.com] in ‘Repository’ field

3

Insert “BO_APAC” in ‘User’ field

4

Select “English [US]” in ‘Language’ field

5

Insert  in  field

6

#

Main activities

Tips/Best practices

Key points

7

Click on E-catalog ID that you want delete items

#

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"

#

Main activities

Tips/Best practices

Key points

10

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

#

Main activities

Tips/Best practices

Key points

1

Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

#

Main activities

Tips/Best practices

Key points

2

Select “ECATDATA_M [mp3sapr3.ibm.be.solvay.com] in ‘Repository’ field

3

Insert “BO_APAC” in ‘User’ field

4

Select “English [US]” in ‘Language’ field

5

Insert  in  field

6

#

Main activities

Tips/Best practices

Key points

7

Click on E-catalog ID that you want delete items

#

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"

#

Main activities

Tips/Best practices

Key points

 10

There is no back up in MDM, please be careful when you change or delete something

#

Main activities

Tips/Best practices

Key points

1

Since you are creating new E-catalog, you need to created E-catalog ID in this program before uploading the template

#

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…"

#

Main activities

Tips/Best practices

Key points

10

11

Double click on “[Amount]” and change the price

Once you change, new data will be saved automatically

12

You are recommended to export new data to requester, please see 5. E-catalog exporting in MDM Data Manager

#

Main activities

Tips/Best practices

Key points

1

Please see how to upload the file in 5.3 Template uploading in MDM Import Manager
When you are in step #19 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

#

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

#

Main activities

Tips/Best practices

Key points

2

Please see how to upload the file in 5.3 Template uploading in MDM Import Manager
When you are in step #19 you need to select "Replace" in Default Import Action

#

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

#

Main activities

Tips/Best practices

Key points

 1

Please see how to delete line items in 10.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

#

Main activities

Tips/Best practices

Key points

2

Please see how to upload the file in 5.3 Template uploading in MDM Import Manager
When you are in step #19 you need to select "Replace" in Default Import Action

#

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