C_ProjectNetworkGraphOverview

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 C_ProjectNetworkGraphOverview.
-- 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: CPROJNTWKGROVW

CREATE VIEW C_ProjectNetworkGraphOverview AS
SELECT
  ProjectNetwork,
  cast( '' as vsnmr_v ) AS Version,
  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,
  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,
  SuperiorProjectNetwork,
  SuperiorProjectNetworkIntID,
  SuperiorNtwkActivityInternalID,
  _NetworkActivityByInternalKey.NetworkActivity AS SuperiorNtwkActivityExternalID,
  ProjectNetwork.IsMarkedForDeletion AS IsMarkedForDeletion,
  ScheduledReleaseDate,
  case when _WBSElementData._WBSElementShortText.LanguageBasedShortText is not initial then _WBSElementData._WBSElementShortText.LanguageBasedShortText else _WBSElementData.WBSDescription end as WBSDescription AS WBSDescriptionendasWBSDescription,
  _Project.ProjectDescription AS ProjectDescription
FROM I_ProjectNetworkBasicData AS ProjectNetwork
LEFT OUTER JOIN I_StsObjConcatActiveStsILL AS _Status ON ProjectNetworkObject = _Status.StatusObject  -- association [0..1]
LEFT OUTER JOIN C_ProjectForNetworkGraph AS _Project ON ProjectInternalID = _Project.ProjectInternalID  -- association [1..1]
LEFT OUTER JOIN C_WBSElementForGraph AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- 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]
;