Aggregate numeric values

[Former Member]

Hi All,

I have an internal table (itab has fields - field1, field2, field3,field 4, field5), the fields are all character type. some are numeric characters. I want to aggregate field4 (numeric char), when field1, field2 and field5 are the same, Anyone has an idea on how to code it?

Thanks,

Meiying

[paul_bakker2]

Have you tried using the COLLECT statement?

cheers

Paul

[pavanm592]

Hi Yang,

You can get it with COLLECT statement.check the sap keyword help for collect.

you try like this.

TYPES : BEGIN OF ty_test,

         field1 TYPE char4,

         field2 TYPE char4,

         field3 TYPE char4,

         field4 TYPE n LENGTH 5,

         field5 TYPE char4,

   END OF ty_test.

data : lt_test TYPE STANDARD TABLE OF ty_test,

        ls_test TYPE ty_test. 

*&For Aggregate values create a table with only required fields

  TYPES : BEGIN OF ty_aggr,

         field1 TYPE char4,

         field2 TYPE char4,

         field4 TYPE n LENGTH 5,

         field5 TYPE char4,

   END OF ty_aggr.

data : lt_aggr TYPE STANDARD TABLE OF ty_aggr,

        ls_aggr TYPE ty_aggr. 

LOOP AT lt_test INTO ls_test.

MOVE-CORRESPONDING ls_test to ls_aggr.

COLLECT ls_aggr INTO lt_aggr.   "You will get the field4 aggregate

CLEAR : ls_test,ls_aggr.

ENDLOOP.

Regards,

Pavan