basic idea on collect statment !

[Former Member]

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 ?

[Former Member]

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 ?

[Sandeep_Panghal]

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). "

[Former Member]

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).

tc

sajimon chandran

[Former Member]

<<removed_by_moderator>>

Moderator message:

Don't Copy Paste SAP Help Documentation

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

[Former Member]

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

[Sandeep_Panghal]

No need of char field.

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

Soemthing like:

Collect HKONT.

Append it_collect.

[Former Member]

Hi,

Loop at it_bsis into wa_bsis.

[Former Member]

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.

[Former Member]

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

Thread is locked for Further posting.