C_ProjectWithVersion

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_ProjectWithVersion.
-- 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: CPROJWITHVERS

CREATE VIEW C_ProjectWithVersion AS
SELECT
  I_ProjectWithVersion.ProjectWithCodingMask AS Project,
  I_ProjectWithVersion.Version AS Version,
  cast(I_ProjectWithVersion.IsMarkedForDeletion as ps_s4_loevm) AS IsMarkedForDeletion,
  I_ProjectWithVersion.ControllingArea AS ControllingArea,
  cast ( I_ProjectWithVersion._ControllingArea.ControllingAreaName as ps_s4_bezei ) AS ControllingAreaName,
  I_ProjectWithVersion.ProjectInternalID AS ProjectInternalID,
  I_ProjectWithVersion.ProjectObject AS ProjectObject,
  I_ProjectWithVersion.PlanningMethForProjBasicDate AS PlanningMethForProjBasicDate,
  I_ProjectWithVersion.PlanningMethForProjFcstdDate AS PlanningMethForProjFcstdDate,
  I_ProjectWithVersion.CompanyCode AS CompanyCode,
  cast ( I_ProjectWithVersion._CompanyCode.CompanyCodeName as fac_co_code_name ) AS CompanyCodeName,
  I_ProjectWithVersion.CreatedByUser AS CreatedByUser,
  I_ProjectWithVersion.CreationDate AS CreationDate,
  I_ProjectWithVersion.LastChangedByUser AS LastChangedByUser,
  I_ProjectWithVersion.LastChangeDate AS LastChangeDate,
  I_ProjectWithVersion.ResponsiblePerson AS ResponsiblePerson,
  I_ProjectWithVersion.ResponsiblePersonName AS ResponsiblePersonName,
  I_ProjectWithVersion.ApplicantCode AS ApplicantCode,
  I_ProjectWithVersion.ApplicantName AS ApplicantName,
  I_ProjectWithVersion.ProjectProfileCode AS ProjectProfileCode,
  cast( I_ProjectWithVersion._ProjectProfileCode._Text[1: Language = $session.system_language ].ProjectProfileCodeText as ps_s4_profi_txt ) AS ProjectProfileCodeText,
  I_ProjectWithVersion.BusinessArea AS BusinessArea,
  cast ( I_ProjectWithVersion._BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName as fis_busarea_name ) AS BusinessAreaName,
  I_ProjectWithVersion.ProfitCenter AS ProfitCenter,
  I_ProjectWithVersion._ProfitCenter[1: ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date ]._Text[1: Language = $session.system_language ].ProfitCenterName AS ProfitCenterName,
  I_ProjectWithVersion.Plant AS Plant,
  I_ProjectWithVersion._Plant.PlantName AS PlantName,
  I_ProjectWithVersion.CostCenter AS CostCenter,
  I_ProjectWithVersion._CostCenter._Text.CostCenterName AS CostCenterName,
  I_ProjectWithVersion.ControllingObjectClass AS ControllingObjectClass,
  cast( I_ProjectWithVersion._ControllingObjectClass._Text[1: Language = $session.system_language ].ControllingObjectClassName as ps_s4_scope_cvtext ) AS ControllingObjectClassName,
  I_ProjectWithVersion.PlannedStartDate AS PlannedStartDate,
  I_ProjectWithVersion.PlannedEndDate AS PlannedEndDate,
  I_ProjectWithVersion.Currency AS Currency,
  I_ProjectWithVersion.FactoryCalendar AS FactoryCalendar,
  I_ProjectWithVersion.NetworkProfile AS NetworkProfile,
  cast( I_ProjectWithVersion._NetworkProfile._Text[1: Language = $session.system_language ].NetworkProfileName as ps_s4_ntwk_profi_txt ) AS NetworkProfileName,
  I_ProjectWithVersion.ProjectHasOwnStock AS ProjectHasOwnStock,
  I_ProjectWithVersion.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  cast (I_ProjectWithVersion.TaxJurisdiction as ps_s4_txjcd) AS TaxJurisdiction,
  cast( I_ProjectWithVersion._TaxJurisdiction._Text[1:Language = $session.system_language].TaxJurisdictionName as ps_s4_txjt preserving type ) AS TaxJurisdictionName,
  I_ProjectWithVersion.ProjInterestCalcProfile AS ProjInterestCalcProfile,
  cast ( I_ProjectWithVersion._ProjInterestCalcProfile._Text[1: Language = $session.system_language ].ProjInterestCalcProfileName as ps_s4_zscht preserving type ) AS ProjInterestCalcProfileName,
  I_ProjectWithVersion.InvestmentProfile AS InvestmentProfile,
  I_ProjectWithVersion.BudgetProfile AS BudgetProfile,
  I_ProjectWithVersion.PlanningProfile AS PlanningProfile,
  I_ProjectWithVersion.FunctionalArea AS FunctionalArea,
  cast ( I_ProjectWithVersion._FunctionalArea._Text[1: Language = $session.system_language ].FunctionalAreaName as fac_funcnl_area_name ) AS FunctionalAreaName,
  cast ( I_ProjectWithVersion._ProjBasicDatePlanMethName._Text[1: Language = $session.system_language ].ProjBasicDatePlanMethName as ps_s4_planbasic_val_text ) AS ProjBasicDatePlanMethName,
  cast ( I_ProjectWithVersion._ProjFcstdDatePlanMethName._Text[1: Language = $session.system_language ].ProjBasicDatePlanMethName as ps_s4_planfcst_val_text ) AS ProjFcstdDatePlanMethName,
  I_ProjectWithVersion.SchedulingDurationUnit AS SchedulingDurationUnit,
  I_ProjectWithVersion.WBSSchedulingProfile AS WBSSchedulingProfile,
  I_ProjectWithVersion._Wbsschedulingprofile._Text[1: Language = $session.system_language ].WBSSchedulingProfileName AS WBSSchedulingProfileName,
  cast ( _ProjectVersionHeader.ProjectVersionDescription as wty_vetxt ) AS ProjectVersionDescription,
  _ProjectVersionHeader.ProjectVersionGroupName AS ProjectVersionGroupName,
  FreeDefinedTableFieldSemantic,
  FreeDefinedAttribute01,
  FreeDefinedAttribute02,
  FreeDefinedAttribute03,
  FreeDefinedAttribute04,
  FreeDefinedQuantity1Unit,
  FreeDefinedQuantity1,
  FreeDefinedQuantity2Unit,
  FreeDefinedQuantity2,
  FreeDefinedAmount1Currency,
  cast ( cast ( FreeDefinedAmount1 * 10 as abap.curr(14,2) ) as ps_s4_usr06proj ) AS FreeDefinedAmount1,
  FreeDefinedAmount2Currency,
  cast ( cast ( FreeDefinedAmount2 * 10 as abap.curr(14,2) ) as ps_s4_usr07proj ) AS FreeDefinedAmount2,
  FreeDefinedDate1,
  FreeDefinedDate2,
  FreeDefinedIndicator1,
  FreeDefinedIndicator2,
  ObjBasedAuthorizationIsActive,
  _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,
  I_ProjectWithVersion._ResponsiblePerson AS _ResponsiblePerson,
  I_ProjectWithVersion._ProjectApplicant AS _ProjectApplicant
