Customer Type Classifications Agenda Customer Grouping Fields in

Customer Type Classifications Agenda § Customer Grouping Fields in SAP § Proposal § Legal Status Field § Customer Classifications § Retrofits Required § Customer Line Item Display (FBL 5 N) 1 | x. Nova. Core | November 2012 | Business Use Only

Customer Grouping Fields in SAP 43 grouping fields Table KNA 1 - General Master Data 24 Company Code & Sales Organization independent fields 2 Field Length Description Techn Suitability Conflicts w oth Div GFORM 2 Legal status High x. NC NIELS 2 Nielsen ID Medium ? ? KUKLA 2 Customer classification High Low BRSCH 4 Industry key High Medium BRAN 1_D 10 Industry Code 1 High Low BRAN 2 10 Industry code 2 High Low BRAN 3 10 Industry code 3 High Low BRAN 4 10 Industry code 4 High Low BRAN 5 10 Industry code 5 High Low KATR 1 2 Attribute 1 Medium Low KATR 2 2 Attribute 2 Medium Low KATR 3 2 Attribute 3 Medium Low KATR 4 2 Attribute 4 Medium Low KATR 5 2 Attribute 5 Medium Low KATR 6 3 Attribute 6 Medium Low KATR 7 3 Attribute 7 Medium Low KATR 8 3 Attribute 8 Medium Low KATR 9 3 Attribute 9 Medium Low KATR 10 3 Attribute 10 Medium Low KDKG 1 2 Customer condition group 1 Low ? ? KDKG 2 2 Customer condition group 2 Low ? ? KDKG 3 2 Customer condition group 3 Low ? ? KDKG 4 2 Customer condition group 4 Low ? ? KDKG 5 2 Customer condition group 5 Low ? ? | x. Nova. Core | November 2012 | Business Use Only

Customer Grouping Fields in SAP 42 grouping fields 3 Table Field Length KNB 1 Co. Code FDGRV 10 KDGRP KNVV - Sales Organization Master Data Fields 1 Company Code and 17 Sales Organization dependent fields Techn Suitability Conflicts w oth Div Planning group Low ? ? 2 Customer group Low ? ? KVGR 1 3 Customer group 1 Low ? ? KVGR 2 3 Customer group 2 Low ? ? KVGR 3 3 Customer group 3 Low ? ? KVGR 4 3 Customer group 4 Low ? ? KVGR 5 3 Customer group 5 Low ? ? STGKU 1 Customer Statistics Group Low ? ? KALKS 1 Pricing procedure Zero ? ? PLTYP 2 Price list type Zero ? ? KONDA 2 Price group (customer) Zero ? ? VKBUR 4 Sales Office Zero ? ? BZIRK 6 Sales district Zero ? ? VKGRP 3 Sales Group Zero ? ? LPRIO 2 Delivery Priority Zero ? ? KLABC 2 Customer classification (ABC) Zero ? ? KTGRD 2 Account assignment group Zero x. NC KKBER 4 Credit control area Zero x. NC | x. Nova. Core | November 2012 | Business Use Only Description

Most Suitable Fields Proposal Legal Status Field § Legal status field already governed by x. Nova. Core (separation of public and private sector) § Using this field in conjunction with another one reduces the number of grouping codes considerably § Good practice to use one field to measure 1 dimension only + Customer Classification § AR Reporting groups are truly company and sales organization independent § Field length of 2 digits only which meets reporting requirements perfectly § Not too many retrofitting conflicts 4 | x. Nova. Core | November 2012 | Business Use Only

Legal Status Field Proposed Codes 10 Public 20 Private 21 Large Corporation 27 Partnership 29 Sole Proprietorship 50 Natural Person § Approved by Sonja Haupt (Head of Group Reporting Systems Development) § Publicly listled companies are considered private organizations § Does not wish to change description from public to government 5 | x. Nova. Core | November 2012 | Business Use Only

Customer Classifications Proposed Codes (Summarized) 1 Wholesalers/Distributors 2 Hospitals/Clinics 3 Pharmacies 4 Healthcare Professionals 5 Retail 8 End Consumer 9 Other S Pharma Manufacturers V Internal Z Non-Core Business 6 | x. Nova. Core | November 2012 | Business Use Only

Customer Classifications Proposed Codes (Detailed) 10 Wholesalers/Distributors 11 Wholesalers 12 Distributors 1 Z Wholesalers/Distributors Other 50 Retail 51 FMCG Retail Chains 51 FMCG Retail Independent 5 Z Retail Other 20 Hospitals/Clinics 21 Hospital Chains 22 Hospitals Independent 23 Nursing Homes 25 Home Care 29 Laboratories 2 Z Hospitals/Clinics Other 80 End Consumer 90 Other 91 Medical Aids 95 NGOs/Charities 99 Teaching Institutions S 0 Pharma Manufacturers 30 Pharmacies 31 Pharmacy Chains 35 Pharmacy Independent 3 Z Pharmacies Other 40 Healthcare Professionals 41 HMOs 42 Independent Practitioners' Assoc 48 Doctors 4 A Veterinarians 4 Z Healthcare Professionals Other 7 | x. Nova. Core | November 2012 | Business Use Only V 0 Internal V 1 Sales Force V 2 Technical Sample Accounts V 2 Employees VA Inter-Company Z 0 Non-Core Business

