Select statement with range

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

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

regards,

amit mittal.

[Former Member]

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

[Former Member]

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

[Former Member]

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