Skip to Content
author's profile photo Former Member
Former Member

Bex customer exit - Variable for YTD-1month

What iam trying to do is using a customer exit variable in BW calculate the YTD period minus 1 (if my month is April then I have do YTD till march).

Case i_vnam.

WHEN 'ZPPYTD'.* customer exit variable.

IF I_STEP = 2.

LOOP AT I_T_VAR_RANGE INTO LOC_VAR_RANGE

WHERE VNAM = 'ZPOSTPER'.

*input user variable example 004

CLEAR L_S_RANGE.

L_S_RANGE-LOW = LOC_VAR_RANGE-LOW(3).004

*converting the low value to 001 which is basically Jan.

L_S_RANGE-LOW(3) = '001'.

*calculating for input = 004 then l_cal is 004-001= 003.loc_var_range is used again for finding the high interval.

L_FPER(3) = LOC_VAR_RANGE-LOW.

L_CALC *value is 3 = L_FPER - L_VAL.

V1 = '00'.

CONCATENATE V1 L_CALC INTO L_CAL.

LOC_VAR_RANGE-LOW = L_CAL.

  • Problem area the value calculated for loc_var_range-low is not accepted. I would like to append it with value of l_cal(003).

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.

ENDIF.

ENDCASE.

Has anybody done this kind of exit variable or is there any other way to do it?.

Regards,

Raj

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2004 at 12:12 AM

    Hi Raj,

    Create a restricted key figure using the delivered YTD variable, then using right mouse context menus drill down to the option 'Set Variable Offset'. The default is 0, but you can change it to -1, -2 .. -n corresponding to any previous period you want.

    Regards

    Rob

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.