cancel
Showing results for 
Search instead for 
Did you mean: 

Error while importing Item MAster Data using DTW

Former Member
0 Kudos

Hi,

when we are importing item master data using items template

it is giving error.

Error:":connected value 1 was not found "

can any one send the oitems template that is working fine wthout any error.

Thanks,

Neetu

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Paste few lines from the Excel Template to identify the problem

Former Member
0 Kudos

we are trying to import data prepration templates>>Testcase1_Test Data for Import function>Oitems.

while importing that template then also giving error.

send me the template i.e.working without error.

Thanks,

Neetu

Former Member
0 Kudos

You cannot import data prepration templates>>Testcase1_Test Data for Import function>Oitems directly.

You will have to do certain prerequisites like setting CommissionGroup, CommissionPercent, CommissionSum,CustomsGroupCode etc., in SAP before importing Items.

So I would like you to try out with minimum fields in the template and import. After understanding, you can import the required fields.

I suggest you to use the template from "C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\oItems"

Former Member
0 Kudos

if i m impoting data i.e. oitems on patch level 41 it is working fine,but if we are using same template to umport data on patch level 0 it is giving error

Error:'Invalid Code [OITM.ChapterId] applicayion defined or object defined error 65171"

Why it is giving error and how to solve it,,

Thanks

Neetu

Former Member
0 Kudos

Remove ChapterId from the template and try to import.

Check SAP Note 1078102 - DI - Expose Excisable field in OITM table

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E&note_numm=1078102]