Skip to Content
author's profile photo Former Member
Former Member

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
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 30, 2012 at 05:12 PM


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



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.