R_ProjNetworkGraphOverviewTP

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 R_ProjNetworkGraphOverviewTP.
-- 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 R_ProjNetworkGraphOverviewTP AS
SELECT
  ProjectNetwork.ProjectNetwork AS ProjectNetwork,
  cast( '' as vsnmr_v ) AS Version,
  Hierarchy.ProjectObjectRootNode AS ProjectObjectRootNode,
  ProjectNetwork.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  ProjectNetwork.ProjectNetworkDescription AS ProjectNetworkDescription,
  ProjectNetwork.ProjectNetworkType AS ProjectNetworkType,
  cast( ProjectNetwork._OrderType._Text[1:Language = $session.system_language].OrderTypeName as ps_s4_auarttext preserving type) AS OrderTypeName,
  ProjectNetwork.ProjectNetworkObject AS ProjectNetworkObject,
  Hierarchy.ProjectObject AS ProjectObject,
  cast( ProjectNetwork.ProjectInternalID as ps_s4_pspnr preserving type) AS ProjectInternalID,
  cast( ProjectNetwork.WBSElementInternalID as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  ProjectNetwork.Plant AS Plant,
  ProjectNetwork.MRPController AS MRPController,
  ProjectNetwork.OrderCategory AS OrderCategory,
  ProjectNetwork._Plant.PlantName AS PlantName,
  cast( ProjectNetwork._PriorityCode._Text[1:Language = $session.system_language].PriorityCodeName as ps_s4_priotext preserving type ) AS PriorityCodeName,
  ProjectNetwork.SalesOrder AS SalesOrder,
  cast( ltrim(ProjectNetwork.SalesOrderItem, '0' ) as posnr_va) AS SalesOrderItem,
  cast( ProjectNetwork._ControllingArea.ControllingAreaName as ps_s4_bezei) AS ControllingAreaName,
  cast( ProjectNetwork._CompanyCode.CompanyCodeName as fac_co_code_name ) AS CompanyCodeName,
  cast( ProjectNetwork._BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName as fis_gtext preserving type ) AS BusinessAreaName,
  ProjectNetwork._ProfitCenter[1: ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date ]._Text[1: Language = $session.system_language ].ProfitCenterName as ProfitCenterName AS ProfitCenterNameasProfitCenterName,
  cast( ProjectNetwork.PlannedStartDate as ps_s4_pstrt) AS PlannedStartDate,
  cast( ProjectNetwork.PlannedEndDate as ps_s4_pende) AS PlannedEndDate,
  cast( ProjectNetwork.ScheduledBasicStartDate as ps_s4_gstrs) AS ScheduledBasicStartDate,
  cast( ProjectNetwork.ScheduledBasicEndDate as ps_s4_co_gltrs) AS ScheduledBasicEndDate,
  cast( ProjectNetwork.ActualStartDate as cgpl_actualstartdate) AS ActualStartDate,
  cast( ProjectNetwork.ActualEndDate as pshlp_actual_finish_de) AS ActualEndDate,
  ProjectNetwork.BasicSchedulingType AS BasicSchedulingType,
  ProjectNetwork.FcstSchedulingReductionLevel AS FcstSchedulingReductionLevel,
  ProjectNetwork.OrdIsNotSchedldAutomatically AS OrdIsNotSchedldAutomatically,
  ProjectNetwork.CapacityRqmtHasNotToBeCreated AS CapacityRqmtHasNotToBeCreated,
  ProjectNetwork.SchedulingIsAllowingForBreaks AS SchedulingIsAllowingForBreaks,
  ProjectNetwork.SuperiorProjectNetwork AS SuperiorProjectNetwork,
  ProjectNetwork.SuperiorProjectNetworkIntID AS SuperiorProjectNetworkIntID,
  ProjectNetwork.SuperiorNtwkActivityInternalID AS SuperiorNtwkActivityInternalID,
  _NetworkActivityByInternalKey.NetworkActivity AS SuperiorNtwkActivityExternalID,
  ProjectNetwork.IsMarkedForDeletion AS IsMarkedForDeletion,
  ProjectNetwork.ScheduledReleaseDate AS ScheduledReleaseDate,
  ProjectNetwork.CreationDate AS CreationDate,
  ProjectNetwork.CreatedByUser AS CreatedByUser,
  ProjectNetwork.LastChangeDate AS LastChangeDate,
  ProjectNetwork.ResponsibleCostCenter AS ResponsibleCostCenter,
  ProjectNetwork._Plant.FactoryCalendar AS FactoryCalendar,
  ProjectNetwork._MRPController.MRPControllerName AS ResponsiblePersonName,
  _Status.StatusProfile AS StatusProfile,
  _WBSElementData.WBSDescription AS WBSDescription,
  _Project.ProjectDescription AS ProjectDescription,
  ProjectNetwork.PriorityCode AS PriorityCode,
  ProjectNetwork.ControllingArea AS ControllingArea,
  ProjectNetwork.CompanyCode AS CompanyCode,
  ProjectNetwork.BusinessArea AS BusinessArea,
  ProjectNetwork.ProfitCenter AS ProfitCenter,
  ProjectNetwork.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive
FROM I_ProjectNetworkBasicData AS ProjectNetwork
INNER JOIN I_ProjectObjectHierNodeRltn AS Hierarchy ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_NtwkActivityGraphOverviewTP AS _NetworkActivity ON ProjectNetworkInternalID = _NetworkActivity.ProjectNetworkInternalID AND ProjectNetwork = _NetworkActivity.ProjectNetwork AND ProjectObjectRootNode = _NetworkActivity.ProjectObjectRootNode  -- association [1..*]
LEFT OUTER JOIN R_MilestoneGraphOverviewTP AS _Milestone ON ProjectNetwork = _Milestone.ProjectNetwork AND ProjectObjectRootNode = _Milestone.ProjectObjectRootNode  -- association [1..*]
LEFT OUTER JOIN R_ProjSchedMaintOrderGraphTP AS _MaintenanceOrder ON ProjectNetwork = _MaintenanceOrder.SuperiorProjectNetwork AND ProjectObjectRootNode = _MaintenanceOrder.ProjectObjectRootNode  -- association [1..*]
LEFT OUTER JOIN I_StsObjConcatActiveStsILL AS _Status ON ProjectNetworkObject = _Status.StatusObject  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityByInternalKey AS _NetworkActivityByInternalKey ON SuperiorProjectNetworkIntID = _NetworkActivityByInternalKey.ProjectNetworkInternalID AND SuperiorNtwkActivityInternalID = _NetworkActivityByInternalKey.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN I_WBSElementData_2 AS _WBSElementData ON WBSElementInternalID = _WBSElementData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN R_ProjectForNetworkGraphTP AS _Project ON ProjectInternalID = _Project.ProjectInternalID  -- association [1..1]
LEFT OUTER JOIN R_WBSElementForGraphTP AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
;