Cost Center Accounting Datasources for Actual and Budget

[Former Member]

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

[sander_vanwilligen · Accepted solution]

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

[Former Member · Accepted solution]

Hi Sander,

Thanks for your response.

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.

Comments : i see in BI the below Value types

10 : Aactual

20 : Plan

30 : Target

40 : Commitments

50 : Budget

I checked in ECC , COEP table has data with valuetype : 5 ( 50 in BI) , so i want to know which datasource can bring this data. i triggered  0CO_OM_CCA_1 and 0CO_OM_CCA_9 but both didnt get valuetype : 50 data. Do i need to any step in ECC to get this data to BI or is there any other data source that can bring this data.

Q4. Can some one 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.

Comments : For init and full load for CCA datasources do i need to do any activity in ECC apart from time stamp table for delta.

I dont have access to service sap so i couldnt see the note.

thanks,

visali

[sander_vanwilligen · Accepted solution]

Hi Visali,

Re. Value Type and Budget, it is not a simple 1 to 1 conversion (e.g. OLTP Value Type '5' = BW Value Type '050'). In ECC the following table plays a crucial role: COSP_VTYPE. Please also refer to SAP Note 523742 - BCT-CO: BW key figure model and R/3 tables for trans. data.

In table COSP_VTYPE I can find that OLTP Value Type '5' (Target) is only mapped to BW Value Type '030'.

Extraction takes place using DataSource 0CO_OM_CCA_1. Please note that you have to select Value Type '030' explicitly.

Re. the loading, you do not have to do any activity. SAPI (Service API) takes care of the delta mechanism and timestamp table. Please also refer to SAP Note 416265 - BCT-CO delta DataSources: Technical background information.

Re. the referenced SAP Notes, please arrange an S-user account or ask someone within your organization to download the SAP Notes for you (e.g. a SAP Basis administrator will certainly have an S-user).

Best regards,

Sander

[Former Member · Accepted solution]

Hi, Thanks a lot. I am clear now.