Hi!
I have KF - amount
characteristic - Plan/Fact/Estimate with value P,F,E
time char - 0fiscper
I need
001.2008 | 002.2008|...007.2008 |008.2008|...012.2008
-
Fact|Plan |Fact|Plan |...Fact|Plan |Est.|Plan|...Est|Plan
by one query.
to current month amount with Fact and Plan, from next month of current year amount with Estimate and Plan.
in column 0fiscper restricted cutomer exit variable and KF restricted another cutomer exit variable and KF restricted Plan.
I want to create cutomer exit variable on 0fiscper to define only current year(I can do it)
I need cutomer exit variable on Plan/Fact/Estimate to restrict KF by Fact from Jan.of current year to cur.month and by Estimate From next month to december.
but I don't know how to do it.
Is it real?