I_InternalProject

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_InternalProject.
-- 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_InternalProject AS
SELECT
  EngagementProject.EngagementProject AS InternalProject,
  cast( EngagementProject.EngagementProjectUUID as /cpd/eng_db_key preserving type ) AS InternalProjectUUID,
  EngagementProject.EngagementProjectName AS InternalProjectName,
  EngagementProject.EngagementProjectType AS EngagementProjectType,
  EngagementProject.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  EngagementProject.EngagementProjectStage AS EngagementProjectStage,
  EngagementProject.EngagementProjectCategory AS EngagementProjectCategory,
  EngagementProject.ProjectStartDate AS ProjectStartDate,
  EngagementProject.ProjectEndDate AS ProjectEndDate,
  EngagementProject.ProjectVisibility AS ProjectVisibility,
  EngagementProject.ProjectManager AS ProjectManager,
  EngagementProject.ProjectManagerWorkAgreement AS ProjectManagerWorkAgreement,
  EngagementProject.LastChangeDateTime AS LastChangeDateTime,
  EngagementProject.LastChangedByUser AS LastChangedByUser,
  EngagementProject.ProfitCenter AS ProfitCenter,
  EngagementProject.CostCenter AS CostCenter,
  EngagementProject.ControllingArea AS ControllingArea,
  EngagementProject.ProjectProfileCode AS ProjectProfileCode,
  EngagementProject.CompanyCode AS CompanyCode
FROM I_EngagementProject AS EngagementProject
LEFT OUTER JOIN I_EngagementProjFinancialPlan AS _EngagementProjFinancialPlan ON InternalProjectUUID = _EngagementProjFinancialPlan.EngagementProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_PersnWrkAgreementDet AS _PersonWorkAgreementDet ON ProjectManagerWorkAgreement = _PersonWorkAgreementDet.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_EngagementProjectStage AS _EngagementProjectStage ON EngagementProjectStage = _EngagementProjectStage.EngagementProjectStage  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectItem AS _EngagementProjectItem ON InternalProjectUUID = _EngagementProjectItem.EngagementProjectUUID  -- association [0..*]
LEFT OUTER JOIN I_EngagementProjectSrvcOrg AS _EngagementProjectServiceOrg ON EngagementProjectServiceOrg = _EngagementProjectServiceOrg.EngagementProjectServiceOrg  -- association [0..1]
LEFT OUTER JOIN E_Internalproject AS _Extension ON InternalProjectUUID = _Extension.InternalProjectUUID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement AS _PersonWorkAgreement ON ProjectManager = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..*]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement_1 ON ProjectManagerWorkAgreement = _PersonWorkAgreement_1.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_EngmntProjWithUserInvlmnt AS _UserInvlmnt ON InternalProjectUUID = _UserInvlmnt.ProjectUUID  -- association [1..1]
;