Skip to Content

How will I make this work in Multiprovider?

Hi guyz,

I have two DSOs, namely DSO_1 and DSO_2, and on top of the is a Multiprovider..

DSO_1 is composed of:

*Payer

*Material

Amount

DSO_2 is composed of:

*Payer

*Material

*Account

Quantity

NOTE: * means PRIMARY KEY

The report is something like this:

Payer Material Account Amount Quantity

My question is, how will I make the report above work if I don't have an Account Number in my DSO_1?

EXAMPLE:

DSO_1 contains:

Payer Material Amount

10 100 30

10 200 40

DSO_2 contains:

Payer Material Account Quantity

10 100 1010 50

10 100 1011 60

10 200 1040 70

10 200 1045 80

10 200 1047 90

How will I get this output? Is this possible?

Payer Material Account Amount Quantity

10 100 1010 30 50

10 100 1011 30 60

10 200 1040 40 70

10 200 1045 40 80

10 200 1047 40 90

Thanks a lot!

Loed

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Nov 20, 2013 at 01:16 PM

    Hi,

    Constant selection at Bex level will help you in getting the data in one line.

    You need to apply constant selection on Amount with Char Account as this is not present in this DSO.

    For more information on my approach you may search the document with the name.

    How to Display Result Row in One Line While Reporting On Multiprovider.

    That document will give you step by step navigation on the approach which i mentioned.

    Hope that helps.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2013 at 12:47 PM

    Did you try infoset DSO1 left-outer-join DSO2?

    Br, H

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2013 at 06:36 PM

    This message was moderated.

    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.