Needs to create u0091customer exitu0092 in a variable

Hi Experts,

Issue: Needs to create ‘customer exit’ in a variable.

Query build on a Cube.

In that query the time dimension is the YEAR. (‘period’ will gives the value for whole year (Not for specific months).)

When we are in January 2008, the report must display the data of year 2007.

When we are in the other months( from Feb'08), the report must display the data of 2008.

Here we are trying to create “customer exit” on “Period” Variable, for the query.

Let me say like this for Example:

‘Date’ = Sy_datum {Assume date is 20080129}

'Year' = 'Date'(4) {here ‘4’ calls value of the year 2008}

'Month' = 'Date'+4(2) {here ‘2’ calls value of the month 01}

If 'Month' EQ '01'

0calyear = 'year' -1

Else

0calyear = 'year'

End if.

I feel the logic mentioned above is correct.But I need the structured ABAP code for this.

Please do the needful and let me give your valuable solution regarding the particular issue.

Thanks in advance.