Update Price List by DTW ODBC Connection

[Former Member]

Hi Experts,

I wondered if there was a way to update a Price List in SAP by DTW ODBC connection please? I have two databases with exactly the same Price Lists, apart from I need to update one price list in one of the databases with the inforamtion as a Price List in another SAP database on the same server. The price list is called C60000 and is the 7th Price list (therefore number 6) and this is the Query I was using:

SELECT T1.[ItemCode], T1.[Price] FROM OPLN T0 INNER JOIN ITM1 T1 ON T0.ListNum = T1.PriceList WHERE T1.[PriceList] = '6'

The Query shows correctly in STEP 4 of DTW when I click on Import in the last Step nothing really seems to happen...

Many many thanks for all your help.

Caroline

[Former Member]

Hi Caroline,

Which table is your target to update? OPLN is the list only. ITM1 include item price by price list.

Thanks,

Gordon

[Former Member]

HI Gordon,

Thanks for your fast reply!

I guess it's ITM1 I need to update... the actual prices in the Price List.

Thanks,

Caroline

[Former Member]

Check this then: