Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

HOW TO GET FISCALYEAR PERIOD WISE DATA BY GIVING FISCAL YEAR AS INPUT

Hi All,

  I have to display data for customer balances on fiscper by giving the Fiscal year as the input parameter.

Fiscal Year variant is J3 i.e; April to March.

For ex1: if i give the Fiscal year as 2015(now as we are August,report should display data from April to July).

Fiscal year/period    Customer Balance

007.2015                   100

006.2015                   300

005.2015                   50

004.2015                   500

Ex2: Suppose we are in April 2015, If i execute the report in April month it should display the data for the previous finacial year that is from April 2014 to March2015.

I want to show above two scenario's in single report.


All your suggestions and assistance are highly appreciable.

Many Thanks

--Naveen

Former Member
Former Member replied

Hello Naveen,

As suggested by Loed, you can create Customer exit variable to get the periods from start of fiscal month to current month as well as to get the previous fiscal year value.

More over I see that you have requested for the ourput that too period wise.

For that i suggest you to create another structure in Row for diffrent periods. In this structure you can categorize your data or say Key figure value (customer balance) . this is going to be your cell Structure. so it will geive you fix ouput report, Its just that your values gets changed according to the input you are giving.

Hope this helps.

Thanks & Regards,

Maunank Patel.

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question