C_CustomerProject

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_CustomerProject.
-- 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: CCUSTOMERPROJECT

CREATE VIEW C_CustomerProject AS
SELECT
  EngagementProject.EngagementProject AS CustomerProject,
  EngagementProject.EngagementProjectUUID AS CustomerProjectUUID,
  _EngagementProjFinancialPlan.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  EngagementProject.ProjectVisibility AS ProjectVisibility,
  EngagementProject.EngagementProjectType AS CustomerProjectType,
  EngagementProject.EngagementProjectStage AS CustomerProjectStage,
  EngagementProject.CompanyCode AS CompanyCode,
  EngagementProject.ProjectProfileCode AS ProjectProfileCode,
  EngagementProject.ControllingArea AS ControllingArea,
  EngagementProject.CostCenter AS CostCenter,
  EngagementProject.EngagementProjectServiceOrg AS CustomerProjectServiceOrg,
  EngagementProject.EngagementProjectCategory AS EngagementProjectCategory,
  EngagementProject.ProfitCenter AS ProfitCenter,
  EngagementProject.EngagementProjectName AS CustomerProjectName,
  EngagementProject.Customer AS Customer,
  EngagementProject.LastChangeDateTime AS LastChangeDateTime,
  EngagementProject.LastChangedByUser AS LastChangedByUser,
  EngagementProject.ProjectManager AS ProjectManager,
  EngagementProject.ProjectManagerWorkAgreement AS ProjectManagerWorkAgreement,
  EngagementProject.ProjectStartDate AS ProjectStartDate,
  EngagementProject.ProjectEndDate AS ProjectEndDate,
  EngagementProjectPlanData.Currency AS Currency,
  EngagementProjectPlanData.PlndCostAmt AS PlndCostAmt,
  EngagementProjectPlanData.PlndEffortQty AS PlndEffortQty,
  EngagementProjectPlanData.PlndRevnAmt AS PlndRevnAmt,
  MyProjects.IsMyProject AS IsMyProject
FROM I_EngagementProject AS EngagementProject
LEFT OUTER JOIN C_WorkPackage AS _WorkPackage ON EngagementProjFinPlanUUID = _WorkPackage.EngagementProjFinPlanUUID  -- association [0..*]
LEFT OUTER JOIN I_EngagementProjectRole AS _ProjectController ON CustomerProject = _ProjectController.EngagementProject AND _ProjectController.EngagementProjectTeamRole = 'P003'  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectRole AS _ProjectAccountant ON CustomerProject = _ProjectAccountant.EngagementProject AND _ProjectAccountant.EngagementProjectTeamRole = 'P002'  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectRole AS _ProjectPartner ON CustomerProject = _ProjectPartner.EngagementProject AND _ProjectPartner.EngagementProjectTeamRole = 'P004'  -- association [0..1]
LEFT OUTER JOIN E_CustomerProject AS _Extension ON CustomerProject = _Extension.CustomerProject  -- association [0..1]
LEFT OUTER JOIN I_PersnWrkAgreementDet AS _PersonWorkAgreement ON ProjectManagerWorkAgreement = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..*]
;