OpenSAP s4h8 Week 2 All Slides

Week 2: Features to Enhance Data Migration

Unit 1: Getting Started with the Migration Object Modeler

Getting Started with the Migration Object Modeler Recap: SAP S/4HANA migration cockpit

Migration cockpit is embedded and exclusively delivered in SAP S/4HANA Migrates data from non-SAP and SAP systems to SAP S/4HANA

SAP S/4HANA

Predefined content and mapping for each migration object reduces migration costs and time High data quality and consistency due to automated mapping No programming required by the customer Easy and safe migration through guided activities

* only for on-premise

Flexible integration of custom data © 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC

2

Getting Started with the Migration Object Modeler Migration object modeler – Designed to integrate custom data Migration object modeler is part of the SAP S/4HANA migration cockpit Design functionality to easily integrate custom objects and enhancements

On-Premise SAP S/4HANA

Integration of newly created objects ▪ Custom objects ▪ SAP standard objects that are not yet in the scope of the SAP S/4HANA migration cockpit Customer-specific enhancements (e.g. add new fields) to SAP standard objects delivered with the SAP S/4HANA migration cockpit

Available for on-premise

© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC

3

Getting Started with the Migration Object Modeler Migration object overview

To start the migration object modeler you use transaction LTMOM. NOTE: To run the necessary transaction your user needs the following role: SAP_CA_DMC_MC_DEVELOPER


4

Getting Started with the Migration Object Modeler Demo

D E MO


5

Getting Started with the Migration Object Modeler Rules You can use rules to change the values that are migrated from source fields to target fields. The different supported rules are as follows: field-based rules, event-based rules, and internal rules.

Field-based rules: can be used to change the value of a target field during the migration. Event-based rules: custom coding can be inserted at predefined points of processing an event (for example at Start of Loop or Start of Record). Internal rules: can be called by field-based rules or eventbased rules. This allows you to separate code into different modules, which can then also be shared by other fieldbased rules or event-based rules.


6

Getting Started with the Migration Object Modeler Translation objects A translation object defines how values from a specific field in the source system must be translated to target values during the data migration. There are objects, for example profit centers, company codes, and country keys that have identifiers in the source system that do not correspond to the identifiers in SAP S/4HANA.

Example The following values from the Country field in the source system must be translated to different target values: Germany  DE United Kingdom  UK America  US In this case, you create a translation object called Country, and assign it to a field-based rule or an internal rule and assign the rule to the corresponding target field.


7

Getting Started with the Migration Object Modeler Additional functionality

Information

Generate Runtime Object

Display Generated Function Group

▪ Generate Runtime Object: In this activity, the application generates the programs required to read data from the source system and to transfer data to SAP S/4HANA. ▪ If required, you can view the function modules (internal SAP programs) that facilitate the transfer of data to the SAP S/4HANA system. To view the function modules, choose Display Generated Function Group. ▪ To view additional information and documentation on the migration object modeler you can choose Information icon.


8

Getting Started with the Migration Object Modeler What you’ve learned today & outlook

Different areas of the migration object modeler: ▪ Source structure ▪ Target structure ▪ Structure mapping ▪ Field mapping ▪ Rules and translation objects

Outlook: Extending delivered content using the example of customer master data


9

Thank you. Contact information: [email protected]

© 2017 SAP SE or an SAP affiliate company. All rights reserved. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company. The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors. National product specifications may vary. These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP or SAP affiliate company 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. In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation, and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platform directions and functionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reason without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, and they should not be relied upon in making purchasing decisions. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. All other product and service names mentioned are the trademarks of their respective companies. See http://global.sap.com/corporate-en/legal/copyright/index.epx for additional trademark information and notices.

Getting Started with the Migration Object Modeler Source structures Under Source Structures, you can adjust the source structure so that your data can be transferred to the SAP S/4HANA system Example: You can add a new field, and specify the relevant information for the field.


Choose ‘Insert Field’

12

Getting Started with the Migration Object Modeler Target structures Under Target Structures, you can get an overview of the target structures associated with the migration object Structures can be single fields, multiple fields, or tables Example: Before you add a new field to the source structure, you can determine which target structure the source field should be mapped to.


13

Getting Started with the Migration Object Modeler Structure mapping Under Structure Mapping, you can check how the source structure is mapped to the corresponding target structure As a prerequisite, the source structure must be mapped to a target structure before you can map the fields of the source to the target structure (see Field Mapping)


14

Getting Started with the Migration Object Modeler Field mapping Under Field Mapping, you can map fields from the source structure to fields in the target structure Simply drag the relevant field from the right-hand side to the target structure field on the left-hand side

