C_PPM_ProjectControlTP

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_PPM_ProjectControlTP.
-- 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 C_PPM_ProjectControlTP AS
SELECT
  ProjectUUID,
  ProjectSummaryTaskUUID,
  ProjectInternalID,
  WBSElementInternalID,
  ProjectTemplateUUID,
  cast( Project as cats_cpr_extid preserving type) AS Project,
  ProjectName,
  _TaskText.ObjectNameMasterLanguage AS ProjectNameMasterLanguage,
  Project.ProjectProfileCode AS ProjectProfileCode,
  Project.EntProjIsMultiSlsOrdItmsEnbld AS EntProjIsMultiSlsOrdItmsEnbld,
  _ProjectProfileVH.ProjectProfileCodeText AS ProjectProfileCodeText,
  _I_Project.ProjectObject AS ProjectObject,
  _ProjObjRoot.WBSElementObject AS WBSElementObject,
  _ProjObjRoot.LeadingSalesOrder AS LeadingSalesOrder,
  _ProjObjRoot.LeadingSalesOrderItem AS LeadingSalesOrderItem,
  ResultAnalysisInternalID,
  _RsltAnlysKeyText[1:Language = $session.system_language].ResultAnalysisDescription AS ResultAnalysisDescription,
  ProcessingStatus,
  _ProcessingStatusText[1:Language = $session.system_language].ProcessingStatusText AS ProcessingStatusText,
  _PriorityText[1:LanguageCode = $session.system_language].PriorityCodeName AS PriorityCodeName,
  EnterpriseProjectType,
  _EnterpriseProjectTypeText[1:Language = $session.system_language].ProjectTypeName AS ProjectTypeName,
  EntProjectSettlementType,
  _EntProjectSettlementTypeText[1:Language = $session.system_language].SettlementTypeText AS SettlementTypeText,
  EntProjectSettlementElement,
  cast(ProjectStartDate as dpr_tv_planstartdate preserving type) AS ProjectStartDate,
  cast(ProjectEndDate as dpr_tv_planfinishdate preserving type) AS ProjectEndDate,
  FactoryCalendar,
  _FactoryCalendarVH._Text[1: Language = $session.system_language].FactoryCalendarName AS FactoryCalendarName,
  cast(ActualStartDate as dpr_tv_actual_start preserving type) AS ActualStartDate,
  cast(ActualEndDate as dpr_tv_actual_finish preserving type) AS ActualEndDate,
  cast(' ' as abap.char(2) ) AS EntProjectDataModelVersion,
  ResponsibleCostCenter,
  _ResponsibleCostCenterVH._Text[1: Language = $session.system_language].CostCenterName AS ResponsibleCostCenterName,
  ProfitCenter,
  _ProfitCenterVH._Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  _ControllingArea.ControllingAreaCurrency AS ControllingAreaCurrency,
  cast( CompanyCode as bukrs preserving type ) AS CompanyCode,
  _CompanyCodeVH.CompanyCodeName AS CompanyCodeName,
  Plant,
  _PlantVH.PlantName AS PlantName,
  Location,
  TaxJurisdiction,
  _TaxJurisdictionVH.TaxJurisdictionName AS TaxJurisdictionName,
  _TaxJurisdictionVH.Country AS Country,
  FunctionalLocation,
  _FunctionalLocationVH._FunctionalLocationText[1: Language = $session.system_language].FunctionalLocationName AS FunctionalLocationName,
  _LocationVH.LocationName AS LocationName,
  FunctionalArea,
  ProjectCurrency,
  _FunctionalAreaVH.FunctionalAreaName AS FunctionalAreaName
