PT Sterling Tulus Cemerlang



Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – Indonesia

500+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

Template Not Exists on DTW for SAP Business One

Did you know that you can easily generate a various template for Data Transfer Workbench on SAP Business One?

When you need to upload a setup data, master data, or transaction data to SAP Business One, you always using a Data Transfer Workbench. As an user (or internal IT), you can ask to your SAP Consultant to give you a templates base what you need. Or, you can directly search a template on directory C:\Program Files\sap\Data Transfer Workbench\Templates\Templates. That’s a templates provided after you installed a SAP Business One Data Transfer Workbench on your PC-client/TS (for HANA) or on your server (for Non HANA).

But when you need that template for urgent matters, and didn’t find it on that directory, what can you do?

It’s easy, first open the Data Transfer Workbench (DTW) application, logging in to your company’s database with superuser code.

On menu bar, click Templates, choose “Customize Template” or Ctrl+M
Generate a Template with Data Transfer Workbench

On Customize Template window, click Select Object

Generate a Template with Data Transfer Workbench

Generate a Template with Data Transfer Workbench

As an example:
Choose Resources > Resource Master Data. Then, choose Create Template for the Structure
Generate a Template with Data Transfer Workbench
Please wait for a while, choose a directory to save that template.
Input a file name, and save as type ‘Excel Template’, then click Save.
Generate a Template with Data Transfer Workbench
After that, check on your destined directory, and your template now ready to use.

Sample Templates Generated from Data Transfer Workbench

Also read:

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: or call +6221-5806336 or wa +6287786555055

, , ,