If a field from a source structure has been mapped to a target field, the system displays a green icon, and a red icon if it has not been mapped


Filter for mapped/ unmapped fields

15


Unit 2: Extending Pre-delivered Content Using the Migration Object Modeler

Extending Pre-delivered Content Using the Migration Object Modeler Recap: Migration object modeler – Designed to integrate custom data

Migration object modeler is part of the SAP S/4HANA migration cockpit Design functionality to easily integrate custom objects and enhancements

On-Premise SAP S/4HANA

Integration of newly created objects ▪ Custom objects ▪ SAP standard objects that are not yet in the scope of the SAP S/4HANA migration cockpit

Customer-specific enhancements (e.g. add new fields) to SAP standard objects delivered with the SAP S/4HANA migration cockpit Available for on-premise


2

Extending Pre-delivered Content Using the Migration Object Modeler What you’ll learn today

Customer master data (customer migration object): ▪ Extending source structure with field “Express station” (BAHNE; char 25) ▪ Applying field mapping ▪ Downloading changed template

▪ Filling new template and uploading to SAP S/4HANA ▪ Checking created business partner with additional information on Express station


3

Extending Pre-delivered Content Using the Migration Object Modeler Demo

D E MO


4

Extending Pre-delivered Content Using the Migration Object Modeler What you’ve learned today & outlook

▪ Extending file template for migration object customer with field “Express station” (BAHNE) ▪ Downloading changed template ▪ Filling new template and uploading to SAP S/4HANA ▪ Checking created business partner with additional information on Express station

Outlook: Creating your own migration object to upload custom data


5


© 2017 SAP SE or an SAP affiliate company. All rights reserved. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company. The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors. National product specifications may vary. These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP or SAP affiliate company 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. In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this docume nt or any related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation, and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platform directions and functionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reason without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, and they should not be relied upon in making purchasing decisions. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trade marks of SAP SE (or an SAP affiliate company) in Germany and other countries. All other product and service names mentioned are the trademarks of their respective companie s. See http://global.sap.com/corporate-en/legal/copyright/index.epx for additional trademark information and notices.


Unit 3: Creating Your Own Migration Object Using the Migration Object Modeler

Creating Your Own Migration Object Using the Migration Object Modeler Recap: Extending pre-delivered content using the migration object modeler

Adding additional fields to delivered migration content (example: “Express station” field (BAHNE) for customer master data) Business Partner


2

Creating Your Own Migration Object Using the Migration Object Modeler What we’ll learn today

Creating your own migration object to fill data in table SAIRPORT Table SAIRPORT

Function module used to fill table SAIRPORT: Z_SAIRPORT_CREATE


3

Creating Your Own Migration Object Using the Migration Object Modeler Demo

D E MO


4

Creating Your Own Migration Object Using the Migration Object Modeler SAP S/4HANA migration cockpit – Further information Guided Demo:

SAP S/4HANA Migration Cockpit (MC)

Migration Application Help:

http://help.sap.com/s4hana On-Premise

SAP S/4HANA 1610 FPS02 – direct link

S/4HANA Cloud

SAP S/4HANA Cloud 1705 – direct link

Click-Through Demos: ▪ Introducing SAP S/4HANA Migration Cockpit (based on 1610 FPS02) ▪ Working on a migration object with the migration object modeler ▪ Adding fields to a migration object ▪ Creating a new migration object Available in SAP Learning Hub:


https://blogs.sap.com/2017/03/12/key-and-end-user-enablement/ →

Scroll down to the Getting Started Tutorials → Select “S/4HANA Data Migration (New)”; SAP Learning Hub subscription required 5

Creating Your Own Migration Object Using the Migration Object Modeler What we’ve learned today & outlook

Creating your own migration object to fill table SAIRPORT ▪ Assigning function module Z_SAIRPORT_CREATE ▪ Creating source structure

▪ Applying structure mapping ▪ Applying field mapping

▪ Checking template-file

Outlook: ▪ Rapid data migration and data quality features


6




Unit 4: Rapid Data Migration and Data Quality Features

Rapid Data Migration and Data Quality Features What’s dirty data costing you?

“I know we have some data quality problems, but we’re still making money, so how bad can it be?”

You wouldn’t run your car on dirty oil, so why are you letting your business run on questionable data?

Data quality does matter.

Read the blog at https://blogs.sap.com/2013/03/12/what-is-dirty-data-costing-you/ © 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC

2

Rapid Data Migration and Data Quality Features Why data quality matters – Bad data quality implications and root cause Good data quality is a prerequisite for operational and analytical applications. Without data quality processes… ▪ It is difficult to determine the right target audience for marketing campaigns

