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

Cost Center Accounting Datasources for Actual and Budget

Posted on Nov 11, 2015 at 03:44 AM 1.2k Views

Hi ,

I have a requirement to see Actual and Budget data in the same report for Cost centers.

Currently budget data is not maintained and will be maintained henceforth.

we have a existing report built on 0CO_OM_CCA_40 for Actuals data.

I see the below are datasources in BI :

0CO_OM_CCA_9 ( Cost Centers: Actual Costs Using Delta Extraction )

0CO_OM_CCA_1 (Cost centers: Costs and allocations )

0CO_OM_CCA_40 (Cost Centers: Actual Line Items (can produce delta figs))

Now my question is

1 )which data source i need to use Budget data from ECC

what is the Table name and Value type to look for budget data in ECC.

2) for actuals : 0CO_OM_CCA_40 do i need use this data source

or combitation of 0CO_OM_CCA_9 and 0CO_OM_CCA_1. what is the difference.

3) How different is plan from budget. Can someone explain.

4) Can some explain data load to these CCA datasources ( like init and delta , i know it does not have set up tables and delta timestamp has to be maintained in some table).But for init load should i need to do any step in ECC before i trigger infok in BI.

Thanks,

Visali

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Sander van Willigen
    Sander van Willigen
    Posted on Nov 11, 2015 at 06:50 PM
    4

    Hi Visali,

    Let me try to answer your questions.

    Q1. which data source i need to use Budget data from ECC

    what is the Table name and Value type to look for budget data in ECC.

    A1. DataSource 0CO_OM_CCA_1 has to be used; select Value Type '020'. Tables in ECC are COSS and COSP.

    Q2. for actuals : 0CO_OM_CCA_40 do i need use this data source

    or combitation of 0CO_OM_CCA_9 and 0CO_OM_CCA_1. what is the difference.

    A2. DataSource 0CO_OM_CCA_40 is new and meant for HANA in-memory scenarios. In BW on AnyDB you can use DataSource 0CO_OM_CCA_9 for actual costs (only Value Type '010').

    Q3. How different is plan from budget. Can someone explain.

    A3. Plan values are represented by Value Type '020'; budget values (a.k.a. target values) are represented by Value Type '030'.

    Q4. Can some explain data load to these CCA datasources ( like init and delta , i know it does not have set up tables and delta timestamp has to be maintained in some table).But for init load should i need to do any step in ECC before i trigger infok in BI.

    A4. CCA works with a timestamp delta mechanism. No setup tables are used.

    Please also refer to SAP Note 573962 - BCT-CO: DataSources for costs - totals record and line item for more information.

    Best regards,

    Sander

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer

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.