topic Re: Need help with select statement in Application Development and Automation Discussions

Need help with select statement

Former Member — Wed, 17 Nov 2010 12:41:39 GMT

SELECT  SINGLE * into corresponding fields of LS_JOB from DTAB
where
JOB_REPORT = JOBNAME and
JOBCOUNT = JOBCOUNT and
SCHED_START_DATE = today or SCHED_START_DATE = tomorrow .

In the select the requirement is that after the where condition select should be evaluated in the following way

(JOB_REPORT = JOBNAME and JOBCOUNT = JOBCOUNT and {SCHED_START_DATE = today or SCHED_START_DATE = tomorrow })

OR takes precedence over and and the statement is not evaluated as above. I thought of writing like code like this to achive my purpose

SELECT  SINGLE * into corresponding fields of LS_JOB from DTAB
where
JOB_REPORT = JOBNAME and
JOBCOUNT = JOBCOUNT and
SCHED_START_DATE = today .

IF SY-SUBRC NE 0.
SELECT  SINGLE * into corresponding fields of LS_JOB from DTAB
where
JOB_REPORT = JOBNAME and
JOBCOUNT = JOBCOUNT and
SCHED_START_DATE = tomorrow.
ENDIF.

Is there a way to do this with a single select statement.

Thanks

Re: Need help with select statement

Former Member — Wed, 17 Nov 2010 12:50:41 GMT

Why dont you use the BETWEEN operator?


SELECT  SINGLE * into corresponding fields of LS_JOB from DTAB
where
JOB_REPORT = JOBNAME and
JOBCOUNT = JOBCOUNT and
SCHED_START_DATE BETWEEN today AND tomorrow.

Vikranth

Re: Need help with select statement

Former Member — Wed, 17 Nov 2010 12:51:39 GMT

same effect is achieved with:

and SCHED_START_DATE in (today, tomorrow).

Re: Need help with select statement

Former Member — Wed, 17 Nov 2010 12:52:39 GMT

SELECT SINGLE * into corresponding fields of LS_JOB from DTAB

where

JOB_REPORT = JOBNAME and

JOBCOUNT = JOBCOUNT and

( SCHED_START_DATE = today or SCHED_START_DATE = tomorrow ).

This should work with paranthesis as written above.

Regards

Munish Garg

Re: Need help with select statement

Former Member — Wed, 17 Nov 2010 12:58:31 GMT

Hi,

Write the coding as :

SELECT SINGLE * into corresponding fields of LS_JOB from DTAB

where

JOB_REPORT = JOBNAME and

JOBCOUNT = JOBCOUNT and

( SCHED_START_DATE = today or

SCHED_START_DATE = tomorrow ) .

Regards,

Srini.

Re: Need help with select statement

matt — Wed, 17 Nov 2010 13:15:19 GMT

It's fairly standard programming practice that when you have a logical expression, that you use brackets to override the default operator precendence.

Have you been programming long?

Re: Need help with select statement

Former Member — Wed, 17 Nov 2010 14:29:15 GMT

Started in ABAP in recently.

I would not use my C or C++ background....

If I do that I will never get past the ABAP compiler....I am trying to not compare them

Edited by: Vighneswaran CE on Nov 17, 2010 3:30 PM