Skip to Content
Feb 02, 2021 at 12:53 PM

Calculation and Aggregations on calendarweek-basis in S/4HANA Cloud



is there a way to calculate and/or aggregate with a dimension based on calendar weeks? I'm trying to implement this functionality via a custom-cds directly in S4HC to be able to consume it afterwards in embedded SAC

I know that its possible to calculate the week, based on the difference to the first day of the year. This formula isn't universal and has to be maintained to work properly in every year.

Is there a way to show i.e. an capacityrequirement that has a start and enddate in different weeks, in both weeks, with the capacityrequirement correctly split over the different weeks?

Thank you for your help!

Best regards