Copy 02 into L1 into F4105

insert into bfdta.F4105

SELECT
    T1.COITM,T1.COLITM,T1.COAITM,T1.COMCU,T1.COLOCN,T1.COLOTN,T1.COLOTG,'L1',T1.COUNCS,T1.COCSPO,T1.COCSIN,T1.COURCD,T1.COURDT,T1.COURAT,T1.COURAB,'L1_FIX',T1.COUSER,T1.COPID,T1.COJOBN,T1.COUPMJ,T1.COTDAY,T1.COCCFL,T1.COCRCS,T1.COOSTC,T1.COSTOC
FROM
    (
        SELECT
            *
        FROM
            BFDTA.F4105
        WHERE
            COLEDG = '02'
        AND TRIM(COMCU)LIKE '311%') T1
LEFT OUTER JOIN
    (
        SELECT
            *
        FROM
            BFDTA.F4105
        WHERE
            COLEDG = 'L1'
        AND TRIM(COMCU)LIKE '311%') T2
ON
    T1.COMCU = T2.COMCU
AND T1.COITM = T2.COITM
WHERE
    T2.COLEDG IS NULL
ORDER BY
    T1.COMCU,
    T1.COLITM