C_ProjectVersGraphOverview

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_ProjectVersGraphOverview.
-- 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: CPROJVGRAPHOV

CREATE VIEW C_ProjectVersGraphOverview AS
SELECT
  ProjectExternalID,
  Version,
  ProjectDescription,
  ControllingArea,
  Project,
  cast ( _ControllingArea.ControllingAreaName as ps_s4_bezei ) AS ControllingAreaName,
  cast(ProjectInternalID as ps_s4_proj_pspnr) AS ProjectInternalID,
  ProjectObject,
  PlanningMethForProjBasicDate,
  PlanningMethForProjFcstdDate,
  CompanyCode,
  cast ( _CompanyCode.CompanyCodeName as fac_co_code_name ) AS CompanyCodeName,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  ResponsiblePerson,
  ResponsiblePersonName,
  ApplicantCode,
  ApplicantName,
  ProjectProfileCode,
  cast( _ProjectProfileCode._Text[1: Language = $session.system_language ].ProjectProfileCodeText as ps_s4_profi_txt ) AS ProjectProfileCodeText,
  BusinessArea,
  cast ( _BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName as fis_busarea_name ) AS BusinessAreaName,
  ProfitCenter,
  _ProfitCenter[1: ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date ]._Text[1: Language = $session.system_language ].ProfitCenterName AS ProfitCenterName,
  Plant,
  _Plant.PlantName AS PlantName,
  CostCenter,
  ControllingObjectClass,
  cast( _ControllingObjectClass._Text[1: Language = $session.system_language ].ControllingObjectClassName as ps_s4_scope_cvtext ) AS ControllingObjectClassName,
  PlannedStartDate,
  PlannedEndDate,
  Currency,
  FactoryCalendar,
  NetworkProfile,
  cast( _NetworkProfile._Text[1: Language = $session.system_language ].NetworkProfileName as ps_s4_ntwk_profi_txt ) AS NetworkProfileName,
  ProjectHasOwnStock,
  WBSIsStatisticalWBSElement,
  cast ( TaxJurisdiction as ps_s4_txjcd) AS TaxJurisdiction,
  cast( _TaxJurisdiction._Text[1:Language = $session.system_language].TaxJurisdictionName as ps_s4_txjt preserving type ) AS TaxJurisdictionName,
  ProjInterestCalcProfile,
  cast ( _ProjInterestCalcProfile._Text[1: Language = $session.system_language ].ProjInterestCalcProfileName as ps_s4_zscht preserving type ) AS ProjInterestCalcProfileName,
  InvestmentProfile,
  BudgetProfile,
  PlanningProfile,
  FunctionalArea,
  cast ( _FunctionalArea._Text[1: Language = $session.system_language ].FunctionalAreaName as fac_funcnl_area_name ) AS FunctionalAreaName,
  cast ( _ProjBasicDatePlanMethName._Text[1: Language = $session.system_language ].ProjBasicDatePlanMethName as ps_s4_planbasic_val_text ) AS ProjBasicDatePlanMethName,
  cast ( _ProjFcstdDatePlanMethName._Text[1: Language = $session.system_language ].ProjBasicDatePlanMethName as ps_s4_planfcst_val_text ) AS ProjFcstdDatePlanMethName,
  SchedulingDurationUnit,
  WBSSchedulingProfile,
  _Wbsschedulingprofile._Text[1: Language = $session.system_language ].WBSSchedulingProfileName AS WBSSchedulingProfileName,
  cast(IsMarkedForDeletion as ps_s4_loevm) AS IsMarkedForDeletion,
  cast ( '' as wty_vetxt ) AS ProjectVersionDescription,
  FreeDefinedTableFieldSemantic,
  _FieldKeyLabel.FreeDfndTableFieldSemanticName AS FreeDfndTableFieldSemanticName,
  FreeDefinedAttribute01,
  FreeDefinedAttribute02,
  FreeDefinedAttribute03,
  FreeDefinedAttribute04,
  FreeDefinedQuantity1Unit,
  FreeDefinedQuantity1,
  FreeDefinedQuantity2Unit,
  FreeDefinedQuantity2,
  FreeDefinedAmount1Currency,
  cast ( FreeDefinedAmount1 as abap.curr( 13, 2 ) ) AS FreeDefinedAmount1,
  FreeDefinedAmount2Currency,
  cast ( FreeDefinedAmount2 as abap.curr( 13, 2 ) ) AS FreeDefinedAmount2,
  FreeDefinedDate1,
  FreeDefinedDate2,
  FreeDefinedIndicator1,
  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_ProjectVersionData
LEFT OUTER JOIN C_ProjNtwkVersGraphOverview AS _ProjectNetwork ON ProjectInternalID = _ProjectNetwork.ProjectInternalID AND _ProjectNetwork.Version = Version  -- association [0..*]
LEFT OUTER JOIN C_WBSElmntVersGraphOverview AS _WBSElement ON ProjectInternalID = _WBSElement.ProjectInternalID AND _WBSElement.Version = Version AND _WBSElement.WBSElementHierarchyLevel = 1  -- association [0..*]
LEFT OUTER JOIN I_StsObjConcatActiveStsILL AS _Status ON _Status.StatusObject = ProjectObject  -- association [0..1]
LEFT OUTER JOIN E_ProjectVersion AS _VersionExtension ON Version = _VersionExtension.Version AND Project = _VersionExtension.Project  -- 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_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea  -- association [1..*]
;