Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
julie_jamieson2
Active Contributor
0 Kudos

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

Labels in this area