DTW - Importing Volume Discount for all Business Partners

[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

[Laura_Nest]

I have experienced the same thing. I found that the SPP2 wasn't been seen by the DTW- don't know if it was corrupt or altered enough that it didn't work . I figured it out because the DTW Error files didn't show the 3 files, only 2. It didn't list SpecialPricesQuantityAreas file - only the ospp, spp1 speicalprices and specialpricesdataareas files where there should have been three. Also, on Step 5 of the DTW: Map Object Field, on Target tab if you expand the SpecialPricesQuantityAreas and there is nothing under 'row' , it isn't going to work. (there should be Quantity, SPDARowNumber, SpecialPrice) .Compare to the SpecialPricesDataAreas and you'll see there is another level under 'row'. There should more under 'row' on specialpricesquantityareas ) When it did show, I no longer got the Invalid Quantity message and the DTW was successful. So I went back to a template that did work loading data and used that to compare Step 5 of DTW.

[LoHa]

Hi Laura,

I think the problem is the missing CardCode.

As you see in the Note, in SPP1 the CardCode AND the ItemCode AND Linenum are the keys.
In the SPP2 it is ItemCode AND CardCode and SPP1LNum are the keys.

regards Lothar