Skip to Content
avatar image
Former Member

Fiscal year /period? (Urgent - Help needed)

Hi Experts,

I wanted to display the Actual Sales value(from COPA Cube) based on the input selection - 'Fiscal Year /Period' with the below condition.

If the input fiscal year/period is 004.2006 then the Actual sales values should be displayed for 001.2006 to 004.2006 and if the selection is 001.2006 then the values are for the period- 001.2006...

It should always start from the begin of fiscal year/period.

Can any one help me...

Thanks in advance,

regs,

Mahantesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 29, 2005 at 08:23 AM

    Hi dear,

    you need to build an exit variable that, when I_STEP = 2, you can fill (CONCATENATE popupvariable(4) '001') with the first value of the year inserted by the user in the selection pop-up.

    Try to search in these forums for some sample code...

    Hope it helps!

    Bye,

    Roberto

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Mahantesh,

      Instead of the code mentioned in the last posting, use the following:

      WHEN 'ZVAR2'.

      IF I_STEP = 2. "after the popup

      LOOP AT I_T_VAR_RANGE INTO LOC_VAR_RANGE

      WHERE VNAM = 'ZVAR1'.

      CLEAR L_S_RANGE.

      L_S_RANGE-HIGH = LOC_VAR_RANGE-LOW.

      L_S_RANGE-LOW = LOC_VAR_RANGE-LOW.

      MOVE: '001' to L_S_RANGE-LOW(3) .

      L_S_RANGE-SIGN = 'I'.

      L_S_RANGE-OPT = 'BT'.

      APPEND L_S_RANGE TO E_T_RANGE.

      EXIT.

      ENDLOOP.

      ENDIF.

      Kindly , let me know whether it is solved your problem or not.

      With rgds,

      Anil Kumar Sharma .P

      Kindly assign the points if it helps you.

      urgent-help-needed

  • avatar image
    Former Member
    Nov 29, 2005 at 08:36 AM

    Hi,

    there is a standard SAP variable (0FYTCFP) that gives you the interval from the first period up to the current fiscal year period - without any user entry. If that is sufficient for your requirements, you can use it without the need of ABAP coding.

    Regards

    Stephan

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 23 at 09:59 AM

    Hi,

    First, you should create a manual single entry variable for your fiscper, let's call it ZMANUAL_FPER.

    Then, create another variable (customer exit) for your fiscper, let's call it ZEXIT_FPER.

    In your CMOD, do this code (just replace the variables used in your CMOD):

    WHEN 'ZEXIT_FPER'.
    IF i_step = 2.
    LOOP AT i_t_var_range INTO s_t_var_range WHERE vnam = 'ZMANUAL_FPER'.
    CONCATENATE s_t_var_range-high(4) '01' INTO l_s_range-low.
    l_s_range-sign = 'I'.
    l_s_range-opt = 'EQ'.
    APPEND l_s_range TO e_t_range.
    ENDLOOP.
    ENDIF.
    

    Then, filter your fiscper with BETWEEN from ZEXIT_FPER to ZMANUAL_FPER.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded