Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Query for Unit Commision

I am trying to write a query show the per unit commission for an item on a Sales Order and put that value into a UDF.

I have got as far as getting a result on the document for a specific row, but I cannot get it to select for all rows on the document.

What I have is as follows:

SELECT (T0.Price* T0.Commission/100)

FROM RDR1 T0 INNER JOIN ORDR T1 ON T0.DocEntry = T1.DocEntry

WHERE T1.DocNum = $[$8.0] AND T0.ItemCode = $[$38.0]

It is the last part where I am trying to specify by itemcode that is proving troublesome. I have used a specific line number instead of ItemCode and that works.

Can someone help me on this?

Rick Winn

Former Member
Former Member replied

The syntax for ItemCode on the marketing document is $\[$38.1.0]

You simply need

SELECT ($\[$38.17.Number]*$\[$38.28.Number]/100)

38.17 refers to Price After Discount column and 38.28 refers to the commission column

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question