topic Re: sum amount in Application Development and Automation Discussions

sum amount

Former Member — Tue, 11 May 2010 11:06:57 GMT

i use this part of code:

loop at i_mapping into wa.
  if wa-xblnr ne m_xblnr and wa-mwskz ne m_mwskz.
        clear : wa1.
  move m_xblnr to wa1-xblnr.
        move m_mwskz to wa1-mwskz.
        move m_net   to wa1-znet.
        append wa1 to i_new.
        clear m_net.
   endif.
  append wa to i_new.
  add wa-znet to m_net.
  move wa-xblnr to m_xblnr.
  move wa-mwskz to m_mwskz.
endloop.

clear : wa1.
move m_xblnr to wa1-xblnr.
move m_mwskz to wa1-mwskz.
move m_net   to wa1-znet.
append wa1 to i_new.

this appends the i_mapping to i_new and appends some new lines with the summation of znet by xblnr.

i want not to sum only by xblnr but with xblnr mwskz.

to be more clear if the xblnr and mwszk in first line for example is equal with the third ( let's say that is the last line ) then i want to append a new line (forth line) with the summation of znet of first and third line.

Re: sum amount

Former Member — Tue, 11 May 2010 11:15:46 GMT

Try this

the itab1 has the out put

data : BEGIN OF itab OCCURS 0,

field1 type i,

field2 type i,

field3 type i,

end of itab.

DATA itab1 LIKE HASHED TABLE OF itab

WITH UNIQUE KEY field1 field2.

itab-field1 = 11.

itab-field2 = 10.

itab-field3 = 10.

append itab.

itab-field1 = 11.

itab-field2 = 20.

itab-field3 = 20.

append itab.

itab-field1 = 12.

itab-field2 = 10.

itab-field3 = 20.

append itab.

itab-field1 = 12.

itab-field2 = 10.

itab-field3 = 30.

append itab.

loop at itab.

collect itab into itab1.

endloop.

output.

11 10 10

11 20 20

12 10 50

Re: sum amount

Former Member — Tue, 11 May 2010 11:22:39 GMT

Hi,

Check the IF condition


sort <first itab> by xblnr mwskz.
if wa-xblnr ne m_xblnr or wa-mwskz ne m_mwskz

This will insert the summary record for each change of xblnr or mwskz. If you want only summary records use the collect statement.

Regards

Vinod

Re: sum amount

Former Member — Tue, 11 May 2010 11:23:29 GMT

Hi,

Before loop at i_mapping into wa.

sort i_mapping by XBLNR MWSKZ.

Regards

Dillip Sahoo

Re: sum amount

Former Member — Tue, 11 May 2010 11:28:16 GMT

i have tried everything but it works only for xblnr . what about the combination of xblnr and mwskz.

Re: sum amount

Former Member — Tue, 11 May 2010 11:29:58 GMT

Have you changed the AND condition to OR?

Regards

Vinod

Re: sum amount

Former Member — Tue, 11 May 2010 11:33:24 GMT

yes. it is better but appends a line without doing summation.

if in first itab there is no line to sum ( unique xblnr mwskz) then i dont want to add an extra line.

Edited by: antonis nezos on May 11, 2010 2:37 PM

Re: sum amount

Former Member — Tue, 11 May 2010 11:40:29 GMT

Hi, add a counter variable to check the same

data : m_cnt(5) type n value 0. "added"
loop at i_mapping into wa.
  if wa-xblnr ne m_xblnr and wa-mwskz ne m_mwskz.
        if m_cnt gt 1.          " added"
        clear : wa1.
        move m_xblnr to wa1-xblnr.
        move m_mwskz to wa1-mwskz.
        move m_net   to wa1-znet.
        append wa1 to i_new.
        clear m_net, m_cnt .   "added"
      endif.                       "added"
   endif.
  append wa to i_new.
  add wa-znet to m_net.
 add 1 to m_cnt.   "added"
  move wa-xblnr to m_xblnr.
  move wa-mwskz to m_mwskz.
endloop.
 
if m_cnt gt 1. "added"
clear : wa1.
move m_xblnr to wa1-xblnr.
move m_mwskz to wa1-mwskz.
move m_net   to wa1-znet.
append wa1 to i_new.
endif.   "added"

Regards

Vinod

Edited by: Vinod Kumar on May 11, 2010 5:12 PM

Edited by: Vinod Kumar on May 11, 2010 5:14 PM

Re: sum amount

deepak_dhamat — Tue, 11 May 2010 11:50:34 GMT

what is data type of wa1-mwskz

Regards

Deepak.

Re: sum amount

Former Member — Tue, 11 May 2010 11:52:36 GMT

THANK YOU!!!

Edited by: antonis nezos on May 11, 2010 3:24 PM

Re: sum amount

deepak_dhamat — Tue, 11 May 2010 12:07:17 GMT

hi,

change data of wa1-mwskz to character

then loop internal table

collect into another other internal table of same type

endloop.

and you will get your desired result .

Regards

Deepak.

Re: sum amount

Former Member — Tue, 11 May 2010 12:25:22 GMT

i noticed that sums and the lines with different mwskz.

the number of lines is correct but not the summation.

Edited by: antonis nezos on May 11, 2010 3:25 PM

Re: sum amount

Former Member — Tue, 11 May 2010 12:31:09 GMT

i noticed that sums and the lines with different mwskz.

the number of lines is correct but not the summation.

any ideas?

Re: sum amount

Former Member — Wed, 12 May 2010 04:39:43 GMT

Hi,

Can you explain with sample output ?

Regards

Vinod