C_CustomerProjectVH

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_CustomerProjectVH.
-- 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: CCUSTPROJVH

CREATE VIEW C_CustomerProjectVH AS
SELECT
  I_CustomerProject.CustomerProject AS CustomerProject,
  I_CustomerProject.CustomerProjectName AS CustomerProjectName,
  I_CustomerProject.CustProjMgrPersonnelNumber AS EmploymentInternalID,
  cast(_PersonWorkAgreement._WorkforcePerson.PersonFullName as /cpd/proj_manager_name preserving type ) AS CustomerProjectManagerName,
  I_CustomerProject.CustomerProjectServiceOrg AS CustomerProjectServiceOrg,
  I_CustomerProject.CustomerProjectVisibility AS CustomerProjectVisibility,
  I_CustomerProject.ProjectProfileCode AS ProjectProfileCode,
  I_CustomerProject.EngmntProjectHeaderCompanyCode AS EngmntProjectHeaderCompanyCode,
  I_CustomerProject.CostCenter AS EngagementProjectCostCenter,
  I_CustomerProject.ProfitCenter AS ProfitCenter,
  I_CustomerProject._UserInvlmnt.IsMyProject AS IsMyProject
FROM I_CustomerProject
LEFT OUTER JOIN I_EngagementProject AS _EngagementProject ON CustomerProject = _EngagementProject.EngagementProject  -- association [1..1]
LEFT OUTER JOIN I_PersnWrkAgreementDet AS _PersonWorkAgreement ON EmploymentInternalID = _PersonWorkAgreement.PersonWorkAgreement  -- association [1..*]
;