C_EntProjectHierElementTP

DDL: C_ENTPROJECTHIERELEMENTTP Type: view_entity CONSUMPTION
43 Fields 1 Data Sources 3 Associations

Enterprise Project Hierarchy Element

C_EntProjectHierElementTP is a Consumption CDS View that provides data about "Enterprise Project Hierarchy Element" in SAP S/4HANA. It reads from 1 data source (I_EnterpriseProjectElementTP_2) and exposes 43 fields with key field ProjectElementUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_EnterpriseProjectElementTP_2 I_EnterpriseProjectElementTP_2 projection

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_EntProjElmntPurOrdAssgmt _PurOrder _PurOrder.ProjectElementUUID = $projection.ProjectElementUUID
[0..*] I_EntProjElmntSalesDocument _SalesOrder _SalesOrder.ProjectElementUUID = $projection.ProjectElementUUID
[0..*] I_EntProjElmntMaintOrder _MaintOrder _MaintOrder.ProjectElementUUID = $projection.ProjectElementUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Enterprise Project Hierarchy Element view
Metadata.allowExtensions true view
ObjectModel.query.implementedBy ABAP:CL_PPM_QUERY_WBS_WITH_HIER view
ObjectModel.representativeKey ProjectElementUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY ProjectElementUUID ProjectElementUUID Obj Link Entity GUID
ProjectElement ProjectElement Proj Element ID
ProjectElementDescription ProjectElementDescription Name
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
PlannedStartDate PlannedStartDate Latest Planned Start
PlannedEndDate PlannedEndDate Ltst Planned Finish
ActualStartDate ActualStartDate Actual Start
ActualEndDate ActualEndDate Actual Finish
ProcessingStatusText _ProcessingStatusText ProcessingStatusText
ProcessingStatus ProcessingStatus Worklist Status
ParentObjectUUID ParentObjectUUID UUID Parent GO
ProjectUUID ProjectUUID Project UUID
ProfitCenter ProfitCenter Profit Center
ControllingArea ControllingArea Controlling Area
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
FunctionalArea FunctionalArea Sendr Fctl Area
FactoryCalendar FactoryCalendar Factory Calendar
int4
int4
int4
int4
int4
int4
int4
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementIsBillingElement WBSElementIsBillingElement Billing elem.
HierarchyNode HierarchyNode Node
HierarchyParentNode HierarchyParentNode Hier.node
HierarchyDistanceFromRoot HierarchyDistanceFromRoot Dist. From Root
HierarchyDescendantCount HierarchyDescendantCount Desc. Count
HierarchyDrillState HierarchyDrillState Drill State
HierarchyRank HierarchyRank Hierarchy Rank
HierarchyLevel HierarchyLevel Hierarchy Level
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement Statistical
IsProjectMilestone IsProjectMilestone Milestone
_PurOrder _PurOrder
_SalesOrder _SalesOrder
_MaintOrder _MaintOrder

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_EntProjectHierElementTP.
-- 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.

CREATE VIEW C_EntProjectHierElementTP AS
SELECT
  ProjectElementUUID,
  ProjectElement,
  ProjectElementDescription,
  ResponsibleCostCenter,
  PlannedStartDate,
  PlannedEndDate,
  ActualStartDate,
  ActualEndDate,
  _ProcessingStatusText.ProcessingStatusText AS ProcessingStatusText,
  ProcessingStatus,
  ParentObjectUUID,
  ProjectUUID,
  ProfitCenter,
  ControllingArea,
  CompanyCode,
  Plant,
  FunctionalArea,
  FactoryCalendar,
  virtual NmbrOfProjDmndServiceRequests : abap.int4 AS int4,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  WBSElementInternalID,
  WBSElementIsBillingElement,
  HierarchyNode,
  HierarchyParentNode,
  HierarchyDistanceFromRoot,
  HierarchyDescendantCount,
  HierarchyDrillState,
  HierarchyRank,
  HierarchyLevel,
  WBSIsStatisticalWBSElement,
  IsProjectMilestone
FROM I_EnterpriseProjectElementTP_2
LEFT OUTER JOIN I_EntProjElmntPurOrdAssgmt AS _PurOrder ON _PurOrder.ProjectElementUUID = ProjectElementUUID  -- association [0..*]
LEFT OUTER JOIN I_EntProjElmntSalesDocument AS _SalesOrder ON _SalesOrder.ProjectElementUUID = ProjectElementUUID  -- association [0..*]
LEFT OUTER JOIN I_EntProjElmntMaintOrder AS _MaintOrder ON _MaintOrder.ProjectElementUUID = ProjectElementUUID  -- association [0..*]
;

Learn More