Skip to Content
Former Member
Jul 30, 2012 at 09:56 AM

DTW add/update special prices


Hi all,

I'm trying to add special prices for BP through the DI (SAP 2007). It all goes well, but for some BP-itemcode combination there is already an entry in the database (linenum = 0). So in the new DTW files I put the RowNumber/LINENUM value to 1 but I get the error 'Invalid Date Range'.

The already existing value runs for one month in 2011, so it's finished already. The new value runs from today until the end of times.

What am I doing wrong?

These are the DTW files:


ItemCode CardCode Price PriceListNum AutoUpdate

ItemCode CardCode Price ListNum AutoUpdt

0544415011 30060 0 0 N


ParentKey ParentKey2 PriceCurrency AutoUpdate DateTo SpecialPrice DateFrom PriceListNo RowNumber

ItemCode CardCode Currency AutoUpdt ToDate Price FromDate ListNum LINENUM

0544415011 30060 N 0 20120730 0 1


ParentKey ParentKey2 Quantity SPDARowNumber SpecialPrice RowNumber PriceCurrency

ItemCode CardCode Amount SPP1LNum Price SPP2LNum Currency

0544415011 30060 40.0000 1 20.8100 0 EUR

The existing value in the db is this one:

Itemcode CardCode LINENUM Price Currency Discount ListNum FromDate ToDate AutoUpdt Expand

0544415011 30060 0 0.000000 0.000000 0 2011-10-07 00:00:00.000 2011-11-07 00:00:00.000 N Y