cancel
Showing results for 
Search instead for 
Did you mean: 

Year(YYYY) as input variable

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

Hello Shiva,

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

thanks,

former_member188325
Active Contributor
0 Kudos

Hi aby,

did u try with 0CALYEAR?

regards