Skip to Content
0
Mar 01, 2009 at 09:00 PM

Integrated Planning : Planning for a rolling year

25 Views

Hi,

My Planning year is from April to March. I am finding it hard to define it in the query.

I use fiscal year and posting period as time characteristic.

If I use the selection

Q1 - - 0FISCPER= 03,04,05, 0FISCYEAR = YR

Mar - 0FISCPER= 03, 0FISCYEAR = YR

Apr - 0FISCPER= 04, 0FISCYEAR = YR

May- 0FISCPER= 05, 0FISCYEAR = YR

Q2

.....

Q3

.....

Q4 - 0FISCPER= 01,02,12, 0FISCYEAR = YR, YR+1

Dec - 0FISCPER= 12, 0FISCYEAR = YR

Jan - 0FISCPER= 01, 0FISCYEAR = YR +1

Feb - 0FISCPER= 02, 0FISCYEAR = YR +1

When I plan on Q4, the system distributes data for Jan to YR and YR+1 also. I use tried using Analog distribution with reference, and analog distribution by self-reference but both give the same result.

How would I design my query so that I can plan on a fiscal yr which is not equal to a calender year.

Best wishes,

Dheeraj