Show TOC

Procedure documentationExporting Master Data

 

You can use the Export Master Data service to extract data from your source systems. You can choose to export supplier master data, customer master data, key mapping information, or value mapping information. To use this service select the Export Master Data iView under the Data Transfer workset.

The Export Master Data service extracts data into an XML file. The structure of this XML file corresponds to the service interface Import Master Data.

Procedure

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

  2. In the Export Settings section, use the Object Type drop-down menu to choose the Object Type you want to export.

    You can export supplier master data, customer master data, key mapping information, or value mapping information.

  3. In the Description field, enter a description for your export.

    This description can be searched for in the data transfer log and on the Monitor Data Transfer screen.

  4. Choose or create a variant. The variant is a bundle of selection criteria for data export.

    If you have stored selection criteria in a file you can upload it here by choosing the Import Values button. The file must be saved in tab-delimited text file format with the data contained in a single column. You can add reference data to your export by choosing additional object to export from the Add. Objects field. This reference data can be used for value mapping.

  5. If required, select the Delta Export checkbox.

    If you select a delta export then the system only takes data that has changed since the last export that used the same variant.

  6. In the Technical Settings section, choose the method you want to use to export the data from the Communication Channel drop-down menu.

    You can choose to write to a file (or files) or to call a SOA service in the target system. If you want to extract data to a file, you must create a logical directory (target directory) on the application server and map it to a physical directory path.

    All files extracted to the application server file system using the Export Master Data service are placed in this directory. If you have chosen to write to file you must enter a target directory in the Target Directory field. For more information on logical directories see the documentation for the customizing activity Define File Source and Archive Directories for Data Transfer.

    Note Note

    If you have selected the communication channel Service, no XML file is created physically on the local or application server file system. In this case, a SOA message is created, which can be consumed by a service inbound proxy.

    End of the note.
  7. If you have chosen to export using files then you can choose your own file prefix to make locating and identifying files easier.

  8. In the Package Size field enter a package size.

    The package size represents the number of supplier master data records allowed in a single file. If you choose a package size of 100 and export 1000 records then the system creates 10 files. This is only valid for supplier master data and customer master data. You do not need to enter a value here if you are exporting key or value mapping information.

  9. In the Target System field, use the input help to select a target system.

    You need to choose a target system if you want to perform value mapping during the master data extraction process or if you want to export value mapping information. You must create the mapping in advance in the source system using the Maintain Value Mapping (Transaction VMIMG) Customizing activity.

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

  11. In the Parallel Processing Settings section, select the checkbox if you want to use parallel processing to speed up the export.

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

  12. To see how many records you have selected for export, choose the Number of Selected Objects button.

    Dependent records may also be included in your export so this allows you to check the exact number of records you are exporting.

  13. Choose the Export Data button to run the service.

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

Result

You have successfully created a run to export your master data from your source systems.