Exporting 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
.
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
.
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.
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.
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.
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.
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
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.
If you have chosen to export using files then you can choose your own file prefix to make locating and identifying files easier.
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.
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.
In the Scheduling Settings
section, select whether you want to import now or at a future date.
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.
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.
Choose the Export Data
button to run the service.
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.
You have successfully created a run to export your master data from your source systems.