on 01-03-2008 7:32 AM
Hi Gurus,
i have an requirement on controlling reports,
_the requirement is_
RK_ZCOOM_M01_0003(Actual Current Year (YtD))(restricted key figure)
- Key Figure: 0AMOUNT
- Value type (0VTYPE): 10
- Fiscal year/period: Based upon the entered Fiscal year/period (RK_ZCOOM_M01_0001) the data has to be selected for all periods of the Fiscal year up to the Fiscal Period. This requires a specific interval-variable using the Customer-exit. In this exit, the fiscal year has to be determined, and concatenated with 001. This value has to be used as From-value, the To-value is the value as entered for RK_ZCOOM_M01_0001.
NB: From January up to the selection period, or up to the actual month when running the report?
NB: This column should be the sum of individual fiscal year/periods, so it can facilitate a drilldown across periods as defined for the Trend-report.
RK_ZCOOM_M01_0001 contains the restriction on value type and one variable fiscper single with optional selection.
could anyone help me on this.
Thanks & Regards
Suresh.
HI Gurus
i have write a code but it is not working fine when i am executing the report it does not populating the data.
i have written the code for this query is
&----
*& Include ZXRSRU01
&----
DATA: L_S_RANGE TYPE RSR_S_RANGESID.
DATA: LOC_VAR_RANGE LIKE RRRANGEEXIT.
Data: v_loc_date type d.
Data: v_loc_date1 type d.
Data: v_loc(4) type c.
DATA: lv_year(4) type c.
DATA: lv_date like sy-datum.
CASE I_VNAM.
WHEN 'ZCYTD'.
IF I_STEP = 2. "after the popup
LOOP AT I_T_VAR_RANGE INTO LOC_VAR_RANGE
WHERE VNAM = ' ZFISPER'.
CLEAR L_S_RANGE.
L_S_RANGE-LOW = LOC_VAR_RANGE-LOW(4)."low value, e.g.2007001
L_S_RANGE-LOW+4(3) = '001'.
L_S_RANGE-HIGH = LOC_VAR_RANGE-LOW. "high value = input
L_S_RANGE-SIGN = 'I'.
L_S_RANGE-OPT = 'BT'.
APPEND L_S_RANGE TO E_T_RANGE.
EXIT.
ENDLOOP.
ENDIF.
WHEN 'ZCYTD'.
IF I_STEP = 2. "after the popup
LOOP AT I_T_VAR_RANGE INTO LOC_VAR_RANGE
WHERE VNAM = 'ZFISPER'.
CLEAR L_S_RANGE.
v_loc = LOC_VAR_RANGE-LOW(4).
v_loc = v_loc - 1.
CONCATENATE v_loc '001' INTO L_S_RANGE-LOW(7).
CONCATENATE v_loc loc_var_range-low+4(3) INTO L_S_RANGE-HIGH(7).
L_S_RANGE-SIGN = 'I'.
L_S_RANGE-OPT = 'BT'.
APPEND L_S_RANGE TO E_T_RANGE.
EXIT.
ENDLOOP.
ENDIF.
ENDCASE.
***********************************
could you please help me where i was wrong for this code.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suresh,
Create a customer exit on fiscyear. Populate the value of the fiscal year from user input fiscper.
in the query RKF. FiSCPER <= USERINPUT VARIABLE And FISCYEAR = customer exit variable
you will get YTD values from starting of the year to usser input period and we will have drilldown capabilty on fisper also
hope this helps
PV
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suresh,
yEAR VARIABLE IS single mandatory
WHEN 'year variabLE' .
IF I_STEP = 2 .
CLEAR E_T_RANGE .
L_S_RANGE-SIGN = 'I' .
L_S_RANGE-OPT = 'EQ' .
READ TABLE I_T_VAR_RANGE INTO LOC_VAR_RANGE WITH KEY VNAM = 'month variabLE' .
IF SY-SUBRC = 0 .
L_S_RANGE-LOW = LOC_VAR_RANGE-LOW+0(4) .
L_S_RANGE-HIGH = LOC_VAR_RANGE-LOW+0(4) .
ENDIF.
APPEND L_S_RANGE TO E_T_RANGE .
ENDIF.
hope this helps
PV
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.