how to get data from 0sd_c03 and 0fiar_c03

37 Views

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