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

Fiscal Year / Period description in reporting

Posted on Nov 06, 2011 at 12:57 AM 49 Views

Hello All,

Is there a way to change the description of fiscal year / period (0FISCPER) in reporting?

Ex: We have Fiscal Yr/Period in the report selection and our period is from Apr - Mar (Fiscal Yr variant = V0).

Fiscal Yr/ Period (001/2010) ---> CalMonth (04/2010) --- description is Apr 2010 which is right

Similarly

Fiscal Yr/ Period (010/2010) ---> CalMonth (01/2011) --- but the description shows Jan 2010 instead of Jan 2011

User wants to see the description as Jan 2011 when they enter Fiscal Yr / Period 010/2010. Any suggestions on how to

achieve this.

Thanks in Advance

Kumar

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Jagadeesh Mandepudi
    Jagadeesh Mandepudi
    Posted on Nov 07, 2011 at 10:32 AM
    0

    Hi

    Yes, we can do this by using text variable i.e. in the coloumns you have taken any header with text variable whcih is feeding by customer exit. in the customer exit you need to populate the next year.

    Regards

    Jagadeesh.M

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo sree ranganath
    sree ranganath
    Posted on Nov 07, 2011 at 10:55 AM
    0

    Hi ,

    1>> create a text variable with replacement path to get the period only( to get this you have to give offset as 0 - 2]...

    lets say this variable is &ZFISCREP&

    2>>create another text variable with replacement path on cal month [to get the year .. so give offser to get year only}

    lets say this variable is &ZMONTHREP&

    in the description add these two i.e &ZFISCREP&&ZMONTHREP&

    then you will get the desired result

    Regards,

    Ranganath

    Add a comment
    10|10000 characters needed characters exceeded

    • sree ranganath Former Member
      Nov 08, 2011 at 10:46 AM

      Thanks for your replies. Using text variable with exit will work if i want to show the description in column/row header. But the requirement is when the user enter FiscYr/Period in report selection and does a check he should be able to see description as Jan2011 for period 010/2010.

      create a text variable customer exit lets say zperiod as variable name

      When 'ZPERIOD'.

DATA: ZPEROD(3)   TYPE C,
ZTEMP1(7) TYPE C.
 
if i_step = 2.
CLEAR L_S_RANGE.
Loop at i_t_var_range into intern_range where VNAM = 'user entered variable for FISCPER'.
 
ZTEMP1 = INTERN_RANGE-LOW.
ZPEROD =  ZTEMP1+5(3)
CASE ZPEROD.

WHEN '001'.

ZPERIOD = 'JAN'.

WHEN '002'.

ZPERIOD = 'FEB'.

* WRITE OTHERS ALSO

WHEN '012'.

ZPERIOD = 'DEC'.

END CASE.
  
L_S_RANGE-SIGN = 'I'.
 
L_S_RANGE-OPT = 'EQ'.
  
L_S_RANGE-LOW = ZPEROD.
 
 
APPEND L_S_RANGE TO E_T_RANGE.
 
ENDLOOP
ENDIF.

      This variable will give only month as jan feb ...dec.

      but you need YEAR as well

      so create another text variable with replacement path on cal month infoobject

      and give the offset to get the year

      this variable is used to get the year

      lets say this variable is &zyear&

      add these two variables in the description

      i.e &zperiod&&zyear&

      you will get the result what you ask

      And also in the filter block of report output. How can i be able to change the description of the characteristic 0FISCPER

      Change the desciprtion of 0fiscper in query designer properties.

      Regards,

      Ranganath

      Edited by: Ranganath on Nov 9, 2011 7:58 AM

    Comment on This Answer
  • author's profile photo Patricia Yang
    Patricia Yang
    Posted on Nov 09, 2011 at 09:20 AM
    0

    Hi Kumar,

    There is actuall a simple setting for this.

    Go to transaction RSRHIERARCHYVIRT -> Text Fiscal Year/Period.

    Now it should be set to Fiscal year in your system.

    Just change to calendar year and it would show text according to the calender year.

    Regards,

    Patricia

    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.