How to write this select query ?

[Former Member]

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 ?

[Former Member]

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 ?

[Sm1tje]

WHERE TABNAME LIKE 'Z%'

[Former Member]

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

[Former Member]

This message was moderated.