Effective Master Data Management with SAP …

1 Andy Walker, Jagadeesh GanapathyEffective Master data Management with SAP NetWeaver MDMBonn Boston223 38/5/08 10:55:01 AMContents at a GlancePART I MDM Business Background and Skills1 Introducing MDM Concepts and Definitions .. 192 Why MDM Is Needed: Master data Silos Issues .. 533 The MDM Business Case and the MDM Program Assessment .. 914 The Dun & Bradstreet Services .. 1315 Mobilizing for MDM: People and Planning .. 173 PART II SAP NetWeaver MDM Technical Framework and Solution Architecture6 Developing an SAP NetWeaver MDM Architecture for an Enterprise.

2 2057 Converting and Maintaining Master data .. 2338 The SAP NetWeaver MDM Landscape, data Modeling, and data Maintenance .. 2619 SAP NetWeaver MDM data Integration and Enrichment .. 29910 Integrating SAP NetWeaver MDM with the SAP NetWeaver Components .. 33111 Advanced Features .. 361 The Authors .. 395223 58/5/08 10:55:01 .. 15 PART I MDM Business Background and Skills1 Introducing MDM Concepts and Definitions .. Introduction .. Understanding MDM and Asking the Right Questions .. MDM Concepts.

3 MDM Terminology .. Scope of This Book .. Introducing the Master data Silos .. Introducing the Dun & Bradstreet Concepts .. Reconciling the Master data Silos with the D&B D-U-N-S Number .. Records of Reference, Records of Origin, and Consuming Systems .. The Yellow Pages of a Corporation .. The Importance of MDM data Quality .. MDM Definitions .. Master data Objects .. Business Partners .. Vendor Definitions .. Customers .. Natural Persons .. Summary.

4 512 Why MDM Is Needed: Master data Silos Issues .. Case Study 1 Master data Silos .. Financial Accounting Application (FI1) Vendors and Accounts Payable .. Financial Accounting Application (FI1) Customers and Accounts Receivables .. Customer Relationship Management Application (CRM1) 61223 78/5/08 10:55:01 Sales and Distribution Application (SD1) .. Supply Chain Management Application (SCM1) .. Business Intelligence (BI1) .. Maintaining Master data Across the Silos .. Business data Varies by Application.

5 Different Teams and Organizations .. Impacts of Outsourcing .. Features of Unlinked Systems .. Maintaining data Silos Business Process Issues .. Measuring Performance with Business Partners .. Case Study 2 Impact of Mergers and Acquisitions .. Large Organizations Multiplying the data Silos Issues .. Multiple Countries .. Mergers and Acquisitions .. Multiple Business Units .. Multiple Financial Accounting Applications .. IT Strategies .. Summary .. 883 The MDM Business Case and the MDM Program Assessment.

6 The SAP NetWeaver MDM Business Case .. MDM Core Services .. Uniform, Consistent Master data Processes .. Lifecycle Management Processes .. Corporate Linkage and Legal Entity Hierarchies .. Reconciling and Reporting Across the Master data Silos .. Reconciliation and Reporting Issues .. The Record of Reference in the Absence of MDM .. The Business Value of MDM for Reconciliation and Reporting .. 1 Financial and Legal Compliance .. 1 SOX Section 302 Corporate Responsibility for Financial Reports.

7 1 SOX Section 404 Management Assessment of Internal Controls .. 1 SOX Section 409 Real-Time Issuer Disclosure .. 1 Integrating MDM with the Major Business Areas .. 1 Financial Accounting Integration .. 1 05223 88/5/08 10:55:01 Supply Chain Management Integration .. 1 Customer Relationship Management Integration .. Business Intelligence Integration .. Corporate Integration .. IT and data Management .. 1 Summarizing the MDM Business Case by Organizational Element .. 1 Obstacles to MDM Adoption One More Master data System to Maintain.

8 1 The Obstacles to MDM .. 1 Overcoming the Obstacles .. 1 Setting Up MDM Governance The Role of the MDM Steering Board .. 1 The MDM Business Partner Scorecard .. MDM Phase 1 .. MDM Phase 1 Program Assessment Scorecard .. MDM Phase 2 .. 1 Two or More Live Systems Linked to MDM .. 1 MDM Contains 95% of All Business Partners Within a Company .. 1 MDM Is Consolidated into a Large Business Intelligence Warehouse Solution .. 1 Business Users Are Searching the MDM Yellow Pages to Understand the Business Partner s Corporate Structure.

9 1 MDM Is Consolidated into 80% of Applications .. 1 All Spend data Is Tracked and Classified .. 1 Corporate Purchasing Controls Are Implemented .. 1 Credit Risk Management Programs Use the MDM and D&B Corporate Legal Entity Structures .. 1 MDM Is Integrated into 95% of Systems .. 1 Centralized MDM Processes Are Implemented Groupwide .. 1 Summary .. 1304 The Dun & Bradstreet Services .. Dun & Bradstreet Services .. How D&B Maintains Company data .. The D&B D-U-N-S Number Defined .. 1 32223 98/5/08 10:55:01 D&B Worldbase Database.

10 1 D&B Corporate Linkage .. 1 D&B Lifecycle Management Processes .. 1 D&B Entity Matching .. 1 D&B and Financial and Legal Compliance .. 1 D&B Maintenance of Joint Venture Corporate Linkage Structures .. 1 The Dun & Bradstreet SAP NetWeaver MDM Enrichment Architecture .. 1 Dun & Bradstreet Implications for an Organization .. 1 Architecture Principles in Using D&B External Services .. 1 The D&B D-U-N-S Number as a Unique Key .. Persuading Local Business and System User Groups .. Measuring D&B Entity Matching Progress.