Cumulative values in GL drilldown reports
This document describes how figures are calculated from the drilldown reports in the General Ledger (S_PL0_86000029, S_PL0_86000028 and S_E38_98000088).
The figures are calculated in the following way:
1.- The calculated keyfigure BILWERT (Balance Sheet Value) behaves in different ways for balance sheet and for P+L accounts. For balance sheet accounts it always provides you with cumulated values. For example for period 6 to 6 it will show cumulated value for periods 1 - 6 plus the balance carry forward value.
2.- The BILWER is calculated like:
BILWERT = WERTB + WERTE,
WERTB - Balance sheet accounts value
WERTE - Income statement account value
3.- However, if an account is a P&L statement account, you will see the real period balance value for the particular period range. It means, that for period 6-6 you will see value for the single period 6. For period 1-6 you will see cumulated value for period range 1 - 6 without balance carry forward.
The particular accounts will be valuated depending on the Financial Statement specified in the parameter selection at the time of running the report.
Following this logic the account classification should be as follows:
1.- All accounts assigned to the nodes "Assets" and "Liab+Equity" are taken as balance sheet accounts and cumulated values are provided for those accounts by report S_E38_98000088 (and other GL reports).
2.- All accounts which are not assigned within the FSV at all are considered as balance sheet accounts and cumulated values are provided by GL drilldown reports.
3.- All accounts which are assigned out of "Assets" and "Liab+Equity" nodes within particular FSV are taken as Profit and Loss acounts and period values are provided for them in the GL drilldown reports.
The original settings (which you can see under T-cd: FS00) has no influence on it when using the FI-GL drilldown reports.
If the FSV is not specified in the selection, this means that all accounts are handled in the same way as "balance sheet account" from the above explanation.