Consulta para Revisar pedidos duplicados en SAP a partir de portal de clientes

Select TOrdr.UserSign, Tu.USER_CODE, TOrdr.Ref2, wscokey, TS.Series, SeriesName, DocNum, TOrdr.DocDate, CreateTS, DocTime, JrnlMemo , CardCode, CardName, wscoRegUsr, wscoOrigin, wscoReplicatedDT

from ORDR TOrdr

inner join  (

select ref2, DocDate, count(*) DupCount

from ordr 

where  DocDate >= '20231207' 

group by ref2, DocDate

having count(*)  > 1)  TDup on TDup.Ref2 = TOrdr.Ref2

INNER JOIN wspprod.DBO.wspSalesDoc tws ON tws.wscoKey = CAST(TOrdr.Ref2 as INT) 

INNER JOIN NNM1 TS on TS.Series = TOrdr.Series

INNER JOIN ousr TU on TU.USERID = TOrdr.UserSign

where  TOrdr.DocDate >= '20231207'  --and wscoOrigin = 'wcp'

ORDER BY TOrdr.Ref2