C_WBSElmntVersGraphOverview

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_WBSElmntVersGraphOverview.
-- 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: CPROJWBSELMVOVW

CREATE VIEW C_WBSElmntVersGraphOverview AS
SELECT
  cast (ProjectWBSElement.WBSElementExternalID as ps_posid_edit ) AS WBSElementExternalID,
  Version,
  WBSElementInternalID,
  ProjectWBSElement.WBSDescription AS WBSDescription,
  cast ( ProjectWBSElement._ProjectType._Text[1:Language = $session.system_language].ProjectTypeName as ps_s4_pratx preserving type ) AS ProjectTypeName,
  cast ( ProjectWBSElement._PriorityCode._Text[1:Language = $session.system_language].PriorityCodeName as ps_s4_priotext preserving type ) AS PriorityCodeName,
  ProjectWBSElement.WBSElementObject AS WBSElementObject,
  ProjectWBSElement.ProjectInternalID AS ProjectInternalID,
  ProjectWBSElement.FreeDefinedTableFieldSemantic AS FreeDefinedTableFieldSemantic,
  _FieldKeyLabel.FreeDfndTableFieldSemanticName AS FreeDfndTableFieldSemanticName,
  ProjectWBSElement.ProjectType AS ProjectType,
  ProjectWBSElement.ControllingArea AS ControllingArea,
  ProjectWBSElement.RespCostCenterControllingArea AS RespCostCenterControllingArea,
  ProjectWBSElement.ProfitCenter AS ProfitCenter,
  ProjectWBSElement.IsMarkedForDeletion AS IsMarkedForDeletion,
  _ProfitCenter[1: ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date]._Text[1:Language = $session.system_language ].ProfitCenterName AS ProfitCenterName,
  ProjectWBSElement.Plant AS Plant,
  _Plant.PlantName AS PlantName,
  ProjectWBSElement.WBSElementHierarchyLevel AS WBSElementHierarchyLevel,
  ProjectWBSElement.ResponsiblePersonName AS ResponsiblePersonName,
  ProjectWBSElement.ApplicantName AS ApplicantName,
  cast ( ProjectWBSElement._ControllingObjectClass._Text[1:Language = $session.system_language].ControllingObjectClassName as ps_s4_scope_cvtext ) AS ControllingObjectClassName,
  cast ( ProjectWBSElement._ControllingArea.ControllingAreaName as ps_s4_bezei preserving type ) AS ControllingAreaName,
  cast ( ProjectWBSElement._CompanyCode.CompanyCodeName as ps_s4_butxt preserving type ) AS CompanyCodeName,
  cast ( ProjectWBSElement._BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName as fis_gtext preserving type ) AS BusinessAreaName,
  ProjectWBSElement.BasicStartDate AS BasicStartDate,
  ProjectWBSElement.BasicEndDate AS BasicEndDate,
  ProjectWBSElement.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  ProjectWBSElement.SchedldBasicEarliestEndDate AS SchedldBasicEarliestEndDate,
  ProjectWBSElement.SchedldBasicLatestStartDate AS SchedldBasicLatestStartDate,
  ProjectWBSElement.ScheduledBasicLatestEndDate AS ScheduledBasicLatestEndDate,
  ProjectWBSElement.ActualStartDate AS ActualStartDate,
  ProjectWBSElement.ActualEndDate AS ActualEndDate,
  ProjectWBSElement.BasicDuration AS BasicDuration,
  ProjectWBSElement.BasicDurationUnit AS BasicDurationUnit,
  ProjectWBSElement.TentativeActualStartDate AS TentativeActualStartDate,
  ProjectWBSElement.TentativeActualEndDate AS TentativeActualEndDate,
  ProjectWBSElement.ActualDuration AS ActualDuration,
  ProjectWBSElement.ActualDurationUnit AS ActualDurationUnit,
  ProjectWBSElement.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  ProjectWBSElement.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  ProjectWBSElement.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  ProjectWBSElement.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  ProjectWBSElement.WBSElementIsPlanningElement AS WBSElementIsPlanningElement,
  ProjectWBSElement.WBSIsAccountAssignmentElement AS WBSIsAccountAssignmentElement,
  ProjectWBSElement.WBSElementIsBillingElement AS WBSElementIsBillingElement,
  ProjectWBSElement.CostCenter AS CostCenter,
  ProjectWBSElement.ResponsibleCostCenter AS ResponsibleCostCenter,
  cast (_Project.ProjectExternalID as ps_pspid_edit preserving type) AS ProjectExternalID,
  _Project.ProjectDescription AS ProjectDescription,
  ProjectWBSElement.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  ProjectWBSElement.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  ProjectWBSElement.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  ProjectWBSElement.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  ProjectWBSElement.FreeDefinedQuantity1Unit AS FreeDefinedQuantity1Unit,
  ProjectWBSElement.FreeDefinedQuantity1 AS FreeDefinedQuantity1,
  ProjectWBSElement.FreeDefinedQuantity2Unit AS FreeDefinedQuantity2Unit,
  ProjectWBSElement.FreeDefinedQuantity2 AS FreeDefinedQuantity2,
  ProjectWBSElement.FreeDefinedAmount1Currency AS FreeDefinedAmount1Currency,
  cast ( ProjectWBSElement.FreeDefinedAmount1 as abap.curr( 13, 2 ) ) AS FreeDefinedAmount1,
  ProjectWBSElement.FreeDefinedAmount2Currency AS FreeDefinedAmount2Currency,
  cast ( ProjectWBSElement.FreeDefinedAmount2 as abap.curr( 13, 2 ) ) AS FreeDefinedAmount2,
  ProjectWBSElement.FreeDefinedDate1 AS FreeDefinedDate1,
  ProjectWBSElement.FreeDefinedDate2 AS FreeDefinedDate2,
  ProjectWBSElement.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  ProjectWBSElement.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  _FieldKeyLabel.FreeDefinedAttribute01Label AS FreeDefinedAttribute01Label,
  _FieldKeyLabel.FreeDefinedAttribute02Label AS FreeDefinedAttribute02Label,
  _FieldKeyLabel.FreeDefinedAttribute03Label AS FreeDefinedAttribute03Label,
  _FieldKeyLabel.FreeDefinedAttribute04Label AS FreeDefinedAttribute04Label,
  _FieldKeyLabel.FreeDefinedQuantity1Label AS FreeDefinedQuantity1Label,
  _FieldKeyLabel.FreeDefinedQuantity2Label AS FreeDefinedQuantity2Label,
  _FieldKeyLabel.FreeDefinedAmount1Label AS FreeDefinedAmount1Label,
  _FieldKeyLabel.FreeDefinedAmount2Label AS FreeDefinedAmount2Label,
  _FieldKeyLabel.FreeDefinedDate1Label AS FreeDefinedDate1Label,
  _FieldKeyLabel.FreeDefinedDate2Label AS FreeDefinedDate2Label,
  _FieldKeyLabel.FreeDefinedIndicator1Label AS FreeDefinedIndicator1Label,
  _FieldKeyLabel.FreeDefinedIndicator2Label AS FreeDefinedIndicator2Label
FROM I_WBSElementVersionData AS ProjectWBSElement
LEFT OUTER JOIN I_StsObjConcatActiveStsILL AS _Status ON _Status.StatusObject = WBSElementObject  -- association [0..1]
LEFT OUTER JOIN C_ProjectVersForNetworkGraph AS _Project ON _Project.ProjectInternalID = ProjectInternalID AND _Project.Version = Version  -- association [1..1]
LEFT OUTER JOIN I_FreeDfndTblFieldSemanticText AS _FieldKeyLabel ON FreeDefinedTableFieldSemantic = _FieldKeyLabel.FreeDefinedTableFieldSemantic AND _FieldKeyLabel.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProjectApplicant AS _ProjectApplicant ON ApplicantCode = _ProjectApplicant.ApplicantCode  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _ResponsibleCostCenter ON _ResponsibleCostCenter.CostCenter = ResponsibleCostCenter AND _ResponsibleCostCenter.ControllingArea = RespCostCenterControllingArea  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea  -- association [0..*]
;