Skip to Content
0
Former Member
Oct 03, 2005 at 01:12 PM

Multiprovider

45 Views

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.