Show TOC

Function documentationImport Data Locate this document in the navigation structure

 

You can use CSV files to import master data into SAP Sourcing. See your administrator for details about formatting CSV files for import.

This section describes how to import data into SAP Sourcing and view the results of the data import. You also use the Import Data function to install language packs and agreements.

Note Note

Additionally, you can access the Data Import List page by choosing Supplier Management in the navigation bar and then choosing Import Data from the Performance submenu.

End of the note.

Activities

Importing Data from a CSV File

You can use CSV files to import master data into SAP Sourcing. See your administrator for details about formatting CSV files for import.

Importing Value List Values from a CSV File

Value list values present a special case with a number of guidelines to be followed.

To update an existing object, you must provide the object's display name in the CSV file. If you do not specify an existing display name, a new object is created in the database. If the object already exists, this can cause database constraint violations.

The importer handles display names and display name IDs as follows:

  • If both a display name and a display name ID are present in the CSV file, the object display name is the display name and a new resource is created or an existing resource is updated so that the display name of the object matches the default value of the resource.

  • If only a display name is present in the CSV file, the object display name is the display name and a new resource is created having a default value equal to the specified display name.

  • If no display name is present in the CSV file, the display name will be set to the default value of the existing resource.

To import data from a CSV file:

  1. Choose   Setup   System Administration   Import and Export Tools   Import Data  .

  2. On the Data Import page, choose Create.

  3. Follow the prompts in the wizard to import the file.

Viewing Imported Data Results

You can use CSV files to import master data into SAP Sourcing. See your administrator for details about formatting CSV files for import.

To view the results of a data import:

  1. Choose   Setup   System Administration   Import and Export Tools   Import Data  .

  2. On the Data Import page, choose the file for which to view import results.

  3. On the File Import page, review the import results.