I have to create a report for the pending Purchase Orders.
Now, in R/3, EKPO contains information of all the POs.
EKBE contains information of the completely and partially invoiced POs.
So, I have created 2 datasources, one from EKPO and one from EKBE.
The EKPO datasource goes to on ODS, and the EKBE datasource goes to another ods.
To calculate the pending values, eg: Pending PO Quantity, i have to subtract the PO Quantity for a particular Line Item of a PO from EKBE, from the one in EKPO.
If the value is not equal to zero, then that line item is pending.
So, for this, how do i go about using the 2 ODSs?
1. Can i create a datamart on both the ODSs and then do the required calculation?
2. Can i create an export datasource from EKPO ODS and then do the required calculation in EKBE ODS?
3. Any other suggestions?
Thanx in advance
Edited by: BW Developer on Jun 27, 2008 6:56 AM