I_PPM_ProjectTask

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_ProjectTask.
-- 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: IPPMPROJTASK

CREATE VIEW I_PPM_ProjectTask AS
SELECT
  Task.TaskUUID AS TaskUUID,
  Task.ExternalId AS ExternalId,
  Task.ExternalId AS Task,
  Task.ProjectUUID AS ProjectUUID,
  Task.ProjectInternalID AS ProjectInternalID,
  cast ( Task.WBSElementInternalID as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  Task.TaskName AS MilestoneName,
  Task.TaskName AS TaskName,
  Task.TaskType AS TaskType,
  Task.TaskProcessingStatus AS ProcessingStatus,
  Task.ObjectType AS ObjectType,
  Task.SortingNumber AS SortingNumber,
  Task.TaskTemplateUUID AS TaskTemplateUUID,
  Task.EntProjIsMultiSlsOrdItmsEnbld AS EntProjIsMultiSlsOrdItmsEnbld,
  HierarchyData.ParentObjectUUID AS ParentObjectUUID,
  WBSElemBasicData.WBSElement AS WBSElement,
  WBSElemBasicData.WBSDescription AS WBSDescription,
  WBSElemBasicData.CompanyCode AS CompanyCode,
  WBSElemBasicData.ControllingArea AS ControllingArea,
  WBSElemBasicData.FunctionalArea AS FunctionalArea,
  WBSElemBasicData.ProfitCenter AS ProfitCenter,
  WBSElemBasicData.ResponsibleCostCenter AS ResponsibleCostCenter,
  WBSElemBasicData.Plant AS Plant,
  WBSElemBasicData.FactoryCalendar AS FactoryCalendar,
  WBSElemBasicData.CostingSheet AS CostingSheet,
  WBSElemBasicData.CostCenter AS CostCenter,
  WBSElemBasicData.InvestmentProfile AS InvestmentProfile,
  WBSElemBasicData.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  WBSElemBasicData.Location AS Location,
  WBSElemBasicData.TaxJurisdiction AS TaxJurisdiction,
  WBSElemBasicData.FunctionalLocation AS FunctionalLocation,
  WBSElemBasicData.WBSElementIsBillingElement AS WBSElementIsBillingElement,
  WBSElemBasicData.EntProjectSettlementElement AS EntProjectSettlementElement,
  WBSElemBasicData.EntProjIsSettlmtRuleInherited AS EntProjIsSettlmtRuleInherited,
  WBSElemBasicData.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  LatestStartDate AS PlannedStartDate,
  LatestFinishDate AS PlannedEndDate,
  ActualStartDate,
  ActualFinishDate AS ActualEndDate,
  Task.MilestoneApprovalStatus AS MilestoneApprovalStatus,
  tasktype.IsEssentialMilestone AS IsMainMilestone,
  Task.IsProjectMilestone AS IsProjectMilestone,
  Task.TaskUUID AS ActiveTaskUUID,
  Task.CreatedByUser AS CreatedByUser,
  Task.CreationDateTime AS CreationDateTime,
  Task.LastChangedByUser AS LastChangedByUser,
  Task.LastChangeDateTime AS LastChangeDateTime
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_WBSElementBasicData AS WBSElemBasicData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_StdTaskHierarchyData AS HierarchyData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementBasicData AS _ProjObjRoot ON ( _ProjObjRoot.WBSElementInternalID = WBSElementInternalID )  -- association [0..1]
LEFT OUTER JOIN I_PPM_Project AS _Root ON ProjectUUID = _Root.ProjectUUID  -- association [1..1]
;