The DTW (Data Transfer Workbench) is the tool in SAP to mass update documents.
The basic process is as follows.
If this is your first time, go to Step 5 first.
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. (Optional) 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
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
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.
3. With our Example here that ItemCode would be '10 001' so our sheet would look like this.
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 the DTW RDP from https://connect.business1cloud.com/
Enter your password, press Refresh, then select a database and log in.
Select what you are doing, in this case we are Updating Master Data.
Set to txt (Tab Delimited)
Select your file with the Elipse
Make sure the fields are mapped how you expect and press next.
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.
Once you have either done the simulation or selected your error handling and pressed next, press Import to start the upload.
Wait for it to process and press finish.
This will give you a detailed log for the results. If you get errors you can select error file to get additional details.
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
Generating all Templates can take some time but will leave you with a Directory filled with templates.
Please sign in to leave a comment.