Skip to Content

SAPB1 link sales order line to discount group table

Oct 04, 2017 at 10:04 PM


avatar image

Hi All,

I want to create query report linking sales order lines to discount group table. If a discount group is applicable then the sales order line should store a link somewhere to the discount group table. How do I create this link as RDR1 does not seem to store this information


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Agustin Marcos Cividanes Oct 05, 2017 at 09:16 AM


try this query:

select T0.CardCode, T1.ItemCode, T3.Discount from oinv T0 inner join OEDG T2 onT2.objCode= T0.cardcode inner joininv1 T1 on T0.docentry= T1.docentry inner join edg1 T3 on T1.ItemCode= T3.ObjKey and T1.SpecPrice='W' where T0.DocEntry= yourdocentry

You can change the where condition and use the docnum field (if it unique in your database).

Kind regards

10 |10000 characters needed characters left characters exceeded