how to removes duplicates entries in query generator in sap b1

[JAYAKUMAR2]

SELECT distinct T0."ItemCode" AS "Itemcode",T1."U_UTL_BTNO",T0."DocDate",
T0."Dscription" AS "Item",T3."InvntryUom" as "UoM", T4."ItmsGrpNam",

/*select d."ItmsGrpNam" from oitb d where d."ItmsGrpNam"=[%3]*/

T2."PlannedQty" AS "Std. Qty",

T0."Quantity" AS "Issued Qty",

(T0."Quantity"- T2."IssuedQty" ) AS "Returned Qty",

(T0."Quantity"-(T0."Quantity"- T2."IssuedQty" ) ) AS "Consumption",

(T2."PlannedQty"-(T0."Quantity"- (T0."Quantity"- T2."IssuedQty" ) )) AS "Excess/Shortage",T5."Price",

((T0."Quantity"-(T0."Quantity"- T2."IssuedQty" ))*T0."Price") AS "Item rate",

(T0."Quantity"-(T0."Quantity"-T2."IssuedQty" )) * ((T0."Quantity"-(T0."Quantity"- T2."IssuedQty"))*T0."Price") AS "Std Value (FIFO)",

(CASE WHEN ((T2."PlannedQty"-(T0."Quantity"- (T0."Quantity"- T2."IssuedQty" ))) * ((T0."Quantity"-(T0."Quantity"- T2."IssuedQty"))*T0."Price")) = 0
THEN (T0."Quantity"-(T0."Quantity"-T2."IssuedQty" )) * ((T0."Quantity"-(T0."Quantity"- T2."IssuedQty"))*T0."Price")
ELSE ((T2."PlannedQty"-(T0."Quantity"- (T0."Quantity"- T2."IssuedQty" ))) * ((T0."Quantity"-(T0."Quantity"- T2."IssuedQty"))*T0."Price"))
END) AS "Actual Value (FIFO)"

FROM IGE1 T0 INNER JOIN OWOR T1 ON T0."BaseRef"= T1."DocNum" and T0."BaseType"=T1."ObjType"

INNER JOIN WOR1 T2 ON T1."DocEntry" = T2."DocEntry" AND T2."ItemCode" = T0."ItemCode"
INNER JOIN OITM T3 ON T0."ItemCode" = T3."ItemCode"
INNER JOIN OITB T4 ON T4."ItmsGrpCod" = T3."ItmsGrpCod"
INNER JOIN PDN1 T5 ON T5."ItemCode"= T2."ItemCode"
INNER JOIN OPDN T6 ON T6."DocEntry" = T5."DocEntry"

WHERE T4."ItmsGrpCod" IN ('100','101')

AND T0."DocDate" >= [%0] AND T0."DocDate" <= [%1] AND T1."U_UTL_BTNO" =[%2] AND T4."ItmsGrpNam"=[%3]