on 12-22-2007 1:27 AM
DTW version:2005.0.13
API version:6.80.320
I can't find the correct DTW templates about SalesOpportunities.
When I add userfields in SalesOpportunities,there are always mistakes. I wonder why?
email:whitetiger_zw@yahoo.com.cn
You'd better to use DTW 2005.0.11
And make sure restart your DTW after you added UDFs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
here is the folder where there are templates for sales opportunities:
C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\oSalesOpportunities
I am using :
DTW version:2005.0.14
API version:6.80.320
If you use DTW version:2005.0.13, and can't find resolution for userfields, you must test the DTW version:2005.0.14.
Rgds,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
wei zhao,
If you have created user fields in the Sales Opportunities table, you can add the same user field in your Excel DTW template at the end. Remember to use the same name of the User field while adding the columns. example: U_field1, U_xxx
Also in your DTW template, add two rows of the same user field column like other columns in the template.
This way, while importing using DTW using Map Rule Tab (Check Input Data Screen) check if the user field from your template are mapped correctly to your user field in Sales Oppor. tables.
If not you can manually select the target fields matching your user fields in the template.
Suda
Wei,
The weakness of DTW template sample or template of SAP B1 2005A are not included the example of how user defined field is written in the template. It is only available in the SAP B1 2004A DTW templates. The UDF fields have to be created in the template. you just simple write U_udf code1, U_udf code2, etc. you must write two rows.
E.g. the udf code is aiwd, the description of UDF is amount in words, so the user defined field in the template must be U_aiwd. Mapping them (source must be same as target field) in the step 3 when performing uploading using DTW.
Rgds,
Edited by: jimmy michael on Dec 24, 2007 12:29 PM
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.