Tips for Working with Data Transfer Workbench (DTW)
- Every version of SAP is released with a DTW version so it is recommended to always be importing into SAP from the same version level in DTW.
- Log in using an "SAP Super User" with a professional license
- Try to separate importing new data and updating existing data. Performing both simultaneously typically has a pretty big performance hit.
- Tab delimited text files and ODBC connections work well for data work. A lot of client legacy data will contain either comma’s or semi-colons which will affect your import file adversely.