C_PPM_ProjectBriefCostHeader

DDL: C_PPM_PROJECTBRIEFCOSTHEADER SQL: CPPMPROBRFCOSHD Type: view CONSUMPTION Package: ODATA_PPM_PRO_PROJECT_BRIEF
21 Fields 1 Data Sources

Source of Cost Chart

C_PPM_ProjectBriefCostHeader is a Consumption CDS View that provides data about "Source of Cost Chart" in SAP S/4HANA. It reads from 1 data source (R_EnterpriseProject) and exposes 21 fields with key field ProjectUUID. Part of development package ODATA_PPM_PRO_PROJECT_BRIEF.

Data Sources (1)

SourceAliasJoin Type
R_EnterpriseProject PPM from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPPMPROBRFCOSHD view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Source of Cost Chart view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.representativeKey ProjectUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID R_EnterpriseProject ProjectUUID Project UUID
ProjectSummaryTaskUUID R_EnterpriseProject ProjectSummaryTaskUUID Entity GUID
WBSElementInternalID R_EnterpriseProject WBSElementInternalID WBS Internal ID
Project R_EnterpriseProject Project WBS Element
ProjectInternalID R_EnterpriseProject ProjectInternalID Project Def.
Currency
ActualCost
PlannedCost
ActualCostUpToCurPerd
PlannedCostUpToCurPerd
CostDvtnUpToCurrentPeriod
CostDvtnUpToCurPerdCritlty
ControllingArea R_EnterpriseProject ControllingArea Controlling Area
ProfitCenter R_EnterpriseProject ProfitCenter Profit Center
CompanyCode
ResponsibleCostCenter R_EnterpriseProject ResponsibleCostCenter Responsible Cost Center
FunctionalArea R_EnterpriseProject FunctionalArea Sendr Fctl Area
Plant R_EnterpriseProject Plant Valuation Area
EnterpriseProjectType R_EnterpriseProject EnterpriseProjectType Proj.type
ProjectProfileCode R_EnterpriseProject ProjectProfileCode Project Profile
_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 C_PPM_ProjectBriefCostHeader.
-- 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: CPPMPROBRFCOSHD

CREATE VIEW C_PPM_ProjectBriefCostHeader AS
SELECT
  PPM.ProjectUUID AS ProjectUUID,
  PPM.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  PPM.WBSElementInternalID AS WBSElementInternalID,
  PPM.Project AS Project,
  PPM.ProjectInternalID AS ProjectInternalID,
  PPM._ControllingArea.ControllingAreaCurrency AS Currency,
  cast( 0 as abap.curr( 25, 2 )) AS ActualCost,
  cast( 0 as abap.curr( 25, 2 )) AS PlannedCost,
  cast( 0 as abap.curr( 25, 2 )) AS ActualCostUpToCurPerd,
  cast( 0 as abap.curr( 25, 2 )) AS PlannedCostUpToCurPerd,
  cast( 0 as abap.curr( 25, 2 )) AS CostDvtnUpToCurrentPeriod,
  ' ' AS CostDvtnUpToCurPerdCritlty,
  PPM.ControllingArea AS ControllingArea,
  PPM.ProfitCenter AS ProfitCenter,
  PPM._CompanyCode.CompanyCode AS CompanyCode,
  PPM.ResponsibleCostCenter AS ResponsibleCostCenter,
  PPM.FunctionalArea AS FunctionalArea,
  PPM.Plant AS Plant,
  PPM.EnterpriseProjectType AS EnterpriseProjectType,
  PPM.ProjectProfileCode AS ProjectProfileCode,
  PPM._ControllingArea._Currency AS _Currency
FROM R_EnterpriseProject AS PPM
;

Learn More