DTW add/update special prices

[Former Member]

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

[Former Member]

Hi,

You may try updating linenum 0 to change the date instead of adding linenum 1.

Thanks,

Gordon