Skip to Content
0
Former Member
Jul 10, 2007 at 07:12 PM

selection based on date

35 Views

i have to select data from covp table based on posting date instead of fiscal year as per my requirement . How do i give that in the where clause ?

select kokrs belnr buzei perio

wogbtr lednr objnr gjahr

wrttp versn kstar owaer budat

from covp into table i_covp

where kokrs = i_prps-pkokr and lednr = '00' and

objnr = i_prps-objnr and

gjahr ge yprevyear and

wrttp = '04' and versn = '000'

and kstar not in s_kstar.

I have to remove gjahr ge yprevyear and give posting date .

Say if the year is 2007 then i have to use dates from sep 1st 2006 to aug 31st 2007 and so on.

I appreciate your responses.