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.