C_GLAccountFlowKPI

Purpose
This CDS view provides you with access to a variety of financial statement-based measures that can be analyzed by the most important dimensions of a journal entry. This view combines actual and plan data enriched with semantic tags. The measures are used to calculate financial statement based KPIs (Key Performance Indicators). The calculation of these KPIs is purely based on the aggregation of line items that are enriched by semantic tags. all line items except year-end closing postings are considered. This CDS view provides you with the information that you need to answer the following business questions: What is my Return on Investment per Profit Center for the fiscal year 2019? What is the opening balance of my Cost of Goods ? What are the changing balances of my Operating Income for the fiscal periods of the fiscal year 2019?

Prerequisites
Users who want to run reports using this CDS view must have a role based on the business role template listed in the table above. In this role, the following restriction types must be set to read access, for example: Company Code Ledgers Financial Account Types Segments These restriction types are edited in the Maintain Business Roles app.

Structure
Object types This view relates to the following SAP object types: Journal Entry Item Financial Planning Entry Item Main CDS parameters and filters The mandatory input parameters are: Financial statement version Ledger Plan category Fiscal year period Other important parameters are: Company code Measures and attributes All relevant dimensions are included in this CDS view along with associations to interface views for some of these dimensions. The most important attributes are: Company code Profit center Cost center Segment Customer

G/L Account Flow Type (Opening, Change, Ending)
This CDS view retrieves for each combination of dimensions and KPIs per desired time interval an amount for the opening balance, an amount for the change and an amount for the ending balance in global currency. Opening All postings from the beginning of the lowest given fiscal year to the start date of the selected time interval Change All postings in the selected time interval Ending Opening plus change balance

Plan/Actual
By specifying a plan category additionally to the plan category ACT01 (stands for actual values) actual values can be compared with planned values.

Time Periods (Special Periods, Selection of Several Years, Year-to-Date, Periods)
By specifying a fiscal year period interval, any time interval, for example, several years, several periods of a year, a year can be selected. Special periods are assigned to the last period of a fiscal year. Balances carried forward are not shown in period 000. If the selection is performed with the beginning of the fiscal year, the balances carried forward are shown as opening balance of period 1.

Comparison to App/Query/ViewC_FinancialStatementKPI
With the CDS view Financial Statement-based KPIs ( C_FinancialStatementKPI ), special periods have to be selected separately. With the CDS view C_FinancialStatementKPI , balances carried forward are shown in period 000. With the CDS view C_FinancialStatementKPI , only year-to-date balances can be retrieved.

Key Performance Indicators (KPIs)
The following table shows the relationship between the financial statement-based KPIs and the semantic tags that are assigned: Formula of KPIs and Assignment to Semantic Tags KPI Technical Field Name Based on Semantic Tag As Aggregated Based on Formula Working Capital Amount in Global Currency (Working Capital Amount in Global Crcy) WorkingCapitalAmtInGlobCrcy CurrentAssetAmtInGlobCrcy - CurrentLiabilityAmtInGlobCrcy Working Capital in Global Currency as a Percentage (Working Capital Glob Crcy Percent) WorkingCapitalGlobCrcyPercent ( CurrentAssetAmtInGlobCrcy / CurrentLiabilityAmtInGlobCrcy) * 100 Current Asset Amount in Global Currency (Current Asset Amount in Global Crcy) CurrentAssetAmtInGlobCrcy CURASSET AmountInGlobalCur