▪ Inaccurate information causes delayed shipments and lower customer satisfaction ▪ Costs are high due to account duplications, and response-rate is low

▪ Reporting uses wrong data – leading to incorrect conclusions and bad decisions

Sources of Data Quality Problems

?

Data entry by employees

75%

Inconsistent definitions of common terms

75%

Data migration or conversion projects

46%

Root Cause

Mixed expectations by users

External data

38%

26%

Data entry by customers System errors

25%

Changes to source systems Other

40%

20% 7%

▪ Sales representatives cannot identify relevant accounts Based on 632 respondents who could select multiple answers. TDWI Research Survey 2006 © 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC

3

Rapid Data Migration and Data Quality Features SAP Data Services – Product view

SAP S/4HANA SAP S/4HANA Cloud


4

Rapid Data Migration and Data Quality Features Data quality example – Cleansing party data Parse & Standardize

Input Field1: Field2: Field3: Field 4:

Correct

Match

Consolidate

Bob oldstead 175 Riviington Ave suite 2 Manhatten, new yourk 10002 First Name: Last Name: AddressL1: AddressL2: AddressL3:

Bob Oldstead 175 Riviington Ave suite 2 Manhatten, new yourk 10002

First Name: Last Name: AddressL1: AddressL2: City: State: Zip Code: Robert E. Oldstead New York, NY 10002 [email protected] 847 442-5555 © 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC

First Name: Middle Name: Last Name: AddressL1: AddressL2: City: State: Zip Code: Longitude: Latitude: Phone: Email:

Bob Oldstead 175 Rivington Ave Suite 2 New York NY 10002 Bob Oldstead , … Robert E. Oldstead , …

First Name: MiddleName: Last Name: AddressL1: AddressL2: City: State: Zip Code: Phone: Email:

Enrich

Robert E Oldstead 175 Rivington Ave Suite 2 New York NY 10002-2517 40.7325525 -74.004970 (847) 442-5555 [email protected]

Robert E Oldstead 175 Rivington Ave Suite 2 New York NY 10002 (847) 442-5555 [email protected] 5

Rapid Data Migration and Data Quality Features Rapid data migration – Overview

RAPID DATA MIGRATION

1

2

ANALYSIS

3

EXTRACT

4

CLEAN

5

VALIDATE

6

LOAD

RECONCILE

Governance and Visualization Rapid data migration gives you what you need: A solution you can trust Easy to use data migration solution to reduce project risks and speed implementation

▪ Reusable tools for ongoing data governance © 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC

▪ Pre-defined content and rules

▪ SAP and partner services 6

Rapid Data Migration and Data Quality Features Rapid data migration – Architecture

Legacy Data Environment

Data Staging and Test Environment Performance Analysis

Target Environment

Dashboards and Business Reporting

Staging Area

Flat Files/ Excel

Data Services Platform

Cleanse

Databases

Applications

Loading

Pre-Built Load Routines for SAP S/4HANA Objects

Validate & Load

Transform

Name Parsing Extract & Address Parsing & Correction Profile Material/Product Parsing Matching

Transform Data into SAP S/4HANA Structure

Business Validation Rules Automatic SAP Config Validation

Reconciliation

XML © 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC

SAP S/4HANA API

SAP S/4HANA SAP Configuration Extraction

Transparency, Communication and Governance 7

Rapid Data Migration and Data Quality Features Rapid data migration for SAP S/4HANA (on-premise) with SAP Data Services

D E MO


8

Rapid Data Migration and Data Quality Features Resources Download Solution (RDM for SAP S/4HANA On-Premise) – http://rapid.sap.com/bp/RDM_S4H_OP Data Migration Blog – https://blogs.sap.com/2012/05/11/a-better-way-to-migrateyour-sap-data-with-rapid-deployment-solutions/

SAP S/4HANA Migration Blog – https://blogs.sap.com/2016/06/21/how-to-migrate-to-saps4hana/

https://www.sap-press.com/3666/

Demo Recording (Extended Version) – http://www.youtube.com/watch?v=jHbBxtLR98c

The Data Migration Guys – https://blogs.sap.com/2015/08/05/introducing-the-datamigration-guys/ © 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC

https://www.sap-press.com/4019/ 9




Unit 5: Additional Features and Outlook

Additional Features and Outlook Migrate quality data for a truly successful go-live

When you migrate your data to SAP S/4HANA, will you simply push your existing data problems to the new system? ▪ Duplicate customer and vendor records ▪ Incomplete and incorrect master data ▪ Incorrect address data

If you do, you will have more problems after migration

