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
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