INSERT INTO BV_W005 SELECT 'rh6w71y56n4g1rf698rsi7xnbbl60y3c',000000,B.*,RPAD(NVL(VKEY1,' '),60,' ') || RPAD(NVL(VKEY2,' '),60,' ') || RPAD(NVL(VKEY3,' '),60,' ') || RPAD(NVL(VKEY4,' '),60,' ') || RPAD(NVL(VKEY5,' '),60,' ') || RPAD(NVL(VKEY6,' '),60,' ') || RPAD(NVL(VKEY7,' '),60,' ') || RPAD(NVL(VKEY8,' '),60,' ') || RPAD(NVL(VKEY9,' '),60,' ') || RPAD(NVL(VKEY10,' '),60,' ') || RPAD(NVL(VKEY11,' '),60,' ') || RPAD(NVL(VKEY12,' '),60,' ') || RPAD(NVL(VKEY13,' '),60,' ') || RPAD(NVL(VKEY14,' '),60,' ') FROM(SELECT A.VPERIOD,A.VKEY1 AS VKEY1,' ' AS VKEY2,' ' AS VKEY3,' ' AS VKEY4,' ' AS VKEY5,' ' AS VKEY6,' ' AS VKEY7,' ' AS VKEY8,' ' AS VKEY9,' ' AS VKEY10,' ' AS VKEY11,' ' AS VKEY12,' ' AS VKEY13,' ' AS VKEY14,' ' AS VKEY15
,SUM(A.VD1) as VD1,SUM(A.VD2) as VD2,SUM(A.VD3) as VD3,SUM(A.VD4) as VD4,SUM(A.VD5) as VD5,SUM(A.VD6) as VD6,SUM(A.VD7) as VD7,SUM(A.VD8) as VD8,SUM(A.VD9) as VD9,SUM(A.VD10) as VD10,SUM(A.VD11) as VD11,SUM(A.VD12) as VD12,SUM(A.VD13) as VD13,SUM(A.VD14) as VD14,SUM(A.VD15) as VD15,SUM(A.VD16) as VD16,SUM(A.VD17) as VD17,SUM(A.VD18) as VD18,SUM(A.VD19) as VD19,SUM(A.VD20) as VD20,SUM(A.VD21) as VD21,SUM(A.VD22) as VD22,SUM(A.VD23) as VD23,SUM(A.VD24) as VD24,SUM(A.VD25) as VD25,SUM(A.VD26) as VD26,SUM(A.VD27) as VD27,SUM(A.VD28) as VD28,SUM(A.VD29) as VD29,SUM(A.VD30) as VD30,SUM(A.VD31) as VD31,SUM(A.VD32) as VD32,SUM(A.VD33) as VD33,SUM(A.VD34) as VD34,SUM(A.VD35) as VD35,SUM(A.VD36) as VD36,SUM(A.VD37) as VD37,SUM(A.VD38) as VD38,SUM(A.VD39) as VD39,SUM(A.VD40) as VD40,SUM(A.VD41) as VD41,SUM(A.VD42) as VD42,SUM(A.VD43) as VD43,SUM(A.VD44) as VD44,SUM(A.VD45) as VD45,SUM(A.VD46) as VD46,SUM(A.VD47) as VD47,SUM(A.VD48) as VD48,SUM(A.VD49) as VD49,SUM(A.VD50) as VD50,SUM(A.VD51) as VD51,SUM(A.VD52) as VD52,SUM(A.VD53) as VD53,SUM(A.VD54) as VD54,SUM(A.VD55) as VD55,SUM(A.VD56) as VD56,SUM(A.VD57) as VD57,SUM(A.VD58) as VD58,SUM(A.VD59) as VD59,SUM(A.VD60) as VD60
FROM WVIEW0051_YYYYMM A
WHERE  A.VPERIOD BETWEEN '202002' AND '202101'
GROUP BY A.VPERIOD,A.VKEY1) B