Skip to Content

1. Overview


1.1 Introduction

The data migration from legacy system is a prerequisite and essential in many projects to execute and fulfill functional requirements. This white paper will document with snapshot in what ways data migration for material master can be achieved using Rapid Deployment Solution in SAP S/4HANA. To understand Rapid Data Migration one should have basic knowledge in SAP BODS.


SAP Rapid Data Migration with SAP Data Services enables you to migrate your data within SAP systems as Business Suite powered by HANA, ERP, SAP Business All-in-One, CRM, and SAP industry solutions for utilities. RDS contents for S/4HANA comes with 40 critical master and transactional data.


The scope of this document is to provide step by step guide for Material Master Migration to S4/HANA using RDS.


2. Rapid Deployment Solution

2.1 Overview of RDS

         

SAP Rapid Deployment Solutions is a “PACKAGED SOLUTION” that include pre-configured content, best practices, and fixed scope implementation service, resulting in fast and predictable software deployments.

For faster and quicker adoption and implementation of various products, SAP delivers Rapid deployment solution kit. RDS solutions provide you with a process framework and the tools, methods, and templates needed to execute complex migration tasks quickly, easily, and cost-effectively.

The rapid data migration to SAP S/4HANA, on premise edition allows you to extract and analyze selected data from virtually any source system.


Key features of Rapid Deployment Solution:

  • Quick response to most urgent business needs, using ready-made accelerators and solution builder tools for faster deployment.
  • Solutions are based on SAP standard templates and tools, making solution adoption easier.
  • Faster time to value.
  • Pre-configured software with in-built validity checks, eliminating the need for unwanted speculation.

Software used:

  • SAP Data Services 4.2 SP5 or above
  • SAP S/4HANA on premise edition

3. BODS setup with RDS package

3.1 Download and import RDS package

Download RDS package [Rapid data migration to SAP S/4HANA on premise edition V1.42] from SAP service market place.

https://websmp204.sap-ag.de/rds-dm2s4op

Atl files can be located under Migration_S4HANA folder in RDS package. Place all the atl files downloaded from RDS package into network drive. Make sure Network drive is created in the same server where Data Service Designer is installed.

Import all atl files one after other to SAP Data Service Designer without any password.

Pic1.jpg

After importing all atl files in SAP Data Services designer you will see 3 Projects each related to migration objects, lookup files and reconciliation. All master and transaction objects that come with RDS package can be verified under DM_BPFDM_IDOC in Local object library section.


Pic2.jpg

There are multiple tabs in local object library for projects, Datastore, jobs, Dataflow and format. Once you import datastore atl file you will see datastore is imported in local object library under datastore tab.


Data staging is an intermediate storage area used for data processing during extract, transform and load (ETL) process. There are 4 datastore in local object library which are used for lookup table and data transformation for staging.


Enter database server details by right click and edit the datastore to establish SQL server connection for all staging Datastore which contain ‘STG’.

Pic3.jpg

4. Establish connection in SAP Data Services

4.1 Datastore connection to target system

Establish datastore connection to S/4HANA target System (DS_SAP) with server details, RFC destination and working directory on SAP Server by clicking advanced tab.

Pic4.jpg

Pic5.jpg

Next step is to create SAP connection using RFC interface in Data Services management console. Click on tools and login to DS management console using S/4HANA system credentials.

Pic6.jpg

RFC connection SNDWX2SD2 to target system S/4HANA is created in SAP Data services.

Pic7.jpg

Same RFC connection should be created in S/4HANA system as well.

Pic8.jpg

4.2 S/4HANA system IDOC configuration

Creation of Logical system BOBJTFR in SALE transaction as per configuration guide provided by SAP.

Pic9.jpg

Creation of Partner Profile in WE20 for Partner BOBJTFR and Partner Type US and maintain inbound parameters for Message Type MATMAS_MASS_BAPI.


Creation of Port in WE21 for RFC destination SNDWX2SD2.


Pic10.jpg

5. Material Master Migration Demo


The below example provides step by step procedure of the material master migration process beginning with the legacy data mapping through to upload the data to target SAP S/4HANA using SAP Data Services.

5.1 Lookup table generation

The creation and management of the lookup tables are controlled by the following four jobs within the project DM_BPFDM_Lookups:

ID

Job Name

Comment

1

Job_DM_Lookups_Initialise

Performs initial setup and creation of all required lookup and management tables in the staging area

2

Job_DM_Lookups_SAPToFile

Extract the latest lookup table data from SAP target system into local text files

3

Job_DM_Lookups_FileToApp

Upload default lookup table data in the provided text files to the staging area

4

Job_DM_Lookups_SAPToApp

Extract lookup table data from SAP target system into the staging area directly

Run the following jobs this would re-create and reload the data for all tables so may take some time:

  1. Job_DM_Lookups_Initialise
  2. Job_DM_Lookups_FileToApp
  3. Job_DM_Lookups_SAPToApp

Pic11.jpg

Lookup tables are populated with data once we execute above jobs and also you can check table entries by selecting lookup table and click on view data.

Pic12.jpg

5.2 Field Mapping

Prepare the upload file as per the template named ‘Source_Files_DI_IN’ provided by SAP as part RDS package. Each worksheet of this template has fields related to different material master views to be filled as per the requirement.

Pic13.jpg

In our example we create materials with basic data view, fill the sheets Basic Data and Description of the template.

Create new excel in format tab and map the upload file location.


Pic14.jpg

Delete existing excel in dataflow DF_DM_MaterialMasterBasicView_Map and replace it with our excel file by drag and drop.


Pic15.jpg

Upload file fields and query fields are different then we need to do field mapping manually. In our case mapping will be done automatically as we are using SAP template where upload fields and query fields are same.


In query area you can see mapping details of each field is displayed by excel file name and its fieldname and this shows mapping is done for those fields.

Pic16.jpg

Similarly do it for material description and assign upload file to dataflow DF_DM_MaterialMasterDescription_Map.

Pic17.jpg

5.3 Job execution

The next step is to execute the job. First do a test run by using the below parameters without generating idocs.

$G_MaterialMasterBasicView_Req = ‘Y’

$G_MaterialMasterDescription_Req = ‘Y’

$G_GenerateIDOC_Req = ‘N’.

Pic18.jpg

Job is completed successfully without any errors.

Pic19.jpg

Execute Job by using the below parameters to generate idocs.

$G_MaterialMasterBasicView_Req = ‘Y’

$G_MaterialMasterDescription_Req = ‘Y’

$G_GenerateIDOC_Req = ‘Y’.

$G_MaterialMasterBasicView_IDOC_Req = ‘Y’

$G_MaterialMasterDescription_IDOC_Req = ‘Y’

$G_ReceiverPartnerNumber = ‘BOBJTFR’

$G_ReceiverPort = ‘A000000004’

Idoc segments are filled with upload file data and transferred to MATMAS_MASS_BAPI.

Pic20.jpg

Idoc is successfully posted and Material is created in S/4HANA system using RDS.

Pic21.jpg

Pic22.jpg

    

6. References

  • scn.sap.com – Migrate your SAP data with Rapid Deployment Solution by Frank Densborn.
  • Configuration guide provided as part RDS package download from service marketplace.
  • Source file template provided as part RDS package download from service marketplace.
  • Youtube.com – SAP Data Migration demo by Frank Densborn.
To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Thomas Pillich

    Hi Sathish,

     

    This is a perfect guide.

    The only Thing I am missing is the check in the S4 HANA target System that the material has been migrated: Se16 screen

     

    and the Information, into which tables the material was migrated:

     

    Source ECC:                                                                                     Target S/4:

    (MARA, MARC, MARD, MLAN, MBEW etc.)                                   which are the new tables?

     

    Could you add this info?

    Thanks!

     

    Thomas

     

     

     

    (0) 
  2. Bindhu Konidala
    Hi Sathish,
    Thank you very much for the great blog.
    I followed the steps given in the blog. But getting the below error while executing the following job Job_DM_Lookups_Initialise.
    Please kindly suggest to proceed further.
    Thanks in Advance,
    Bindhu
    (0) 
  3. Harsh Talesra

    Hi Sathish

    Thanks for your blog.

    I had this ques.

    What is the process code you are associating the message type MATMAS_MASS_BAPI with during the creation of partner profile?

    Regards,

    Harsh

    (0) 

Leave a Reply