Year(YYYY) as input variable

[Former Member]

Hello,

i want the user to have option for entering only year(yyyy) and internally the object 0fiscper should get populated. how do i do this?

i.e if user enters 2006, i want the report to be executed with sales values for current fiscal year(or for 0fiscper 01.2006 to 12.2006)!!

please suggest detailed steps for the same?

thanks

[Former Member]

Hi,

I hope you have both the 0FISCYEAR and 0FISCPER characteristics in the Infocube on which the query is being based.

Select the variable for Fiscal year 0P_FYEAR in the free characteristics, and the characteristic 0FISCPER in the rows/column of the query.

You will get the desired result.

Cheers

Anurag

[Former Member]

Hello Anurag,

thanks,

i will try to use 0fiscyear in the cube.

it's for cube 0sd_c03. should i map billing date to 0fiscyear?

thanks,

[Former Member]

Aby,

this is only a business choice...you have to decide with your key-users what is more important to have from a functional point of view as time reference in your reporting analysis !

Hope it helps!

Bye,

Roberto

(don't forget that you can use different dates for every KF in your cube !)

[Former Member]

Hi Aby

You can use Customer Exit varaible for this.

you create a customer exit variable for fiscal year period.

in code loop at the calyear and populate this values into fiscal year period variable.

Cheers

Shiva

[Former Member]

Hello Shiva,

Can you please give me the ABAP code and the steps for the same?

thanks,

[former_member188325]

Hi aby,

did u try with 0CALYEAR?

regards