I_PPM_ProjectSummaryTask

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_PPM_ProjectSummaryTask.
-- 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_PPM_ProjectSummaryTask AS
SELECT
  ProjectRoot.ProjectUUID AS ProjectUUID,
  SummaryTask.TaskUUID AS ProjectSummaryTaskUUID,
  ProjectRoot.ProjectCategory AS ProjectCategory,
  ProjectRoot.ProjectLastChangedByUser AS ProjectLastChangedByUser,
  ProjectRoot.ProjectLastChangedDateTime AS ProjectLastChangedDateTime,
  ProjectRoot.ProjectReasonCode AS ProjectReasonCode,
  ProjectRoot.MasterLanguage AS MasterLanguage,
  ProjectRoot.IsSummaryTaskEnabled AS IsSummaryTaskEnabled,
  ProjectRoot.ProjectLocation AS ProjectLocation,
  ProjectRoot.PlanVersion AS PlanVersion,
  ProjectRoot.OrganizationalUnitObjectType AS OrganizationalUnitObjectType,
  ProjectRoot.OrganizationalUnit AS OrganizationalUnit,
  ProjectRoot.ProjectEarliestOrLatest AS ProjectEarliestOrLatest,
  ProjectRoot.EntProjectIsConfidential AS EntProjectIsConfidential,
  ProjectRoot.EnterpriseProjectServiceOrg AS EnterpriseProjectServiceOrg,
  ProjectRoot.ProjectTemplateUUID AS ProjectTemplateUUID,
  ProjectRoot.ProjectInternalID AS ProjectInternalID,
  SummaryTask.WBSElementInternalID AS WBSElementInternalID,
  SummaryTask.TaskType AS ProjectType,
  SummaryTask.ExternalId AS Project,
  SummaryTask.TaskName AS ProjectName,
  SummaryTask.ReleaseDateTime AS ReleaseDateTime,
  SummaryTask.EarliestStartDateTime AS EarliestStartDateTime,
  SummaryTask.EarliestStartDate AS EarliestStartDate,
  SummaryTask.EarliestFinishDateTime AS EarliestFinishDateTime,
  SummaryTask.EarliestFinishDate AS EarliestFinishDate,
  SummaryTask.StartConstraintType AS StartConstraintType,
  SummaryTask.StartConstraintDateTime AS StartConstraintDateTime,
  SummaryTask.StartConstraintDate AS StartConstraintDate,
  SummaryTask.FinishConstraintType AS ProjectFinishConstraintType,
  SummaryTask.FinishConstraintDateTime AS FinishConstraintDateTime,
  SummaryTask.FinishConstraintDate AS FinishConstraintDate,
  SummaryTask.ActualStartDateTime AS ActualStartDateTime,
  SummaryTask.ActualStartDate AS ActualStartDate,
  SummaryTask.ActualFinishDateTime AS ActualFinishDateTime,
  SummaryTask.ActualFinishDate AS ActualFinishDate,
  SummaryTask.LatestStartDateTime AS LatestStartDateTime,
  SummaryTask.LatestStartDate AS LatestStartDate,
  SummaryTask.LatestFinishDateTime AS LatestFinishDateTime,
  SummaryTask.LatestFinishDate AS LatestFinishDate,
  SummaryTask.ProjectElementDuration AS ProjectElementDuration,
  SummaryTask.DurationUnit AS DurationUnit,
  SummaryTask.ProjectVersionNumber AS ProjectVersionNumber,
  SummaryTask.TaskProcessingStatus AS ProjectProcessingStatus,
  SummaryTask.PriorityCode AS PriorityCode,
  SummaryTask.CreatedByUser AS CreatedByUser,
  SummaryTask.CreationDateTime AS CreationDateTime,
  SummaryTask.LastChangedByUser AS LastChangedByUser,
  SummaryTask.LastChangeDateTime AS LastChangeDateTime,
  SummaryTask.EntProjIsMultiSlsOrdItmsEnbld AS EntProjIsMultiSlsOrdItmsEnbld,
  SummaryTask._CreatedByUser AS _CreatedByUser,
  SummaryTask._LastChangedByUser AS _LastChangedByUser,
  ProjectRoot._ProjectLastChangedByUser AS _ProjectLastChangedByUser,
  SummaryTask._Text AS _ProjectName,
  ProjectRoot._I_Project AS _I_Project,
  SummaryTask._Priority AS _Priority
FROM I_PPM_Task AS SummaryTask
INNER JOIN I_PPM_ProjectRoot AS ProjectRoot ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_AuthznByUsrH AS _AuthUser ON _AuthUser.ReferencedObjectUUID = ProjectSummaryTaskUUID 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 = ProjectSummaryTaskUUID 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 = ProjectSummaryTaskUUID 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 = ProjectSummaryTaskUUID AND _AuthGroup.UserID = $session.user AND ( _AuthGroup.Activity = 'Admin' OR _AuthGroup.Activity = 'Write' OR _AuthGroup.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _ProjObjRoot ON ( _ProjObjRoot.WBSElementInternalID = WBSElementInternalID )  -- association [0..1]
LEFT OUTER JOIN I_PPM_ProjectType AS _ProjectType ON ( _ProjectType.ProjectType = ProjectType )  -- association [0..1]
LEFT OUTER JOIN I_PPM_ProTypeText AS _ProjectTypeName ON ( _ProjectTypeName.ProjectType = ProjectType )  -- association [0..*]
LEFT OUTER JOIN I_PPM_Task AS _Task ON ( _Task.ProjectUUID = ProjectUUID ) AND ( ( _Task.ObjectType = 'TPO' ) OR( _Task.ObjectType = 'TTO' ) )  -- association [0..*]
LEFT OUTER JOIN I_PPM_Task AS _Phase ON ( _Phase.ProjectUUID = ProjectUUID ) AND ( _Phase.ObjectType = 'PPO' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_ItemInfo AS _Portfolio ON ( _Portfolio.ProjectUUID = ProjectUUID )  -- association [0..1]
;