hi
You can use collect statement if you have all the non-numeric fields are similar. Collect will sum up all the numeric fields where the non-numeric fields are same.
if you have other fields which are not similar, in your case the field 1, which you are not considering. I would suggest you to use Sum statement. Sort the table on field 2 and then sum up the values 'AT END OF' Statement.
sample code:
Control level processing for creating a list. At the end of line groups, the total of reserved places is calculated and issued.
DATA: sflight_tab TYPE SORTED TABLE OF sflight
WITH UNIQUE KEY carrid connid fldate,
sflight_wa LIKE LINE OF sflight_tab.
SELECT *
FROM sflight
INTO TABLE sflight_tab.
LOOP AT sflight_tab INTO sflight_wa.
AT NEW connid.
WRITE: / sflight_wa-carrid,
sflight_wa-connid.
ULINE.
ENDAT.
WRITE: / sflight_wa-fldate,
sflight_wa-seatsocc.
AT END OF connid.
SUM.
ULINE.
WRITE: / 'Sum',
sflight_wa-seatsocc UNDER sflight_wa-seatsocc.
SKIP.
ENDAT.
AT END OF carrid.
SUM.
ULINE.
WRITE: / 'Carrier Sum',
sflight_wa-seatsocc UNDER sflight_wa-seatsocc.
NEW-PAGE.
ENDAT.
AT LAST.
SUM.
WRITE: / 'Overall Sum',
sflight_wa-seatsocc UNDER sflight_wa-seatsocc.
ENDAT.
ENDLOOP.
Exceptions
Catchable Exceptions
CX_SY_ARITHMETIC_OVERFLOW
Cause: Overflow when calculating totals
Runtime Error: ADDF_INT_OVERFLOW (catchable)
Cause: Value too large when calculating totals in internal table, field too small
Runtime Error: SUM_OVERFLOW
Non-Catchable Exceptions
Cause: The statement SUM was used outside a LOOP processing of an internal table.
Runtime Error: SUM_NO_INTERNAL_TABLE
Cause: The statement SUM was used within a AB>LOOP processing belonging to another ABAP program.
Runtime Error: SUM_ON_FOREIGN_INTERNAL_TABLE
Cause: The statement SUM was used within a loop starting with LOOP ... ASSIGNING.
Runtime Error: SUM_NO_ASSIGNING
-
Santosh
Bluesky
