C_EntProjCtrlProfnlSrvcTP

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_EntProjCtrlProfnlSrvcTP.
-- 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_EntProjCtrlProfnlSrvcTP AS
SELECT
  ProjectUUID,
  Project,
  virtual ProjectDescription : abap.char(40) AS char40,
  ProjectDescription AS ProjectName,
  ProjectInternalID,
  EnterpriseProjectServiceOrg,
  ResponsibleCostCenter AS CostCenter,
  ProfitCenter,
  ProjectStartDate,
  ProjectEndDate,
  ProjectCurrency,
  ProcessingStatus,
  ProjectProfileCode,
  EntProjectIsConfidential,
  CompanyCode,
  ControllingArea,
  ProjectCategory,
  ProjectLastChangedDateTime,
  _EntProjProjectObjectLink[1: EntProjectObjectLinkType = 'SOLO']._EntProjBusSolnOrderLinkTP [1: ProjectUUID = projectuuid].BusinessSolutionOrder AS BusinessSolutionOrder,
  _EntProjProjectObjectLink[1: EntProjectObjectLinkType = 'SOLO']._EntProjBusSolnOrderLinkTP [1: ProjectUUID = projectuuid].BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  _EntProjRoleStaffing[1: ProjectRoleType = 'YP_RL_0001']._BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  _CustomerToBusinessPartner.Customer AS Customer,
  _ProjectProfileText.ProjectProfileCodeText : localized AS ProjectProfileCodeTextlocalized,
  _EntProjProfnlSrvcProjStgeTxt.ProcessingStatusText : localized AS ProcessingStatusTextlocalized,
  virtual SalesOrder : abap.char(10) AS char10,
  _EnterpriseProjectForUser.UserID AS UserID,
  virtual IsMyProject : boolean AS virtualIsMyProjectboolean,
  virtual ProjectIsInternal : boolean AS virtualProjectIsInternalboolean
FROM I_EnterpriseProjectTP_2
LEFT OUTER JOIN C_EntProjMemberContactCard AS _ProjectManager ON _ProjectManager.BusinessPartnerUUID = businesspartneruuid  -- association [0..1]
LEFT OUTER JOIN C_EntProjCustomerContactCard AS _Customer ON _Customer.Customer = customer  -- association [0..1]
LEFT OUTER JOIN C_EntProjCostCtrCntctCard AS _CostCenter ON _CostCenter.ControllingArea = ControllingArea AND _CostCenter.CostCenter = CostCenter  -- association [0..1]
LEFT OUTER JOIN C_EntProjSrvcOrgCntctCard AS _ServiceOrganization ON _ServiceOrganization.EnterpriseProjectServiceOrg = EnterpriseProjectServiceOrg  -- association [0..1]
LEFT OUTER JOIN C_EntProjPrftCtrCntctCard AS _ProfitCenterContactCard ON _ProfitCenterContactCard.ControllingArea = ControllingArea AND _ProfitCenterContactCard.ProfitCenter = ProfitCenter  -- association [0..1]
LEFT OUTER JOIN C_EnterpriseProjectEntitlement AS _EnterpriseProjectEntitlement ON _EnterpriseProjectEntitlement.ProjectUUID = ProjectUUID  -- association [1..*]
LEFT OUTER JOIN C_EntProjProfnlSrvcBillgElmnt AS _EntProjProfnlSrvcBillgElmnt ON _EntProjProfnlSrvcBillgElmnt.ProjectUUID = ProjectUUID  -- association [0..*]
LEFT OUTER JOIN C_EntProjProfnlSrvcBillgDoc AS _EntProjProfnlSrvcBillgDoc ON _EntProjProfnlSrvcBillgDoc.ProjectUUID = ProjectUUID  -- association [0..*]
;