Effective Master Data Management with SAP NetWeaver MDM

Andy Walker works for a large global energy company and lives in Ascot, London. He has spoken on the subject of MDM at the SAP Sapphire Orlando conference in May 2008, the Vienna user conference in May 2007, the MDM Gartner conference (Florida) in September 2007 and the CDI MDM Summit (New York) in November 2007. In addition to MDM, Andy's areas of expertise include ERP deployment, with both SAP and non-SAP systems. Andy graduated from Loughborough University with a First Class Batchelor of Science Honours degree in Computer Studies in 1985. Jagadeeshwaran Ganapathy leads the SAP MDM Competency at Wipro, and has served as a lead Architect in multiple MDM projects across the US and UK. He has spoken on the topic of SAP MDM Best Practices at SAP Sapphire 2008 Conference in Orlando, US. He has 14 years of work experience with a rich background in SAP ERP and Functional consulting. Jagadeesh holds a Bachelors Degree in engineering, and CPIM (Certified in Production and Inventory management) certification from APICS (American Production and Inventory Control society).

1 Introducing MDM Concepts and Definitions ... 19 1.1 Introduction ... 19 1.2 MDM Concepts ... 27 1.3 MDM Definitions ... 43 1.4 Summary ... 51 2 Why MDM Is Needed: Master Data Silos Issues ... 53 2.1 Case Study 1 Master Data Silos ... 54 2.2 Maintaining Master Data Across the Silos ... 68 2.3 Case Study 2 Impact of Mergers and Acquisitions ... 82 2.4 Large Organizations Multiplying the Data Silos Issues ... 87 2.5 Summary ... 88 3 The MDM Business Case and the MDM Program Assessment ... 91 3.1 The SAP NetWeaver MDM Business Case ... 91 3.2 MDM Core Services ... 94 3.3 Integrating MDM with the Major Business Areas ... 104 3.4 Obstacles to MDM Adoption One More Master Data System to Maintain ... 115 3.5 The MDM Business Partner Scorecard ... 120 3.6 MDM Phase 2 ... 124 3.7 Summary ... 130 4 ... The Dun & Bradstreet Services ... 131 4.1 Dun & Bradstreet Services ... 131 4.2 Dun & Bradstreet Implications for an Organization ... 147 4.3 Applying the D&B Solution The Case Studies Revisited ... 167 4.4 Summary ... 171 5 Mobilizing for MDM: People and Planning ... 173 5.1 Establishing MDM Program and Data Governance ... 173 5.2 Building the Key MDM Program Components ... 184 5.3 Mobilizing the MDM Program Team ... 187 5.4 The MDM Discovery Phase ... 195 5.5 MDM Planning and Roadmaps ... 199 5.6 Summary ... 202 6 Developing an SAP NetWeaver MDM Architecture for an Enterprise ... 205 6.1 Designing the SAP NetWeaver MDM Technical Framework ... 206 6.2 Enterprise MDM Data Architecture Standards and Requirements ... 224 6.3 Summary ... 230 7 Converting and Maintaining Master Data ... 233 7.1 Data Cleansing and Migration ... 234 7.2 Ongoing Data Maintenance ... 252 7.3 Summary ... 260 8 The SAP NetWeaver MDM Landscape, Data Modeling, and Data Maintenance ... 261 8.1 MDM Technical Landscape and Data Modeling ... 262 8.2 MDM Data Manager Functions ... 286 8.3 Summary ... 298 9 SAP NetWeaver MDM Data Integration and Enrichment ... 299 9.1 MDM Import Manager ... 300 9.2 MDM Syndication ... 312 9.3 MDM Enrichment Adapter ... 320 9.4 Summary ... 328 10 Integrating SAP NetWeaver MDM with the SAP NetWeaver Components ... 331 10.1 SAP NetWeaver Portal Design and Deployment ... 331 10.2 Process Integration Using SAP NetWeaver PI ... 352 10.3 Summary ... 358 11 Advanced Features ... 361 11.1 Introducing Application Programming Interfaces and Web Services ... 361 11.2 The MDM Java API ... 364 11.3 MDM Web Services ... 375 11.4 Planning for Service Pack Upgrades and Recent Service Pack Functionality ... 382 11.5 Future Roadmaps ... 392 11.6 Summary ... 393