Importing Data via File Upload

Objective

After completing this lesson, you will be able to import data through file upload in SAP Responsible Design and Production.

Introduction

Imagine encountering a crucial data integration challenge that impacts your system’s integrity. Navigating these complexities with precision is essential.

In this lesson, we delve into a strategic approach that ensures seamless data import while maintaining accuracy and efficiency.

Excel Import

To import data via an Excel upload, complete the following steps:

Collect and fill in the data in the corresponding SAP Responsible Design and Production Excel templates.
Upload the files in the logical sequence.

The image shows a screenshot of an example Excel Spreadsheet.

Before you begin the Excel data import process, review the following resources:

To access the official public import documentation, see: Data Import Through File Upload
To download the Excel template files:
1. Open the Import Data application.
2. Choose Upload File.
3. A new window opens with a list of Excel templates and the corresponding download links.
Note
To access the Import Data application, you must have the following role assigned:
SAP Responsible Design and Production Data Import Expert (see Initial Configuration – Authorizations)
To learn more about the names of the attributes, see: Data Structure.
To learn more about the template elements, see: Common Elements.
To learn more about what conditions need to be fulfilled before uploading files to SAP Responsible Design and Production, see: Checklist for the File Upload.

Upload Files

The image shows a screenshot of a file being imported in the Import Data application.

Data Import Behavior

If data already exists in the system, the system handles configuration and organizational data differently from the other object types.

For more information, see: Behavior of the Data Import.

Upload Completion

When the data is successfully imported, you can download a log file to view the results.

The image shows a screenshot of a completed upload.

The imported data can be found in the corresponding apps outlined here:

View Replication Results

File Upload Checklist

Before you upload files to SAP Responsible Design and Production, check that the following conditions are fulfilled:

Note

If one of the conditions is not fulfilled, the import will fail.

Adhere to the proper upload order.
For more information, see: Data Import Through File Upload.
Ensure the file size does not exceed 25 MB.
If you need to split your file, make sure that the split is done at the correct rows for all related tabs accordingly. For example, when you load more than one file for deliveries, make sure to do the split in both tabs (Delivery and DeliveryItem) at the same place, at the same delivery ID. When you need to split the file for products, make the split in each tab at the same product ID.
Ensure the file format is XLSX.
CSV files cannot be imported.
Ensure that no sheets from the template files were removed.
Additional sheets can be added, but are disregarded during the import.
Ensure no sheet names were changed and that they still match the template files.
Ensure the five header lines in column A were not changed and that they still match the template files.
For more information, see: Common Elements.
Ensure no additional columns were inserted.
If you want to add a comment, use the Your Remarks column.
Ensure the correct SAP S/4HANA attribute was exported for every field.
The proper SAP S/4HANA attribute is listed in the file templates for every column.
Ensure the mandatory fields are filled.
For more information, see: Common Elements.
Ensure the field length does not exceed the maximum field length.
Ensure the data type of every field is correct.
Ensure the row with sample values is removed.
Adhere to the correct data and time format and use the correct decimal separator.
For more information, see: Format.
For some fields, only values from a code list are allowed. Make sure to use values from the code list for those fields.
The code lists are part of the templates.
Some field values must match a corresponding value from a related sheet or file. That means, a value must match another value in a different file or sheet that you need to import too. Make sure to use values that exist in the related sheet or file.
Ensure no blank line items or blank fields are left in column B.
If an empty field is encountered in column B, then this is regarded as the end of the table. Only the data that was read until this point is imported.

How to Import Data

Choose Watch Demo to start the simulation.

DemoStart Demo

Summary

Importing Data:
Import data using file upload in SAP Responsible Design and Production.
Excel Template:
Use the correct SAP Responsible Design and Production Excel templates and follow the upload order.
Checklist Adherence:
Ensure all conditions in the upload checklist are met for successful file import.
File Requirements:
Ensure files are in XLSX format, with the correct headers, sheet names, and data types.
View the simulation to understand the data import process in detail.

Next lesson