Skip to Content

SAPB1 link sales order line to discount group table

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

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 05, 2017 at 09:16 AM

    Hi

    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

    Add comment
    10|10000 characters needed characters exceeded