ABAP COLLECT statement syntax to add up all numeric internal table values within SAP

This ABAP statement works in a similar way to APPEND and inserts the contents of a work area into an internal table. But instead of simply adding to the end of the itab, it first checks for entries with the same key and then adds to the numeric values of existing row with that same key.

Please note: The key is made up of all fields before numeric field and they must all be the same!

Here is and example ABAP code snipet that demonstrates the use of the COLLECT statement

data: it_ekko type STANDARD TABLE OF ekko,
      wa_ekko like line of it_ekko.
COLLECT wa_ekko into it_ekko.


Related Articles

ABAP DELETE statement keyword to delete data from SAP internal and database tables
ABAP DESCRIBE statement keyword to get information about tables and fields
PERFORM TABLES command passing internal table as parameter
ABAP read command to read line of internal table in SAP
ABAP UPDATE command to modify database field values
AUTHORITY-CHECK abap Statement / command
ABAP delete command in SAP
ABAP MODIFY statement to update SAP data within database and internal tables
ABAP WRITE statement command with in SAP to display data report to users
SAP ABAP Statement syntax including basic implementation code
Concatenate ABAP statement syntax for concatenating data objects, sting values or rows of an SAP internal table
ABAP EXPORT data TO MEMORY ID and import it back again
IF, CHECK & WHEN ABAP commends example source code and information
Call Function module IN BACKGROUND TASK - Execute abap code in seperate background process
Function module IN UPDATE TASK statement - Execute abap code in seperate unit of work
ABAP STRLEN command to get the value length of a SAP field
SAP ABAP SELECT command and its different uses
SELECT..ENDSELECT command
ABAP FOR ALL ENTRIES SELECT statement addition in SAP data retrieval
ABAP SELECT inner join statement to select from two tables at the same time
SELECT directly into an internal table
SELECT directly into an internal table when field order is different
Function module STARTING NEW TASK statement - Execute abap code in seperate work process