Date format

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[learnsap]

Hi Alson,

Before the select statement...

p_gjahr = p_gjahr - 1.

will solve the problem.

Regards,

Ramesh S

*Award points if reply is helpful