I am trying to develop a query to fetch Actual Cost from the Cost Plan of Record, for a particular month. But there is no records I found in the table ODF_SSL_CST_DTL_ACOST, in which I believe the slice values for Cost Plan Actual cost should be there. And this slice is active in back-end too. I cannot use PPA_WIP tables since it will not be equal with Actual Cost showing in the cost plan always. Can anyone help me?
Not all internal slice tables are meant to have the slice data populated from the UI.
As far as I understand, its only the planned cost which gets stored in the slice tables. The actuals and variances are calculated on the fly and not stored in the slice tables.
As recommended in the other thread, customers usually use WIP tables to pull out the cost and I have also explained in what circumstances, the cost will not match the cost plan and wip tables.
Atlernatively, you can refer the following DB Tables:
Hope this helps!
I couldn't find the Actual Cost slice data in those tables.
Use ODF_SSL_CST_DTL_COST table to get actual cost information.