Data Quality Management in an SAP Landscape

(1)

(2)

Disclaimer

This presentation outlines our general product direction and should not be relied on in making a

purchase decision. This presentation is not subject to your license agreement or any other agreement

with SAP. SAP has no obligation to pursue any course of business outlined in this presentation or to

develop or release any functionality mentioned in this presentation. This presentation and SAP's

(3)

Gartner Magic Quadrant for Data Quality Tools

www.sap.com/campaign/na/usa/Gartner_Data_Quality/index.html

SAP ranked as a

LEADER

in the

“Gartner Magic Quadrant for

Data Quality Tools”.

Magic Quadrant for Data Quality Tools

(4)

SAP SAP Enterprise Information Management (SAP EIM) SAP Data

Services SAP Data Quality Management (SAP DQM) DQM for SAP

SAP Data Services

SAP Information Steward

SAP Data Migration

SAP Master Data

Governance

SAP NetWeaver Master

Data Management

SAP Content Management

Solutions

SAP Information Lifecycle

Management Solutions

Etc.

ETL

Data Quality

Profiling

Text Analytics

Etc.

DQM for SAP

DQM SDK

Etc.

SAP Information

Management (IM)

SAP Data Services

SAP Data Quality

Management

(SAP DQM)

DQM for SAP

Utilizes SAP DQM’s

market-leading address cleansing,

(5)

Human

Input

SAP Data Quality Management for SAP solutions

Ensures High-Quality Data in All Applications

SAP

ERP/CRM/MDG

Data

Quality

External

Systems

SAP Data Quality

Management, version for SAP

solutions, provides a

prepackaged native

integration

of data quality

best practices within the SAP

Customer Relationship

Management (SAP CRM),

SAP Enterprise Resource

Planning (SAP ERP) and SAP

Master Data Governance

(SAP MDG) environments.

Enforce

Dat

(6)

Verify

Improve

Real-time data validation

(address reference data available

for 230+ countries)

Batch data cleansing

(ensure ongoing data accuracy

and completeness)

Duplicate record detection

(Potential duplicates are identified

and tracked for best record

resolution)

Clearer, more efficient customer

segmentation

(with the ability to match on

marketing attributes for SAP CRM)

Pre-built best practice data quality

templates

(tuned specifically for SAP ERP,

SAP CRM, and SAP MDG apps)

Detect pre-existing records during

data loads

(Prospect lists, trade show leads,

webinars, etc.)

Seamlessly support key data quality best practices

Data Quality Management, version for SAP Solutions (DQM for SAP)

Improve the quality of customer, partner, and supplier data from within SAP ERP, SAP CRM, and SAP MDG applications by

utilizing SAP DQM’s address cleansing and matching capabilities

(7)

Cleanse and enhance, detect duplicates

Data quality capabilities available in real time

Address cleansing and enhancement



Improves productivity

–

Minimal data entered, missing elements added

–

Parsing corrects misfielded data

–

Entry is cased, no need to retype / correct



Suggestion lists prompt for additional content after minimal information entered



Address reference data for 230+ countries regularly updated, ensures data stays relevant



Ability to review and accept (or not) a validated address

o

Validation results can be overridden in accordance with customer preferences



Geocoding for Business Partner Data

Duplicate Checking



Prevent new duplicates from entering system



Likely duplicates tracked in Cleansing Cases, for later review and resolution

(8)

Automatically completes and corrects entries, then

presents to user for approval

(9)

Previously unknown entries are identified, before another duplicate

can be created

(10)

(11)

The real world is changing, your data as well?

Cleanse and update address information when reference data is updated

Quarterly Adjustment Reports



Automates batch data cleansing within SAP



Periodically refresh existing accounts’ address data e.g. after reference data updates



Neurottstr.  Dietmar-Hopp-Allee



Provides reports to display addresses for review prior to committing to database

(12)

Closer Look into the Batch Address Reviewer Report

(13)

