Show TOC

Procedure documentationImporting Master Data

 

You can use the Import Master Data service to import files containing supplier, customer, material, and classification data to the Master Data Governance system. You can also import key and value mapping information. The data from these files can update existing master data records or create new ones using the options available in the Import Master Data service.

We recommend that you import the classification data for a material together with the material data. We also recommend that you import the business partner relationship data with the business partner data.

The Import Master Data and Export Master Data services use the same XML tag structure in their files. You can run a sample export from the Export Master Data service and view the resulting file to determine the tag structure for importing key and value mapping information that you have created outside the MDG hub.

Prerequisites

You have prepared your file for import in IDoc-XML format. Supplier and Customer information can also be imported in SOA message format.

Procedure

  1. On the SAP NetWeaver Portal or SAP NetWeaver Business Client, open the Import Master Data service. You can also access the screen using transaction DTIMPORT.

  2. In the Import Settings section, select an object type to import, enter a description for the import run, and choose whether or not to overwrite existing data with information from the import. Business partner, supplier, and customer imports automatically overwrite existing records. This cannot be changed.

    If you have set up a custom file converter in Customizing, you can select it here.

  3. In the Governance Settings section, choose whether or not you want to use governance for your import.

    If you choose not to use governance, the objects are imported directly to the active area and you must choose a post processing type. If you select governance, data is imported to the staging area using change requests. The post processing settings are determined by your change request type.

    Note Note

    You use the post processing settings to determine where to send objects that contain errors. If you choose change requests, the system sends the objects with errors to the staging area where you can work on them. If you choose manual post processing, the records with errors are sent to either IDoc handling, if the import was done using IDoc-xml, or forward error handling, if the import was done using SOA message.

    To access forward error handling use transaction /SAPPO/PPO2. In the Business Process field enter BP_BUPA001 for business partner and BP_RELSOO1 for business partner relationships. In the Order Assignment field enter 2 if you are not already assigned as a processor. To reduce the number of records selected, enter a date in the Created On field.

    End of the note.

  4. In the Scheduling Settings section, select whether or not you want to import now or at a future date.

  5. In the Parallel Processing Settings section, select whether or not you want to use parallel processing to speed up the import.

    Note that there should be a queue name prefix already set up for your imports. You should use this prefix when naming your queue so that the queue is executed automatically. If you do not have the queue set up, you have to manually trigger the processing. For more information on setting up queues, see the configuration documentation.

  6. In the Data Sources section, choose the Add button and select an object type. In the Source Directory field, use the input help to select a source directory for the import. You can use the Show Directory Content button to preview the files stored in a selected source directory.

  7. To test your import, choose the Simulate Import button.

  8. To execute your import, choose the Import button.

Result

You have successfully created a run to import your master data into the Master Data Governance system. After the successful import of the files into the system, the files are moved automatically from the selected source directory into the archive directory. The files in the archive directory should be deleted manually in order to free disk space.

To monitor your import or simulated import choose the Display Monitoring button. This opens the Monitor Data Transfer service where you can supervise your import. For more information, see Monitor Data Transfer.