Leave the garbage behind when you move.


2

Additional Features and Outlook Crisis = “Danger” + “Opportunity”?

It is said that the Chinese character for “crisis” is the combination of the characters for “danger” and “opportunity” While being fully aware of the risks associated with data migration projects, you should also be cognizant of the opportunity that a data migration project represents: ▪ The opportunity to improve data en route – go live on your new system with better data than you had in the old system

▪ The opportunity to use the data migration project to kick-start an overall information governance program that ultimately makes your business smarter, leaner, better ▪ The opportunity to master data migration as a business competency to support mergers and acquisitions, IT projects, and business transformation initiatives


3

Additional Features and Outlook Data quality solutions from SAP Data Quality Management, Microservices ▪ Data quality services in the cloud ▪ Built on SAP Cloud Platform ▪ Consumption-based pricing ▪ Pre-built integrations with SAP applications ▪ Integration into any application on-premise or cloud

Cloud

Continuous Monitoring

SAP Data Services ▪ Data integration platform for heterogeneous environments ▪ Data profiling, transformation, and data cleansing

Match

Enhance

▪ ▪ ▪ ▪

Measure

Consolidate

SAP-agnostic

Agile Data Preparation (SaaS)

Self-service data prep application Enrich, blend, augment data Harmonize disparate sources Share and collaborate on data sets

Analyze

Data Quality Validate/ Correct

SAP HANA-based Parse

Standardize

Agile Data Preparation (On-Premise) ▪ Same as above but different deployment model

SAP Information Steward

▪ ▪ ▪ ▪ ▪ ▪

Data assessment/profiling Data quality policies and business rules Data quality scorecards Data quality financial impact Lineage and impact analysis Business glossary


SAP HANA, smart data quality & smart data integration ▪ Native features within SAP HANA platform ▪ Can be integrated into SAP HANA applications ▪ REST API for non-SAP HANA applications On-premise 4

Additional Features and Outlook SAP Information Steward complements SAP Data Services Discover

Define

Understand & catalog enterprise data

Rules and ownership

Business Business users can see how their information measures up against information governance rules and standards


Assess Overall data quality

Monitor

Improve

Quality continuously

Data quality & governance

IT IT can share data quality metrics with business users and involve them in owning the data problem

5

Additional Features and Outlook What is SAP Agile Data Preparation?

▪ Perform data discovery and profiling ▪ Enrich, blend, and augment data ▪ Harmonize disparate data sources ▪ Share and collaborate prepared data sets

SAP Agile Data Preparation is a self-service data preparation application that helps multiple user roles explore, integrate, and transform raw data into actionable information. It provides users with greater agility to respond to new data sources, business requirements, and market opportunities.

Combine data sources and find hidden patterns

Transform data with one-click fixes to ensure data trust

Share data discoveries and take action

Export prepared data sets to any analytical tool, including SAP Analytics & BI solutions


6

Additional Features and Outlook SAP Agile Data Preparation – Key capabilities

1

SAP Agile Data Preparation SAP BW

Analyst, Scientist, Steward

SAP Business Suite

Combine

Explore

2

Shape

Ingest data from variety of sources

Profile data

Enrich SAP HANA

Clean

ingest

distribute

3 SAP HANA

De-dup.

Databases

IT

Govern

4 Delimited Files

Delimited Files

5 Sources


Prepare

Targets

Combine, shape, enrich, or cleanse data

Output data for downstream uses

IT Governance team – analyze and optimize user processes 7

Additional Features and Outlook SAP Agile Data Preparation

D E MO


8

Additional Features and Outlook Transitioning to SAP S/4HANA? Get your guide for the road ahead! It’s time to start planning your SAP S/4HANA transition! In this book, you'll learn about the SAP S/4HANA transition scenarios to find your way to move to SAP S/4HANA. Step-by-step instructions will help you prepare, implement, and integrate SAP S/4HANA. In this book, you'll learn about:

▪ SAP S/4HANA – The basics  The challenges of the digital transformation  Cloud, on-premise, and hybrid scenarios  SAP Business Suite vs. SAP S/4HANA

▪ SAP S/4HANA – The Transition Scenarios  Step-by-step guide moving to SAP S/4HANA Cloud  Step-by-step guide moving to SAP S/4HANA

 SAP S/4HANA migration cockpit  Integrate SAP S/4HANA in your system landscape  Central Finance © 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC

Migrating to SAP S/4HANA ▪ www.sap-press.com/4247  22% off with code OPENSAPMIG (expires March 2018)

▪ www.sap-press.de/4213 (German) 9



OpenSAP s4h8 Week 2 All Slides

Recommend Documents