Dynamic Query

[Former Member]

hi,

i want to make dynamic query..

presently i am having query like this..

modify ztab1 from wa1.

modify ztab2 from wa2.

modify ztab3 from wa3.

now i want to pass table name and wa in variable assume

v_wa = wa1.

v_tab = ztab1

modify v_tab from v_wa.

v_wa = wa2.

v_tab = ztab2

modify v_tab from v_wa.

v_wa = wa3.

v_tab = ztab3

modify v_tab from v_wa.

i am not able to do this can somebody help me out...

thanx

abhishek suppal

[jayanthi_jayaraman]

Hi,

Try this.

modify (v_tab) from (v_wa).

[Former Member]

Hi,

you can dynamically change the work arear by using field symbols.

modify (tablename) from <fs>.

this above statement suitable for database table only, but i don't thing it will work for internal table.

assign (wa) to <fs>

Modify itab1 from <fs>

Cheers,

Sasi

[Former Member]

Field symbols <F1> TYPE ANY

v_tab = 'ZTAB1'.

ASSIGN (V_TAB) TO <F1>.

<F1> = wa1.

modify (v_tab) from <F1>.

Hope this helps.

[Former Member]

v_tab = 'ZTAB1'.

[Former Member]

Field symbols <F1> TYPE ANY

<F1> = wa1.

v_tab = ztab1

modify (v_tab) from <F1>.

Hope this helps.