FROM I_ProjectWithVersion
LEFT OUTER JOIN C_ProjectNetworkBasicInfo AS _ProjectNetwork ON ProjectInternalID = _ProjectNetwork.ProjectInternalID AND Version = _ProjectNetwork.Version  -- association [0..*]
LEFT OUTER JOIN C_WBSElementBasicInfo AS _WBSElement ON ProjectInternalID = _WBSElement.ProjectInternalID AND Version = _WBSElement.Version AND _WBSElement.WBSElementHierarchyLevel = 1  -- association [0..*]
LEFT OUTER JOIN C_ProjectStsObjActiveSts AS _Status ON _Status.StatusObject = ProjectObject  -- association [0..*]
LEFT OUTER JOIN C_ObjectBasedAuthorizationList AS _ObjBsdAuthzn ON ProjectObject = _ObjBsdAuthzn.ProjectObject  -- association [0..*]
LEFT OUTER JOIN I_UserAccByObjBsdAuthzn AS _UsrByObjBsdAuthzn ON ProjectObject = _UsrByObjBsdAuthzn.ProjectObject AND _UsrByObjBsdAuthzn.ObjectBasedAuthorizationUser = $session.user AND _UsrByObjBsdAuthzn.AuthorizationTypeValue > 1  -- association [0..1]
LEFT OUTER JOIN I_ProjectValueHelp AS _ProjectValueHelp ON Project = _ProjectValueHelp.Project  -- association [0..1]
LEFT OUTER JOIN I_ProjectWithCodingMaskVH AS _ProjectWithCodingMaskVH ON _ProjectWithCodingMaskVH.Project = Project  -- association [0..1]
LEFT OUTER JOIN I_ProjectVersionVH AS _ProjectVersionVH ON Project = _ProjectVersionVH.ProjectObjectExternalID AND Version = _ProjectVersionVH.Version AND _ProjectVersionVH.ObjectType = 'PD'  -- association [0..1]
LEFT OUTER JOIN I_ProjectVersionHeader AS _ProjectVersionHeader ON Project = _ProjectVersionHeader.Project AND Version = _ProjectVersionHeader.Version  -- association [0..1]
LEFT OUTER JOIN I_FreeDfndTblFieldSemanticText AS _FieldKeyLabel ON FreeDefinedTableFieldSemantic = _FieldKeyLabel.FreeDefinedTableFieldSemantic AND _FieldKeyLabel.Language = $session.system_language  -- association [0..1]
;