topic Re: collect in Application Development and Automation Discussions

collect

Former Member — Fri, 21 Sep 2007 10:50:48 GMT

hi,

data:num1 type num.

num type c.

loop at int_final.

int_final1-matnr = int_final-matnr.

int_final1-vkorg = int_final-vkorg.

int_final1-num1 = int_final-num.

collect int_final1 into int_final1.

endloop.

this case y this collect is not working.

vkr.

Re: collect

former_member189629 — Fri, 21 Sep 2007 10:56:14 GMT

collect int_final1 into int_final.

Message was edited by:

Karthik

Re: collect

Former Member — Fri, 21 Sep 2007 10:56:43 GMT

it seems to me num is a number field but you declare as character type so it is not adding when it is getting repeating value of matnr and vkorg .

declare num as type i or type p it will work (except type C,N,D,T,X).

regards

shiba dutta

Re: collect

hymavathi_oruganti — Fri, 21 Sep 2007 10:57:04 GMT

it should not be

collect int_final1 into int_final1.

it should be

collect int_final1 into int_final.

Re: collect

Former Member — Fri, 21 Sep 2007 10:59:58 GMT

Hi,

see the code

loop at int_final.
int_final1-matnr = int_final-matnr.
int_final1-vkorg = int_final-vkorg.
int_final1-num1 = int_final-num.
collect int_final1 .   " No need to write collect int_final1 into int_final1.
endloop.

Regards

Sudheer

Re: collect

Former Member — Fri, 21 Sep 2007 11:00:22 GMT

hi,

you should use the collect statement seperate seperate fields according with some keys....

we cannot collct all the fields...

try with seperately....

thanks,

Message was edited by:

Alvaro Tejada Galindo

Re: collect

former_member404244 — Fri, 21 Sep 2007 11:00:26 GMT

Hi,

declare num as type i .It will work.also try like this

loop at int_final.

int_final1-matnr = int_final-matnr.

int_final1-vkorg = int_final-vkorg.

int_final1-num1 = int_final-num.

collect int_final1 .

endloop.

Regards,

Nagaraj

Re: collect

hymavathi_oruganti — Fri, 21 Sep 2007 11:04:10 GMT

u r looping at int_final and y r u using int_final1 inside?

what is int_final1 ? is it work are? then ur loop should like below

loo at int_final into int_final1.

and collect as i mentioned above.

if there is no work area and the itab is with header line.

then

change all int_final1 to int_final

and write collect int_final.

Re: collect

Former Member — Fri, 21 Sep 2007 11:07:50 GMT

Hi,

In your case 'NUM' and 'NUM1' should be declared as an interger vairable (either type 'I' or 'P').

COLLECT: will add the numeric fields for the same character field values.

For more information on Collect , see the F1 help..

Hope this helps you.

Regards,

Dilli

Re: collect

Former Member — Sat, 22 Sep 2007 02:34:57 GMT

you should declare as an interger vairable (either type 'I' or 'P'). after that write the code as:

loop at int_final.

int_final1-matnr = int_final-matnr.

int_final1-vkorg = int_final-vkorg.

int_final1-num1 = int_final-num.

collect int_final1 .

endloop.

regards,

praveen.

Re: collect

Former Member — Sat, 22 Sep 2007 11:32:55 GMT

hi vkr,

you are collecting int_final1 into again int_final1 , that is not correct .

So write the code as,

loop at int_final.

int_final1-matnr = int_final-matnr.

int_final1-vkorg = int_final-vkorg.

int_final1-num1 = int_final-num.

collect int_final1 .

endloop.

please reward points if helpfull

with regards,

radhika kolluru.