Marvels of Material Master Data
This presentation is the property of its rightful owner.
Sponsored Links
1 / 41

Peter Aynsley-Hartwell Utopia Inc. PowerPoint PPT Presentation


  • 62 Views
  • Uploaded on
  • Presentation posted in: General

Marvels of Material Master Data Solved with SAP Business Objects. Carla Cook Suncor (C Cubed Information Services Inc). Bill Towsley Suncor. Peter Aynsley-Hartwell Utopia Inc. What We Will Cover. Suncor Overview The Data Migration Project The Tools & Approach

Download Presentation

Peter Aynsley-Hartwell Utopia Inc.

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Peter aynsley hartwell utopia inc

Marvels of Material Master Data

Solved

with SAP Business Objects

Carla Cook

Suncor(C Cubed Information Services Inc)

Bill Towsley

Suncor

Peter Aynsley-Hartwell

Utopia Inc.


Peter aynsley hartwell utopia inc

What We Will Cover

Suncor Overview

The Data Migration Project

The Tools & Approach

The Reality and The Results

Key points to Take Home

Questions


Peter aynsley hartwell utopia inc

Suncor Energy

Suncor Energy is the largest Canadian Oil and Gas company

  • 300,000 plus bbls/day synthetic crude oil

  • 4 refineries totaling 450,000 bbls/day

  • 1,500 plus retail and wholesale outlets

  • 350 different lubricant and specialty fluid products

  • Implemented SAP enterprise-wide in 2006

  • Owner of Petro-Canada (SAP since 1993)


Data migration project

Data Migration Project


Peter aynsley hartwell utopia inc

Overall Scope

  • Integrate former Petro-Canada processes and data into Suncor SAP

  • Legacy Systems


Peter aynsley hartwell utopia inc

Overall Scope

  • SAP Modules

    • FI/CO, MM, SD, PM,PS, HRM, CRM, SRM

  • 80 Objects requiring ETL (Extract Transform Load)

    • 30 Objects managed with SBO Data Services

  • Total timeframe of 13 months with 3 staged releases

    • Systems Integration – Deloitte

    • Data Migration – Suncor/SAP/Utopia

    • SAP Support - IBM

Slide 6


Project timelines and sbo data services landscape

Project TimelinesandSBO Data Services Landscape

The Data Migration Project

Slide 7


Peter aynsley hartwell utopia inc

I&O

Montréal

Edmonton/Burrard (non-distribution)

R3 go-live (8/2)

M&D Lubes

R3 Integration Testing

(2/11)

BUILD

Deploy

(3/18)

QA1

R3 ITC1

R3 ITC2

R3 UAT

(6/3)

I&O go-live (10/3)

(7/1)

(4/15)

QA2

Montréal go-live (10/31)

S1

S2

S3

FRICEW Build – FUT Readiness

100%

Development (1/28)

(6/3)

QA3

Priority 3

(12/15)

Edmonton go-live (1/30)

S1

S2

S3

(2/11)

Para.

Functional Unit Testing

(7/1)

Perf.

Data Conversion Build / Cleansing

Data Cleansing

2nd Data Trial – All Objects (~12/17)

ITC Prep.

(3/25)

BPP Updates/Creation

Training Devel. Complete

Change, Training & Communication

(1/28)

HR PR1

HR PR2

HR PR3

Release System Freeze

Security Build

Security Testing (increasing scope)

Legacy PC to Suncor BW Migration

SPIM Gate-4

To Be Data Model

Master Queries

WB/Query Ration./Dispo.

LPC User WB/Query Build/Test

R2B PSSP Build (Sustain.)

R2B PSSP Testing (Sustain.)

R2B PSSP Deploy (Sustain.)

HR Build R3/R4

FUT Prep.

HR FUT

2 CCD’s & 70% Development (1/21)

R2B HR GL Prep

100% Config & Development (2/28)

8

Key Milestone / Interim Milestone/

Deliverable Completion Dates

