Customer Exit for MTD

Hi,

My requirement is to create Customer exit variable to calculate the Month to date (MTD) value (Quantity) in a query. I created a Customer exit variable for MTD (0CALDAY) in Query & wrote code in CMOD for the same as follows.

DATA: ZYEAR(4) TYPE N,

ZMON(2) TYPE N,

ZDAY(2) TYPE N.

CASE I_VNAM.

WHEN 'ZVCE_MTD'.

IF I_STEP = 2.

REFRESH E_T_RANGE.

LOOP AT I_T_VAR_RANGE INTO LOC_VAR_RANGE.

ZYEAR = LOC_VAR_RANGE-LOW+0(4).

ZMON = LOC_VAR_RANGE-LOW+4(2).

ZDAY = LOC_VAR_RANGE-LOW+6(2).

CLEAR L_S_RANGE.

CONCATENATE ZYEAR ZMON '01' INTO L_S_RANGE-LOW.

CONCATENATE ZYEAR ZMON ZDAY INTO L_S_RANGE-HIGH.

L_S_RANGE-SIGN = 'I'.

L_S_RANGE-OPT = 'BT'.

APPEND L_S_RANGE TO E_T_RANGE.

EXIT.

ENDLOOP.

ENDIF.

ENDCASE.

I debugged this code by putting a break point & running the query in RSRT, the code is getting executed & i am getting the From & To dates in E_T_RANGE output.

But when I execute the Query, I am getting the output Quantity for FTD only, not MTD.

For example, if i give 05-12-2009 as variable input for 0CALDAY when i execute the query, i should get the summed up quantity for 01 Dec to 05 Dec in a single cell. But now, i am getting the summed up quantity for 05 Dec only.

Help me in resolving this.

Regards,

Murali