topic Re: How to write this select query ? in Application Development and Automation Discussions

How to write this select query ?

Former Member — Mon, 02 Mar 2009 07:11:35 GMT

Hi,

I need to write a select query where i need to retrieve the names of the cutomised tables (Starting with Z or Y)

The select query

SELECT * FROM xyz INTO TABLE itab_xyz WHERE TABNAME = 'Z*'

doesn't work.

What's the correct way to write this ?

Re: How to write this select query ?

Sm1tje — Mon, 02 Mar 2009 07:12:31 GMT

WHERE TABNAME LIKE 'Z%'

Re: How to write this select query ?

Former Member — Mon, 02 Mar 2009 07:18:09 GMT

It will give you all give you all taable in Y* AND Z* RANGE.

Ranges:R_TAB for <tabname>.       " Dic ref

R_TAB-low = 'Y*'.
R_TAB-high = 'ZZ*'.       "ZZ* iS equvalent to Z* no issues here
R_TAB-options = 'I'.
R_TAB-sign = 'BT'.

Append R_prog.

SELECT * FROM xyz INTO TABLE itab_xyz WHERE TABNAME in r_TAB.

Regards,

Gurpreet

Re: How to write this select query ?

Former Member — Mon, 02 Mar 2009 07:55:18 GMT

This message was moderated.