Retrofits Required Sandoz US&CA New codes could live side by side 8 Code U 2 U 0 U 6 MC U 1 UM UQ U 9 UL U 4 U 5 U 8 UB UD 1 MI 2 U 7 U 3 UC UG UE UH UF UN UJ UK UZ Description US: Chain Store US: Independent Pharm US: Institutional Ac CA: PA Calc Prog US: Chain Warehouse US: Physician US: Long Term Care US: HMO-Hlth Mnt. Or US: Contracting Org. US: Wholesaler US: Distributor US: Mfg. Vendor, Pkg US: Mail Order Pharm US: Medicaid Office A-customer CA: Key Acc Inv Prog B-customer US: Specialty Pharm US: House Account US: Intra-Company US: County Govt. US: Federal Govt. US: Donation Org. US: State Govt. US: Intercompany US: Repackager US: 3 rd Party Return US: Legacy Obsolete Total | x. Nova. Core | November 2012 | Business Use Only No of Customers 54, 921 46, 907 28, 518 21, 489 11, 437 10, 818 4, 204 1, 048 699 629 407 360 251 215 143 135 60 52 49 34 32 30 17 15 5 5 2 1 182, 483 New Code P 34 US/CA 31 Pharmacy Chains 35 Pharmacy Independent 90 Other ? ? Use different field 31 Pharmacy Chains 48 Doctors ? ? 41 HMOs ? ? 11 Wholesalers 12 Distributors S 0 Pharma Manufacturers 3 Z Pharmacies Other 91 Medical Aids Use KNVV field Use different field Use KNVV field S 0 Pharma Manufacturers 80 End Consumer VA Inter-Company 90 Other 95 NGOs/Charities 90 Other VA Inter-Company ? ? ?

Retrofits Required Pharma Latam New codes could live side by side Code Description New Code PH Latam 1 A Gen Wholesaler- Pvt 4, 940 1 K Physician/GPOs- Pvt 539 48 Doctors 1 H Pharmacy -Indpt-Pvt 405 35 Pharmacy Independent 1 N Other - Pvt 404 90 Other 3 N Other - Oth 335 90 Other 2 B Government - Pub 246 90 Other 2 A Gen. Wholesaler- Pub 204 11 Wholesalers 1 E Hospital/Hospice-Pvt 196 20 Hospitals/Clinics 2 C Tender - Pub 184 90 Other 1 J Pharmacy - Chain Pvt 182 31 Pharmacy Chains 2 E Hospital/Hospice-Pub 123 20 Hospitals/Clinics 1 M Retailers -Pvt 121 50 Retail 3 A Gen Wholesaler- Oth 119 1 Z Wholesalers/Distributors Other 2 D HMOs - Pub 91 41 HMOs 3 J Pharmacy - Chain Oth 44 3 Z Pharmacies Other 2 K Physician/GPOs- Pub 32 48 Doctors 1 L Pharma Manuf -Pvt 22 S 0 Pharma Manufacturers 1 D HMOs -Pvt 20 41 HMOs 2 N Other - Pub 5 90 Other 1 B Government - Pvt 4 90 Other 3 K Physician/GPOs- Oth 4 4 Z Healthcare Professionals Other 1 F Homecare -Pvt 3 25 Home Care 1 G Nursing Home -Pvt 3 22 Nursing Homes 3 E Hospital/Hospice-Oth 3 20 Hospitals/Clinics 3 H Pharmacy -Indpt-Pvt 2 3 Z Pharmacies Other A-customer 1 Use KNVV field Government- Oth 1 90 Other 1 3 B Total 9 No of Customers | x. Nova. Core | November 2012 | Business Use Only 8, 233 11 Wholesalers

Retrofits Required Ciba Vision - 103901 customers Will use ABC Classification field on KNVV when migrating to IRIS A 0, A 1, . . A 5 – Highest importance customers B 0, B 1. . B 5 C 0, C 1, . . C 5 D 0, D 1, . . . D 5 – Inside Sales E 0, E 1, . . E 5 – Lowest volume F 1. . F 4 I 1. . I 5 Z 0. . Z 5 10 | x. Nova. Core | November 2012 | Business Use Only

Customer Line Item Display (FBL 5 N) Additional fields can be added via transaction code SE 36 with logical database ‘DDF’ 11 | x. Nova. Core | November 2012 | Business Use Only