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

Current Year and YTD in Report/Query

Hi to all the experts here,

I have a report requirements to show the cost in the report for the current fiscal year and last fiscal year filtering by YTD month in the report as below when the user enter the month: 12.2010, the month: 07.2010 is the first posting period of the fiscal year.

                       
                      07.2010    08.2010     09.2010      10.2010     11.2010     12.2010     Last Fiscal Year     Last 2 Fiscal Year
Current Year           10,000    20,000       20,000       20,000       20,000    20,000       100,000                  90,000
Last Year              15,000    15,000       15,000       15,000       15,000    15,000       120,000                 100,000
 

I know that I need to create customer exit to archieve this, but I not sure what to do to get this, I have problems on getting the figures for the Last Fiscal Year and Last 2 Fiscal Year here.

Please help. Appreciated alot. Thanks alot!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 20, 2011 at 03:32 PM

    Hi there,

    You can easily create a customer exit variable for 0FISCPERIOD, so that it takes the first month of the fiscal period based on the month selected. Then you can use offset for that variable and restrict the keyfigures by subtracting the required number of months from it, so that i can display the values for the Last Fiscal as well as the Last 2 Fiscal.

    Hope this helps !

    Regards

    Snehith.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi

      The Fiscal year/period (0FISCPER) in your BW system must be maintained as starting from 07.2010 onwards then you can try the below:

      In the report Filters you can use the manual entry variable for 0FISCPER where the user can input the month restrictions.

      Then for the Current year and Previous year amount KFs you can create 2 customer exits for Current year and Previous year on 0FISCPER characteristic where you can set the interval using the values input by the user in the selection screen. (eg. If user enters 7.2010 to 12.2010 you can use these values in the exit code to set the interval for the customer exit variable.)

      This way you can have the amounts restricted by the period entered by the user in the report.

      For the structure you have mentioned in your post you can have the 0FISCPER in columns and then the KFs current/previous year in the rows so that once you have the Current/Previous YTD as created above, you will see the individual month period values also in the drilldown.

      Hope this helps.

      Regards,

      Ninad

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.