C_FinancialStatementKPI

DDL: C_FINANCIALSTATEMENTKPI SQL: CFIFINSTMTKPI Type: view CONSUMPTION Package: FINS_FI_SEM_TAG
6 Fields 1 Data Sources

KPIs based on Financial Statements

C_FinancialStatementKPI (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

C_FinancialStatementKPI is a Consumption CDS View that provides data about "KPIs based on Financial Statements" in SAP S/4HANA. It reads from 1 data source (I_ActualPlanLineItemSemTag) and exposes 6 fields. Part of development package FINS_FI_SEM_TAG.

SAP API Hub

CategoryConsumption
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-FIO-GL-HIE-2CL
CapabilitiesAnalytical Query
Extensible (Key User)Yes
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS View provides you with access to a variety of financial statement-based measures that can be analyzed by all details of a journal entry. This view is based on the CDS Cube ViewI_ActualPlanLineItemSemTag, which combines actual and plan data and enriches the data with semantic tags. The measures are used to calculate financial statement-based KPIs based on the semantic tags that are assigned. The calculation of these KPIs is purely based on the aggregation of line items that are enriched by semantic tags.</p> <p>This CDS view provides you with the information that you need to answer the following business questions:</p> <ul> <li> <p>What is my Return on Investment per Segment?</p> </li> <li> <p>What are my Cost of Goods sold per Product Group</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ActualPlanLineItemSemTag I_ActualPlanLineItemSemTag from

Parameters (3)

NameTypeDefault
P_PlanningCategory fcom_category
P_KeyDate vdm_v_key_date
P_ToFiscalPeriod fis_period_to

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CFIFINSTMTKPI view
AbapCatalog.compiler.compareFilter true view
EndUserText.label KPIs based on Financial Statements view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.query true view
OData.publish true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
multipleSelectionsfalse
mandatorytrueGLAccountHierarchy
multipleSelectionsfalse
resultElementLedger
multipleSelectionstrue
multipleSelectionstrue

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_FinancialStatementKPI.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CFIFINSTMTKPI
-- Parameters: P_PlanningCategory : fcom_category, P_KeyDate : vdm_v_key_date, P_ToFiscalPeriod : fis_period_to

CREATE VIEW C_FinancialStatementKPI AS
SELECT
  multipleSelections: false AS multipleSelectionsfalse,
  mandatory: true AS mandatorytrueGLAccountHierarchy,
  resultElement: 'Ledger' AS resultElementLedger,
  multipleSelections: true AS multipleSelectionstrue
FROM I_ActualPlanLineItemSemTag
;

Learn More