0CO_OM_CCA_20 and 0CO_OM_CCA_40

[Former Member]

Hi everyone,

i am making Report on Cost Centre Allocation. and i would like to know how can we join these 2 Datasource

i have read throught 12 Articles on SCN about these Datasource but there is no Description about joining of 2 data in the Datasources so i would like to ask for help:

0CO_OM_CCA_20:contain plan and actual totals cost

0CO_OM_CCA_40: contain actual line time level cost

i have loaded data from 0CO_OM_CCA_20 to InfoCube 0CCA_C20 and 0CO_OM_CCA_40 to 0CCA_R40. i want to create an InfoProvider based on 2 Infocubes

But the 0CCA_C20 has no Company Code and 0CCA_R40 has it. So i don't know how can we Join 2 InfoCubes?

Thanks

[bhavinvyas]

Hi,

Try to work with data-source 0CO_OM_CCA_9 instead of 0CO_OM_CCA_40.

It will have same info and company code as well,

Please see the following help page.

http://help.sap.com/saphelp_nw70/helpdata/en/8f/d93c00e39d5b4fb6eaa3bf16e6fb09/frameset.htm

Thanks,

Bhavin VYAS

[Former Member]

Hi Bhavin,

i think these 2 Datasource are the same.

My Problem is that i want to join 2 Infosources , but the Key fields to join are not the same between 2 Infosource.

The reason i want to join 2 Infosource is that:

i want to have all Fields of InfoCube 0CCA_C20 and the line intem level of 0CCA_R40.

But when 0CCA_C20 has no Company Code and 0CCA_R40 has company code, then we can't join them right?

[bhavinvyas]

may be you can try to merge with cost center and controlling area.

Thanks,

Bhavin Vyas