Follow

DTW Data Transfer Workbench

The DTW (Data Transfer Workbench) is the tool in SAP to mass update documents.
The basic process is as follows.
1. Find the fields you need to update.
2. Find the Template that would accomplish this. (See 5)
3. Get the data needed and update template with the information you need to update.
4. Upload via DTW
5. First Time Template Generation.

1. First you need to find the fields to update. Lets use Item Name on the Item Master Data.
Turn on View System Information
View > System Information
You could use the shortcut Ctrl+Shift+I
or hold Alt press V then S release Alt
mceclip0.png

Then go to the Field you need to edit, in the screenshot below we are hovering the mouse over Description. While doing that you can look at the bottom left and see that we are looking at the OITM table (Item Master) and the field name is ItemName

mceclip1.png


2. If we look at the OITM Template for the DTW (you can find this attached to the guide as OITM - Items) we can see that Item Code is a mandatory field. Typically the ItemCode or Item Number is the field you will use to map the updates to.
mceclip2.png

3. With our Example here that ItemCode would be '10 001' so our sheet would look like this. mceclip4.png
mceclip3.png

You will want to Save the File as Text (Tab delimited) (*.txt)


4. Now that we have the data and have saved it as the proper file type we recommend testing this on a sandbox.
Download mceclip5.png the DTW RDP from https://connect.business1cloud.com/ 
Enter your password, press Refresh, then select a database and log in.

mceclip8.png
Press Import
mceclip9.png
Next
mceclip10.png
Select what you are doing, in this case we are Updating Master Data.
mceclip11.png
mceclip12.png
mceclip13.png
Set to txt  (Tab Delimited)
mceclip14.png
Select your file with the Elipse
mceclip15.png
Press Next
mceclip16.png
Make sure the fields are mapped how you expect and press next.
mceclip17.png
Select how you would want to handle the errors. If you have tested this in your sandbox anything should be fine but if you are doing this in your live environment first I would recommend using Run Simulation first. This will simulate uploading without actually making any changes.
mceclip18.png

Once you have either done the simulation or selected your error handling and pressed next, press Import to start the upload.

mceclip20.png

Wait for it to process and press finish.
mceclip21.png
This will give you a detailed log for the results. If you get errors you can select error file to get additional details.
mceclip22.png




5. If you have never generated the template files, perform this step after logging into the DTW. 
Select Templatese > Generate UDF Templates, that will create the Template files in the location you select. You will want to copy those to your local computer. If you have never set that up, please follow this guide. Make local files available on RDP connection

mceclip24.png
Generating all Templates can take some time but will leave you with a Directory filled with templates.
mceclip25.png
mceclip26.png

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments