cancel
Showing results for 
Search instead for 
Did you mean: 

How to change BEx variable 0FYTCFP

Former Member
0 Kudos

Hi,

I am doing HR report to calculate payroll using user-entry variable to decide which month should be reported. Also I need to show the cumulation result from beginning of fiscal year to the month that user enters, which is a proble for me. BW provides variable 0FYTCFP (Cumulated up to Current Fiscal Year/Period) using SAP Exit, but it is only for current period. Does anyone know what I can do to fulfill this requirement?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You must create a custom customer exit in cmod.

create a variable type customer exit in bex and a variable for the input for the fiscal period.

in cmod write:

IF I_STEP = 1.

CASE I_VNAM.

WHEN 'varcustexit'.

LOOP AT I_T_VAR_RANGE INTO LOC_VAR_RANGE

WHERE VNAM = 'varinput'.

CLEAR L_S_RANGE.

LPERIODO = LOC_VAR_RANGE-LOW.

L_S_RANGE-LOW = LOC_VAR_RANGE-LOW(4).

L_S_RANGE-LOW+4(1) = '0'. "for fiscper

L_S_RANGE-LOW+5(2) = '01'.

L_S_RANGE-HIGH = LOC_VAR_RANGE-LOW.

L_S_RANGE-SIGN = 'I'.

L_S_RANGE-OPT = 'BT'.

APPEND L_S_RANGE TO E_T_RANGE.

EXIT.

ENDLOOP.

endcase.

endif.

alessandro

Former Member
0 Kudos

You can use a time range from January upto reporting period.