Hi All,
I have a requirement to Create a Report on BI 7.0 on infocube :0FIGL_C10 (GL New Transaction Figures)
to get YTD,QTD and Current Month Using ,selection Screen having single entry (Mandatory)
Fical Year Period .
Example :Fiscal Year Period (*.) = 03.2009.
Key Fig:0BALANCE (used in YTD)
Output:(single Report)
G/L Account (Hierarchy) Current Month YTD QTD
User Entry Variable :at selection screen:
ZFSYP ( 0FISCPER) ( Single Entry, Mandatory, Manual Input)
Customer exit variable : ZYTD3 (0FISCPER) (Interval ,Customer exit,Mandatory Uncheked Vairable entry )
i have created Customer exit variables and written ABAP code to ger YTD
as below-
-- *But not getting output as expected ,
WHEN 'ZYTD3'.
IF I_STEP = 2.
clear: L_DATE4,
L_DATE5,
WA_VAR_RANGE.
LOOP AT I_T_VAR_RANGE INTO WA_VAR_RANGE WHERE VNAM = 'ZFSYP'.
L_DATE = WA_VAR_RANGE-LOW+4(3).
L_YEAR = WA_VAR_RANGE-LOW+0(4).
CONCATENATE L_YEAR '001' INTO L_DATE4.
CONCATENATE L_YEAR L_DATE INTO L_DATE5.
WA_RANGE-LOW = L_DATE4.
WA_RANGE-HIGH = L_DATE5.
WA_RANGE-OPT = 'BT'.
WA_RANGE-SIGN = 'I'.
IF WA_VAR_RANGE-HIGH > WA_RANGE-LOW.
APPEND WA_RANGE TO E_T_RANGE .
ELSE.
WA_RANGE-LOW = '00000000'.
WA_RANGE-HIGH = '00000000'.
APPEND WA_RANGE TO E_T_RANGE .
ENDIF.
ENDLOOP.
ENDIF.
Can any one throw a light where is the wrong ?