I_EnterpriseProjectElementTP_2

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_EnterpriseProjectElementTP_2.
-- 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 I_EnterpriseProjectElementTP_2 AS
SELECT
  Workpackage.ProjectElementUUID AS ProjectElementUUID,
  Workpackage.ProjectElement AS ProjectElement,
  Workpackage.WBSElementInternalID AS WBSElementInternalID,
  Workpackage.ProjectUUID AS ProjectUUID,
  Workpackage.ProjectElementDescription AS ProjectElementDescription,
  Workpackage.ParentObjectUUID AS ParentObjectUUID,
  Workpackage.TaskTemplateUUID AS TaskTemplateUUID,
  Workpackage.ProjectElementOrdinalNumber AS ProjectElementOrdinalNumber,
  Workpackage.ProcessingStatus AS ProcessingStatus,
  Workpackage.IsProjectMilestone AS IsProjectMilestone,
  Workpackage.PlannedStartDate AS PlannedStartDate,
  Workpackage.PlannedEndDate AS PlannedEndDate,
  Workpackage.ActualStartDate AS ActualStartDate,
  Workpackage.ActualFinishDate AS ActualEndDate,
  Workpackage.ResponsibleCostCenter AS ResponsibleCostCenter,
  Workpackage.CompanyCode AS CompanyCode,
  Workpackage.ProfitCenter AS ProfitCenter,
  Workpackage.FunctionalArea AS FunctionalArea,
  Workpackage.ControllingArea AS ControllingArea,
  Workpackage.Plant AS Plant,
  Workpackage.Location AS Location,
  Workpackage.TaxJurisdiction AS TaxJurisdiction,
  Workpackage.FunctionalLocation AS FunctionalLocation,
  Workpackage.EntProjectElementType AS EntProjectElementType,
  Workpackage.FactoryCalendar AS FactoryCalendar,
  Workpackage.CostingSheet AS CostingSheet,
  Workpackage.InvestmentProfile AS InvestmentProfile,
  Workpackage.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  Workpackage.CostCenter AS CostCenter,
  Workpackage.WBSElementIsBillingElement AS WBSElementIsBillingElement,
  Workpackage.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  Workpackage.LeadingSalesOrder AS LeadingSalesOrder,
  Workpackage.LeadingSalesOrderItem AS LeadingSalesOrderItem,
  Workpackage.EntProjectElementObjectType AS EntProjectElementObjectType,
  Workpackage.CreatedByUser AS CreatedByUser,
  Workpackage.CreationDateTime AS CreationDateTime,
  Workpackage.LastChangedByUser AS LastChangedByUser,
  Workpackage.LastChangeDateTime AS LastChangeDateTime,
  Workpackage.MilestoneApprovalStatus AS MilestoneApprovalStatus,
  Workpackage.IsMainMilestone AS IsMainMilestone,
  cast('' as abap.char( 50 ) ) AS HierarchyNode,
  cast( '' as abap.sstring(1333) ) AS HierarchyParentNode,
  cast( 0 as abap.int4 ) AS HierarchyDistanceFromRoot,
  cast( 0 as abap.int4 ) AS HierarchyDescendantCount,
  cast( '' as abap.char(22) ) AS HierarchyDrillState,
  cast( 0 as hum_hierarchy_rank ) AS HierarchyRank,
  cast( 0 as abap.int4 ) AS HierarchyLevel,
  cast ( '' as boole_d preserving type ) AS EntProjElmntDmndCpyIsReqd,
  cast ( '' as boole_d preserving type ) AS EntProjElmntSettlmtCpyIsReqd,
  _EnterpriseProject.ProjectCategory AS ProjectCategory,
  _EnterpriseProject.EnterpriseProjectServiceOrg AS EnterpriseProjectServiceOrg
FROM R_EnterpriseProjectElement AS Workpackage
LEFT OUTER JOIN I_EnterpriseProjectElementTP_2 AS _ParentProjElement ON ParentObjectUUID = _ParentProjElement.ProjectElementUUID  -- association [0..1]
LEFT OUTER JOIN I_EnterpriseProjectElementTP_2 AS _SubProjElement ON ProjectElementUUID = _SubProjElement.ParentObjectUUID  -- association [1..*]
LEFT OUTER JOIN E_PPM_Task AS _ProjectElementExtension ON ProjectElementUUID = _ProjectElementExtension.TaskUUID  -- association [1..1]
LEFT OUTER JOIN E_PPM_EngagementProjElmnt AS _EngagementProjElmtExtension ON ProjectElementUUID = _EngagementProjElmtExtension.TaskUUID  -- association [1..1]
LEFT OUTER JOIN I_EntProjectElementJVATP_2 AS _EntProjectElementJVA ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_EntProjElmntPublicSectorTP_2 AS _EntProjectElmntPublicSector ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_EntProjElmntBlockFuncTP_2 AS _EntProjElmntBlkFunc ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_EntProjElmntLongDescTP AS _EntProjElmntLongDesc ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_EntProjElmntDlvbrlTP AS _EntProjElmntDlvbrl ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_EntProjElmntWorkItemTP AS _EntProjElmntWorkItem ON /* condition not available in parsed metadata */  -- association [0..*]
;