Skip to Content
author's profile photo
Former Member

Multiprovider

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Oct 03, 2005 at 01:16 PM

    Hi,

    If you do not want Box in the rows of the result set you can easily get this report.Other wise it is not possible to create the query as per your reqired format.

    Other wise use Info set instead of Multi provider.

    With rgds,

    Anil Kumar Sharma .P

    Message was edited by: Anil Kumar Sharma

    Add comment
    10|10000 characters needed characters exceeded