topic Re: Aggregate numeric values in Application Development and Automation Discussions

Aggregate numeric values

Former Member — Fri, 17 Jul 2015 20:08:54 GMT

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

Re: Aggregate numeric values

paul_bakker2 — Sat, 18 Jul 2015 07:40:19 GMT

Have you tried using the COLLECT statement?

cheers

Paul

Re: Aggregate numeric values

pavanm592 — Sat, 18 Jul 2015 07:47:16 GMT

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