topic Re: Help in Sum in Application Development and Automation Discussions

Help in Sum

Former Member — Sun, 25 May 2008 07:03:11 GMT

Hi,

i Have in program internal table with fields like below

and i wont to sum the sick days and put it in the last Colman

what is the Best way to do that?

Regards

i have this table without Colman sum (empty) .

pernr      orgeh       sick_days        sum
 
123        5555            3                   7
123        5555            4                   7
456        6666            7                  16
456        6666            1                  16
456        6666            8                  16
789        5656            3                  6
789        5656            3                  6

Re: Help in Sum

Former Member — Sun, 25 May 2008 07:19:10 GMT

hi there....

loop at this internal table, initiate the variable which will hold the sum as 0, and then do as follows

loop at itab.

sum = sum + sick_days.

endloop.

write 😕 sum.

what will happen is that the loop will start off from the first record till the last and will keep on adding the number of sick days into sum. Hence, at the end of the loop, u will hav the total number of sick days.

i hope this answers ur query. Do reward if helpful or get back with further issues.

Re: Help in Sum

Former Member — Sun, 25 May 2008 07:23:06 GMT

hi ....

i think i misunderstood the qstn earlier,

do like this....

select sum (Sick_days) from itab into sum group by pernr.

write 😕 itab-col1, itab-col2... sum.

endselect.

this will surely help.

do reward if it does.

Re: Help in Sum

Former Member — Sun, 25 May 2008 07:25:24 GMT

Hi prem ,

Thanks but what i wont is little bit complicated,

what i wont is is to do sum for every employee,

in your Example it make sum for all employees.

Regards

i try with this code but i dont success.

DATA: sum_sick_days TYPE p decimals 2,
            tmp_sum TYPE p decimals 2,

  LOOP AT e_tab INTO  wa_e_tab.
    at end of penrnr.
      SUM.
      sum_sick_days = wa_e_tab-sick_days.
      tmp_sum =  sum_sick_days.
    ENDAT.
    wa_e_tab-sum = tmp_sum.
    MODIFY  e_tab FROM wa_e_tab TRANSPORTING sum  .
  ENDLOOP.

Re: Help in Sum

Former Member — Sun, 25 May 2008 07:27:05 GMT

Hi,

i cant do select from internal table.

Regards

Re: Help in Sum

Former Member — Sun, 25 May 2008 08:13:47 GMT

hi....

ok, then lets try like this...

use two loops on the internal table.

loop at itab into wa1.

loop at itab into wa2.

if wa1-pernr eq wa2-pernr.

sum = sum + sick_days.

write : wa2-col1, wa2-col2...., sum..

else.

sum=0.

endif.

endloop.

trty this one out and lemme know if it works.

wa1 and wa2 are two workareas for the same internal table.

do reward if this helps or get back again.

Re: Help in Sum

Former Member — Sun, 25 May 2008 08:14:14 GMT

Hi,you can do this in the following way,



Loop at Itab into wa.

at new pernr.

sum = 0.

endat.

sum  = sum + sick_days.

at end pernr.

sum  = sum + sick_days. " Keep and remove and check for the result,you may need it or you may not,Iam not sure

write : wa-pernr,wa-orgeh,wa-sick_days,wa-sum.

endloop.

I think this will work perfectly,for every new pernr sum=0(At new) and for all the iteraions for the same pernr sum will be added with sick days an at the end of the same pernr it will be printed.I commented a line,check for that line.

Reward If Found Useful

Re: Help in Sum

Former Member — Sun, 25 May 2008 08:44:19 GMT

Hi Rock,

i try your code and it bring the same data like my code:

the problem that in at end of pernr not acsses to the code when we have last emplyeee what i get :

pernr                 period     miss_days        sum
00010153	         200610	     21.80	           21.80
00010155	        200606	     20.56	           20.56
00010158	        200608	    23.00	           23.00
00010158	        200610	    21.56	            21.56
00010158	        200611	    22.00	           22.00



this is my code :

  LOOP AT e_tab INTO wa_e_tab.

    AT NEW penrnr.
      sum = 0.
    ENDAT.
    sum  = sum + wa_e_tab-sick_days.
    AT END OF penrnr.
      sum  = sum + wa_e_tab-sick_days.
      MOVE sum TO  wa_e_tab-sum.
      MODIFY  e_tab FROM wa_e_tab TRANSPORTING sum  .
    ENDAT.
  ENDLOOP.

Regards

Re: Help in Sum

Former Member — Sun, 25 May 2008 08:46:57 GMT

hi ricardo,

the best possible way is the one i hav suggested above using two similar workarea and using two loops.

try that out and lemme know if it helps.

Re: Help in Sum

Former Member — Sun, 25 May 2008 08:54:24 GMT

Hi perm,

i try like your code and its almost o.k.

i need like in the e.g to put 66 for every line of sum for employee 10158.

pernr      perid       sick_days      sum
10153	200610	  21.80	            21.80
10155	200606	  20.56	           20.56
10158	200608	  23.00	           22.00
10158	200610	  21.56	           44.00
10158	200611	  22.00	           66.00

Regards

Re: Help in Sum

Former Member — Sun, 25 May 2008 08:57:55 GMT

hi there....

thanks...

for that, put the write statement, outside the endif. it will work as required.

if is does, close the qstn by rewarding.

Re: Help in Sum

Former Member — Sun, 25 May 2008 08:59:00 GMT

the code will look something like this

loop at itab into wa1.

loop at itab into wa2.

if wa1-pernr eq wa2-pernr.

sum = sum + sick_days.

else.

sum=0.

endif.

write : wa2-col1, wa2-col2...., sum..

endloop.

Re: Help in Sum

Former Member — Sun, 25 May 2008 09:05:21 GMT

hi Prem,

i try like your E.g and i have exactly the same output like below.

Regards

LOOP AT e_tab INTO wa_e_tab.
    LOOP AT e_tab INTO wa_e_tab2.
      IF wa_e_tab-penrnr EQ wa_e_tab2-penrnr.
        sum = sum + wa_e_tab-sick_days.
        MOVE sum TO  wa_e_tab-sum.
      ELSE.
        sum =  0.
      ENDIF.
      MODIFY  e_tab FROM wa_e_tab TRANSPORTING sum  .
    ENDLOOP.
  ENDLOOP.

Re: Help in Sum

Former Member — Sun, 25 May 2008 09:11:10 GMT

hi there...

so is the problem solved or still some trouble??

Re: Help in Sum

Former Member — Sun, 25 May 2008 09:21:06 GMT

Hi,

there is still problem i don't get like in e.g 66 for all employee.

Regards

Re: Help in Sum

Former Member — Sun, 25 May 2008 09:25:18 GMT

hi ricardo...

ur modify statement is not correct.

LOOP AT e_tab INTO wa_e_tab.

LOOP AT e_tab INTO wa_e_tab2.

IF wa_e_tab-penrnr EQ wa_e_tab2-penrnr.

sum = sum + wa_e_tab-sick_days.

MOVE sum TO wa_e_tab-sum.

ELSE.

sum = 0.

ENDIF.

MODIFY e_tab FROM wa_e_tab TRANSPORTING sum .

ENDLOOP.

instead of wa_e_tab use wa_e_tab2.... this is because ur still in the internal loop. so only this wa will affect the rows with same penrnr. use a where condition in this also. like

MODIFY e_tab FROM wa_e_tab2 TRANSPORTING sum where wa_e_tab-penrnr EQ wa_e_tab2-penrnr

i hope this helps.