Customer Exist code to get quarter wise summation value in bex query

99 Views Last edit Dec 25, 2021 at 08:26 PM 2 rev

i have got stuck in build the report for Q1 (APR,MAY and June) Quarter values summation same like Q2,Q3 and Q4.

required same for Previous year also.

i tried multiple code but no luck,

sample code are below.tried for CYCQ.WHEN 'ZV_ZISCNSL01_TIME_CYCQ'.

ls_range-sign = 'I'.

ls_range-opt = 'BT'.

IF i_step = 2.

READ TABLE i_t_var_range INTO ls_var_range WITH KEY vnam = 'ZV_ZISCNSL01_TIME_01'.

IF sy-subrc = 0.

lv_curr_year = ls_var_range-low+0(4).

lv_prev_year = lv_curr_year - 1.

CASE ls_var_range-low+5(2).

WHEN '01' OR '02' OR '03'.

CONCATENATE lv_curr_year '01' INTO ls_range-low.

CONCATENATE lv_curr_year '03' INTO ls_range-high.

WHEN '04' OR '05' OR '06'.

CONCATENATE lv_curr_year '04' INTO ls_range-low.

CONCATENATE lv_curr_year '06' INTO ls_range-high.

WHEN '07' OR '08' OR '09'.

CONCATENATE lv_curr_year '07' INTO ls_range-low.

CONCATENATE lv_curr_year '09' INTO ls_range-high.

WHEN '10' OR '11' OR '12'.

CONCATENATE lv_curr_year '10' INTO ls_range-low.

CONCATENATE lv_curr_year '16' INTO ls_range-high.

ENDCASE.

APPEND ls_range TO e_t_range.

ENDIF.