I_PPM_ProjectElementProgress

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_ProjectElementProgress.
-- 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: IPPMPROJELEMPROG

CREATE VIEW I_PPM_ProjectElementProgress AS
SELECT
  Task.TaskUUID AS TaskUUID,
  Task.ProjectUUID AS ProjectUUID,
  Task.ObjectType AS ObjectType,
  Task.TaskType AS TaskType,
  Hierarchy.ParentObjectUUID AS ParentObjectUUID,
  Hierarchy.OrdinalNumber AS OrdinalNumber,
  Hierarchy.HierarchyNodeLevel AS HierarchyNodeLevel,
  TaskText.ObjectName AS ObjectName,
  cast(Task.IsProjectMilestone as boolean) AS IsProjectMilestone,
  cast(Task.IsSummaryTask as boolean) AS IsSummaryTask,
  Task.FactoryCalendar AS FactoryCalendar,
  Task.TaskProcessingStatus AS ProcessingStatus,
  Task._ProcessingStatus._Text[1:Language=$session.system_language].ProcessingStatusText AS ProcessingStatusText,
  Task.StartConstraintType AS StartConstraintType,
  Task.FinishConstraintType AS FinishConstraintType,
  Task.LatestStartDate AS LatestStartDateTime,
  Task.LatestFinishDate AS LatestFinishDateTime,
  Task.ActualFinishDate AS ActualFinishDateTime,
  Tasktype.IsEssentialMilestone AS IsMainMilestone,
  Task.ProjectElementDuration AS ProjectElementDuration,
  Task.DurationUnit AS DurationUnit,
  Task.PercentageOfCompletion AS PercentageOfCompletion,
  Task.RemainingWorkQuantityInSeconds AS RemainingWorkQuantityInSeconds,
  case when Task.ObjectType <> 'DPO' and Task.ObjectType <> 'PPO' and Task.TaskProcessingStatus <> '40' and Task.TaskProcessingStatus <> '41' and Task.TaskProcessingStatus <> '42' then cast(unit_conversion( quantity => Task.RemainingWorkQuantityInSeconds, source_unit => cast( 'S' as abap.unit(3) ), target_unit => Task.RemainingWorkExtQuantityUnit, error_handling => 'KEEP_UNCONVERTED') as abap.dec( 15, 2 ) ) else cast(0 as abap.dec( 15, 2 ) ) end as RemainingWorkQuantity AS dec152endasRemainingWorkQuantity,
  Task.RemainingWorkExtQuantityUnit AS RemainingWorkExtQuantityUnit,
  Task._RemainingWorkExtQuantityUnit._Text[1:Language=$session.system_language].UnitOfMeasureName AS RemainingWorkQuantityUnitName,
  Task.CreatedByUser AS CreatedByUser,
  Task.CreationDateTime AS CreationDateTime,
  Task.LastChangedByUser AS LastChangedByUser,
  Task.LastChangeDateTime AS LastChangeDateTime,
  Task._Severity.CriticalityCode AS CriticalityCode,
  Task._Severity.SeverityText AS SeverityText,
  Task.WBSElementInternalID AS WBSElementInternalID,
  _ResponsibleBP.BusinessPartnerUUID AS BusinessPartnerUUID,
  _ResponsibleBP.BusinessPartnerName AS BusinessPartnerName,
  _ResponsibleBP.ProjectRoleUUID AS ProjectRoleUUID,
  _ResponsibleBP.EmailAddress AS EmailAddress,
  _ResponsibleBP.MobilePhoneNumber AS MobilePhoneNumber,
  _ResponsibleBP.AddressPhoneNumber AS AddressPhoneNumber,
  _ResponsibleBP.ProjectRoleName AS ProjectRoleName,
  _GlobalSetting.EPPMSettingsDefaultValue AS EPPMSettingsDefaultValue,
  _ResponsibleBP._BusinessUser AS _BusinessUser
FROM I_PPM_Task AS Task
LEFT OUTER JOIN I_PPM_Tasktype AS Tasktype ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EnterpriseProjElmntHier AS Hierarchy ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_TaskText AS TaskText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EPPMGlobalSetting AS _GlobalSetting ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_SingleResponsibleForObj AS _ResponsibleBP ON _ResponsibleBP.ReferencedObjectUUID = TaskUUID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _ProjObjRoot ON ( _ProjObjRoot.WBSElementInternalID = WBSElementInternalID )  -- association [0..1]
LEFT OUTER JOIN I_PPM_Project AS _Project ON _Project.ProjectUUID = Task.ProjectUUID  -- association [0..1]
;