SAP S/4HANA Migration Cockpit: Filling Staging Tables with Data Using SAP HANA Studio
Withing the migration approach "Migrate Data Using Staging Tables" you can fill tables with data either manually, using the SAP HANA Studio or by using third party or SAP ́s ETL tools. This guide contains information about how to load data from flat files (supported extensions are .csv, .xls, and.xlsx) to the Migration Cockpit ́s staging tables. Download the DocumentPUBLIC
Filing Staging Tables with Data Using SAP
HANA Studio
SAP S/4HANA Migration Cockpit
Filing Staging Tables with Data Using SAP
HANA Studio
SAP S/4HANA Migration Cockpit
© 2024 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. 2 / 20
Typographic Conventions
Type Style Description
Example Words or characters quoted from the screen. These include field names, screen
titles, pushbuttons labels, menu names, menu paths, and menu options.
Textual cross-references to other documents.
EXAMPLE Technical names of system objects. These include report names, program names,
transaction codes, table names and key concepts of a programming language when
they are surrounded by body text, for example, SELECT and INCLUDE.
Example Output on the screen. This includes file and directory names and their paths,
messages, names of variables and parameters, source text, and names of
installation, upgrade and database tools.
Example Exact user entry. These are words or characters that you enter in the system exactly
as they appear in the documentation.
<Example> Variable user entry. Angle brackets indicate that you replace these words and
characters with appropriate entries to make entries in the system.
E X A M P L E Keys on the keyboard, for example, F 2 or E N T E R .
Typographic Conventions
Type Style Description
Example Words or characters quoted from the screen. These include field names, screen
titles, pushbuttons labels, menu names, menu paths, and menu options.
Textual cross-references to other documents.
EXAMPLE Technical names of system objects. These include report names, program names,
transaction codes, table names and key concepts of a programming language when
they are surrounded by body text, for example, SELECT and INCLUDE.
Example Output on the screen. This includes file and directory names and their paths,
messages, names of variables and parameters, source text, and names of
installation, upgrade and database tools.
Example Exact user entry. These are words or characters that you enter in the system exactly
as they appear in the documentation.
<Example> Variable user entry. Angle brackets indicate that you replace these words and
characters with appropriate entries to make entries in the system.
E X A M P L E Keys on the keyboard, for example, F 2 or E N T E R .
© 2024 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. 4 / 20
Table of contents
1 Introduction ............................................................................................................................................................. 5
2 How to Fill the Staging Tables Using the SAP HANA Studio .............................................................. 6
2.1 Overview ......................................................................................................................................................................................................... 6
2.2 Creating your Flat File............................................................................................................................................................................ 6
2.3 Prerequisites ................................................................................................................................................................................................ 8
2.4 Procedure ...................................................................................................................................................................................................... 8
3 Relevant Information, Documentation and Links .................................................................................. 17
3.1 Relevant SAP Notes and Knowledge Base Articles (KBA) ....................................................................................... 17
3.2 Other relevant Information, links, and documentation ............................................................................................... 18
Table of contents
1 Introduction ............................................................................................................................................................. 5
2 How to Fill the Staging Tables Using the SAP HANA Studio .............................................................. 6
2.1 Overview ......................................................................................................................................................................................................... 6
2.2 Creating your Flat File............................................................................................................................................................................ 6
2.3 Prerequisites ................................................................................................................................................................................................ 8
2.4 Procedure ...................................................................................................................................................................................................... 8
3 Relevant Information, Documentation and Links .................................................................................. 17
3.1 Relevant SAP Notes and Knowledge Base Articles (KBA) ....................................................................................... 17
3.2 Other relevant Information, links, and documentation ............................................................................................... 18
© 2024 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. 5 / 20
1 Introduction
The SAP S/4HANA migration cockpit is designed for customers who have just installed SAP S/4HANA and
want to move their legacy data from SAP or non-SAP software systems. It allows you to migrate your master
data and transactional data to SAP S/4HANA, and it facilitates this process by providing predefined migration
content and mapping. The migration cockpit is part of both SAP S/4HANA and SAP S/4HANA Cloud.
The migration approach Migrate Data Using Staging Tables is recommended if you want to transfer a lot of
data to SAP S/4HANA in an automated way. It is a most efficient way of transferring large volumes of data.
Staging tables are database tables and therefore provide greater flexibility than files regarding managing
data (for example sorting data, searching for data, checking for duplicate records and so on).
If you use the migration approach Migrate Data Using Staging Tables, the SAP S/4HANA migration cockpit
automatically creates staging tables for each migration object that is relevant for your project. You can fill the
staging tables with data either manually, using the SAP HANA Studio or by using third party or SAP ́s ETL
tools (for example SAP Agile Data Preparation).
This guide contains information about how to load data from flat files (supported extensions are .csv, .xls, and
.xlsx) to the Migration Cockpit ́s staging tables by using the SAP HANA Studio using the option Data from Local
File.
1 Introduction
The SAP S/4HANA migration cockpit is designed for customers who have just installed SAP S/4HANA and
want to move their legacy data from SAP or non-SAP software systems. It allows you to migrate your master
data and transactional data to SAP S/4HANA, and it facilitates this process by providing predefined migration
content and mapping. The migration cockpit is part of both SAP S/4HANA and SAP S/4HANA Cloud.
The migration approach Migrate Data Using Staging Tables is recommended if you want to transfer a lot of
data to SAP S/4HANA in an automated way. It is a most efficient way of transferring large volumes of data.
Staging tables are database tables and therefore provide greater flexibility than files regarding managing
data (for example sorting data, searching for data, checking for duplicate records and so on).
If you use the migration approach Migrate Data Using Staging Tables, the SAP S/4HANA migration cockpit
automatically creates staging tables for each migration object that is relevant for your project. You can fill the
staging tables with data either manually, using the SAP HANA Studio or by using third party or SAP ́s ETL
tools (for example SAP Agile Data Preparation).
This guide contains information about how to load data from flat files (supported extensions are .csv, .xls, and
.xlsx) to the Migration Cockpit ́s staging tables by using the SAP HANA Studio using the option Data from Local
File.