Skip to Content

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!

Hi Julie,

Thanks for sharing information.

You may post as document or blog not as discussion.

Regards,

Nagarajan

This document was generated from the following discussion: DTW Discount Groups Line numbering

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply