Uploading Item prices using DTW error

[former_member327292]

This question is Not Answered.(Mark as assumed answered)

  

John Velasco Sep 20, 2012 10:05 AM        

I keep getting error when uploading item prices using DTW. Item code already exists. My template contains the following

ParentKey	LineNum	PriceList	Price	Currency
ItemCode	LineNum	PriceList	Price	Currency
00450L		271	51.7
00450L		305	51.7
00450L		37	51.7
00450L		330	51.12
00450L		345	48.82
00450L		108	51.7
00450L		250	46.34
00450L		303	51.7
00450L		181	49.4
00450L		369	47.64
00450L		33	47.94
00450L		133	51.7
00450L		63	48.2
00450L		218	51.7
00450L		374	51.7
00450L		138	48.7
00450L		378	51.7
00450L		376	51.7
00450L		39	46.44
00450L		275	51.7
00450L		222	51.7
00450L		255	48.31
00450L		208	50.95

[vasileiosfasolis]

Hi John

youn have to fill the Linenum field

if your pricelist is number 1 then the Linenum will be 0

the formula is pricelist -1

[Former Member]

Hi,

Pricelist Num - open item master in add mode-> in price list column select tht required pricelist. Enable view->system Information. Now move the cursor to the selcted pricelist, u can see the pricelist number in bottom left of the SAP window. You can view numbers like 1, 2 or 3.. now put tht number in price list colum in ITM1 template.

Line Num - if ur price list number 1 put line number as 0, fill the entire temple wit same value. if it is 2 line num is 1 fill accordingly.

currency - fill currency

Import both OITM and ITM1 template at a time.

For Example

ParentKey	LineNum	PriceList	Price	Currency
ItemCode	LineNum	PriceList	Price	Currency
0079925015	0	1	0	INR
0081	0	1	37.78	INR
0082	0	1	37.78	INR
01092	0	1	73	INR
01100314	0	1	0.57	INR
01100315	0	1	2	INR
01100316	0	1	2.1	INR
01100317	0	1	1.2	INR
01100318	0	1	5.3	INR
01100319	0	1	3.83	INR
01100320	0	1	13.59	INR
01100321	0	1	8.62	INR
01100322	0	1	50	INR
01100323	0	1	0.79	INR
01100324	0	1	3.22	INR
01100325	0	1	5.04	INR

Regards,

Chidambaram R

[KennedyT21]

Hi John Velasco,

Provide the Line number and the Currency and try..

You have to use OITM and ITM1 Template to import Item Prices........

And run both the templates at a time...

Hope Helpful

Regards

Kennedy