topic Re: Doubt In a Select Query.. in Application Development and Automation Discussions

Doubt In a Select Query..

Former Member — Wed, 31 May 2006 09:54:36 GMT

Hi..

I have a Doubt in a simple Query from the table NAST.

My query is as follows:--

Select kappl

objky

kschl

parnr

parvw

nacha

vsztp

from nast into table vit_nast

where kappl = p_kappl

and kschl in s_kschl

and parnr in s_parnr

and nacha = p_nacha

and vsztp in s_vsztp.

Now I want to select all the NAST records which are either not processed (NAST-VSTAT = 0) or incompletely processed (NAST-VSTAT = 2)(the field in the table NAST is VSTAT which denotes the Processing status of message)

So Can I add both the conditions in the WHERE clause of the the above Select Query?

Is there any other optimised way I can do that?

Thanks

Re: Doubt In a Select Query..

Former Member — Wed, 31 May 2006 09:59:07 GMT

hi,

Select kappl

objky

kschl

parnr

parvw

nacha

vsztp

from nast into table vit_nast

where kappl = p_kappl

and kschl in s_kschl

and parnr in s_parnr

and nacha = p_nacha

and vsztp in s_vsztp

and (vstat = 0 or vstat = 2).

hope this helps,

keerthi.

Re: Doubt In a Select Query..

Former Member — Wed, 31 May 2006 10:00:40 GMT

Select kappl

objky

kschl

parnr

parvw

nacha

vsztp

from nast into table vit_nast

where kappl = p_kappl

and kschl in s_kschl

and parnr in s_parnr

and nacha = p_nacha

and vsztp in s_vsztp

and ( vstat = 0 or vstat = 2).

Re: Doubt In a Select Query..

Former Member — Wed, 31 May 2006 10:01:05 GMT

u can add the condition to the qury like this

Select kappl

objky

kschl

parnr

parvw

nacha

vsztp

from nast into table vit_nast

where kappl = p_kappl

and kschl in s_kschl

and parnr in s_parnr

and nacha = p_nacha

and vsztp in s_vsztp.

and ( VSTAT = 0 or VSTAT = 2 )

Re: Doubt In a Select Query..

Former Member — Wed, 31 May 2006 10:02:14 GMT

hi,

Select kappl

objky

kschl

parnr

parvw

nacha

vsztp

from nast into table vit_nast

where kappl = p_kappl

and kschl in s_kschl

and parnr in s_parnr

and nacha = p_nacha

and vsztp in s_vsztp

and ( VSTAT = 0 0r VSTAT = 2 ).

Re: Doubt In a Select Query..

Former Member — Wed, 31 May 2006 10:02:36 GMT

Hi,

you can use OR in the WHERE claus eand specify both the conditions.

Regards,

Aswin

Re: Doubt In a Select Query..

Former Member — Wed, 31 May 2006 10:04:35 GMT

do this way

Select kappl

objky

kschl

parnr

parvw

nacha

vsztp

from nast into table vit_nast

where kappl = p_kappl

and kschl in s_kschl

and parnr in s_parnr

and nacha = p_nacha

and vsztp in s_vsztp

and ( vstat = 0 or vstat = 2).

Re: Doubt In a Select Query..

Former Member — Wed, 31 May 2006 10:07:48 GMT

hi subhash,

Select kappl

objky

kschl

parnr

parvw

nacha

vsztp

from nast into table vit_nast

where kappl = p_kappl

and kschl in s_kschl

and parnr in s_parnr

and nacha = p_nacha

and vsztp in s_vsztp.

and( VSTAT = 0 or VSTAT = 2 )

hope this helps,

priya.

Re: Doubt In a Select Query..

Former Member — Wed, 31 May 2006 10:17:55 GMT

ranges: r_stat for nast-vstat.

r_stat-low = '0'.
r_stat-option = 'EQ'.
r_stat-sign = 'I'.
append r_stat.
clear r_stat.

r_stat-low = '2'.
r_stat-option = 'EQ'.
r_stat-sign = 'I'.
append r_stat.
clear r_stat.

Select kappl
objky
kschl
parnr
parvw
nacha
vsztp
from nast into table vit_nast
where kappl = p_kappl
and kschl in s_kschl
and parnr in s_parnr
and nacha = p_nacha
and vsztp in s_vsztp
<b>and vstat in r_stat.</b>

check this..

Regards

vijay