SAP - MDM

Master data is the information that describes core business entities such as Customers, products, locations, suppliers,…. Master data typically is non-transactional data, shared by several applications, static in nature.

Master data management is the development and maintenance of the required organizations, processes and tools to ensure that every master data element …

Is captured once, on time, accurately, completely, correctly and consistently thus enabling master data quality;

Is stored in a way that guarantees integrity and a single place of reference

Is made available to those who need it, whenever they need it, both internally and externally.’

Business Drives:
- Single Version of the Truth
- Business Intelligence
- Operational Efficiencies
- Application Integration
- Compliance

Master Data Layers:
- Combined Master Data
- Master Data
- Reference Data
- Meta Data


History and Positioning at SAP
- Pre 2004: SAP MDM 3.0
- July 2004: SAP MDM-E (SAP acquires A2i)
- 2005: MDM 5.5 SP03
- 2006-2007: MDM 5.5 SP04, SP05, SP06
- 2008: MDM 7.1 (Q3)

Core MDM Scenarios
- Master Data Consolidation
- Master Data Harmonization
- Central Master Data Management

Horizontal Scenarios
- Customer Data Integration
- Product Information Management
- Improved Business Intelligence

Industry Scenbarios
- Global Data Synchronization

Embedded Scenarios
- SRM/MDM Catalog

Building Blocks












MDM Fun ctional Overview

MDM Integration
- Exchange Information between MDM and various syswtems
- Extract Data, Load Data, Distribute Data (ETL)
- Service Enabled Integration

MDM Integration Flows
















MDM Integration APIs
- ABAP, Java and COM
- Administrate MDM Servers and model repositories
- Access and modify master data
- Exposes MDM matching capabilities and workflow

MDM Web Services
- Based on SOAP and WSDL
- Provide data management capabilities (CRUD)


MDM Operations
- Toolset to Manage Master Data (Search-Edit-Change)
- Governance through Workflow


Role-based Access
- Access data stored MDM using UI

Drilldown Seach
- Powerful and efficient search capabilities
- Allows users to start with all of the items in the repository and then effortlessly zoom in on items of interest

Creation and Maintenance
- Manage data in the repositmory. (maint table and sub tables records)
- Leverage built in data management workflows to manage compliance process

Catalog Management
- Centrally manage catalogs (upload, consolidate, search) and publish the information to business processes

MDM Quality
- Toolset to Enhance Data Quality
- Normalization, Standardization, Enrichment, De-Duplication


Normalization
- Field Mapping (map an individual source field to an individual destination field)
- Value Mapping (value level mapping against the legal destination)
- Conversion (Each source value can manually or automatically be converted or reformatted)

Validations
Matching and Merging
Key Mapping (cross-system identification to ensure enterprise-wide data quality)
Enrichment (MDM sends data elements to an external data enrichment provider and receives a response containing data to be updated or inserted in a repository.)