select query

[Former Member]

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............

[Former Member]

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

[Former Member]

IN WHERE CONDITION USE

GJAHR LE P_GJAHR.

REWARD IF USEFUL.

AMIT SINGLA

[Former Member]

Hi

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>

[Former Member]

Hi Deepthi,

Use < sy-datum.

Regards,

Sai