Loading CO Datasource 0CO_OM_CCA_20 from R3 to BW

[Former Member]

Hi everyone,

I am creating a report on Cost Element for my company. I have found the Datasources which provide me necessary Fields for my Reports, they are:

• 0CO_OM_CCA_20
• 0CO_OM_CCA_09
• 0COSTELMNT_0102_HIER

So i would like to ask you some questions:

1. I have searched for Referenz on Internet, and there Steps for FI Datasource Extraction like belows, but i am not sure if these Steps are still suitable for CO Datasource?:

1. find suitable standard data source(ex - 0fi_ap_4) and activate it from RSA5. do the required maintenance at RSA6.

2. Later do the test run at RSA3 and check the data. if its pulling as you need, then

3. You can replicate data source into bw side,activate it.

4. later from bi content from bw side you can install required objects and make data flow as active..

5. start loading data at  dev system and check it

like at way you can do the same steps other data sources.

or do i have to follow Steps in CO-PA Extraction to load to BW?

2. Regarding the Relationship between 3 Datasources, how can we know if there are some common fields among these Datasource, by which we can use to join these Datasource in BW?

Please help me with this Issue because i am newbie with BW. Thanks

[KodandaPani_KV]

Hi,

you said correct and above are all steps correct.

2. Regarding the Relationship between 3 Datasources, how can we know if there are some common fields among these Datasource, by which we can use to join these Datasource in BW?

all 3 data source have cammon fields ex-  EKKO,EKPO,EBAN -> EBELN have common filed.

check the primary combination for those tables.

Thanks,

Phani.

[Former Member]

Hi Phani,

Thanks for your Reply.

Can you please tell me how did you find the common fields? i want to learn your approach and then i will do the same for other Report.