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

Cost Center Accounting Datasources for Actual and Budget

Posted on Nov 11, 2015 at 03:44 AM 963 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

BW (SAP Business Warehouse)
Add comment
10|10000 characters needed characters exceeded

1 Answer

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

    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 comment
    10|10000 characters needed characters exceeded