topic basic idea on collect statment ! in Application Development and Automation Discussions

basic idea on collect statment !

Former Member — Thu, 23 Apr 2009 06:20:00 GMT

DATA: BEGIN OF IT_BSIS OCCURS 0,

BUKRS TYPE BSIS-bukrs, " co code

HKONT TYPE BSIS-HKONT, "General Ledger Account

BUDAT TYPE BSIS-BUDAT, "Posting Date in the Document

AUFNR TYPE BSIS-AUFNR, " SO Number

WRBTR1 TYPE BSIS-WRBTR, " Amount in document currency

END OF IT_BSIS.

I want to collect the data on wrbtr1 .

LOOP AT IT_BSIS .

COLLECT IT_BSIS INTO IT_BSIS2 .

ENDLOOP.

data in table

1000 0000300000 20071024 0000100000 2560.00

1000 0000300000 20071117 0610000004 100000.00

1000 0000300000 20071201 0000100000 200.00

do i need to have char type fields in table atleast 1 to have proper answer ?

Re: basic idea on collect statment !

Sandeep_Panghal — Thu, 23 Apr 2009 06:22:27 GMT

Use F1 help.

"Prerequisite for the use of this statement is that wa is compatible with the row type of itab and all components that are not part of the table key must have a numeric data type (i, p, f). "

Re: basic idea on collect statment !

Former Member — Thu, 23 Apr 2009 06:25:49 GMT

Hi,

Its not mandatory to have character type fields to use collect statement.

infact if u have character field , collect statement will not work

table key must have a numeric data type (i, p, f).

sajimon chandran

Re: basic idea on collect statment !

Former Member — Thu, 23 Apr 2009 06:25:57 GMT

<<removed_by_moderator>>

Moderator message:

Don't Copy Paste SAP Help Documentation

Edited by: Vijay Babu Dudla on Apr 23, 2009 2:35 AM

Re: basic idea on collect statment !

Former Member — Thu, 23 Apr 2009 06:30:08 GMT

Hi,

Loop at it_bsis into wa_bsis.

Re: basic idea on collect statment !

Former Member — Thu, 23 Apr 2009 06:31:59 GMT

Hi,

Collect compares all the char and if values in all char fields are same then the numeric fields are added.

In you case as posting date and SO number's are different it cannot add the WRBTR1 for the same BUKRS & HKONT.

Re: basic idea on collect statment !

Former Member — Thu, 23 Apr 2009 06:32:56 GMT

hi,

my question is if my internal table has 5 flds all r integers then how does collect statement works ?

so is there any need for char type field

Re: basic idea on collect statment !

Former Member — Thu, 23 Apr 2009 06:35:07 GMT

Read the F1 help or SAP Help documentation on Basic ABAP statements.

Thread is locked for Further posting.

Re: basic idea on collect statment !

Sandeep_Panghal — Thu, 23 Apr 2009 06:35:07 GMT

No need of char field.

You can collect the field of ur choice in an internal table.

Soemthing like:

Collect HKONT.

Append it_collect.