Derive 0fiscyerar from 0calmonth in a query

[Former Member]

Hello all,

We need to build a query which will show three columns: the first two will use calendar month using the value of the entry variable the user will enter. The third one has to show YTD values using 0fiscyear. But the user only wants to enter 0calmonth, so, is there a way to derive 0fiscyear from 0calmonth in a query?

Thanks in advance

Kenya

[Former Member · Accepted solution]

Hi,

In such a case you should go for exit I believe.

[Former Member · Accepted solution]

Thanks AVR

Any idea how I can do it?

[Former Member]

Thank you guys for your ideas. I found another posting in the forum where someone recomended a How yo guide to derive value variable from another variable. I modified the code acording to my requeriments and it worked.

Thanks

[Former Member]

hi,

to get the YTD value you can use SAP EXIT variable.

for 0FISC YEAR check the variable which sap has provided.

there r variable like >>cumulated upto current month>>.

u check them.

regards

sridhar.v