topic Re: USING SUM IN INTERNAL TABLE in Application Development and Automation Discussions

USING SUM IN INTERNAL TABLE

sudhir_uppalapati — Wed, 20 Jun 2007 05:53:24 GMT

plz give me a simple example for using SUM in internal table and do some calculations in the same internal table.

Re: USING SUM IN INTERNAL TABLE

Former Member — Wed, 20 Jun 2007 05:54:57 GMT

Hi,

Check this link for a sample code using sum..

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb381a358411d1829f0000e829fbfe/content.htm

Thanks

Naren

Re: USING SUM IN INTERNAL TABLE

Former Member — Wed, 20 Jun 2007 05:58:35 GMT

Hi,

Try using the COLLECT statement.

Hope it is useful.

Thanks,

Sandeep.

Re: USING SUM IN INTERNAL TABLE

Former Member — Wed, 20 Jun 2007 05:59:10 GMT

hi,

check this code,

SORT g_tab BY werks.

LOOP AT g_tab INTO g_wa.

AT FIRST.

WRITE: 'plant quantity details'.

ENDAT.

ON CHANGE OF g_wa-werks.

WRITE:/ 'plant:', g_wa-werks.

ENDON.

WRITE: / g_wa-matnr,

g_wa-basmg.

AT END OF werks.

SUM.

WRITE:/ 'total amount:', g_wa-basmg.

ENDAT.

ENDLOOP.

reward points if helpful,

seshu.

Re: USING SUM IN INTERNAL TABLE

Former Member — Wed, 20 Jun 2007 05:59:25 GMT

CHECK WITH THIS

Syntax

SUM.

Effect

The statement SUM can only be specified within a loop starting with LOOP, and is only considered within a AT- ENDAT control structure. Prerequisites for using the statement SUM include using the addition INTO in the LOOP statement, and that the specified work area wa is compatible with the row type of the internal table. In addition, SUM cannot be used when the row type of the internal table itab contains components that are tables.

The statement SUM calculates the component total with the numeric data type (i, p, f) of all rows in the current control level and assigns these to the components of the work area wa. In the control levels FIRST, LAST, and outside of an AT-ENDAT control structure, the system calculates the sum of numeric components of all rows in the internal table.

Example

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.

Hope this solves ur problem....

do reward if useful....

regards

dinesh

Re: USING SUM IN INTERNAL TABLE

Former Member — Wed, 20 Jun 2007 06:01:52 GMT

Hi,

SUM.

You can only use this statement within a LOOP. If you use SUM in an AT - ENDAT block, the system calculates totals for the numeric fields of all lines in the current line group and writes them to the corresponding fields in the work area (see example in ). If you use the SUM statement outside an AT - ENDAT block (single entry processing), the system calculates totals for the numeric fields of all lines of the internal table in each loop pass and writes them to the corresponding fields of the work area. It therefore only makes sense to use the SUM statement in AT...ENDAT blocks.

If the table contains a nested table, you cannot use the SUM statement. Neither can you use it if you are using a field symbol instead of a work area in the LOOP statement.

Example:

DATA: BEGIN OF LINE,

COL1 TYPE C,

COL2 TYPE I,

COL3 TYPE I,

END OF LINE.

DATA ITAB LIKE HASHED TABLE OF LINE

WITH UNIQUE KEY COL1 COL2.

LINE-COL1 = 'A'.

DO 3 TIMES.

LINE-COL2 = SY-INDEX.

LINE-COL3 = SY-INDEX ** 2.

INSERT LINE INTO TABLE ITAB.

ENDDO.

LINE-COL1 = 'B'.

DO 3 TIMES.

LINE-COL2 = 2 * SY-INDEX.

LINE-COL3 = ( 2 * SY-INDEX ) ** 2.

INSERT LINE INTO TABLE ITAB.

ENDDO.

SORT ITAB.

LOOP AT ITAB INTO LINE.

WRITE: / LINE-COL1, LINE-COL2, LINE-COL3.

AT END OF COL1.

SUM.

ULINE.

WRITE: / LINE-COL1, LINE-COL2, LINE-COL3.

SKIP.

ENDAT.

AT LAST.

SUM.

ULINE.

WRITE: / LINE-COL1, LINE-COL2, LINE-COL3.

ENDAT.

ENDLOOP.

Regards,

Padmam.