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!