Skip to Content
0

DTW - Importing Volume Discount for all Business Partners

Nov 30, 2017 at 11:11 PM

112

avatar image
Former Member

Hi,

I'm trying to import/update Volume Discounts for ALL busines partners on several different pricelist.

I've read NOTE 928625 thouroughly, specially point 4 which seems to addres my problem.

It doesn't work 'as advertised' or I'm missing something important.

On https://archive.sap.com/discussions/thread/3227951 you can see that 8.8 didn't supported this specific import, but from note 928625 (recent note) it specifically says it does just that in current SAP version (I'm in SBO 9.2 PL07).

An example of the three templates used (filled in with data) to update a Volume Discount for 4 pricelists and 4 different volumes on one item:

OSPP:

ItemCode CardCode Price Currency Discount ListNum AutoUpdt

A05374 *2 2 tYES

A05374 *3 3 tYES

A05374 *4 4 tYES

A05374 *5 5 tYES

SPP1:

ItemCode CardCode LineNum Currency AutoUpdt ToDate Discount Price FromDate ListNum LINENUM

A05374 *2 0 EUR tYES 20171121 2 0

A05374 *3 0 EUR tYES 20171121 3 0

A05374 *4 0 EUR tYES 20171121 4 0

A05374 *5 0 EUR tYES 20171121 5 0

setting '*<pricelist id>' in cardcode column or leaving this blank doesn't change anything

SSP2:

ItemCode CardCode LineNum Amount SPP1LNum Price SPP2LNum Currency Discount

A05374 0 1 0 20 0 EUR

A05374 0 250 0 15 1 EUR

A05374 0 500 0 10 2 EUR

A05374 0 750 0 5 3 EUR

A05374 0 1 0 25 0 EUR

A05374 0 250 0 20 1 EUR

A05374 0 500 0 15 2 EUR

A05374 0 750 0 10 3 EUR

A05374 0 1 0 30 0 EUR

A05374 0 250 0 25 1 EUR

A05374 0 500 0 20 2 EUR

A05374 0 750 0 15 3 EUR

A05374 0 1 0 10 0 EUR

A05374 0 250 0 10 1 EUR

A05374 0 500 0 10 2 EUR

A05374 0 750 0 10 3 EUR

> setting '*<pricelist id>' in cardcode column will result in:

Update Failed: Key A05374,*2 Invalid value in quanity field 65171

> setting nothing/NULL in this field, doesn't generate errors but does not update the SPP2.

This results in a succesful import of 4 records, which matches the SSP1 file.

But for the SSP2, nothing got updated. What seems logical since it has no idea on what pricelist he should update.

Last but not least, Listnums are 0 for this item, I've dubbelchecked.
In this example I want to update the discount volumes (only 1 per item-pricelist-quanity),we do not care to preserve the old volume discount and so we can update the only record there is using listnum = 0.

The goal is to find a way to do this succesfully and then import for many more items.

Note that although I have a strong technical background, I'm fairly new to DTW.

Thank you for any help as I start pulling my hair of on this problem

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers