Inventory Valuation with Missing Costs - F47122 & F4105

SELECT T1.MJMCU,
       T1.MJLITM,
       T1.MJAITM,
       T1.MJITM,
       T2.IMDSC1,
       T2.COLEDG,
       T1.QTY,
       T2.STD_COST
  FROM (SELECT MJMCU, MJLITM, MJAITM, MJITM, SUM(MJTRQT / 1000) AS QTY
          FROM TESTDTA.F47122
         WHERE MJEDSP = ' '
           AND MJMCU = '     2050012'
         GROUP BY MJMCU, MJLITM, MJAITM, MJITM) T1
  LEFT OUTER JOIN (SELECT COITM,
                          COLITM,
                          COAITM,
                          IMDSC1,
                          COMCU,
                          COLEDG,
                          COUNCS / 10000 AS STD_COST
                     FROM TESTDTA.F4105, TESTDTA.F4101
                    WHERE COITM = IMITM
                      AND COLEDG = '07') T2
    ON T1.MJITM = T2.COITM
   AND T1.MJMCU = T2.COMCU

WHERE -- Comment the next 3 line if you want to see Inv Valuation
    ( COLEDG IS NULL
     OR STD_COST = 0)