on 2005 Sep 16 5:43 AM
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
Hi,
Try this.
modify (v_tab) from (v_wa).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Field symbols <F1> TYPE ANY
v_tab = 'ZTAB1'.
ASSIGN (V_TAB) TO <F1>.
<F1> = wa1.
modify (v_tab) from <F1>.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
v_tab = 'ZTAB1'.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Field symbols <F1> TYPE ANY
<F1> = wa1.
v_tab = ztab1
modify (v_tab) from <F1>.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
105 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.