Cost Center Accounting Datasources for Actual and Budget

1617 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