topic Re: calculation on dynamic Internal table fields in Application Development and Automation Discussions

calculation on dynamic Internal table fields

Former Member — Tue, 19 May 2009 11:25:49 GMT

Hi Experts

I have one dynamic internal table in this i have to do some calcultaions.

dynamic inertnal table fields

quanity

c010

c020

c030

c040

c050

**********

i want to caluclate like for all the records in the internla table

quantity * c010

quantity * c020

quantity * c030

***

is it possible, how can it be done.

Thanks

Farooq

Re: calculation on dynamic Internal table fields

Former Member — Tue, 19 May 2009 11:37:55 GMT

Hi ,

Try like this

1 ) 1st calculate the number of records in that internal table

Do i_values_count times.

clear var1.
Var1 = quantity * <fs>-field1.

append var1 to i_itab2.

enddo.

i_values_count is your total count in internal table

var1 for which your calculated value will be moved

i_itab2 which collects all the calculated sum

Regards

Sudhe

Re: calculation on dynamic Internal table fields

Former Member — Tue, 19 May 2009 11:40:22 GMT

You can do it with field symbols

loop at itab assigning <fs>.

<fs1> = <fs>-quantity * <fs>-c010.

Re: calculation on dynamic Internal table fields

Former Member — Tue, 19 May 2009 11:42:00 GMT

Hi..

Try building the logic with:

ASSIGN COMPONENT sy-index OF STRUCTURE <> TO <>. or a similar variant

Regards,

Arun

Re: calculation on dynamic Internal table fields

rainer_hbenthal — Tue, 19 May 2009 11:45:18 GMT

This is more or less not working code, but shows how to achieve that:


loop at itab assigning <p>.
  do 5 times.
    cinx = sy-index.
    shift cinx left by 1 places.
    overlay cinx with '000'.
    concatenate '<p>-c' cinx into varname.
    assign <fs> to varname.
    <fs> = <fs> * qty.
  enddo.
endloop.

cinx should be a c var in length 3, <p> a fieldsymbol with linetype of your table, and <fs> a field symbol type to your columns. This will upodate c010, c020, c030, c040 and c050. You have to modify the do statements to fit your needs.

Re: calculation on dynamic Internal table fields

Former Member — Tue, 19 May 2009 11:49:10 GMT

Hi,

Thanks for responce.

but here the problem is field names are dynamic.

fields names are not fixed. it may change

***

Quantiy

c010

c050

c070

c100