Importing Data Through File Upload

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Import Data

Excel Import

Overall Documentation

For the import documentation, refer to official public documentation: Data Import Through File Upload

To download template files, go to the Import Data application and choose Upload File. A dialog opens where a download link is available per object type.

To be able to access the Import Data application, you need to have assigned role RDP Data Import Expert (see Initial Configuration – Authorizations).

The name of the attributes are defined here: Data Structure

For more information on the spreadsheet elements, see Common Elements.

Before you upload files to SAP Responsible Design and Production, check if all conditions are fulfilled, see Checklist for the File Upload

Behavior of the Data Import

If data already exists in the system, the system handles configuration and organization data differently from the other object types. For more information, see Behavior of the Data Import

Checklist for the File Upload

Before you upload files to SAP Responsible Design and Production, check if the conditions in this list are fulfilled. If one of the conditions is not fulfilled, the import will fail.

  • Adhere to the proper upload order. See Data Import Through File Upload.
  • The file size does not exceed 5 MB.
  • The file format is XLSX. CSV files cannot be imported.
  • No sheets from the template files were removed. Additional sheets can be added. Additional sheets are disregarded during the import.
  • No sheet names were changed and are matching the template files.
  • The five header lines in column A were not changed and are matching the template files. See Common Elements.
  • No additional columns were inserted. In case you want to add a comment, use the Your Remarks column.
  • 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.
  • The mandatory fields are filled. See Common Elements.
  • The field length does not exceed the maximum field length.
  • The data type of every field is correct.
  • The row with sample values is removed.
  • Adhere to the correct data and time format and use the correct decimal separator. See Format.
  • Values from code lists are used. 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.
  • Related values exist. 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.
  • 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

Select the Watch Demo button to start the simulation.

Save progress to your learning plan by logging in or creating an account