on 09-06-2007 9:05 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.