topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Thu, 20 Sep 2007 10:10:46 GMT

hi,

I want to fetch the records of the current year and the records of all the previous years.....................in Selection screen I am giving the fiscal year as the current year.............then in my Select query how can I write my where condition..........

in where condition gjarh less than and equal to the current year entered in the selection screen.............?How to write.......can anyone help me out in this.........

thanks in advance............

Re: select query

Former Member — Thu, 20 Sep 2007 10:14:00 GMT

Hi Deepthi,

Use the less than and eqaul to (<= or LE) to fetch the entries.

Thanks and Regards,

Sunil Yarlagadda.

Reward if it is helpfull

Re: select query

Former Member — Thu, 20 Sep 2007 10:16:28 GMT

IN WHERE CONDITION USE

GJAHR LE P_GJAHR.

REWARD IF USEFUL.

AMIT SINGLA

Re: select query

Former Member — Thu, 20 Sep 2007 10:17:40 GMT

suppose if your date is SY-DATUM then

for year you can write the logic like this

<b>sy-datum+0(4).</b>

then it will take only the year part

apply this rule for ur code

<b>reward if usefull</b>

Re: select query

Former Member — Thu, 20 Sep 2007 10:22:01 GMT

Hi Deepthi,

Use < sy-datum.

Regards,

Sai