YTD in the report

[Former Member]

Hi

I have some KF's in my report .

1) When user enter the<b> "month"</b> in the selection paramter then he should get those KF's for that current month .

2) And he also wants those KF's values from <b>"Starting Month Of that Year to Current Month(YTD)"</b>.

so how can i get the YTD for those KF's in my report. please let me know

kumar

[former_member187400]

Hi Ravi,

To make it, you need to restrict your data. But you need to use customer exit in order to get the year & month, your user has input.

For the code, you can go through this link.

Hopefully it can help you a lot.

Regards,

Niel

(Many thanks for any points you choose to assign).

[Former Member]

Hi Ravi,

Try to create two variables one for one for Fiscal year and one for Fiscal Year/Period. Use those two variables in your query (select Fiscal Year/Period -> right click -> select the variable name -> select value range -> select greater than or equal to). (Make sure that you select variable entry as mandatory when you create those variables).

Hope this will help!

Let me know if you have any questions.

Thanks,

RK

[Former Member]

Hello,

1. Just restrict the KF with month.

2. You can restrict the KF with standart variable "Current year cumulated to current month". you can find it under the characteristic value variable of 0calmonth.

regards,

Mustafa,

[Former Member]

in addition, set the variable using a value range. then you can set the value between a specific range. for example start range = X and end range = Y. This allows for very flexible and dynamic selections.

in our case, we know ytd is always period 1 thru X, so we create RKF and in the definition, we restrict to a value range (aka interval) on posting period. the start period is hard coded = period 1, then the "to" range is a variable. then using separate year variable, user gets ultimate flexibility.

you can also use sap delivered variables which automatically determine current period/month based on system date.

[Former Member]

Hi Ravi,

Create restricted keyfigure and restrict againest Year (should be derived from Month entered by User) and Month(less than or equal to).

For year variable need customer exit.

Hope it Helps

Srini