C_EntPrjMngProfnlSrvcsProjTP

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_EntPrjMngProfnlSrvcsProjTP.
-- 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_EntPrjMngProfnlSrvcsProjTP AS
SELECT
  ProjectUUID,
  ProjectProfileCode,
  _ProjectProfileText.ProjectProfileCodeText : localized AS ProjectProfileCodeTextlocalized,
  Project,
  virtual ProjectExternalID : ps_pspid_edit AS virtualProjectExternalIDps_pspid_edit,
  ProjectDescription,
  ProjectStartDate,
  ProjectEndDate,
  ProjectCategory,
  virtual ProjectIsInternal : boole_d AS virtualProjectIsInternalboole_d,
  CustomerUUID,
  _CustomerToBusinessPartner.Customer AS Customer,
  EnterpriseProjectServiceOrg,
  ProcessingStatus,
  ResponsibleCostCenter,
  ProfitCenter,
  ProjectCurrency,
  EntProjectIsConfidential,
  virtual PersonExternalID : bu_id_number AS virtualPersonExternalIDbu_id_number,
  virtual ProjectIsDeletable : boolean AS virtualProjectIsDeletableboolean,
  virtual ProjectIsEditable : boolean AS virtualProjectIsEditableboolean,
  _EntProjLongDesc.LongText AS LongText,
  RestrictedTimePosting,
  LastChangeDateTime,
  CreationDateTime,
  CompanyCode,
  ControllingArea,
  Plant,
  FunctionalArea,
  EnterpriseProjectType,
  _EnterpriseProjectForUser.UserID AS UserID,
  virtual IsMyProject : boolean AS virtualIsMyProjectboolean,
  _EntProjRoleStaffing[1: ProjectRoleType = 'YP_RL_0001'].BusinessPartnerUUID AS BusinessPartnerUUID,
  _EntProjRoleStaffing[1: ProjectRoleType = 'YP_RL_0001'].BusinessPartner AS BusinessPartner,
  virtual PersonFullName : bu_name1tx AS virtualPersonFullNamebu_name1tx,
  _EntProjRoleStaffing[1: ProjectRoleType = '0SAP_RL_005'].BusinessPartnerUUID AS ProjectControllerUUID,
  _EntProjRoleStaffing[1: ProjectRoleType = '0SAP_RL_005'].BusinessPartner AS ProjectControllerBPID,
  virtual ProjectControllerName : bu_name1tx AS virtualProjectControllerNamebu_name1tx,
  _EntProjRoleStaffing[1: ProjectRoleType = '0SAP_RL_006'].BusinessPartnerUUID AS ProjectAccountantUUID,
  _EntProjRoleStaffing[1: ProjectRoleType = '0SAP_RL_006'].BusinessPartner AS ProjectAccountantBPID,
  virtual ProjectAccountantName : bu_name1tx AS virtualProjectAccountantNamebu_name1tx,
  _EntProjRoleStaffing[1: ProjectRoleType = '0SAP_RL_007'].BusinessPartnerUUID AS ProjectPartnerUUID,
  _EntProjRoleStaffing[1: ProjectRoleType = '0SAP_RL_007'].BusinessPartner AS ProjectPartnerBPID,
  virtual ProjectPartnerName : bu_name1tx AS virtualProjectPartnerNamebu_name1tx,
  _ProfitCenter[1: ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date ]._Text[1: Language = $session.system_language ].ProfitCenterName as ProfitCenterName AS ProfitCenterNameasProfitCenterName,
  _CustomerToBusinessPartner._Customer.CustomerName AS CustomerName,
  _EntProjProfnlSrvcProjStgeTxt[1: Language = $session.system_language ].ProcessingStatusText AS ProcessingStatusText,
  _EnterpriseProjectSrvcOrgText[1:Language = $session.system_language].EngmtProjectServiceOrgName AS EngmtProjectServiceOrgName,
  _ResponsibleCostCenter[1: ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date ]._Text[1: Language = $session.system_language ].CostCenterName as CostCenterName AS CostCenterNameasCostCenterName
FROM I_EnterpriseProjectTP_2
LEFT OUTER JOIN C_EntProjCostCtrCntctCard AS _CostCenter ON _CostCenter.CostCenter = ResponsibleCostCenter  -- association [1..1]
LEFT OUTER JOIN C_EntProjSrvcOrgCntctCard AS _ServiceOrganization ON _ServiceOrganization.EnterpriseProjectServiceOrg = EnterpriseProjectServiceOrg  -- association [1..1]
LEFT OUTER JOIN C_EntProjPrftCtrCntctCard AS _ProfitCenterContactCard ON _ProfitCenterContactCard.ProfitCenter = ProfitCenter  -- association [1..1]
LEFT OUTER JOIN C_EnPrjPfSrvsMemberContactCard AS _ProjectManager ON _ProjectManager.BusinessPartner = businesspartner  -- association [0..1]
LEFT OUTER JOIN C_EnPrjPfSrvsMemberContactCard AS _ProjectController ON _ProjectController.BusinessPartner = ProjectControllerBPID  -- association [0..1]
LEFT OUTER JOIN C_EnPrjPfSrvsMemberContactCard AS _ProjectAccountant ON _ProjectAccountant.BusinessPartner = ProjectAccountantBPID  -- association [0..1]
LEFT OUTER JOIN C_EnPrjPfSrvsMemberContactCard AS _ProjectPartner ON _ProjectPartner.BusinessPartner = ProjectPartnerBPID  -- association [0..1]
LEFT OUTER JOIN C_EnPrjPfSrvsCustContactCard AS _Customer ON _Customer.Customer = customer  -- association [0..1]
;