Customer Exit Variable in cell definition in BEx

[Former Member]

Hi,

I have defined a query with a Structure in Row and Key Figures in column.

The result of query should look like this:

Fiscal/Year Period | Quantity per month | Quantity cumulative

011.2010 (Variable Offset Value -3) | 5 | 5

012.2010 (Variable Offset Value -2) | 6 | 11

001.2011 (Variable Offset Value -1) | 7 | 7

002.2011 (Variable Single Value, Manual Input) | 8 | 15

"Quantity cumulative" is defined as follows:

Quantity cumulative (002.2011) = Quantity 001.2011 + Quantity 002.2011

Quantity cumulative (001.2011) = Quantity 001.2011

Quantity cumulative (012.2010) = Quantity 011.2010 + Quantity 012.2010

Quantity cumulative (011.2010) = Quantity 011.2010

"Fiscal/Year Period" and "Quantity per month" are OK. But I have problem to define the key figrue "Quantity cumulative".

I have defined a Customer Exit Variable on Reference Characteristic "Fiscal/Year Period". Moreover I have also defined cell definition to define each individual cell for key figrue "Quantity cumulative" restricted by Customer Exit Variable.

The Quantity cumulative (002.2011) and Quantity cumulative (001.2011) are calculated correct. But it doesn't work for 012.2010 and 011.2010 (because of previous year).

I would be helpful if you can give some hints.

Thanks

[Former Member]

Hi,

try to use this trick with an IF condition in you customer exit. Calling 'var1' the manual input of:

data: month_difference TYPE N.

month_difference = 'var1'+4(3) - 4.

IF month_difference >= 0.

DO the classic code which you have already used.

ELSE month_difference < 0.

DO the replace concatenating manually 'var1'(4) and the single month.

ENDIF.

Hope it helps.

Best regards.

Simone.