I_EnterpriseProjectElement

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_EnterpriseProjectElement.
-- 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_EnterpriseProjectElement AS
SELECT
  task.guid AS ProjectElementUUID,
  cast ( task.external_id as /s4ppm/project_ele_id preserving type ) AS ProjectElement,
  task.project_guid AS ProjectUUID,
  task.name AS ProjectElementDescription,
  task.proc_status_own AS ProcessingStatus,
  task.latest_start_date AS PlannedStartDate,
  task.latest_finish_date AS PlannedEndDate,
  task.actualstart_date AS ActualStartDate,
  task.actualfinish_date AS ActualFinishDate,
  task.sort_number AS SortingNumber,
  task.task_type AS EntProjectElementType,
  task.milestone AS IsProjectMilestone,
  prps.txjcd AS TaxJurisdiction,
  prps.tplnr AS FunctionalLocation,
  prps.fakkz AS WBSElementIsBillingElement,
  cast ( task.pspnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  cast ( prps.psphi as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
  cast ( hiera.up as /s4ppm/tv_parent_entity_guid preserving type ) AS ParentObjectUUID,
  cast (hiera.sort_number as /s4ppm/tv_sort_number preserving type ) AS ProjectElementOrdinalNumber,
  prps.xstat AS WBSIsStatisticalWBSElement,
  prps.pbukr AS CompanyCode,
  prps.pkokr AS ControllingArea,
  prps.kostl AS CostCenter,
  prps.kalsm AS CostingSheet,
  prps.fabkl AS FactoryCalendar,
  prps.func_area AS FunctionalArea,
  prps.imprf AS InvestmentProfile,
  prps.stort AS Location,
  prps.werks AS Plant,
  prps.prctr AS ProfitCenter,
  prps.fkstl AS ResponsibleCostCenter,
  prps.abgsl AS ResultAnalysisInternalID,
  prps.vbeln_prps AS LeadingSalesOrder,
  prps.posnr_prps AS LeadingSalesOrderItem,
  task.created_by AS CreatedByUser,
  task.created_on AS CreationDateTime,
  task.changed_by AS LastChangedByUser,
  task.changed_on AS LastChangeDateTime,
  hiera.guid AS HierarchyNodeUUID
FROM /s4ppm/task AS task
LEFT OUTER JOIN I_EnterpriseProject AS _Project ON _Project.ProjectUUID = ProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_EntProjElmntDlvbrl AS _EntProjElmntDlvbrl ON _EntProjElmntDlvbrl.ProjectElementUUID = ProjectElementUUID  -- association [1..*]
LEFT OUTER JOIN E_PPM_Task AS _ProjectElementExtension ON ProjectElementUUID = _ProjectElementExtension.TaskUUID  -- association [1..1]
LEFT OUTER JOIN E_PPM_EngagementProjElmnt AS _EngagementProjElmtExtension ON ProjectElementUUID = _EngagementProjElmtExtension.TaskUUID  -- association [1..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 I_EnterpriseProjectForUser AS _EnterpriseProjectForUser ON _EnterpriseProjectForUser.ProjectUUID = ProjectUUID  -- association [0..1]
;