cancel
Showing results for 
Search instead for 
Did you mean: 

Import data in user define table through DTW.

Former Member
0 Kudos

Hi experts,

Can any one tell me how can i import data from excle in User define tables through DTW. Is any other way/tool avaliable to

import data from excel sheet to User define tables

BR,

Hari

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Hari,

It might be better if you post some of your data here. 65172 error is always linked to data format mismatch.

Thanks,

Gordon

Former Member
0 Kudos

The user defined tables have prefix U.These tables can be seen in dtw at the bottom since the objects in dtw are alphabetically sorted.Create a csv file which contains each and every field of the user defined table including Code and Name.Use this file as source for importing.

Former Member
0 Kudos

while doing this process getting error reason 65172

Former Member
0 Kudos

Hi,

Which version of SAP B1 and DTW are u using there is a bug in, PL 10.

Vasu Natari.

Former Member
0 Kudos

Hi,

I am using Patch 15 and getting same error.

Can you suggest something for same.

Hari

Former Member
0 Kudos

Hi Hari,

I suppose u did not do the following..

1. Open DTW, in the menu click on advanced and clik on maintain interface...

2. Now here select the UDT which u want to impot the data.

3. right click on the UDT and click on Create template for structure

4. NOw u use this tempalte and try.

Please inform of the outcome so that i can think of another soluton.

Hope it helps,

Vasu Natari.

Former Member
0 Kudos

hi ,

if user defined table type is NoObject then process is working ,but when Master type then the error is getting

status :created failed , Reason: Master Data type User Table can not add row 65171

:updated sucessfully , :udt name

when i seend error file msg is like this

<-- donot fill this row-->

in the second row of template

Former Member
0 Kudos

Hello,

See the following notes :

1401223 and 1353428 for more information (how to import UDO-s).

This is what you need.

This requires S user log-in.

Regards,

János.