07-10-2007 8:12 PM
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.
07-10-2007 8:41 PM
Hi,
Please try this and build selection screen for GJAHR.
tables: covp.
parameters: p_gjahr like covp-gjahr.
ranges: r_budat for covp-budat.
r_budat-sign = 'I'.
r_budat-option = 'BT'.
r_budat-low(4) = p_gjahr - 1.
r_budat-low+4(4) = '0901'.
r_budat-high(4) = p_gjahr.
r_budat-high+4(4) = '0831'.
append r_budat.
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
budat in r_budat and "Change here
wrttp = '04' and versn = '000'
and kstar not in s_kstar.
Regards,
Ferry Lianto
07-10-2007 8:39 PM
I answered this in an earlier post. You get the relationship in table T009B.
Rob
07-10-2007 8:41 PM
Hi,
Please try this and build selection screen for GJAHR.
tables: covp.
parameters: p_gjahr like covp-gjahr.
ranges: r_budat for covp-budat.
r_budat-sign = 'I'.
r_budat-option = 'BT'.
r_budat-low(4) = p_gjahr - 1.
r_budat-low+4(4) = '0901'.
r_budat-high(4) = p_gjahr.
r_budat-high+4(4) = '0831'.
append r_budat.
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
budat in r_budat and "Change here
wrttp = '04' and versn = '000'
and kstar not in s_kstar.
Regards,
Ferry Lianto
07-10-2007 8:53 PM
thanks for the reply ... I will even try with t009 and one more thing i have to get period based on posting date . If it is september i have to give period in i_covp as 1 and for oct i have to give 2 and so on .
loop at i_covp.
i have to get month in budat and calculate new period
i_covp-perio = new period.
append i_covp.
endloop.
how do i do that ? i appreciate very much for your valuable time
07-10-2007 8:54 PM
just hard coding it with the case statement or any other easy way .
07-10-2007 9:00 PM
Hi,
You can use case statement to assign period based on posting date.
Regards,
Ferry Lianto