I have a requirement:
To get the Work Order Activity from PM, and their corresponding Work Order numbers, Cost Centers and the Amounts associated from CO module like CCA and WBS6 datasources.
I thought about this solution:
Link the 0PM_C03 with the MD- 0PM_ORDER as a left outer join
and inner join 0PM_C03 with ZTXN_O01 - DSO(based on 0CCA9DSO) and Innerjoin to the ZWBS_C20 .
Is it ok to include 2 infocubes ,1 DSO and 1 MD object in an Infoset. Performance may be worst.. but i cannot think of any other solution.........
Multiprovider does not solve my purpose as it gives 2 records when you identify Work Order number in PM and CO modules. By using an Infoset we can link WO in PM to WO in CO.
Please guide me.....