Sunday, 01 December 2019 13:54

Part 4: SAP S/4HANA migration cockpit – Using SAP HANA Studio to load data to the staging tables

Written by https://blogs.sap.com/2019/12/02/sap-s-4hana-migration-cockpit-using-sap-hana-studio-to-load-data-to-the-staging-tables/
Rate this item
(0 votes)

This is the final blog post of a blog series I wrote together with Markus Andres and Alessandro Sabidussi

The first blog post gave an overview of the SAP S/4HANA migration cockpit,

focusing on the migration approach “Transfer Data Using Staging Tables”.

The second blog post by Markus covered how to use Data Services to populate the staging tables.

The third blog post by Alessandro presented a second option using HANA Smart Data Integration (SDI), which is an embedded functionality in SAP HANA.

In this final post, we will provide general information and a link to a detailed guide about how to populate the SAP S/4HANA Migration Cockpit staging tables with data by using the SAP HANA Studio.

The SAP HANA Studio gives users the possibility to import data from a local file (.csv, .xls, or .xlsx) into an SAP HANA database by using Data from Local File option.

For the SAP S/4HANA migration cockpit’s approach “Transfer Data Using Staging Tables”, a table schema is created when you select and open a migration object within your migration project. As mentioned in the first blog: SAP S/4HANA migration cockpit – Migrating data using staging tables and methods for populating the staging tables, for each source structure of a migration object a separate staging table is generated natively in the SAP HANA database schema.

Structures for Migration Object G/L account and the generated, corresponding staging tables

The table schema or staging tables corresponding to the source structures of the migration objects you selected in your migration project using the SAP S/4HANA migration cockpit (staging tables approach) can be seen and accessed in the SAP HANA studio. You find such staging tables under Systems -> Catalog -> <DatabaseUser> ->Tables

Once you have created your migration project and selected your migration objects, you will then be able to upload data into these tables using the Data from Local File option in the SAP HANA Studio.

 

Prerequisites:

  • In the SAP S/4HANA migration cockpit You have created a migration projectthat uses the migration approach Migrate Data Using Staging Tables.
  • You have selected the relevant migration objects for your migration project.
  • You have created an SAP HANA database connection between the SAP S/4HANA system and the staging system (a remote system that uses the SAP HANA database).
  • You have a flat file(.csv, .xls, or .xlsx) with data to upload.

Procedure:

For detailed information about how to fill the staging tables using the SAP HANA studio – Data from Local File option, seesection 2.4. in the following SAP User Guide:

 https://www.sap.com/documents/2019/09/8003a726-687d-0010-87a3-c30de2ffd8ff.html

This guide shows how to load data from flat files to the staging tables by using the Data from Local File option in the SAP HANA Studio.

You find more information about the SAP HANA Studio here:

With this, we conclude these blog series.

Read 22 times

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.