Loading strategy for actual and planned CO costs?

[Former Member]

Hi,

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!

Thanks.

[Former Member]

Hi,

in general its a good idea to load finished history in Full and do the delta from a single point in time. A reload of originally delta records with a full one has from my point of view no additional use.

What you should consider is to do a partitioning of years for reporting (IC per year with additonal MP). Also have a look how usefull each infoobject is, do you really need each single docnumber and line of each co document in order to decrease the used space and to speed up reporting.