topic Re: collect statement in Application Development and Automation Discussions

collect statement

Former Member — Thu, 26 May 2005 18:04:37 GMT

lets say I was collecting this:

employee name deduction contribution

john doe 500 0

john doe 0 500

for some reason my program appends this instead of collecting it, any ideas.

thanks

Re: collect statement

RichHeilman — Thu, 26 May 2005 18:10:07 GMT

What is the structure of you internal table. What are the fields/types. Maybe post some relevant code.

Regards,

Rich Heilman

Re: collect statement

Former Member — Thu, 26 May 2005 18:17:02 GMT

Hi Jamie,

For a collect to work, your fields that need to be added should be of numeric type(P,I or F). They cannot be C or N.

Srinivas

Re: collect statement

Former Member — Thu, 26 May 2005 18:33:00 GMT

types:

begin of data_struc_totals,

group(12) type c, "group

curr like t5ud3-curre,

pen_num type i, "number of pensioners

reg_num type i, "number of regulars

pen_rem type p decimals 2, "remittance pensioners

reg_rem type p decimals 2, "remittance regulars

pen_cov type p decimals 2, "coverage pensioners

reg_cov type p decimals 2, "coverage regulars

rem_tot type p decimals 2,"Grand Total

cov_tot type p decimals 2,

grand_tot type p decimals 2,

end of data_struc_totals.

here is the data structure,

Re: collect statement

RichHeilman — Thu, 26 May 2005 18:52:19 GMT

Ok, I don't see anything wrong with your table structure. I did a little program and it is working fine.



types:
begin of data_struc_totals,
group(12) type c, "group
curr like t5ud3-curre,
pen_num type i, "number of pensioners
reg_num type i, "number of regulars
pen_rem type p decimals 2, "remittance pensioners
reg_rem type p decimals 2, "remittance regulars
pen_cov type p decimals 2, "coverage pensioners
reg_cov type p decimals 2, "coverage regulars
rem_tot type p decimals 2,"Grand Total
cov_tot type p decimals 2,
grand_tot type p decimals 2,
end of data_struc_totals.

data: itab type table of data_struc_totals with header line.

start-of-selection.



clear itab.
itab-group      = 'A'.
itab-curr       = 'USD'.
itab-pen_num    = '3'.
itab-reg_num    = '2'.
itab-pen_rem    = '5.00'.
collect itab.

clear itab.
itab-group      = 'A'.
itab-curr       = 'USD'.
itab-pen_num    = '1'.
itab-reg_num    = '3'.
itab-pen_rem    = '10.00'.
collect itab.


check sy-subrc  = 0.

This code writes one line in the table

A,USD,4,5,15

Can you post some more of your code showing exactly where you problem is.

Regards,

Rich Heilman

Re: collect statement

Former Member — Thu, 26 May 2005 19:03:13 GMT

your just putting collect itab,

I'm putting collect itab into (results table).

Re: collect statement

RichHeilman — Thu, 26 May 2005 19:10:28 GMT

k, what does your results table look like, and how are you moving the data from one table to the other. Please post some relevant code.



types:
begin of data_struc_totals,
group(12) type c, "group
curr like t5ud3-curre,
pen_num type i, "number of pensioners
reg_num type i, "number of regulars
pen_rem type p decimals 2, "remittance pensioners
reg_rem type p decimals 2, "remittance regulars
pen_cov type p decimals 2, "coverage pensioners
reg_cov type p decimals 2, "coverage regulars
rem_tot type p decimals 2,"Grand Total
cov_tot type p decimals 2,
grand_tot type p decimals 2,
end of data_struc_totals.

data: itab type table of data_struc_totals with header line.
data: itab2 type table of data_struc_totals with header line.


start-of-selection.

  clear itab.
  itab-group      = 'A'.
  itab-curr       = 'USD'.
  itab-pen_num    = '3'.
  itab-reg_num    = '2'.
  itab-pen_rem    = '5.00'.
  append itab.

  clear itab.
  itab-group      = 'A'.
  itab-curr       = 'USD'.
  itab-pen_num    = '1'.
  itab-reg_num    = '3'.
  itab-pen_rem    = '10.00'.
  append itab.

  check sy-subrc  = 0.


  loop at itab.
    move-corresponding itab to itab2.
    collect itab into itab2.
  endloop.

  check sy-subrc  = 0.

Regards,

Rich Heilman

Re: collect statement

Former Member — Thu, 26 May 2005 19:28:41 GMT

data: i_results_totals type table of data_struc_totals with header line.

data: wa_results_totals type data_struc_totals. "Work area

collect wa_results_totals into i_results_totals.

here is the output

OP 40-44 0 0.00 0.00 111 1,561.81 0.00 1,561.81 0.00 0.00

OP 45-49 0 0.00 0.00 127 3,303.88 60,000.00 3,303.88 60,000.00 0.00

OP 50-54 0 0.00 0.00 119 4,992.77 60,000.00 4,992.77 60,000.00 0.00

OP 50-54 40 3,752.47 42,760,000.00 0 0.00 0.00 3,752.47 42,760,000.00 0.00

OP 55-59 0 0.00 0.00 79 5,690.44 60,000.00 5,690.44 60,000.00 0.00

OP 55-59 167 22,895.74 160,000,000.00 0 0.00 0.00 22,895.74 160,000,000.00 0.00

you see how it is not collecting the 55-59 group or the 50-54 group all the time. It does it for a while then appends another line and uses that one for collecting.

Re: collect statement

Former Member — Thu, 26 May 2005 19:32:49 GMT

Just a hunch!

Check to see if the currencies (CURR) are the same for all the lines. Seems like that is the problem.

Rishi

Re: collect statement

Former Member — Thu, 26 May 2005 19:47:05 GMT

that was a good hunch.

thanks a bunch

Re: collect statement

RichHeilman — Thu, 26 May 2005 19:51:14 GMT

Thought that it was understood that anything left of the first numerical field to be collected is the key.....

program will collect by key only, in your case group and currency.

Regards,

Rich Heilman