Skip to Content

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

I have generated a query but some entries are duplicates

Hello,

Could anyone please advise how I can remove the duplicate entries from my query?

The query is a simple one. I want to report on BP reference numbers, Job locations, when the jobs were completed (date & time), cost centre, project code and the username of the person who raised the sales order.

Select

T0.[NumAtCard], T0.[U_IIS_sskJobLoc], T0.[U_IIS_sskJobStatusD], T0.[U_IIS_sskJobStatusT], T0.[U_IIS_sskCostCode], T0.[Project]

From

ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OUSR T2 ON T0.UserSign = T2.USERID

Where

T2.[U_NAME] =[%0] AND  T0.[NumAtCard] Like '4106_%%'


When the query is executed, most of the lines are duplicated once, twice or three times.

Is there a way I can remove the duplicates?

Many thanks.

Jobs.txt.zip (3174 B)
Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question