Dear All,
I am working on a webi report which consumes three data providers based on BEx. My data provider provides following field
1. Stock related information
This data provider gives following columns date and quantity.
2. Purchase
This data provider gives following columns : date of GR Entry, document number and amount
3. Payment
This data provider gives following columns: date of payment, invoice number (purchase number) and amount ( There is no material in this data provider).
Intention of creating this report is to show a table that will be give stock position on daily basis and an amount paid against an invoice. Amount paid should be reflected in the table only when payment is done.
Providing sample data as below
Stock Info
Date Qty
01-Apr-16 100
02-Apr-16 90
03-Apr-16 80
04-Apr-16 70
05-Apr-16 60
06-Apr-16 100
07-Apr-16 90
08-Apr-16 80
09-Apr-16 70
10-Apr-16 60
Purchase
GRE Date Document Number Qty
06-Apr-16 1111 40
Payment
GRE Date Document Number Amount
07-Apr-16 1110 6000
09-Apr-16 1111 4000
Expected Result
Date Qty Amount
01-Apr-16 100
02-Apr-16 90
03-Apr-16 80
04-Apr-16 70
05-Apr-16 60
06-Apr-16 100
07-Apr-16 90
08-Apr-16 80
09-Apr-16 70 4000
10-Apr-16 60
Is their any we can achieve this? I think will have to use outer join and inner join combination. Since we are using BEx as source, I can not combine two queries.
Any help to resolve this issue is highly appreciated.
Regards,
Girish Oak
Add a comment