SAP Knowledge Base Article - Public

2935834 - Behaviour of Key Figure Actual YTD

Symptom

Run a Report and add Key Figure Actual YTD but the result is not as expected.

Environment

 Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics Work Center.
  2. Select Design Reports.
  3. For example, Search and open FINGLAU04_Q0004 Financial Statements - Plan/Actual.
  4. Regarding Selection Criteria , Put Company XXX(XXX Represents the ID of the Company).
  5. For Financial Reporting Structure, Put  YYY(YYY Represents the ID of the Reporting Structure).
  6. In the View tab, Remove Key Figures "Plan" "Variance" and "Variance %".
  7. Then Add Key Figure "Actual YTD".
  8. In column add field "Accounting Period/Year".

Result and Expectation:

The expectation is that the results should be accumulated for example in the month February (February should be Actual YTD January+Actual YTD February). However, the system is not accumulating the amounts from the previous period.

Cause

Key figure 'Actual(…)':

Calculation = opening balance + debit - credit .

Actual is the balance of an item for that period range. The opening balance is already as the ending balance of the previous period and hence the data coming is already cumulative. Actual gives balances for the selected period in the fiscal year.

Key figure 'Actual YTD(…)':

Actual YTD gives the balances from the first period to the current date in that fiscal year.

Resolution

This is a standard system behaviour.

Keywords

Actual YTD in Reporting, Report, Financial Statements - Plan/Actual , KBA , SRD-FIN-ANA-GL , General Ledger (Reporting) , Problem

Product

SAP Business ByDesign all versions