Skip to Content
0
Oct 07, 2013 at 11:59 PM

DTW Discount Groups Line numbering

84 Views

For those of you who, like me, have been struggling to work out how to add or update Discount groups in SAP using the DTW, I have added the answer below:

The #LineNum# in OSPG file should be ordered by #CardCode# separately.

For example, in OSPG table, the exsiting data is as below:

CardCode ObjType ObjKey Discount%
C20000 8 2 10 N NULL
C20000 8 4 15 N NULL
C20000 8 5 20 N NULL
C23900 8 1 10 N NULL
C23900 8 10 15 N NULL
C23900 8 11 20 N NULL

If you want to update the discount for C23900 from 15 to 16:
Since it is the second line of C23900, so the LineNum should #1#- using the start at 0 convention -, therefore, in the CSV file, it should be:

ParentKey LineNum ObjectEntry DiscountPercentage
CardCode LineNum ObjKey Discount
C23900 1 10 16

If you want to add a new discount for C23900,
Since there are lines of C23900, so the LineNum should #3#, therefore, in the CSV file, it should be:
ParentKey LineNum ObjectEntry DiscountPercentage
CardCode LineNum ObjKey Discount
C23900 3 2 17

Be careful that when you add a new line, the ObjKey should be not duplicated with the existing one.

I do hope this helps someone out at some stage!