topic Re: select stat in Application Development and Automation Discussions

select stat

Former Member — Thu, 18 Oct 2007 06:16:59 GMT

Hi,

i have writen one select like below

PARAMETERS: pa_rdate TYPE datum.

PARAMETERS: g_rdate TYPE datum.

SELECT vertrag

FROM ever

INTO TABLE li_ever_contracts_p

WHERE ( ( auszdat = pa_rdate )OR ( auszdat = g_rdate ) )

AND ( ( aedat = pa_rdate OR ( aedat = g_rdate ) ).

I don't want to use the brakets then how to write select query.

Re: select stat

Former Member — Thu, 18 Oct 2007 06:20:09 GMT

Hi,

If you want select query with the required logic you need to use brackets. No other easy way.

regards,

Atish

Re: select stat

former_member404244 — Thu, 18 Oct 2007 06:24:59 GMT

HI,

U can try with ranges

ranges : r_auszdat for <tablename>-auszdat,

r_aedat for ekko-aedat.

r_auszdat-sign = 'I'.

r_auszdat-option = 'EQ'

r_auszdat-low = pa_rdate

APPEND r_auszdat.

r_auszdat-sign = 'I'.

r_auszdat-option = 'EQ'.

r_auszdat-low = g_rdate .

APPEND r_auszdat.

r_aedat-sign = 'I'.

r_aedat-option = 'EQ'.

r_aedat-low = pa_rdate .

APPEND r_aedat.

r_aedat-sign = 'I'.

r_aedat-option = 'EQ'.

r_aedat-low = g_rdate.

APPEND r_aedat.

Now write select query.

SELECT vertrag

FROM ever

INTO TABLE li_ever_contracts_p

WHERE auszdat in r_auszdat

AND aedat in r_aedat.

Reward if helpful.

Regards,

Nagaraj

Re: select stat

Former Member — Thu, 18 Oct 2007 06:25:11 GMT

Hi,

create a ranges in the program and then add the parameters in the range..

Ex..


RANGES: R_DATE FOR SY-DATUM.

R_DATE-SIGN = 'I'.
R_DATE-OPTION = 'EQ'.
R_DATE-LOW = PA_RDATE.
APPEND R_DATE.

R_DATE-LOW = G_RDATE.
APPEND R_DATE.


SELECT vertrag 
FROM ever
INTO TABLE li_ever_contracts_p
WHERE auszdat IN r_date   " Changed here
AND aedat  IN r_date .   " Changed here

Thanks

Naren

Re: select stat

Former Member — Thu, 18 Oct 2007 06:25:29 GMT

at max you can remove 2 brackets from the query

SELECT vertrag

FROM ever

INTO TABLE li_ever_contracts_p

WHERE ( auszdat = pa_rdate OR auszdat = g_rdate )

AND ( ( aedat = pa_rdate OR aedat = g_rdate ).

Re: select stat

Former Member — Thu, 18 Oct 2007 06:27:57 GMT

where auszdat in (pa_rdate,g_rdate) and aedat in (pa_rdate,g_rdate)