Data Transfer Workbench (DTW) is a platform where you can upload bulk data into the database of the SAP Business One.

Usually we can find the system from templates under SAP Data Transfer Workbech installation folder.

For User Defind Field and User Define Object DTW templates, the easiest way is to generate them form the Data Transfer Workbench itself.

Step 1:

Login to DTW software using required user id and password.

After logging in you can see  "Templates" at top of the toolbar and Click on it.


A drop down will appear showing the following


Step 2:

Select 'Customize Template, Generate UDO Template, Generate UDF Template" as per your requisition.

UDO Templates:User Defined Templates-  the templates for the user defined tables that have been created in the database.


UDF Templates: Standard Templates, which is standard in SAP Business One.


Customize Template- This option gives you to customize a template as per your choice.

Screenshot 2016-06-29 19.30.16

Step 3:

Below "Browse" button is provided for the location where you want to save the templates which is being generated.

After selecting the appropriate location, click on "Generate Templates" to generate.

Generation of Template may take a couple of minutes.

Thus the required template is generated.

If you need assistance with DTW, feel free to contact us.

Contact Us

by MTC Systems on Jun 29, 2016 4:33:57 PM

Leave a comment

Related posts

No Restriction When Setting Revenue Accounts in SAP

SAP Business One is designed to fit all types of businesses. For example, usually we set the revenue accounts of a business as...

MTC Systems
By MTC Systems - November 14, 2017
Tips When Reading Forms in SAP Business One

It can be inconvenient when you company receives a document with a long list of items. Finding a specific item can also be...

MTC Systems
By MTC Systems - November 10, 2017
Tracking the Inventory Counting in SAP Business One

Inventory is an important direction of most of the manufactural companies. Inventory counting and tracking can be helpful in...

MTC Systems
By MTC Systems - February 2, 2017