topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Wed, 15 Aug 2007 16:40:30 GMT

Hi Gurus,

I need to select all the records from Z_tab to it_tab that meet below conditions:

mode = a or b

amount1 < amount2

and for this I have written the following code

select * into table it_tab

from z_tab

for all entries in it_temp

where mode = 'A' or mode = 'B'

and amount1 < amount2.

but its showing me an error that field amount2 is unkown, although this field is defined in my z_tab table.

please help me out.

Thanks

Rajeev Gupta

Re: Select statement

Former Member — Wed, 15 Aug 2007 16:44:29 GMT

Hi,

Hope your Ztab contains amount1 and amount2 fields.

For that select using

select * into table it_tab

from z_tab

for all entries in it_temp

where mode = 'A' or mode = 'B'.

delete it_itab where amount2 ge amount1.

finally you will have the required values in it_itab.

Regards,

Baburaj

Re: Select statement

Former Member — Wed, 15 Aug 2007 16:48:42 GMT

HI,

In this select you are trying to compare the two database table fields which is not possible. rather do this.

select * from z_tab into table itab where mode in ('A','B').

if sy-subrc eq 0.

delete itab where amont1 > amount2.

endif.

Y are u using the for all entris in it_Temp does this table contains amount2?

if yes

then use this.

select * from z_tab for all enteris in it_temp into table itab where mode in ('A','B') and amount1 < it_temp-amount2..

Thanks

mahesh

Re: Select statement

Former Member — Wed, 15 Aug 2007 16:50:09 GMT

You cannot do that in one single select statement. Easiest will be to get all the records (include the columns amount1 and amount2 as well to your itab) just based on mode and then loop at the itab. delete the record if amount1 < amount2.

Re: Select statement

kesavadas_thekkillath — Thu, 16 Aug 2007 03:00:45 GMT

try amount2 > amount1

Re: Select statement

varma_narayana — Thu, 16 Aug 2007 03:30:07 GMT

Hi..

The error is coming bcoz amount1 is not a field in ur Table zTab.

You have to change the query like this:

select * into table it_tab

from z_tab

for all entries in it_temp

where mode = 'A' or mode = 'B'

and amount2 > amount1.

<b>Reward if Helpful</b>

Re: Select statement

Former Member — Thu, 16 Aug 2007 03:49:35 GMT

use tablename.ammount2 it wil remove ur error

use the tablename to wich amnt2 is associated