How to import period discounts for price list using DTW

[Former Member]

I am trying to use the DTW for importing periodic discounts In version 9.1 PL06

According to Note 928625 the OSPP contains item code (and pricelist, which was not mentioned)

The Add is successful, but no values are added to SPP1

ParentKey	ParentKey2	LineNum	PriceCurrency	AutoUpdate	Dateto	Discount	SpecialPrice	DateFrom	PriceListNo	RowNumber
ItemCode	CardCode	LineNum	Currency	AutoUpdt	ToDate	Discount	Price	FromDate	ListNum	LINENUM
Z00001	*2		ILS	tYES	20151231	20		20151101		0

Help anyone ?

[Former Member · Accepted solution]

My Mistake was using the *2 in the parentkey2 column.

It should be empty.