topic Re: internal table in Application Development and Automation Discussions

internal table

madan_ullasa — Mon, 28 Nov 2005 13:58:24 GMT

frnds,

i'm using the table control statements at new, at end of..

but the prob. is that, it considers the fields to the left of the column of the field we use in the condition.

eg.

my itab is .

field F1 F2 F3

_______________________

1st row a1 b1 100

2nd row a2 b1 300

3rd row a3 b2 400

now if i use at new F2, or end of F2, and then SUM, still the values on the right are not added. Coz it considers each value of F1 as a new field.

any other method to sum the values on right, at the change of value of the field F2.

RichHeilman — Mon, 28 Nov 2005 14:02:30 GMT

You could look into the ON CHANGE OF statement.

Regard,

RIch Heilman

Former Member — Mon, 28 Nov 2005 14:03:25 GMT

Try 'ON Change of' field and ENDON clause.

madan_ullasa — Mon, 28 Nov 2005 14:04:11 GMT

hi,

it does not work . coz it considers the change of value at end only.

FredericGirod — Mon, 28 Nov 2005 14:05:37 GMT

Hi Madan,

you have to play with something like :

F2_old like F2.

if F2_old ne F2.
  move F2 to F2_old.
  write /1 value_of_sum.
  value_of_sum = F3.
else.
  value_of_sum = value_of_sum + F3.
endif.

or you have to create the same table, clear the first colum, and make a quick sum.

Rgd

Frédéric

Former Member — Mon, 28 Nov 2005 14:41:04 GMT

Make F2 your farmost right column.:

F1 F3 F2

FredericGirod — Mon, 28 Nov 2005 14:43:46 GMT

That didn't work, cause F3 have the value, so F2 will change each time F3 change.

Fred

Message was edited by: Frédéric Girod

madan_ullasa — Mon, 28 Nov 2005 14:44:04 GMT

hey frnd,

i got it ... but will have to make F2 the far most left column..it works :)-:)-

regards,

madan............