Skip to Content
0
Former Member
Dec 20, 2006 at 10:19 AM

Reg select query

17 Views

Hi Guys,

I got a problem with select query...could you polease help me out...plz check the second select query statement

when i open tstcp table i gave Ztable and then when I exceute i am able to get the list when i do it programatically it is not working .....

any suggestions...points will be rewarded..

select tabname

from dd02l into table i_dd02l where tabname like 'Z%' and

( tabclass = 'VIEW'

or

tabclass = 'TRANSP' ) and

( mainflag = 'X'

or

mainflag = '' ).

if not i_dd02l[] is initial.

loop at i_dd02l.

v_tabna = i_dd02l-tabname.

select single tcode

param into (v_tcode , v_param)

from tstcp where param like '%v_tabna%'.

i_tstcp-tcode = v_tcode.

i_tstcp-param = v_param.

append i_tstcp.

clear i_tstcp.

endloop.

endif.

Regards,

Ravi Ganji