Sap Data Migration Along With Sap Data Services (Bods)

The course covers SAP Data Migration strategies to load data in S4HANA using BODS, IDoc, BAPI, LSMW and LTMC

What you'll learn

After completing this course, you will become SAP Data Migration consultant.

Be able to take BODS Application development certificate exam.

Learn SAP Data Migration approaches.

Learn various SAP Loading methods like IDoc, LSMW, LTMC and BAPI.

Extract from SAP system.

BODS Performance tuning.

best practice on various SAP objects like Material Master, Customer Master, Vendor Master etc

Real time Data Migration project scenarios

Requirements

No any background knowledge required. however, SQL and a Programming Language knowledge is good to have.

Description

The course will prepare the beginners who are willing to make career into SAP Data Migration. The course covers SAP Data Services (BODS) as well in depth. Here is the course that you will be learning throughout the course. It mainly focuses on the SAP Data Migration from scratch until go-live of a project. You will learn what are the things required to setup Data Migration project, various phases of data migration like working on Mocks and learn the cut-over to make project go-live.After taking this course, the learners will be able to work as SAP Data Migration Consultant or as SAP Data Services (BODS) developer.In the end of the course the certification path will also be discussed. OverviewOverview of the SAP Data MigrationOverview of the Data servicesData services Architecture on single and distributed environmentBODS ConceptsCreating the repository (Local, Central repository).Exploring the menu options in the designer.Creating the project, Job flow, Data flow, Workflows etc., defining different types of Data stores (Source and destination data stores).Use data store and system configurations.Defining file formats for flat, Excel.Working with Batch JobsCreating Batch JobsWorking with objectsCreate a data flowAdding the Query transform to the data flowUse target tablesExecute the jobWorking with BODS TransformsQuery TransformCase TransformMerge TransformValidation TransformRow Generation TransformValidation TransformSQL TransformPivot TransformUsing Functions, Scripts, and VariablesDefine built-in functionsDecode()nvl()gen_row_num()gen_row_num_by_group()Aggregate function – count, min, maxcurrent_system_configuration()substr()replace_substr() help meword_ext() -host_name( )job_name()rpad() –lpad()rtrim_blanks()ltrim_blanks()Use functions in expressionsUse variables and parametersCreate Custom functionsUse Data Services scripting languageSetting up Error HandlingSet up recoverable workflowsSetting up Exception HandlingTry/Catch TechniquesIF ConditionalWhile-Loop ImplementationMulti-User Environment (Local Repo Vs Central Repo)SAP ECC / S4HANA IntegrationWorking with IDocWorking with LSMWWorking with LTMC / LTMOM

Overview

Section 1: Introduction to SAP Data Migration and SAP Data Services (BODS)

Lecture 1 Introduction to the course

Lecture 2 Introduction to SAP Data Migration

Section 2: SAP Data Services (BODS) Concepts and Setup

Lecture 3 Creating the repository (Local, Central repository).

Lecture 4 Exploring the menu options in the designer

Lecture 5 Create Datastore and setup

Lecture 6 Create System Configuration and setup

Lecture 7 Defining file formats for flat, Excel

Lecture 8 BODS Object Hierarchy

Lecture 9 S4HANA Overview

Section 3: Development of Extraction Program

Lecture 10 Preparation of Data Migration program

Lecture 11 Develop the Extraction program.

Section 4: Working with transformations and validations

Lecture 12 Transformation - Working with Query Transform to map and transform the fields.

Lecture 13 Transformation - Dealing with Internal and External number ranges

Lecture 14 Transformation - Checking of the Validation rules

Lecture 15 Transformation - Apply the Validation rules (Part 1)

Lecture 16 Transformation - Apply the Validation rules (Part 2)

Lecture 17 Transformation - Generate Invalid Report

Lecture 18 Transformation - Generate Preload Report

Section 5: Start loading the data in the target system

Lecture 19 Load data using IDoc

Lecture 20 Load data using LSMW

Lecture 21 Load data using the LTMC file based approach

Lecture 22 Load data using LTMC staging table based approach

Lecture 23 Add fields in LTMC template or staging table using LTMOM

Lecture 24 Generate Postload report

Section 6: Miscellaneous

Lecture 25 Scripting in BODS

Lecture 26 Functions and Variables

Lecture 27 Pivot Transform

Lecture 28 Job Recovery and Exception Handling

Section 7: Sharing BODS code

Lecture 29 Import and export the code

Anyone who wants to build career into SAP Data Migration,Anyone who wants to learn SAP Data Services (BODS),an ABAP developer wants to enhance skills into Data Migration,a database developer who wants to switch to BODS development,a BODS Admin who wants to become BODS developer.