topic internal table in Application Development and Automation Discussions

internal table

Former Member — Sat, 18 Mar 2006 04:47:46 GMT

hi frnd's,

I had an internal table with 5 fields.I want to sum up (total) a one field value and dispaly it in the screen.

can this be possible.

Re: internal table

Former Member — Sat, 18 Mar 2006 04:53:59 GMT

Hi Suganya,

Can u explain ur question?

U want to sum your field values at the end of the internal table??

Re: internal table

suresh_datti — Sat, 18 Mar 2006 04:56:27 GMT

Hi,

Pl try this..


SORT ITAB.

LOOP AT ITAB.
AT LAST.
SUM.
write:/ itab-field. "the field you want to total
endat.
endloop.

Regards,

Suresh Datti

Re: internal table

Former Member — Sat, 18 Mar 2006 04:57:42 GMT

Example I had a field name a,b,c in internal table it_alpha.

It contains ten datas in to it,then i wnt to sum all the datas of field a in it_alpha,and display it into the textfield total__________ in screen.

Re: internal table

Former Member — Sat, 18 Mar 2006 04:58:32 GMT

it is not a report program.

Re: internal table

Former Member — Sat, 18 Mar 2006 05:05:43 GMT

DATA sum LIKE it_alpha-a.

LOOP AT it_alpha.

sum = sum + it_alpha-a.

ENDLOOP.

Now use the sum wherever you want.

Regards,

Wenceslaus.

Re: internal table

Former Member — Sat, 18 Mar 2006 05:08:34 GMT

The internal table has fields a,b,c. U want to sum the values of a & display it.

declare variale sum.

Loop at it_alpha.

sum = sum + it_aplha-a.

endloop.

Use the sum at last to display it in the textfield total__________ in screen.

Re: internal table

venkata_ramisetti — Sat, 18 Mar 2006 05:18:20 GMT

HI,

Write code similar to below.

DATA:BEGIN OF ITAB OCCURS 0,

FIELD1 TYPE FIELD1,

FIELD2 TYPE FIELD2,

FIELD3 TYPE FIELD3,

AMOUNT TYPE P DECIMALS 2,

QTY TYPE P DECIMALS 3,

END OF ITAB.

DATA: V_TOTAL_AMOUNT TYPE TYPE P DECIMALS 2,

V_TOTAL_QTY TYPE TYPE P DECIMALS 3.

*Assume thAT you populated data

LOOP AT ITAB.

AT FIRST.

SUM.

V_TOTAL_AMOUNT = ITAB-AMOUNT .

V_TOTAL_QTY = ITAB-QTY.

ENDAT.

ENDLOOP.

THanks,

Ramakrishna