topic Re: Collect statement in Application Development and Automation Discussions

Collect statement

Former Member — Tue, 27 Jun 2006 14:16:45 GMT

Hi Friends,

I have many line in an internal table but have the same IT_SEND.

I have the same materials etc.. in all the lines. However the weight differs in every line. SO just wanted to add all weights.

I am using

loop at IT_SEND.

collect IT_SEND.

endloop.

Is this correct.

Shejal.

Re: Collect statement

Former Member — Tue, 27 Jun 2006 14:17:59 GMT

I mean wanted to all the weights and have a single line in my internal table.

Shejal.

Re: Collect statement

Former Member — Tue, 27 Jun 2006 14:18:02 GMT

hi,

loop at IT_SEND.

collect IT_SEND into it_send2.

endloop.

IT_SEND 😆 Stands for work area with sum.

Re: Collect statement

Former Member — Tue, 27 Jun 2006 14:18:38 GMT

I think so, the collect sums all number fields for the record with the same values for the char fields.

But you should use another table:

loop at IT_SEND into IT_SEND2.

collect IT_SEND.

endloop.

Or you use the COLLECT statament while appending the record into IT_SEND.

Max

Re: Collect statement

Former Member — Tue, 27 Jun 2006 14:19:35 GMT

HOwever if i have different materials and i still want to add the weights of all the materials irrespective of what the material is.

Shejal.

Re: Collect statement

Former Member — Tue, 27 Jun 2006 14:21:15 GMT

In that case you cannot use the COLLECT statement as it is dependent on having the same key of the char fields in the table.

In this case you will have to write the logic yourself for totalling.

regards

Ravi

Re: Collect statement

Former Member — Tue, 27 Jun 2006 14:21:28 GMT

if the fields u have in the table are MATNR and weight fields only, COLLECT will work,

if u have different materials also it will work

Message was edited by: Chandrasekhar Jagarlamudi

Re: Collect statement

Former Member — Tue, 27 Jun 2006 14:24:18 GMT

Hi Shejal,

Take another internal table and move matnr and totals for same matnr into it.Whenever performing COLLECT, it is better to take another internal table to store result values of COLLECT.

<b>DATA: BEGIN OF ITAB,

MATNR LIKE MARA-MATNR,

WEIGHT LIKE MARA-BRGEW,

END OF ITAB.

LOOP AT IT_SEND.

MOVE-CORRESPONDING IT_SEND TO ITAB.

COLLECT ITAB.

ENDLOOP.</b>

Thanks,

Vinay

Re: Collect statement

Former Member — Tue, 27 Jun 2006 14:24:40 GMT

Chandrasekhar,

Would it work even for different materials and if yes how?

Shejal.

Re: Collect statement

Former Member — Tue, 27 Jun 2006 14:25:09 GMT

Hi,

Yes it will work.

alternative solution.

wa_temp.

loop at itab.
  wa_temp-material = itab-material.

    sum.
    at end of material.

       wa_temp-weight = itab-weight.

      append wa_temp into itab2.
    endat. 
endloop.

Re: Collect statement

Former Member — Tue, 27 Jun 2006 14:28:06 GMT

Thanks guYS I THING I GOT IT.

Shejal.

Re: Collect statement

Former Member — Tue, 27 Jun 2006 14:31:47 GMT

Hi Shejal,

COLLECT will add all numeric values, if all other non-numeric values (Character values) are same.

In your case you have only matnr and weight,So it holds good for all different materials.

Thanks,

Vinay