Loading strategy for actual and planned CO costs?
WE are building a reporting solution that gathers actual and planned costs/revenues for WBS elements, network activities and service orders.
The delta extractor for the service order costs return around 100 million records for a year and we potentially have several years to load
We are currently using the full load extractors on a weekly basis to extract planned costs.
We will use the delta extractors on a daily basis to extract actual costs.
Due to the amount of actual costs, I was wondering whether for past years we would not be better at using the full load extractors (using VTYPE=10 for actuals, instead of 20 for planned costs) instead of using the delta load extractors.
Even in the long run, wouldnt it be wiser at the end of the year to delete all actual costs requests loaded along the year, and reload the complete year using the full load extractor?
Advices are welcome!