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

DTW add/update special prices

268 Views

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:

OSPP

ItemCode CardCode Price PriceListNum AutoUpdate

ItemCode CardCode Price ListNum AutoUpdt

0544415011 30060 0 0 N

SPP1

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

SPP2

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