cancel
Showing results for 
Search instead for 
Did you mean: 

Fiscal Year from Fiscal Period/Year Using Exit

Former Member
0 Kudos

Hi ,

I have question for you guys, how to get Fiscal Year from Fiscal Period/Year using Customer Exit Variable.

Thanks in Advance,

GVK

Message was edited by:

GVK

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello GVK

do u need it in reporting...

Put this code in I_SREP=2

WHEN 'cust_exit_name'."this will return u fiscal year

CLEAR: v_year,s_var_range." Define v_year first

READ TABLE i_t_var_range INTO s_var_range

WITH KEY vnam = 'user input variable for fiscal period'.

v_year = s_var_range+0(4) .

s_range-low = v_year.

s_range-sign = 'I'.

s_range-opt = 'EQ'.

APPEND s_range TO e_t_range.

Thanks

Tripple k

Former Member
0 Kudos

Hi Tripple k,

Thank you for quick reply. I used the code which u gave me ,but i am getting an error while i run the report. this error pops up after i give input in the selection screen. Error msg is " Value 2007 for user-exit variable ZFISYER is invalid"

Below is the code i wrote based on ur code.

WHEN 'ZFISYER'.

CLEAR: VYEAR, ZE_T_RANGE.

READ TABLE I_T_VAR_RANGE INTO ZI_T_VAR_RANGE WITH KEY VNAM =

'0P_FPER'.

VYEAR = ZI_T_VAR_RANGE-LOW+0(4).

ZE_T_RANGE-LOW = VYEAR.

ZE_T_RANGE-SIGN = 'I'.

ZE_T_RANGE-OPT = 'EQ'.

CLEAR E_T_RANGE.

APPEND ZE_T_RANGE TO E_T_RANGE.

hope i am clear on my error. Any thoughts on this Error Guys

Thanks,

GVK

Message was edited by:

GVK

Message was edited by:

GVK

Former Member
0 Kudos

GVK,

use <b>I_STEP = 2</b> . See change below

WHEN 'ZFISYER'.
CLEAR: VYEAR, ZE_T_RANGE.

IF I_STEP = 2.

READ TABLE I_T_VAR_RANGE INTO ZI_T_VAR_RANGE WITH KEY VNAM =
'0P_FPER'.

VYEAR = ZI_T_VAR_RANGE-LOW+0(4).
ZE_T_RANGE-LOW = VYEAR.
ZE_T_RANGE-SIGN = 'I'.
ZE_T_RANGE-OPT = 'EQ'.
CLEAR E_T_RANGE.
APPEND ZE_T_RANGE TO E_T_RANGE.

ENDIF.

Hope it Helps

Srini

Former Member
0 Kudos

Hi Srini,

I am getting Same error " Value 2007 for user-exit variable ZFISYER is invalid". My input for Fiscal Period/Year is 005.2007.

Any More thoughts on this Gurus !!!

Thanks,

GVK

Message was edited by:

GVK

Former Member
0 Kudos

This error usually comes when there is no value available. Update your Fiscal year characteristics with 2007.

Thanks,

Satish

Former Member
0 Kudos

Hi Satish,

It dosent work.

Any more thoughts on this error Gurus???

Thanks,

Kiran

Former Member
0 Kudos

Almost all the extractors that carry fiscal period will carry fiscsl year also. Which extractor arr you looking at?

You can avoid customer exit variable if you do derive the year from the extractor itself or in the routine you cna derive it by offset from the fiscal period. Both are simpler than customer exit variable.

Ravi Thothadri