Skip to Content
author's profile photo Former Member
Former Member

how to get data from 0sd_c03 and 0fiar_c03

hi all

we have two infocubes 0SD_C03 and 0FIAR_C03

i want to create a multiprovider based on these two infocubes

can anyone suggest me how do i proceed.

i need the payment receipt( credit amt local currency) value which is in 0FIAR_C03

and net value in 0SD_C03

for our report which gives Total Sales, Billing and Payment receipt values.

I am able to get sales and billing values by creating a selection on netvalue from 0SD_C03 based on sales document category but my payment reciept is in 0FIAR_C03 cube .. ( which gets data from BSID and BSAD tables using datasource 0FI_AR_4.)

0FI_AR_4. DataSource extracts Accounts Receivable Accounting line items from tables BSID (open items) and BSAD (cleared items) in the R/3 source system

how do i achieve this

is multiprovider is the only way

if so please suggest what fields i need to use to join these two infocubes in multiprovider

thanks & regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2011 at 05:07 AM

    Hi Krishna,

    Multiprovider will be the best option for this. But at the same time you need to fetch the unique records out of these two cubes. Always you have to see assignments which you are selecting and that can be proposed. KF's data can be extract based on this.

    Please share the detail information regarding your unique chars.

    Assign points if helful.

    Regards,

    Amit

    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.