Restricted Key Figure with interval variable

[Former Member]

Hi,

I've a restricted key figure for KF 0AMOUNT restricted by 0FISCPER. There is a variable restriction on 0FISCPER which determines the period interval in customer exit.

e.g. 001.2008 to 009.2008

The problem is, in query this RKF is returning only the values for period 009.2008. It should return the total for all the periods.

Can you tell me what could be missing?

Regards,

Amit

[Former Member]

Hello!

1) Does it work well with a simple interval selection (with no exit?).

2) Would't it be easier just to redesign and keep the periods only on the local structure and not on the restricted KF?

I have used locally and it worked ok.

Besides what is the added value of using the restricted CKF?

[Former Member]

Hi Amit,

Remove the variable restriction for the one which has current period entry and leave RKF which has variable which retrieves the interval period.

Hope it should work...

Regards,

Madhu

[Former Member]

Yes there is fiscal year, fiscal period planning version on the variable screen.

From the fiscal period entered it's determining the interval in customer exit.

[former_member205352]

Where have you put your user entry variable of fiscal year/period ??

Have you restricted 0FISCPER with this variable.

If yes then that is the issue.

Entire query gets restricted to this.

Hope this helps.

[Former Member]

praveen

that is the case. There is a input variable for 0FISCPER.

There are two RKF's based on 0FISCPER but two different variables.

One returns the current period and other returns the interval from period 001 to current period.

So both will return the value for entered single period?

What is the solution for this?

[Former Member]

Hi Amit,

Also check if any other selection criteria is given during query executing(variable screen). This may also impact the output on the whole.

Regards,

Madhu

[Former Member]

The variable is returning the correct value. It's also a Interval variable.

[Former Member]

Hi Amit,

please check the cutomer exit, as the range might not be properly defined in the exit.

Firstly check if the variable is defined as range or single value, and if defined as range please check the below mentioned lines in the exit:

L_S_RANGE-SIGN = 'I'.

L_S_RANGE-OPT = 'BT'.

as they stand for:

SIGN (I)ncluding [ ] or (E)xcluding ] [

OPT Operators: EQ =, BT [ ], LE <=, LT <, GE >=, GT >, CP, and so on.

hope it helps

Regards,

Umesh

[Former Member]

Hi Amit,

Since you have a customer exit variable for Fiscper, check if it is catching on the present period instead of selecting the interval period which is entered.

Also check if there is any Char. restricted for current period or for the period enter in variable screen.

Hope it helps...

Best Regards,

Madhu