Skip to Content
0
Former Member
Nov 04, 2011 at 11:49 AM

Update Price List by DTW ODBC Connection

103 Views

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