topic selection statement in Application Development and Automation Discussions

selection statement

Former Member — Fri, 20 Jun 2008 06:40:41 GMT

i want to check this condition ina select statement

if clearing date in s_cldate or clearing date

is greater than key date

wat will be the syntax

Re: selection statement

former_member195383 — Fri, 20 Jun 2008 06:43:24 GMT

s_cldate GT key_date.

Re: selection statement

Former Member — Fri, 20 Jun 2008 06:43:41 GMT

Hi,

Select *

from TABLE

into ITAB

where CLEARING_DATE in S_CLDATE

or CLEARING_DATE gt V_KEY_DATE

--> Is this you want?

Reward points if it is helpful.

Edited by: Ravi Kumar on Jun 20, 2008 8:50 AM

Re: selection statement

Former Member — Fri, 20 Jun 2008 06:44:06 GMT

select *

from....

into ......

where clear_date in s_idate or

clear_date GT key_day.

this will be the better option.

s_date-low = key_date

s_daet-sign = 'I'.

s_date-option = 'GT'.

append it to ur select option internal table

select *

from....

into ......

where clear_date in s_date.

Edited by: S.r.v.r.Kumar on Jun 20, 2008 12:15 PM

Re: selection statement

Former Member — Fri, 20 Jun 2008 06:47:13 GMT

SELECT * from <table name>

INTO TABLE <itab>

WHERE cldate IN S_CLDATE

OR cldate GT key_date .

IF s_date contains SINGLE date rather than range then.

READ TABLE S_CLDATE INDEX 1.

SELECT * from <table name>

INTO TABLE <itab>

FOR ALL ENTRIES IN S_CLDATE

WHERE cldate GT S_CLDATE-LOW.

Regards,

Swarup.

Edited by: swarup basagare on Jun 20, 2008 8:51 AM

Re: selection statement

sachin_mathapati — Fri, 20 Jun 2008 06:49:16 GMT

Hi ,

What you can do is, append all the dates(s_cldate ,clearing date) in internal table itab and delete entries from itab if date is less than key date .Then use select query for all entries in itab where date = date.

Regards,

Sachin M M

Re: selection statement

Former Member — Fri, 20 Jun 2008 06:50:22 GMT

Hi,

Try the code below :



select f1 f2 from <dbtabel> into table itab
             where ( augdt in s_cldate 
                OR augdt > key_date ).

Thanks,

Sriram Ponna.