Hello Experts
our scenario is as follows:
In my char(0MAT_PLANT) there is material standard price as a key figure and my ODS contains transaction data from the ZTABLE.
Now i want to create a query as such we need to get the transaction data from the ODS and corresponding material standar price from 0MAT_PLANT.
i am trying to create a multiprovider for the above ODS and CHAR object.
<b>ZODS</b>
Mat.no Box Plant QTY
X0001 001 1100 100.00
X0002 001 1100 50.00
X0001 002 1100 200.00
X0002 002 1100 100.00
<b>0MAT_PLANT</b>
Mat.no Plant Price
X0001 1100 20.00
X0002 1100 19.00
Query output should be like this:
Mat.No Box Plant (QTY*Price)
X0001 001 1100 2000.00
X0002 001 1100 950.00
X0001 002 1100 4000.00
X0002 002 1100 1900.00
Will the multiprovider work?
As in ODS i have 0Material where as in Char i dont have 0Material. How do the link up 0material to get above result.
Note: I dont want to use 0Mat_plant material in my ZODS because i need to display the attributes of 0Material in the query. Thanks in advance
Regards
Sri.