FROM I_PPM_ProjectTP AS Project
LEFT OUTER JOIN I_PPM_TaskText AS _TaskText ON _TaskText.TaskUUID = Project.ProjectSummaryTaskUUID  -- association [0..1]
LEFT OUTER JOIN C_PPM_ProjectProfileVH AS _ProjectProfileVH ON _ProjectProfileVH.ProjectProfileCode = ProjectProfileCode  -- association [0..1]
LEFT OUTER JOIN I_CostCenterStdVH AS _ResponsibleCostCenterVH ON _ResponsibleCostCenterVH.CostCenter = ResponsibleCostCenter AND _ResponsibleCostCenterVH.ControllingArea = ControllingArea AND _ResponsibleCostCenterVH.ValidityEndDate > $session.system_date AND _ResponsibleCostCenterVH.ValidityStartDate < $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterStdVH AS _ProfitCenterVH ON _ProfitCenterVH.ProfitCenter = ProfitCenter AND _ProfitCenterVH.ControllingArea = ControllingArea AND _ProfitCenterVH.ValidityEndDate > $session.system_date AND _ProfitCenterVH.ValidityStartDate < $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_CompanyCodeStdVH AS _CompanyCodeVH ON _CompanyCodeVH.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_PlantVH AS _PlantVH ON _PlantVH.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN C_PPM_ProjectElementLocationVH AS _LocationVH ON _LocationVH.Plant = Plant AND _LocationVH.Location = Location  -- association [0..1]
LEFT OUTER JOIN C_MM_FunctionalAreaValueHelp AS _FunctionalAreaVH ON _FunctionalAreaVH.FunctionalArea = FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_InvestmentProfile AS _InvestmentProfVH ON _InvestmentProfVH.InvestmentProfile = InvestmentProfile  -- association [0..1]
LEFT OUTER JOIN I_CostingSheetProcedure AS _CostingSheetProcedureVH ON _CostingSheetProcedureVH.CostingSheetProcedure = CostingSheet  -- association [0..*]
LEFT OUTER JOIN I_CostCenterStdVH AS _CostCenterVH ON _CostCenterVH.CostCenter = CostCenter AND _CostCenterVH.ControllingArea = ControllingArea AND _CostCenterVH.ValidityEndDate > $session.system_date AND _CostCenterVH.ValidityStartDate < $session.system_date  -- association [0..1]
LEFT OUTER JOIN C_PPM_ProjectMemberContactCard AS _Manager ON _Manager.BusinessPartnerUUID = ProjectManagerUUID  -- association [0..1]
LEFT OUTER JOIN C_FactoryCalendarValueHelp AS _FactoryCalendarVH ON _FactoryCalendarVH.FactoryCalendar = FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON _CreatedByUser.ContactCardID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN C_EnterpriseProjectVH AS _ProjectVH ON _ProjectVH.Project = Project  -- association [0..1]
LEFT OUTER JOIN C_PPM_ProjectManagerTP AS _TeamMemberRoleStaffing ON _TeamMemberRoleStaffing.ProjectUUID = ProjectUUID  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON _FixedAsset.InvestmentProjectWBSElement = WBSElementInternalID AND WBSElementInternalID <> '00000000' AND _FixedAsset.IsMainAsset = 'X'  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON _ControllingArea.ControllingArea = ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ProjAvailabilityCtrlPrflVH AS _ProjAvailCtrlProfileVH ON _ProjAvailCtrlProfileVH.AvailabilityControlProfile = AvailabilityControlProfile  -- association [0..1]
LEFT OUTER JOIN C_PPM_ProjJntVntrAccountingTP AS _JointVentureAccounting ON _JointVentureAccounting.ProjectUUID = ProjectUUID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = ProjectCurrency  -- association [0..1]
LEFT OUTER JOIN C_EntProjectLongTextTP AS _LongText ON ProjectUUID = _LongText.ProjectUUID  -- association [1..1]
LEFT OUTER JOIN C_PPM_ProjectPublicSectorTP AS _PublicSectorManagement ON _PublicSectorManagement.ProjectUUID = ProjectUUID  -- association [0..1]
LEFT OUTER JOIN C_EntProjectTaxJurisdictionVH AS _TaxJurisdictionVH ON TaxJurisdiction = _TaxJurisdictionVH.TaxJurisdiction AND CompanyCode = _TaxJurisdictionVH.CompanyCode  -- association [0..*]
LEFT OUTER JOIN C_PPM_ProjCtrlBlockFunctionTP AS _ElementBlockFunc ON _ElementBlockFunc.ProjectUUID = ProjectUUID  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationStdVH AS _FunctionalLocationVH ON _FunctionalLocationVH.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_EntProjWorkflowOverview AS _EntProjWorkflowOverview ON _EntProjWorkflowOverview.ProjectUUID = ProjectUUID  -- association [0..1]
LEFT OUTER JOIN I_EntProjectSettlementTypeText AS _EntProjectSettlementTypeText ON EntProjectSettlementType = _EntProjectSettlementTypeText.EntProjectSettlementType  -- association [0..*]
LEFT OUTER JOIN I_EntProjectResultAnalysisKey AS _RsltAnlysKey ON ResultAnalysisInternalID = _RsltAnlysKey.ResultAnalysisInternalID  -- association [1..1]
LEFT OUTER JOIN I_EntProjResultAnalysisKeyText AS _RsltAnlysKeyText ON ResultAnalysisInternalID = _RsltAnlysKeyText.ResultAnalysisInternalID  -- association [0..*]
;