I_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 I_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.

CREATE VIEW I_CustomerProject AS
SELECT
  cast(CustomerProject.EngagementProject as /cpd/ss_cp_id preserving type ) AS CustomerProject,
  cast(CustomerProject.EngagementProjectUUID as /cpd/ss_cp_uuid preserving type ) AS CustomerProjectUUID,
  cast(CustomerProject.EngagementProjectName as /cpd/ss_cp_desc preserving type) AS CustomerProjectName,
  cast(CustomerProject.EngagementProjectType as /cpd/ss_cp_type preserving type ) AS CustomerProjectType,
  cast(CustomerProject.EngagementProjectStage as /cpd/ss_cp_stage preserving type ) AS CustomerProjectStage,
  cast(CustomerProject.ProjectVisibility as /cpd/ss_cp_visibility preserving type ) AS CustomerProjectVisibility,
  CustomerProject.LastChangedByUser AS LastChangedByUser,
  CustomerProject.LastChangeDateTime AS LastChangeDateTime,
  CustomerProject.Customer AS Customer,
  CustomerProject.EngagementProjectServiceOrg AS CustomerProjectServiceOrg,
  CustomerProject.ProjectProfileCode AS ProjectProfileCode,
  CustomerProject.ProjectManagerWorkAgreement AS CustProjMgrPersonnelNumber,
  CustomerProject.ProjectStartDate AS CustomerProjectStartDate,
  CustomerProject.ProjectEndDate AS CustomerProjectEndDate,
  CustomerProject.CostCenter AS CostCenter,
  CustomerProject.ProfitCenter AS ProfitCenter,
  CustomerProject.CompanyCode AS EngmntProjectHeaderCompanyCode,
  cast( CustomerProject.EngagementProjectCategory as ps_prart ) AS ProjectType,
  _EngagementProjFinancialPlan.Currency AS Currency,
  cast(_EngagementProjFinancialPlan.EngagementProjFinPlanUUID as /cpd/eng_pfp_db_key preserving type ) AS CustProjFinancialPlanUUID,
  _EngagementProjFinancialPlan.UnitOfMeasure AS UnitOfMeasure,
  CustomerProject.ControllingArea AS ControllingArea
FROM I_EngagementProject AS CustomerProject
LEFT OUTER JOIN I_CustomerProjectItem AS _Item ON CustomerProjectUUID = _Item.CustomerProjectUUID  -- association [0..*]
LEFT OUTER JOIN I_EngagementProjectStage AS _Stage ON CustomerProjectStage = _Stage.EngagementProjectStage  -- association [0..1]
LEFT OUTER JOIN I_PersnWrkAgreementDet AS _PersonWorkAgreement ON CustProjMgrPersonnelNumber = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrg AS _EngagementProjectServiceOrg ON CustomerProjectServiceOrg = _EngagementProjectServiceOrg.EngagementProjectServiceOrg  -- association [0..1]
LEFT OUTER JOIN E_CustomerProject AS _Extension ON CustomerProject.EngagementProject = _Extension.CustomerProject  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
;