topic Re: Select statement with range in Application Development and Automation Discussions

Select statement with range

Former Member — Mon, 10 Dec 2007 13:03:42 GMT

Hi ,

How to use range option to have multiple values 0 let us say 100 values in select statement.

my req is :

select * from Dbase into it_tabe

where field1 in ( 2323, 22,3434,sssd,dfff,etc......)

i'm having all ( 2323, 22,3434,sssd,dfff,etc......) in an internal table

with thanks and regards

Arun

Re: Select statement with range

Former Member — Mon, 10 Dec 2007 13:07:12 GMT

use for all entries tab..

select * from Dbase into it_tabe

for all entries in it_field1

where field = ...

here it_field1 table is a table where u hav the values

( 2323, 22,3434,sssd,dfff,etc......)

here specify where condition as per ur field in database table

Hope dis helps

Reward all helpful answers

Re: Select statement with range

Former Member — Mon, 10 Dec 2007 13:07:29 GMT

Hi,

1. U can use FOR ALL ENTRIES IN itab WHERE field1 = Itab-Field1

regards,

amit mittal.

Re: Select statement with range

Former Member — Mon, 10 Dec 2007 13:10:24 GMT

Hi Arun,

Do like this

if you have values ( 2323, 22,3434,sssd,dfff,etc......) in itab write the code like this.

if itab[] is not initial.
 select * from Dbase into table it_tabe for all entries in itab
where field1 = itab-field1.
endif.

Regards,

Satish

Re: Select statement with range

Former Member — Mon, 10 Dec 2007 13:12:25 GMT

hi,

use for all entries statement

if not i_your_table_name[] is initial.

select * from dbtable 
into it_table
for all entries in i_your_table_name
where
field1 = i_your_table_name-your_field_name.

endif.

and make sure you check that i_your_table_name is not initial. or there will be a wrong query executed.

Regards,

Abdullah

Re: Select statement with range

Former Member — Mon, 10 Dec 2007 13:14:24 GMT

Hi,

You can do the same using for all entries clause.

Sorry for wrong suggestion in my last post as dint read the question completely.

Regards,

Lalit

Message was edited by:

Lalit Kabra