SAP Knowledge Base Article - Public

3210687 - Additional Information about Transferring Data from CSV Template Files to Staging Tables for the Migration Cockpit

Symptom

You are using the SAP S/4HANA migration cockpit to migrate data to SAP S/4HANA Cloud Public Edition and want to learn more about Transferring Data from CSV Template Files to Staging Tables.

Environment

You are using SAP S/4HANA Cloud Public Edition.

  • SAP S/4HANA Cloud Public Edition - Migrate your Data - Migration Cockpit app

 

For SAP S/4HANA 2022  - Migrate your Data - Migration Cockpit app - Migrate Data Using Staging tables see KBA 3296020.

 

Resolution

The SAP S/4HANA migration cockpit allows users to migrate master data and transactional data to SAP S/4HANA, and it facilitates this process by providing predefined migration content and mapping. You can fill the staging tables with data either using XML templates, CSV files, manually or by using third party or SAP’s ETL tools.

You can use CSV files to populate the staging tables with data in the Migration Cockpit - Migrate Your Data app. This option also provides a more flexible approach for uploading data. For example, you can remove columns, and change the order of the columns. Note that the mandatory fields must always be present in the header row of your CSV file. For more information, see CSV Header Options | SAP Help Portal.

Note: For SAP S/4HANA and SAP S/4HANA Cloud Private Edition KBA 3296020 and User Guide - Transferring Data from CSV Template files to Staging Tables - SAP S/4HANA Migration Cockpit

User Guide - Transferring Data from CSV Template files to Staging Tables

 

General CSV upload process 

The general process to upload CSV files to the SAP S/4HANA migration cockpit is as follows:

1. Verify and adjust the CSV file options available within the SAP S/4HANA migration cockpit.

2. Download the CSV template files for the relevant migration object. 

3. Create your CSV files. For more details see: Filling CSV Template Files with Data | SAP Help Portal.

4. Upload your Zip or CSV files. After preparing your CSV files or your Zip file containing your single CSV files, you have two options for uploading your CSV files.

    • Option A. Upload a Zip file which contains all your CSV files - standard way.
    • Option B. You create a CSV folder for a migration object and then upload single CSV files or a Zip file containing your single CSV files. 

      5. Map your CSV file to a data structure. An automatic mapping will occur if the name of the CSV file follows the naming convention for CSV files.

      6. Validate and transfer the data to the staging tables.

      For detailed information and steps, see the following user guide 2733253 and the SAP Help Portal: SAP HANA SQL and System Views Reference for SAP HANA Platform → SQL Reference → Data Types.

      Other relevant information:

      • Similar to the XML file templates available within Migration Cockpit for data migration, the size limitation for CSV files is 100MB. Note that this limitation does not depend on the file format, but on SAP GUI, as NetWeaver does not allow more than 100MB. However, compared to that of the XML file templates, a CSV file can contain more migration object instances.
      • Comparing CSV template files with XML template files, a single CSV file corresponds to a worksheet in the XML template file. For example, the migration object Customer has the mandatory data structure General Data (S_CUST_GEN), as well as the data structures Additional Addresses (S_ADDRESS), Address Usages (S_ADDR_USAGE), International Address Versions (S_ADDRESS_IAV), and so on. You can find the information about mandatory and optional data structures on the SAP Help Portal (Available Migration Objects) at http://help.sap.com/S4_CE_MO. On the Migration Object Tables screen, you can also download a metadata file for each migration object. 

      See Also

      The Data Migration landing page on the SAP Help Portalat http://help.sap.com/S4_CE_DM

      Keywords

      CSV files, transfer data to staging tables using csv files, migration cockpit, CSV format, CSV upload, CSV Template Files, Migrate your Data – Migration Cockpit, Migration Cockpit Cloud, data migration, new implementation , KBA , CA-LT-MC , S/4HANA Migration Cockpit , How To

      Product

      SAP S/4HANA Cloud Public Edition all versions