topic Re: Dynamic column name in Application Development and Automation Discussions

Dynamic column name

Former Member — Wed, 21 Feb 2007 10:17:38 GMT

hi experts,

DATA: temp(20) VALUE 'DATA',

i TYPE I VALUE 1,

J(2) type c.

LOOP AT l_t_tsi.

J = I.

CONCATENATE TEMP J INTO COLNAME.

itab-(COLNAME) = l_t_tsi-time_series_value.

i = i + 1.

ENDLOOP.

My internal table (itab) has fields data1(20), data2(20), data3(20)...

I want to generate the column names dynamically only.

The above code gives an error at this line -

itab-(COLNAME) = l_t_tsi-time_series_value.

Thanks in advance,

Bijal

Re: Dynamic column name

Former Member — Wed, 21 Feb 2007 10:19:30 GMT

itab-(COLNAME) u cant use like this.

<b>itab-COLNAME</b>

Re: Dynamic column name

athavanraja — Wed, 21 Feb 2007 10:20:48 GMT

its not possible in this fashion. but if you tell us what you want do by doing this, may be we could come up with better option

Re: Dynamic column name

Former Member — Wed, 21 Feb 2007 10:22:24 GMT

hi,

mentioning colname gives itab does not contain colname field.

thanks

Re: Dynamic column name

Former Member — Mon, 26 Mar 2007 08:23:22 GMT

Hi,

If your aim is to refer to a internal table field dynamically you can do it.

Look at the code segment below -

DATA: temp(20) VALUE 'DATA',

i TYPE I VALUE 1,

J(2) type c.

FIELD-SYMBOLS: <ls_data>.

LOOP AT l_t_tsi.

J = I.

CONCATENATE TEMP J INTO COLNAME.

<b>ASSIGN COMPONENT colname OF itab TO <ls_data>.

<ls_data> = l_t_tsi-time_series_value.</b>

*itab-(COLNAME) = l_t_tsi-time_series_value.

i = i + 1.

ENDLOOP.

Regards,

Manish Joshi

If it solves your problem, close the thread.
Don't clutter-up forum by leaving open threads.