cancel
Showing results for 
Search instead for 
Did you mean: 

How to upload price for a item in price list using DTW ?

former_member187989
Active Contributor
0 Kudos

hi all,

How to upload prices of all the items in price list using DTW ?

What are templates used for it ?

Item masters were already created.

Jeyakanthan

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

The other option is just using "Import from Excel" under Administration - Data Import/Export. Only Item, BP are available with this utility.

It might be more convenient for those who need to update the list more often since you can update price list easier than DTW once you complete the first round setup.

Thanks,

Gordon

Former Member
0 Kudos

hi,

how can we import item price using Import from Excel.

Thanks,

Neetu

0 Kudos

Hi Gordon

I tried updating a pricelist using "import from Excel"

My excel table had four columns:

Column A: item code

Column B: Pricelist number

Column C: Price

Column 😧 currency

I kept getting an error that there was something wrong in row 1.  So I put 1s in row one of each column.  Still got an error but the prices updated.  However all the barcodes for the updated items are now blank.

Any idea what went wrong?

what other data could have been blanked?

Is there a fix to reverse?

Regards

J.R. Naik

Answers (7)

Answers (7)

Former Member

use the template

'C:\Program Files\SAP\Data Transfer Workbench\Templates\Templates\oItems\Items_Prices.xlt'

former_member187989
Active Contributor
0 Kudos

Thanks a lot gordon,problem solved.

Jeyakanthan

former_member187989
Active Contributor
0 Kudos

same error message occurs.

Jeyakanthan

former_member187989
Active Contributor
0 Kudos

Thanks you all for replies,

But the error message appears in log as

update failed docentry cannot find this object in

B1 application-defined or object-defined erroroItems.

Jeyakanthan

Former Member
0 Kudos

From the error I feel that there is a problem with updating 'items' template.

To ensure this create a dummy udf and update this udf values through DTW. Check if you are able to update this.

Then you can try out updating items with prices.

former_member187989
Active Contributor
0 Kudos

Which option to select in DTW import business object/update busienss object,because item master already created ?

Jeyakanthan

Former Member
0 Kudos

Hi

Create two Excel templates 'Items.xls' and 'Items_Prices.xls'

Since you have already imported items, just have the record key and item code alone in the 'Items.xls' . For example:

RecordKey.......ItemCode

1.......................I0001

2.......................I0002

In the Items_Prices template, Fill Pricelist Number fromOPLN and Price of the Item

RecordKey....LineNum......Price

1......................1..............350.00 (Means for Item I001, Pricelist 1 is updated with 350)

1......................2..............300.00 (Means for Item I001, Pricelist 2 is updated with 300)

2......................1..............550.00 (Means for Item I002, Pricelist 1 is updated with 550)

2......................2..............600.00 (Means for Item I002, Pricelist 2 is updated with 600)

In step 4 of DTW, Choose

Check - Update Exisiting Object

Uncheck - Import New Object

This should update the pricelist alone for the items

former_member187989
Active Contributor
0 Kudos

what is line number should i fill it for price list number 1 on item prices template ?

Jeyakanthan

Former Member
0 Kudos

Pricelist Number should be the number from 'OPLN' table - ListNum Column

former_member187989
Active Contributor
0 Kudos

what are the other templates should i use with Item prices ?

Jeyakanthan

Former Member
0 Kudos

'item_prices.xlt' can be used only along with 'items.xlt' template

former_member583013
Active Contributor
0 Kudos

You will need to fill two templates for Item Prices import through DTW

Items and Items_Prices

In the Items template you will need to fill the

RecordKey.......ItemCode

1.......................A0001

In the Items_Prices template, you need to fill the

RecordKey....LineNum......Price

1......................2..............20.00

NOTE: You need to enter the Pricelist number in the ListNum column

Suda