Top 5 FAQs (Frequently Asked Questions) – SAP S/4HANA Migration Cockpit – Migrate Data Using Staging Tables

In this blog, you will find the TOP 5 Frequently Asked Questions (FAQs) related to the SAP S/4HANA Migration Cockpit / Migrate Your Data App, Migrate Data Using Staging Tables (as of March 2022).

You can find the whole list of the latest FAQs for the SAP S/4HANA migration cockpit, SAP S/4HANA (PDF format) for staging tables, as well as for the Direct Transfer approach in the SAP S/4HANA migration cockpit community –> Featured Content -> FAQ and under the following link:

For SAP S/4HANA Cloud, you can find the PDF Version of the FAQs – Migrate your Data – Migration Cockpit in the SAP S/4HANA migration cockpit community -> Featured Content -> FAQ and also under the following link:

Additionally, you can find other Frequently Asked Questions (FAQs) about the SAP S/4HANA migration cockpit in the following SAP Notes and Knowledge Base Articles (KBAs):

.

————————————————————————————————————————————–

TOP 5 Frequently Asked Questions (FAQs)

SAP S/4HANA migration cockpit – Migrate Data Using Staging Tables     

  1. What is the scope of the SAP S/4HANA migration cockpit? Can I use it for the mass processing of data or as an interface to frequently load data into a system? 
  2. Can we use the SAP S/4HANA migration cockpit to update existing data? For example, if data already exists in the target system, can I update the data using the SAP S/4HANA migration cockpit?
  3. How can I improve the performance of the data transfer?  
  4. Must I pay attention to something if I fill the data directly in the staging tables? 
  5. Which ETL Tools can I use to fill the staging tables? 

…………………………………………………………………………………………………………………………………………….

1) What is the scope of the SAP S/4HANA migration cockpit? Can I use it for the mass processing of data or as an interface to frequently load data into a system? 

The SAP S/4HANA migration cockpit is designed for customers who have just installed SAP S/4HANA or are using SAP S/4HANA Cloud and want to move their legacy data from SAP or non-SAP software systems. It allows users to migrate their master data and transactional data to SAP S/4HANA, and it facilitates this process by providing predefined migration content and mapping. The SAP S/4HANA migration cockpit is part of both SAP S/4HANA and SAP S/4HANA Cloud.

The SAP S/4HANA migration cockpit and associated content (migration objects) are neither intended nor recommended to be used as an interface to frequently load data into a system or to mass change existing data. For more details, see SAP Note 2684818 – SAP S/4HANA Migration Cockpit usage for mass processing data or as interface.

 

2) Can we use the SAP S/4HANA migration cockpit to update existing data? For example, if data already exists in the target system, can I update the data using the SAP S/4HANA migration cockpit?

No, it is not possible to use the SAP S/4HANA migration cockpit to update existing data. The SAP S/4HANA Migration Cockpit is designed for a new implementation of an SAP S/4HANA system, therefore, data records can only be migrated once. The SAP S/4HANA migration cockpit and associated content (migration objects) are neither intended nor recommended to be used as an interface to update, frequently load data into a system or to mass change existing data. For more details, see SAP Note 2684818 – migration cockpit usage.

To update or mass change of existing data you should use the provided interfaces or mass processing apps of the business object application area instead (for example: Mass Maintenance of Master Data). For more details see:  Mass Maintenance – SAP Help Portal. For more information about the mass change and maintenance apps, refer to the  SAP Fiori Apps Reference Library (ondemand.com). 

3) How can I improve the performance of the data transfer?  

On the Job Management screen, you can adjust the maximum number of background jobs that are used for your project. If required, you can also adjust the number of background jobs for specific migration objects.

For more details about the Job Management function, see the SAP Help Portal:

If you are using the migration approach Migrate Data Using Staging Tables and upload your data to the staging tables by using XML template files, you can improve performance by splitting the xml template into multiple files and uploading these files in your project. However, you must ensure there are enough background jobs available.

In addition, it is important to consider that there are non-technical and technical measures to influence the runtime of your production migration. The non-technical measures comprise planning and organizational aspects. Considering these points can reduce the necessary system downtime. For more details about performance tips & tricks for the SAP S/4HANA migration cockpit see:

 4) Must I pay attention to something if I fill the data directly in the staging tables? 

Yes. If you fill the data directly in the SAP HANA database, you must take care on the default values and the correctness of the values of some data types. For more details see KBA 2733253 – FAQ for SAP S/4HANA migration cockpit. Migration approach: Transfer / Migrate data from staging tables.

5) Which ETL Tools can I use to fill the staging tables? 

To fill the staging tables, you can either use ABAP code or any ETL tools from a third party or from SAP (for example SAP Data Services, SAP HANA smart data integration (SDI)). You can also use SAP HANA Studio to fill the tables with data.

There are several blogs listed below to show different methods to load data into the staging tables:

For further details refer to KBA 2733253 – FAQ for SAP S/4HANA migration cockpit. Migration approach: Transfer / Migrate data from staging tables.

————————————————————————————————————————————–

For more information about the SAP S/4HANA migration cockpit, please refer to our Overview presentation (Slide Deck) and to our landing pages:

For deep dive material of the SAP S/4HANA Migration Object Modeler (transaction LTMOM) see:

If you would like to discuss specific topics or have specific technical questions you can post/ ask a question in our SAP S/4HANA Communities: