Skip to Content
0
Former Member
Feb 12, 2009 at 04:28 PM

Account receivables - Line items: Modelling or query question

84 Views

There's 0FIAR_C03, a BCT infocube and 0FIAR_O03, a BCT ODS.

There's a nice query on the 0FIAR_O03: 0FIAR_O03_Q0001_CR. In this query you can see all lines which aren't cleared before a particular date.

My question is the following:

I would like to make a query which outputs the non cleared values for each day in a month.

For example: I got three line items.

Line 1: amount 100. Posting date 02.feb.2009. Clearing date: 06.feb.2009.

Line 2: amount 500. Posting date 04.feb.2009. Clearing date: 09.feb.2009.

Line 3: amount 300. Posting date 08.feb.2009. No clearing date.

The output needs to be something like this

0Calenderday Total amount

01.feb.2009 0

02.feb.2009 100

03.feb.2009 100

04.feb.2009 600

05.feb.2009 600

06.feb.2009 500

07.feb.2009 500

08.feb.2009 800

09.feb.2009 300

10.feb.2009 300

11.feb.2009 300

12.feb.2009 300

etc...

Mention the dates without postings! On these dates, some lines are still not cleared....

What is the way to go?

- Multiprovider?

- How to get all dates of a month?

- How to get the values on these dates?

Please put me in the right direction.

Thanks in advance,

Marcel