C_ProjCostByCostCompChart

DDL: C_PROJCOSTBYCOSTCOMPCHART SQL: CPROJBYCSTCOMP Type: view CONSUMPTION
27 Fields 1 Data Sources 1 Associations

Project Costs by Cost Component

C_ProjCostByCostCompChart is a Consumption CDS View that provides data about "Project Costs by Cost Component" in SAP S/4HANA. It reads from 1 data source (I_EnterpriseProjectCosts) and exposes 27 fields with key fields Project, SemanticTag, PlanningCategory, Ledger, PostingDate. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_EnterpriseProjectCosts _CostLineItems from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_SemanticTagValueHelp _SemanticTagVH $projection.SemanticTag = _SemanticTagVH.SemanticTag

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPROJBYCSTCOMP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Project Costs by Cost Component view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY Project Project WBS Element
KEY SemanticTag SemanticTag Semantic Tag
KEY PlanningCategory PlanningCategory Plan Category
KEY Ledger Ledger Ledger
KEY PostingDate PostingDate Posting Date for GR
SemanticTagName _SemanticTagVH SemanticTagName
ActualAmountInGlobalCurrency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
ActualCostForCostComponent1 ActualCost
ActualCostForCostComponent2 ActualCost
ActualCostForCostComponent3 ActualCost
ActualCostForCostComponent4 ActualCost
ActualCost ActualCost
ActualCostComponentName1 I_EnterpriseProjectCosts SemanticTagName
ActualCostComponentName2 I_EnterpriseProjectCosts SemanticTagName
ActualCostComponentName3 I_EnterpriseProjectCosts SemanticTagName
ActualCostComponentName4 I_EnterpriseProjectCosts SemanticTagName
CostComponentName I_EnterpriseProjectCosts SemanticTagName
PlanCostForCostComponent1 ActualCost
PlanCostForCostComponent2 ActualCost
PlanCostForCostComponent3 ActualCost
PlanCostForCostComponent4 ActualCost
PlannedCost ActualCost
PlanCostComponentName1 I_EnterpriseProjectCosts SemanticTagName
PlanCostComponentName2 I_EnterpriseProjectCosts SemanticTagName
PlanCostComponentName3 I_EnterpriseProjectCosts SemanticTagName
PlanCostComponentName4 I_EnterpriseProjectCosts SemanticTagName

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_ProjCostByCostCompChart.
-- 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: CPROJBYCSTCOMP

CREATE VIEW C_ProjCostByCostCompChart AS
SELECT
  Project,
  SemanticTag,
  PlanningCategory,
  Ledger,
  PostingDate,
  _SemanticTagVH.SemanticTagName AS SemanticTagName,
  sum(ActualAmountInGlobalCurrency) AS ActualAmountInGlobalCurrency,
  GlobalCurrency,
  ActualCost AS ActualCostForCostComponent1,
  ActualCost AS ActualCostForCostComponent2,
  ActualCost AS ActualCostForCostComponent3,
  ActualCost AS ActualCostForCostComponent4,
  ActualCost,
  _CostLineItems.SemanticTagName AS ActualCostComponentName1,
  _CostLineItems.SemanticTagName AS ActualCostComponentName2,
  _CostLineItems.SemanticTagName AS ActualCostComponentName3,
  _CostLineItems.SemanticTagName AS ActualCostComponentName4,
  _CostLineItems.SemanticTagName AS CostComponentName,
  ActualCost AS PlanCostForCostComponent1,
  ActualCost AS PlanCostForCostComponent2,
  ActualCost AS PlanCostForCostComponent3,
  ActualCost AS PlanCostForCostComponent4,
  ActualCost AS PlannedCost,
  _CostLineItems.SemanticTagName AS PlanCostComponentName1,
  _CostLineItems.SemanticTagName AS PlanCostComponentName2,
  _CostLineItems.SemanticTagName AS PlanCostComponentName3,
  _CostLineItems.SemanticTagName AS PlanCostComponentName4
FROM I_EnterpriseProjectCosts AS _CostLineItems
LEFT OUTER JOIN C_SemanticTagValueHelp AS _SemanticTagVH ON SemanticTag = _SemanticTagVH.SemanticTag  -- association [0..1]
;

Learn More