Skip to Content
0
Feb 08, 2006 at 09:42 PM

FBL5 FIAR - exception aggregation - count customers with open items at key

62 Views

Hello gurus,

I have read the information about counting all values in reference to a characteristic. I manage to count how many customers have a FIAR open item 'billing status' = Open in my FIAR cube.

Now I am asked to replicate transaction FBL5 of R3. This transaction will give you open items at a given key date by adding

the items with

A) Item status = 'O' and posting date <= key date

and the items with

B) Item status = 'C' and posting date < =key date and clearing date > key date.

I calculate the net value by creating 2 restricted key figures and then adding them in a CKF.

But for counting I have a problem. I can count how many customer make up the open items (case A)

and how many customers makeup items that where cleared between key date and today.(case B).

But I cannot sum the two numbers as there might be customers that are counted in both cases.

For example I have 4 customers that correspond to case A : 1000 1011, 1012 and 1014

And I have 3 customers that correspond to case B 1000 , 1011 and 1013

I would like to get 5 as the number of customers that verify either case A or case B (or both).

Is there a way to do this with the exception 'aggregation 'and 'count all values' property of CKF ?

Claudio