Skip to Content
0
Former Member
Feb 25, 2009 at 12:56 PM

add columns

21 Views

i have internal tanle itab1 is like dis

e_id month exp1 exp2 exp3 exp4 ........... . ...........exp45

258 jan 00 25 25 66 .........

258 feb 30 11 00 22 ...............

258 feb 40 00 22 45..................

258 feb 40 00 26 10.....................

258 mar 00 30 72 45

258 mar 25 88 32 55....................

258 apr 40 00 22 45........................

259 jan 00 25 25 66 ....................

259 feb 30 11 00 22.................

259 feb 40 00 22 45.................

259 feb 40 00 26 10....................

259 mar 00 30 72 45........................

259 mar 25 88 32 55.........................

259 apr 40 00 22 45.......................

260.................

...................

.............

now i want a final intarnal table itab2 like this

e_id month sum(exp1) sum(exp2) sum(exp3) sum(exp4) ........... . ...........sum(exp45)

259 jan 00 25 25 66

259 feb 110 11 48 77

259 mar 25 118 104 110

259 apr 40 00 22 45

260 jan...........

260 feb ......