topic Re: collect in Application Development and Automation Discussions

collect

Former Member — Wed, 25 Apr 2007 10:51:41 GMT

the itab contains the following fields.

sno

sname

smarks

sno sname smarks

1 srinivas 100

2 sri 99

3 srija 89

4 srinivas 45

by using the collect statement i have to add numeric fields and print.how can i write the collect statement plz expalin me.

Re: collect

Former Member — Wed, 25 Apr 2007 10:54:07 GMT

Collect statement will add the numeric fields automatically.

Just try this simple code it will work.

loop at itab.

collect itab.

endloop.

loop at itab.

write: / itab-sno,itab-sname,itab-smarks.

endloop.

Thanks & Regards

Santhosh

Message was edited by:

Santhosh

Re: collect

Former Member — Wed, 25 Apr 2007 10:55:59 GMT

Hi,

First of all the sno field has to be char field, then simply COLLECT ITAB, if the itab contains header line. or collect wa into itab.

Amitava

Re: collect

Former Member — Wed, 25 Apr 2007 13:38:10 GMT

hi,

collect is just like append statement.where it compares all the record in the body with the record present in the field string...if the record does not exists then it gets appended or else if they r integer values then they get added even numeric values get added if the record exists..

if u feel tht it is an useful answer then reward with points,

with regards,

madhuri.

Re: collect

Former Member — Wed, 25 Apr 2007 13:43:31 GMT

i t adds numeric fields if a similar record exists els it appends it...

in ur exp

each record is unique they gets appeds at end it does not adds..

if u have again record with sam info but diff nueric field it adds..

Re: collect

Former Member — Wed, 25 Apr 2007 13:48:24 GMT

when you have the following statement.

COLLECT [wa INTO] itab.

It will autometically add up the neumerical velues when the other character fields remail same.

Re: collect

Former Member — Wed, 25 Apr 2007 13:51:04 GMT

Example

Summarized sales figures by company:

TYPES: BEGIN OF COMPANY, 
        NAME(20) TYPE C, 
        SALES    TYPE I, 
      END OF COMPANY. 

DATA: COMP    TYPE COMPANY, 
      COMPTAB TYPE HASHED TABLE OF COMPANY 
                                WITH UNIQUE KEY NAME. 

COMP-NAME = 'Duck'.  COMP-SALES = 10. COLLECT COMP INTO COMPTAB. 
COMP-NAME = 'Tiger'. COMP-SALES = 20. COLLECT COMP INTO COMPTAB. 
COMP-NAME = 'Duck'.  COMP-SALES = 30. COLLECT COMP INTO COMPTAB

Table COMPTAB now has the following contents:

NAME | SALES

Duck | 40

Tiger | 20

Re: collect

Former Member — Wed, 25 Apr 2007 13:51:16 GMT

Hi,

sno sname smarks

1 srinivas 100

2 sri 99

3 srija 89

4 srinivas 45

sno should be a non-numeric field. After using collect instead append the result

will be

1 srinivas 100

2 sri 99

3 srija 89

4 srinivas 45

as sno sname fileds combination is unique for all the rows.

1 srinivas 100

2 sri 99

3 srija 89

1 srinivas 45

then result of collect is

1 srinivas 145

2 sri 99

3 srija 89

If helpful reward points,

Regards,

Tanmay