cancel
Showing results for 
Search instead for 
Did you mean: 

DTW Discount Groups Line numbering

julie_jamieson2
Active Contributor
0 Kudos
121

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!

Accepted Solutions (0)

Answers (2)

Answers (2)

julie_jamieson2
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hello Julie,

Any updates about this matter? Because i encounter the same problems. When i use DTW to update 1 itemgroup discount for a specific BP it will set all other itemgroups to 0.

julie_jamieson2
Active Contributor
0 Kudos

A fix was supposed to be introduced in 9.1 PL12

Former Member
0 Kudos

See it mentioned in the release notes, thank you!

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi Julie,

Thanks for sharing information.

You may post as document or blog not as discussion.

Regards,

Nagarajan