on 10-08-2013 12:59 AM
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!
Be aware this does not work in 9.1, updating a single line will cause all other values to be set to 0.
I have a call with SAP on this now
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Julie,
Thanks for sharing information.
You may post as document or blog not as discussion.
Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
67 | |
14 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.