I_PPM_ProjectTaskTP

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_ProjectTaskTP.
-- 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: IPPMPROJTASKTP

CREATE VIEW I_PPM_ProjectTaskTP AS
SELECT
  TaskUUID,
  ExternalId,
  Task,
  ProjectInternalID,
  WBSElementInternalID,
  ProjectUUID,
  TaskTemplateUUID,
  MilestoneName,
  TaskName,
  PlannedStartDate,
  PlannedEndDate,
  ActualStartDate,
  ActualEndDate,
  IsMainMilestone,
  TaskType,
  ProcessingStatus,
  MilestoneApprovalStatus,
  EntProjIsMultiSlsOrdItmsEnbld,
  IsProjectMilestone,
  WBSElement,
  WBSDescription,
  CompanyCode,
  ControllingArea,
  FunctionalArea,
  ProfitCenter,
  ResponsibleCostCenter,
  Plant,
  Location,
  FactoryCalendar,
  CostingSheet,
  CostCenter,
  InvestmentProfile,
  WBSIsStatisticalWBSElement,
  ParentObjectUUID,
  SortingNumber,
  ActiveTaskUUID,
  cast ( '' as boole_d preserving type ) AS EntProjElmntDmndCpyIsReqd,
  cast ( '' as boole_d preserving type ) AS EntProjElmntSettlmtCpyIsReqd,
  TaxJurisdiction,
  FunctionalLocation,
  WBSElementIsBillingElement,
  EntProjectSettlementElement,
  EntProjIsSettlmtRuleInherited,
  ResultAnalysisInternalID,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_PPM_ProjectTask
LEFT OUTER JOIN I_PPM_ProjectTP AS _Root ON ProjectUUID = _Root.ProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_PPM_ProjectTaskJVATP AS _JointVentureAccounting ON TaskUUID = _JointVentureAccounting.TaskUUID  -- association [1..1]
LEFT OUTER JOIN I_PPM_ProjTaskPublicSectorTP AS _PublicSector ON TaskUUID = _PublicSector.TaskUUID  -- association [1..1]
LEFT OUTER JOIN I_EntProjElmntBlockFuncTP AS _BlockFunc ON TaskUUID = _BlockFunc.TaskUUID  -- association [0..1]
LEFT OUTER JOIN I_EntProjElmntLongTextTP AS _LongText ON TaskUUID = _LongText.TaskUUID  -- association [1..1]
LEFT OUTER JOIN E_PPM_Task AS _ProjectBriefTaskExtension ON TaskUUID = _ProjectBriefTaskExtension.TaskUUID  -- association [1..1]
;