Phase Completion Milestone Dates


Peter aynsley hartwell utopia inc

DEV

QA

PROD

LPC

Prod Copy

IQ2

LPC Prod

IPR

Suncor Prod

PR1

LPC Prod

IPR

Suncor Prod

PR1

Extract data

to be moved

Extract data

to be moved

Extract data

to

de-duplicate

Extract data

to

de-duplicate

Extract data

to be moved

Load converted & de-duplicated data

Extract

Configuration

Extract

Configuration

Extract

Configuration

Oracle DB/Server

500GB

Oracle DB/Server

500GB

Oracle DB/Server

500GB

Load converted & de-duplicated data

Load converted data

SAP Q

SR4

SAP Q

SR4

Final Build

SAP Q

DR4 Client

305

Landscape - SBO Data flows in the Suncor Landscape

Slide 9


Data migration challenges

Data Migration Challenges

The Data Migration Project

Slide 10


Peter aynsley hartwell utopia inc

Data Migration Challenges

  • Extracting from a live production system

    • Difficult to do cleansing, de-duplication at source

  • Loading live into production landscape

    • Need to move millions of records in a short time without disrupting existing system

  • Complex data mapping

    • Source and target not nearly the same configuration


Peter aynsley hartwell utopia inc

Data Migration Challenges

  • Moving target

    • Short time frame means developing while continuing to refine data mapping spec

  • Agile ETL required

    • Needed to be able to ETL, validate, refine, repeat

  • De-duplication

  • Data cleansing after extract

Slide 12


Tools and approach

Tools and Approach

The Data Migration Project

Technology

Approach and Methodology

Organization

Slide 13


Peter aynsley hartwell utopia inc

Technology

  • SAP Business Objects Data Services

  • SAP NetWeaver MDM

  • SAP Legacy System Migration Workbench

  • SAP Standard IDOCs (Intermediary DOCument)

  • Custom ABAP programs


Peter aynsley hartwell utopia inc

Technology

The SAP BusinessObjects Data Services


Approach and methodology

Approach and Methodology

Utilised SAP Best Practices for Data Quality

  • SAP’s Enterprise Information Management (EIM) Best Practices provides a repeatable process to deliver consistent, sustainable results.

  • Implementation of business rules provides automation of key processes for the data migration process.

  • Integrate quality checks into all data touch points for on-going data governance.

  • Data Quality for all data: Customer, Supplier, Product, and beyond.

  • Manages the process throughout the entire ETL event.


Peter aynsley hartwell utopia inc

SAP

Approach and Methodology

Loading

Target Environment

Data Staging and Test Environment

Legacy Data Environment

Dashboards and Business Reporting

Performance Analysis

Staging Area

Flat Files/

Excel

Pre-Built load routines for SAP Objects

Data Services Platform

Databases

Name Parsing

Business Validation Rules

LSMW

Files

Extract & Profile

IDocs

SAP

Configuration

Extraction

Address Parsing & Correction

Automatic SAP Config Validation

Validate & Load

Transform

Cleanse

Material/Product Parsing

Matching

Applications

Reconciliation

Transform

Data into SAP structure

XML

Transparency, Communication and Governance,


Peter aynsley hartwell utopia inc

Approach and Methodology


Peter aynsley hartwell utopia inc

Organization - Data Mgmt Operational Structure


Peter aynsley hartwell utopia inc

Organization

ETL Team

Slide 20


The reality and the results

The Reality and The Results

The Data Migration Project

Why ETL?

How we utilized the tools

Benefits

What would we do differently?

Slide 21


Peter aynsley hartwell utopia inc

Sample Data Objects – why ETL


Peter aynsley hartwell utopia inc

How we utilized the tools

  • A look under the hood at the Material Master ETL

Slide 23


Peter aynsley hartwell utopia inc

Materials: Data Flow & Implementation Steps

SBO Tasks

MDM Tasks

3

PI

Import Materials into MDM via XML

Sequential updates

