Cumulative, Opening balance calculation SAP Public cloud

[SriSaiBhargav]

Hello Experts,

I am working on an SAP S/4HANA Public Cloud implementation and using Key User Extensibility to create Custom CDS Views. I need to calculate balances of each JE posted to GL Account:

1. Cumulative Balance – a running total based on a date or period

2. Opening Balance – the balance as of the beginning of the selected period.

I am aware that in public cloud, we are limited to certain functionalities. 

Could anyone guide me on:

Is it possible to implement such logic using only Key User tools (e.g., Custom CDS Views))?

Thanks.

[Jeremy_Deo]

Hello dear user,

To set cumulative key figures at the reporting level in SAP S/4HANA Cloud, follow these simple steps:

1. What Are Cumulative Key Figures?

Cumulative key figures show values that add up over time. For example, instead of showing just the sales for each month, a cumulative key figure would show the total sales up to that month.

2. Define the Cumulative Key Figure in Your Report

• In your reporting tool (like SAP Analytics Cloud or S/4HANA Cloud), find the key figure you want to make cumulative.
• Set it to Cumulative so that it keeps adding values together instead of just showing them for individual periods (like months or years).

3. Make Sure Time Is Set Up Correctly

Cumulative key figures depend on time, so make sure you have a time dimension (like months or quarters) in your report. This helps the system know when to add the numbers together.

4. Create the Calculation for Running Totals

• You might need to use a function like CUMULATE() in your tool (like SAC) to calculate the running totals automatically.
• This makes sure that the numbers continue to add up as time goes on.

5. Check Your Report

After setting the key figures as cumulative, review your report. Make sure the numbers are adding up over time as expected, and adjust the time period if needed.

In short: Set your key figure to cumulative, ensure you’re using a time dimension, and make sure the calculation keeps adding the values over time.

I hope those elements will help you solve your issue.

Best regards,

Jeremy

#GenAI was used to help generate this content