F4111 Vs F30026 broken down by Cost Element

SELECT T0.IBITM,
       T0.IBLITM,
       T0.IBAITM,
       IM.IMDSC1,
       T0.IBMCU,
       T0.IBSRP6,
       T0.IBPRP5,
       T0.IBSTKT,
       T1.ILITM,
       T1.ILMCU,
       T1.ILMMCU,
       T1.ILDOC,
       T1.ILDCT,
       T1.ILDGL,
       T1.ILGLPT,
       T1.ILDCTO,
       T1.ILDOCO,
       T1.ILKCOO,
       T3.IECOST,
       T3.IECSL / 10000 "H1_Cost",
       T1.ILUNCS / 10000 "Unit_Cost",
       T1.ILTRQT / 1000 "Quantity",
       T1.ILPAID / 100 "Amount",
       T1.ILUKID,
       T1.ILAID,
       T1.ILAN8,
       T1.ILSHAN
  FROM PRODDTA.F4101  IM,
       PRODDTA.F4102  T0,
       PRODDTA.F4111  T1,
       PRODDTA.F30026 T3
 WHERE T1.ILDCT = 'OV'
   AND T1.ILDCTO = 'ON'
   AND T1.ILMCU < '     1000998'
   AND T1.ILGLPT <> 'IN61'
   AND T1.ILTRQT <> 0
   AND T1.ILDGL >= 111092
   AND T1.ILDGL <= 112092
   AND ROWNUM <= 10 --Comment this line if you want all records
   AND IM.IMITM = T0.IBITM
   AND T0.IBITM = T1.ILITM
   AND T0.IBMCU = T1.ILMCU
   AND IEITM = T0.IBITM
   AND IEMMCU = '     1000999'
   AND IELEDG = 'H1'
   AND IELOCN = ' '
   AND IELOTN = ' '
 ORDER BY T0.IBITM ASC;