I_KPIEarnedValue

DDL: I_KPIEARNEDVALUE SQL: IKPIEV Type: view COMPOSITE
6 Fields 1 Data Sources

KPI: Earned Value

I_KPIEarnedValue is a Composite CDS View that provides data about "KPI: Earned Value" in SAP S/4HANA. It reads from 1 data source (I_EarnedValueData) and exposes 6 fields with key field MasterProject.

Data Sources (1)

SourceAliasJoin Type
I_EarnedValueData I_EarnedValueData from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IKPIEV view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label KPI: Earned Value view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MasterProject I_EarnedValueData MasterProject Project ID
MasterProjectUUID I_EarnedValueData MasterProjectUUID NodeID
Version I_EarnedValueData Version XML Vers.
PlndCostAmt
ActualCostAmount
TransactionCurrency I_EarnedValueData TransactionCurrency Transaction Currency

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 I_KPIEarnedValue.
-- 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: IKPIEV

CREATE VIEW I_KPIEarnedValue AS
SELECT
  I_EarnedValueData.MasterProject AS MasterProject,
  I_EarnedValueData.MasterProjectUUID AS MasterProjectUUID,
  I_EarnedValueData.Version AS Version,
  sum( I_EarnedValueData.PlndCostAmt ) AS PlndCostAmt,
  sum( I_EarnedValueData.ActualCostAmount ) AS ActualCostAmount,
  I_EarnedValueData.TransactionCurrency AS TransactionCurrency
FROM I_EarnedValueData
;

Learn More