04-07-2007 6:22 AM
Hi Experts,
I have to selection scren parameter as p_gjhar like mkpf-gjhar.
I wanna reduce the fiscal year by one year in the select stmt.
select * from mkpf
into i_mkpf
where gjhar = p_gjhar - 1( one year less than the selection screen input)
plz let me know how to solve the issue.
regards
alson.
04-07-2007 6:33 AM
Hi Alson,
Before the select statement...
p_gjahr = p_gjahr - 1.
will solve the problem.
Regards,
Ramesh S
*Award points if reply is helpful
04-07-2007 6:26 AM
p_gjhar = p_gjhar - 1.< or take it in another variable and pass that to select statement>
select * from mkpf
into i_mkpf
where gjhar = p_gjhar.
regards
shiba dutta
Message was edited by:
SHIBA DUTTA
04-07-2007 6:28 AM
Hi Alson,
In the program, before select statement, use the following code:
p_gjhar = p_gjhar - 1.
select * from mkpf
into i_mkpf
where gjhar = p_gjhar.
Best regards,
Prashant
04-07-2007 6:33 AM
Hi Alson,
Before the select statement...
p_gjahr = p_gjahr - 1.
will solve the problem.
Regards,
Ramesh S
*Award points if reply is helpful