I_EngmntProjWithRoles

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_EngmntProjWithRoles.
-- 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: IENGPROJWITHROLE

CREATE VIEW I_EngmntProjWithRoles AS
SELECT
  EngagementProject.EngagementProject AS EngagementProject,
  EngagementProject.EngagementProjectUUID AS EngagementProjectUUID,
  _EngagementProjFinancialPlan.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  EngagementProject.ProjectVisibility AS ProjectVisibility,
  EngagementProject.EngagementProjectType AS EngagementProjectType,
  EngagementProject.EngagementProjectCategory AS EngagementProjectCategory,
  EngagementProject.EngagementProjectStage AS EngagementProjectStage,
  EngagementProject.ControllingArea AS ControllingArea,
  EngagementProject.CostCenter AS CostCenter,
  EngagementProject.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  EngagementProject.ProfitCenter AS ProfitCenter,
  EngagementProject.EngagementProjectName AS EngagementProjectName,
  EngagementProject.Customer AS Customer,
  EngagementProject.LastChangeDateTime AS LastChangeDateTime,
  EngagementProject.LastChangedByUser AS LastChangedByUser,
  EngagementProject.CreatedByUser AS CreatedByUser,
  EngagementProject.CreationDateTime AS CreationDateTime,
  EngagementProject.ProjectManager AS ProjectManager,
  EngagementProject.ProjectManagerWorkAgreement AS ProjectManagerWorkAgreement,
  EngagementProject.ProjectStartDate AS ProjectStartDate,
  EngagementProject.ProjectEndDate AS ProjectEndDate,
  cast(_ProjectController.EmploymentInternalID as persno) AS ProjectController,
  cast( _ProjectAccountant.EmploymentInternalID as persno) AS ProjectAccountant,
  cast(_ProjectPartner.EmploymentInternalID as persno) AS ProjectPartner,
  ProjectProfileCode,
  CompanyCode,
  _MyProjects.IsMyProject AS IsMyProject
FROM I_EngagementProject AS EngagementProject
LEFT OUTER JOIN I_PersnWrkAgreementDet AS _PersonWorkAgreement ON ProjectManagerWorkAgreement = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..*]
LEFT OUTER JOIN I_EngagementProjectRole AS _ProjectController ON EngagementProject = _ProjectController.EngagementProject AND _ProjectController.EngagementProjectTeamRole = 'P003'  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectRole AS _ProjectAccountant ON EngagementProject = _ProjectAccountant.EngagementProject AND _ProjectAccountant.EngagementProjectTeamRole = 'P002'  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectRole AS _ProjectPartner ON EngagementProject = _ProjectPartner.EngagementProject AND _ProjectPartner.EngagementProjectTeamRole = 'P004'  -- association [0..1]
LEFT OUTER JOIN I_EngmntProjWithUserInvlmnt AS _MyProjects ON EngagementProjectUUID = _MyProjects.ProjectUUID  -- association [1..1]
;