I_EnterpriseProjectElementTP

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.
-- 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 AS
SELECT
  Workpackage.TaskUUID AS ProjectElementUUID,
  Workpackage.Task AS ProjectElement,
  Workpackage.WBSElementInternalID AS WBSElementInternalID,
  Workpackage.ProjectUUID AS ProjectUUID,
  cast(TaskName as text40 ) AS ProjectElementDescription,
  HierarchyData.ParentObjectUUID AS ParentObjectUUID,
  Workpackage.ProcessingStatus AS ProcessingStatus,
  Workpackage.SortingNumber AS SortingNumber,
  Workpackage.IsProjectMilestone AS IsProjectMilestone,
  Workpackage.MilestoneApprovalStatus AS MilestoneApprovalStatus,
  Workpackage.IsMainMilestone AS IsMainMilestone,
  Workpackage.PlannedStartDate AS PlannedStartDate,
  Workpackage.PlannedEndDate AS PlannedEndDate,
  Workpackage.ActualStartDate AS ActualStartDate,
  Workpackage.ActualEndDate 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.FactoryCalendar AS FactoryCalendar,
  Workpackage.CostingSheet AS CostingSheet,
  Workpackage.InvestmentProfile AS InvestmentProfile,
  Workpackage.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  Workpackage.CostCenter AS CostCenter,
  Workpackage.WBSElementIsBillingElement AS WBSElementIsBillingElement,
  Workpackage.CreatedByUser AS CreatedByUser,
  Workpackage.CreationDateTime AS CreationDateTime,
  Workpackage.LastChangedByUser AS LastChangedByUser,
  Workpackage.LastChangeDateTime AS LastChangeDateTime,
  Project.LastChangeDateTime AS ProjectLastChangedDateTime,
  Workpackage._CompanyCode AS _CompanyCode,
  Workpackage._ControllingArea AS _ControllingArea,
  Workpackage._FunctionalArea AS _FunctionalArea,
  Workpackage._ProfitCenter AS _ProfitCenter,
  Workpackage._Plant AS _Plant,
  Workpackage._ResponsibleCostCenter AS _ResponsibleCostCenter,
  Workpackage._FactoryCalendar AS _FactoryCalendar,
  Workpackage._CostCenter AS _CostCenter
FROM I_PPM_ProjectTask AS Workpackage
INNER JOIN I_PPM_ProjectSummaryTask AS Project ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EnterpriseProjectElementTP AS _ParentProjElement ON ParentObjectUUID = _ParentProjElement.ProjectElementUUID  -- association [0..1]
LEFT OUTER JOIN I_EnterpriseProjectElementTP AS _SubProjElement ON ProjectElementUUID = _SubProjElement.ParentObjectUUID  -- association [1..*]
LEFT OUTER JOIN I_PPM_AuthznByUsrH AS _AuthUser ON _AuthUser.ReferencedObjectUUID = ProjectElementUUID AND _AuthUser.UserID = $session.user AND ( _AuthUser.Activity = 'Admin' OR _AuthUser.Activity = 'Write' OR _AuthUser.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznBySubstitH AS _AuthSubst ON _AuthSubst.ReferencedObjectUUID = ProjectElementUUID AND _AuthSubst.UserID = $session.user AND ( _AuthSubst.Activity = 'Admin' OR _AuthSubst.Activity = 'Write' OR _AuthSubst.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUserRoleH AS _AuthRole ON _AuthRole.ReferencedObjectUUID = ProjectElementUUID AND _AuthRole.UserID = $session.user AND ( _AuthRole.Activity = 'Admin' OR _AuthRole.Activity = 'Write' OR _AuthRole.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUsrGrpH AS _AuthGroup ON _AuthGroup.ReferencedObjectUUID = ProjectElementUUID AND _AuthGroup.UserID = $session.user AND ( _AuthGroup.Activity = 'Admin' OR _AuthGroup.Activity = 'Write' OR _AuthGroup.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN E_PPM_Task AS _ProjectElementExtension ON ProjectElementUUID = _ProjectElementExtension.TaskUUID  -- association [1..1]
LEFT OUTER JOIN I_EntProjectElementJVATP AS _EntProjectElementJVA ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_EntProjElmntPublicSectorTP AS _EntProjectElmntPublicSector ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_EntProjElmntBlockFuncTP AS _EntProjElmntBlkFunc ON /* condition not available in parsed metadata */  -- association [0..1]
;