on 09-20-2012 9:30 AM
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 |
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
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.