Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.