Batch Address Error Report

(14)

Stay clean with your internal database over time

After external data is loaded or existing data is updated by batch processes

Batch Matching reports



Identify potential duplicates

–

After account addresses are

periodically updated, often new

relationships are found

o

Existing record had old address writing,

in last 3 months a record with new

address writing has been created

–

Batch process can be defined to

match within Index Groups (BUT000,

KNA1 or LFA1) only

–

Mark groups of duplicate candidates

for later review via Cleansing Case

routines.

(15)

(16)

Support external list upload into SAP CRM

Match incoming records from list against CRM Business Partners

External List Management Detect

pre-existing records during data

loads



Prospect lists from Service Bureaus,

leads gathered during trade shows,

webinars



When a file upload to SAP CRM is

executed DQM for SAP detects if lead

already exists during SAP CRM’s ELM

load, before a new prospect is created



Leverage additional marketing attributes

as matching criteria



SAP CRM then allows processing the

identified duplicate records generated by

DQM, version for SAP solution

integration

(17)

What is SAP Master Data Governance (SAP MDG)?

SAP Master Data Governance

Out-of-the-box, domain-specific governance applications built on SAP Business

Suite to centrally create, change and distribute master data

Data

Maintenance

Validation &

Data Quality

Approval

Business Logic

Information Mgmt

Data Integration & Quality

External

Services

(18)

Data quality in SAP MDG: Supplier/customer data models

Out-of-the-box best practices for Address Validation and Duplicate Checks, similar to SAP ERP and

SAP CRM



Address cleansing and enhancement



Duplicate detection



Identify duplicates based on user-specified match criteria/thresholds; preventing new duplicates from entering the system, similar to

SAP ERP and

SAP CRM systems.

(19)

Data quality in SAP MDG - Custom searching/look-up

Provides the open framework to perform duplicate checks within any data model using SAP Data

Services.



Open framework for specifying “match code” fields from SAP GUI (i.e. match break-keys)



“Customizable” match fields



Specify Fields that need to be matched on from SAP GUI.

For example: MDG-Material

Specify “Match Code” – Material data model

Match Fields Settings

(20)

How Does the Data Quality Management Solution Work?

SAP

Cl

ient

Int

erf

aces

SAP CRM /SAP ECC/SAP MDG

RFC Server(s)

_{SAP Data}

Services

4.x

Data Quality

Central Rules

Repository

Postal Validation

Reference Data

(subscription license) S B O P B A dIs f or P V (CRM,E CC,MDG -S )+ S B O P B A dIs for DE S ( CRM,E CC)

G

at

ew

ay

Bus

ines

s

Address

Serv

ic

es

/FLDQ/

RFC

1

RFC

2

RFC

3

DQM for SAP Solutions includes:

 DQM Business Add-Ins – prebuilt software to enable address cleanse, duplicate check, and matching inside SAP system



Includes custom ABAP code, Views, Tables, specific for data quality activities

 DQM’s RFC Server – conduit for data to DS and back again

 Pre-built Data Services jobs – specifically tuned for SAP real-time & batch processing, fields, & tables

 Data Quality Management Premium – which is licensed for use only within SAP CRM, SAP ERP, SAP MDG

(21)

Benefits of SAP Data Quality Management, version for SAP

Solutions

Enhances Data Integrity within your

system

Streamlines Workflows to Boost

Productivity

Helps Establish and Maintain a

Single View

Achieve Operational Efficiency

 On-entry data validation and duplicate prevention



_{Periodic data cleansing processing to ensure}

ongoing data accuracy and completeness

 Reduce redundant work and manual data

cleansing



_{End user productivity through use of native UI and data}

entry validation

 Enables trustworthiness of data from data entry to

reporting via duplicate record detection

Reduce costs by eliminating downstream data cleansing

tasks

(22)

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG.

The information contained herein may be changed without prior notice.

Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.

National product specifications may vary.

These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and

SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth

in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and

other countries.