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

Loading CO Datasource 0CO_OM_CCA_20 from R3 to BW

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 14, 2016 at 02:10 PM

    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.

    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.