PC DATA

(SAP - IPR)

5

MATNR comes back

2

MDM

1

Dedupe / Match / Validate

LEIH – LEIH

HIBE – Z005, Z007, Z013, Z016

RHIB/FHIB – Z006

? - Z008

Z015 – Service masters

? - Z017?

SAP

IR4

Data

XML

SBO

LEIH

Z005

Z006

Z007

Z008

Z013

Z015

Z016

Z017

Implement scenarios below.

4

XML files on MATMAS05 format

> 1000 records each file

6

X-ref

XREF

  • Scenario #1 (update)

  • LPC Material exists in Suncor.

    • We will need to extend the Suncor Material with the PC plant

NOTES:* Neither SBO or MDM are pulling in Suncor Materials

* MDM will have no data to begin

  • Scenario #2 (Create)

  • LPC Material does not exist in Suncor

    • Material to be created and duplicate MATNRs to be added to record

Slide 24


Peter aynsley hartwell utopia inc

Slide 25


Peter aynsley hartwell utopia inc

Slide 26


Peter aynsley hartwell utopia inc

Slide 27


Peter aynsley hartwell utopia inc

The Benefits - Compare Release 1 with Release 3

  • Release 1 (July 2010)

    • ETL using ABAP and SAP MDM

      • Extract from source, transform in-flight load to MDM

      • Mapping changes required ETL re-process(14 hrs for Materials)

  • Release 3 (July 2011)

    • Utilizing SAP Business Objects Data Services and the SAP Data Migration Framework

      • Mapping changes require only a re-run of specific SBO jobs (minutes not hours)


Peter aynsley hartwell utopia inc

The Benefits - Utilized SAP Technology

  • Connect directly to SAP for extraction by OBJECT

    • Utilizes the data model table structures and relationships

  • IDOCS for Loading

    • Using standard IDOC identified inappropriate screen customizations transported into the target system


Peter aynsley hartwell utopia inc

The Benefits - Utilized SAP Technology

  • Pre-Validation of Check Values before loading

    • No requirement for trial loads to test the data

    • Automatically adjusts for configuration changes

  • Data in a common staging area

    • Easy to update and repeat if rules/requirements changed

    • Cross object validation easy

      • eg PO ->Vendor -> Material -> PIR

Slide 31


Peter aynsley hartwell utopia inc

What would we do differently?

  • Follow best practices more stringently

  • Use the end-to-end process rather than break out to “existing” custom ABAP and LSMW

  • Not allow acceptance testing to be disconnected from data loads

    • Test scenarios need to use loaded data and be flexible

  • Understand the target configuration

    • e.g. Custom user-exits on forms not supported by BAPIs


Key points to take home

Key Points to Take Home

What worked for Suncor

Slide 33


Peter aynsley hartwell utopia inc

What worked for Suncor

  • Establishing a strong data management team

  • Using standard processes and tools wherever possible

  • Using a robust ETL tool that met our key requirements of:

    • Flexibility

    • Agility

    • Repeatability


Peter aynsley hartwell utopia inc

Bill Towsley

Suncor Energy

[email protected]

Peter Aynsley-Hartwell

Utopia Inc

[email protected]

Carla Cook

Suncor Energy

(C Cubed Information Services)

[email protected]

Q&A


Peter aynsley hartwell utopia inc

March 27 – 30, 2011

Hyatt Regency Huntington Beach Resort and Spa

Huntington Beach, California


Peter aynsley hartwell utopia inc

SAP Data Migration Framework

Subhead (Arial 40 Bold)

  • Text (Arial 40 Regular)

    • Demoted Text (Arial 34 Regular)


Peter aynsley hartwell utopia inc

Slide 38


Peter aynsley hartwell utopia inc

The Reality and The Results

Slide 39


Peter aynsley hartwell utopia inc

The Reality and The Results

Slide 40


Peter aynsley hartwell utopia inc

The Reality and The Results

Slide 41


  • Login