IBP - actuals YTD

[Former Member]

Hi experts,

I have the requirement to calculate a KF for Actuals YTD, following this logic:

Any idea which should be the steps to follow to configure that?

Many thanks

Juan Carlos

[lingaiahvanam · Accepted solution]

Hi,

You have a requirement to use time as a dimension to aggregate periods. You can calculate year-to-date (YTD), quarter-to-date (QTD), and other similar aggregations using this approach.

This example illustrates the configuration required to use time as a dimension to aggregate periods. It uses a product master data type with two products, P1 and P10, and a sales key figure, at PERPROD level, as shown in the following table:

Quarter-to-date and year-to-date totals are shown in the following table:

As suggested refer to SAP note 2288329 for more details.

Best Regards,

Lingaiah

[peter_casper]

Hi Juan Carlos,

Lingaiah's answer and link to the respective SAP not will do the trick. But in case you are already on IBP version 1905, I would strongly recommend to use the newly introduced function "IBP_CAGGR" which makes this kind of calculation more easy.

It got excellently documented by apolover12 in his blog.

https://blogs.sap.com/2019/06/22/year-to-dateytd-year-to-goytg-in-sap-ibp-cumulative-aggregation/

BR, Peter

[AyanBishnu]

Hi Juan

Have you checked this oss note ? If not please check

https://launchpad.support.sap.com/#/notes/2288329