Update Price Lists Using Data Import

Exporting & Updating the Original Price List

SAP Version 9.3 family and below

1. In the main menu, click on Tools > Queries > Query Generator.
   
   
   
2. Click Execute.
3. In the Query Preview window, click the pencil on the top left to edit the query.
4. Copy and paste the following query into the window, then click Execute.
   SELECT T0.[ItemCode], T0.[PriceList], T0.[Price], T0.[Currency] FROM ITM1 T0 INNER JOIN OPLN T1 ON T0.[PriceList] = T1.[ListNum] WHERE T1.[ListName] =[%0]
   
   
   
5. In the toolbar, click the Export to Excel icon.
6. Name the file, keeping it as a tab delimited text file. The following system message about exporting currency symbols will appear. Select No and click OK.
   
   
   
7. Open the file in Excel. Remove the first column and header. Modify the price. Insert a column with value "Manual" or appropriate UoM code in column I. Save the file as a tab delimited text file.
   
   
   

SAP Version 10.0 family

• Same steps above. Use the following query to retrieve Active items

SELECT
    T1.[PriceList],
    T0.[ItemCode],
    T0.[ItemName],
    null As  'C',
    null As 'D',
    T1.[Price],
    T1.[Currency],
    null As 'G',
    null As 'H',
    null As  'I',
    null As 'LastRequdColumn'
FROM OITM T0
    INNER JOIN ITM1 T1 ON T0.[ItemCode] = T1.[ItemCode]
    INNER JOIN OPLN T2 ON T1.[PriceList] = T2.[ListNum]
WHERE T2.[ListName] = [%0] And (T0.[frozenFor] = 'N' Or T0.[validFor] = 'Y')

Importing the Updated Price List

SAP Version 9.3 Family and below

1. Complete a backup of the database to allow for a restore in case there are problems.
2. In the main menu go to Administration > Data Import/Export > Data Import > Import From Excel.
   
   
   
3. From the drop-down boxes, make the following selections (as shown below):
   Data Type to Import: Items
   Column A: Item No.
   Column B: Price List Code (Columns C and D will be automatically filled out as shown)
   
4. Under File to Import, click the ... button and select the saved file.
5. Click the Import button when ready.

SAP Version 10.0 family

1. Complete a backup of the database to allow for a restore in case there are problems.
2. In the main menu go to Administration > Data Import/Export > Data Import > Import From Excel.
   
   
   
3. From the drop-down boxes, make the following selections (as shown below):
   Data Type to Import: Price List
   Column A: Price List No.
   Column B: Item No. (Columns C to J will be automatically filled out as shown)
   
4. Under File to Import, click the ... button and select the saved file.
5. Click the Import button when ready.

A message with the results will be shown when system finished updating, you will find the information in system message log as well as if any error messages:

You could now verify the change and/or fix the issue for the failed records.