Demo Script for SAP S/4HANA 2021 FPS02 Fully-Activated Appliance: Migration Cockpit – Staging Tables for Product Master Data
In this demo exercise, we’ll walk you through the approach to migrate data using staging tables. Therefore, we us the migration object Product (master data) as an example. To populate the staging tables, we will use the pre-delivered XML template files. Download the DocumentSAP S/4HANA 2021 FPS02 Fully-Activated Appliance
July 2022 (V7.0)
English
PUBLIC
SAP S/4HANA 2021 FPS02 Fully-Activated Appliance:
SAP S/4HANA Migration Cockpit – Migrate Data Using Staging Tables
Migrating Product Master Data
Demo Guide
July 2022 (V7.0)
English
PUBLIC
SAP S/4HANA 2021 FPS02 Fully-Activated Appliance:
SAP S/4HANA Migration Cockpit – Migrate Data Using Staging Tables
Migrating Product Master Data
Demo Guide
Table of Contents
1 Where Can This Script Be Used? 3
2 Demo Story: SAP S/4HANA Migration Cockpit (Staging Tables Approach) - Migrating Product 4
2.1 Start the SAP S/4HANA Migration Cockpit 5
2.2 Create a migration project 7
2.3 Download migration template and prepare data 10
2.4 Upload migration template and transfer data to staging tables 15
2.5 Prepare staging tables 16
2.6 Maintain mapping tasks 17
2.7 Simulate the migration 23
2.8 Execute the migration to SAP S/4HANA 24
2.9 Validate the imported data using SAP S/4HANA Business Apps 25
2.10 Summary 28
Error! Bookmark not defined.
Document History
Revision Date Change
1.0 June 2020 Release for Customer 1909 FPS02
2.0 December 2020 Release for customer 2020 FPS00
3.0 April 2021 Release for customer 2020 FPS01
4.0 July 2021 Release for customer 2020 FPS02
5.0 December 2021 Release for customer 2021 FPS00
6.0 April 2022 Release for customer 2021 FPS01
7.0 July 2022 Release for customer 2021 FPS02
1 Where Can This Script Be Used? 3
2 Demo Story: SAP S/4HANA Migration Cockpit (Staging Tables Approach) - Migrating Product 4
2.1 Start the SAP S/4HANA Migration Cockpit 5
2.2 Create a migration project 7
2.3 Download migration template and prepare data 10
2.4 Upload migration template and transfer data to staging tables 15
2.5 Prepare staging tables 16
2.6 Maintain mapping tasks 17
2.7 Simulate the migration 23
2.8 Execute the migration to SAP S/4HANA 24
2.9 Validate the imported data using SAP S/4HANA Business Apps 25
2.10 Summary 28
Error! Bookmark not defined.
Document History
Revision Date Change
1.0 June 2020 Release for Customer 1909 FPS02
2.0 December 2020 Release for customer 2020 FPS00
3.0 April 2021 Release for customer 2020 FPS01
4.0 July 2021 Release for customer 2020 FPS02
5.0 December 2021 Release for customer 2021 FPS00
6.0 April 2022 Release for customer 2021 FPS01
7.0 July 2022 Release for customer 2021 FPS02
1 Where Can This Script Be Used?
This demo script has been written for usage with the SAP S/4HANA 2021 FPS02 Fully-Activated Appliance (in short
“appliance” in this script), hence you will need such an appliance to make use of this guide.
The appliance can be brought up in two ways, and the demo scenario in this script is largely the same for both:
1. Via SAP Cloud Appliance Library (hosted on cloud providers)
You need a cloud provider account at AWS, MS Azure, or GCP. With this, you can deploy the appliance within 1-2
hours from https://cal.sap.com > Solutions > SAP S/4HANA 2021 (FPS02) Fully-Activated Appliance.
2. Via installing it on your own on-premise hardware.
You need to provide your own hardware, and order & install the appliance as explained in SAP Note 2041140.
If you are new to the SAP S/4HANA Fully-Activated Appliance, introductory information can be found here:
https://blogs.sap.com/2018/12/12/sap-s4hana-fully-activated-appliance-create-your-sap-s4hana-1809-system-in-a-
fraction-of-the-usual-setup-time/
Important:
Before you start your demo, please read SAP S/4HANA Fully-Activated Appliance: Demo Scripts for information about
necessary preparations, especially any post-deployment steps to ensure the full functionality of your appliance. These
steps are covered in sections;
B) General Remarks
C) Post-deployment Steps
D) Log-on to the system
Besides this, you will also find links to all demo scripts on this page.
This demo script has been written for usage with the SAP S/4HANA 2021 FPS02 Fully-Activated Appliance (in short
“appliance” in this script), hence you will need such an appliance to make use of this guide.
The appliance can be brought up in two ways, and the demo scenario in this script is largely the same for both:
1. Via SAP Cloud Appliance Library (hosted on cloud providers)
You need a cloud provider account at AWS, MS Azure, or GCP. With this, you can deploy the appliance within 1-2
hours from https://cal.sap.com > Solutions > SAP S/4HANA 2021 (FPS02) Fully-Activated Appliance.
2. Via installing it on your own on-premise hardware.
You need to provide your own hardware, and order & install the appliance as explained in SAP Note 2041140.
If you are new to the SAP S/4HANA Fully-Activated Appliance, introductory information can be found here:
https://blogs.sap.com/2018/12/12/sap-s4hana-fully-activated-appliance-create-your-sap-s4hana-1809-system-in-a-
fraction-of-the-usual-setup-time/
Important:
Before you start your demo, please read SAP S/4HANA Fully-Activated Appliance: Demo Scripts for information about
necessary preparations, especially any post-deployment steps to ensure the full functionality of your appliance. These
steps are covered in sections;
B) General Remarks
C) Post-deployment Steps
D) Log-on to the system
Besides this, you will also find links to all demo scripts on this page.
2 Demo Story: SAP S/4HANA Migration Cockpit
(Staging Tables Approach) - Migrating Product
When implementing your SAP S/4HANA solution, you can migrate your master data and business data from SAP
systems and non-SAP systems to SAP S/4HANA. To do this, you use the SAP S/4HANA migration cockpit.
There are two migration approaches available:
1. Migrate Data Using Staging Tables
The SAP S/4HANA migration cockpit creates staging tables for the migration objects that are relevant for your
project and migrates data from these staging tables to the target SAP S/4HANA system.
Template files are provided for every migration object. You can use these template files to fill the staging tables
with data. Alternatively, you can fill the staging tables by using your preferred tools (for example SAP Data
Services).
2. Migrate Data Directly from SAP System
An RFC connection connects the SAP S/4HANA migration cockpit to the SAP ERP source system. The SAP
S/4HANA migration cockpit selects data from the source system by using specific criteria. For example, if you are
using the migration scenario SAP ERP to SAP S/4HANA, then the SAP S/4HANA migration cockpit selects data
using company codes (you specify the relevant company codes when creating a project). Note the following
information for the migration scenarios:
More information on the SAP S/4HANA Migration Cockpit can be found on our central landing page:
Link SAP S/4HANA: https://help.sap.com/S4_OP_DM
Link SAP S/4HANA Cloud: https://help.sap.com/S4_CE_DM
In this demo exercise, we’ll walk you through the approach migrate data using staging tables. Therefore, we us the
migration object Product (master data) as an example. To populate the staging tables, we will use the pre-delivered XML
template files.
For your project, consider that the size limit for each file uploaded to SAP S/4HANA Migration Cockpit is 160 MB. This
parameter can be changed if required – see detailed info in our Help Portal (link).
Exercise Description:
1. Create migration project with migration object Product
2. Maintain mapping tasks for fixed value and control parameter
3. Download XML template file
4. Populate XML file with data and upload
5. Prepare staging tables
6. Maintain mappings
7. Simulate the migration
8. Execute the migration
9. Validate imported data using SAP S/4HANA Business Apps
(Staging Tables Approach) - Migrating Product
When implementing your SAP S/4HANA solution, you can migrate your master data and business data from SAP
systems and non-SAP systems to SAP S/4HANA. To do this, you use the SAP S/4HANA migration cockpit.
There are two migration approaches available:
1. Migrate Data Using Staging Tables
The SAP S/4HANA migration cockpit creates staging tables for the migration objects that are relevant for your
project and migrates data from these staging tables to the target SAP S/4HANA system.
Template files are provided for every migration object. You can use these template files to fill the staging tables
with data. Alternatively, you can fill the staging tables by using your preferred tools (for example SAP Data
Services).
2. Migrate Data Directly from SAP System
An RFC connection connects the SAP S/4HANA migration cockpit to the SAP ERP source system. The SAP
S/4HANA migration cockpit selects data from the source system by using specific criteria. For example, if you are
using the migration scenario SAP ERP to SAP S/4HANA, then the SAP S/4HANA migration cockpit selects data
using company codes (you specify the relevant company codes when creating a project). Note the following
information for the migration scenarios:
More information on the SAP S/4HANA Migration Cockpit can be found on our central landing page:
Link SAP S/4HANA: https://help.sap.com/S4_OP_DM
Link SAP S/4HANA Cloud: https://help.sap.com/S4_CE_DM
In this demo exercise, we’ll walk you through the approach migrate data using staging tables. Therefore, we us the
migration object Product (master data) as an example. To populate the staging tables, we will use the pre-delivered XML
template files.
For your project, consider that the size limit for each file uploaded to SAP S/4HANA Migration Cockpit is 160 MB. This
parameter can be changed if required – see detailed info in our Help Portal (link).
Exercise Description:
1. Create migration project with migration object Product
2. Maintain mapping tasks for fixed value and control parameter
3. Download XML template file
4. Populate XML file with data and upload
5. Prepare staging tables
6. Maintain mappings
7. Simulate the migration
8. Execute the migration
9. Validate imported data using SAP S/4HANA Business Apps
2.1 Start the SAP S/4HANA Migration Cockpit
In this process step, you start the SAP S/4HANA migration cockpit.
Be sure to access the appliance using the Windows Remote Desktop option provided with the S/4HANA Fully-Activated
Trial System for this scenario. For information on how to do this, see slides 21 - 23 on the step-by-step Quick Start Guide
which you can download here: https://www.sap.com/cmp/oth/crm-s4hana/s4hana-on-premise-trial.html
Explanation Screeshot:
Go to your CAL instance
and connect to
system S4H. Choose RDP.
Click Connect.
This opens a remote
desktop connection.
Go to the welcome
page and click the link
which opens FIORI.
Use the following logon
data:
1. Enter User: S4H_MG
2. Enter PW: Welcome1
Client 100 is already
Suggested.
3. Click Log On .
In this process step, you start the SAP S/4HANA migration cockpit.
Be sure to access the appliance using the Windows Remote Desktop option provided with the S/4HANA Fully-Activated
Trial System for this scenario. For information on how to do this, see slides 21 - 23 on the step-by-step Quick Start Guide
which you can download here: https://www.sap.com/cmp/oth/crm-s4hana/s4hana-on-premise-trial.html
Explanation Screeshot:
Go to your CAL instance
and connect to
system S4H. Choose RDP.
Click Connect.
This opens a remote
desktop connection.
Go to the welcome
page and click the link
which opens FIORI.
Use the following logon
data:
1. Enter User: S4H_MG
2. Enter PW: Welcome1
Client 100 is already
Suggested.
3. Click Log On .