Skip to Content
0
Former Member
Apr 22, 2009 at 10:58 PM

YTD ,QTD and Current Month using Fiscal Year period (0FISCPER)

89 Views

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 ?