Skip to Content
0
Former Member
Jun 27, 2008 at 04:56 AM

Suggestions needed on Purchasing scenario

6 Views

Hi Experts,

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?

Kindly help.

Thanx in advance

Edited by: BW Developer on Jun 27, 2008 6:56 AM