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