Error while offsetting a variable

[Former Member]

Hello Experts

I want to display the data for last 5 years in my query. So I tried using the SAP exit variable Current Calendar Year (0CYEAR) and the offset it by 5. However, I am getting the following error message for the query "System error in program SAPLRR12 and form REP_ASSIGN_INITIAL_OPT-01"

Any Help on this is appreciated and points will be assigned.

Thanks

[Former Member · Accepted solution]

Use tcode- SNOTE to import this oss note in to ur system if you are on BI 7 and SP<17 .

Note 1117966 - Brain 299 in SAPLRRI2, form REP_ASSIGN_INITIAL_OPT-02-

Hope it Helps

Chetan

@CP..

[Former Member · Accepted solution]

Thanks Chetan for your prompt reply. I have assigned points.

But I would appreciate if you help me clear my understanding of offseting a variable.

Say if the Current Calendar Year variable returns 2008, then will offseting that variable by 5 return me the data for years 2008, 2007, 2006, 2005 , 2004. Or, will it just return me the data for 2008 - 5 = 2004 only.

Thanks

Rishi

[Former Member · Accepted solution]

Just offsetting the variable with -5 will return data for 2004 only. If you want to retrieve a range of years, create a range for resriction using the start and end values of var-5 to var.

[Former Member · Accepted solution]

Mayank,

So you mean to say, the range current calendar year to current calendar year-5 will give me the data for last 5 years.

I have already assigned points

[Former Member · Accepted solution]

Yes, this is correct. Create a range (or interval).