C_InternalProjFactsheet

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_InternalProjFactsheet.
-- 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.
-- Parameters: P_Language : sylangu

CREATE VIEW C_InternalProjFactsheet AS
SELECT
  A.InternalProject AS InternalProject,
  A.InternalProjectUUID AS InternalProjectUUID,
  A.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  A.InternalProjectName AS InternalProjectName,
  A.ProjectVisibility AS ProjectVisibility,
  A.EngagementProjectType AS EngagementProjectType,
  A.EngagementProjectCategory AS EngagementProjectCategory,
  A.EngagementProjectStage AS EngagementProjectStage,
  A.CostCenter AS CostCenter,
  A.ProfitCenter AS ProfitCenter,
  A.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  A.ControllingArea AS ControllingArea,
  A.Currency AS Currency,
  A.LastChangeDateTime AS LastChangeDateTime,
  A.LastChangedByUser AS LastChangedByUser,
  A.ProjectManagerWorkAgreement AS ProjectManager,
  A.ProjectStartDate AS ProjectStartDate,
  A.ProjectEndDate AS ProjectEndDate,
  A.PlndCostAmt AS PlndCostAmt,
  A._OriginCostCenter._Text[1: Language = $session.system_language].CostCenterName AS CostCenterName,
  A._OriginProfitCenter._Text[1: Language = $parameters.P_Language].ProfitCenterName AS ProfitCenterName,
  A._Currency._Text[1: Language = $parameters.P_Language].CurrencyName AS CurrencyName,
  A._EngagementProjectStage._Text[1: Language = $parameters.P_Language].EngagementProjectStageText AS EngagementProjectStageText,
  A._EngagementProjectServiceOrg._Text[1: Language = $parameters.P_Language].EngmtProjectServiceOrgName AS EngmtProjectServiceOrgName,
  A._PersonWorkAgreement._WorkforcePerson.PersonExternalID AS PersonExternalID,
  A._PersonWorkAgreement._WorkforcePersonImageURL.WorkforcePersonImageURL AS WorkforcePersonImageURL,
  A._PersonWorkAgreement._WorkforcePerson._WorkplaceAddress.DefaultEmailAddress AS DefaultEmailAddress,
  A._PersonWorkAgreement._WorkforcePerson._WorkplaceAddress.MblNormalizedPhoneNumber AS MblNormalizedPhoneNumber,
  A._PersonWorkAgreement._WorkforcePerson._WorkplaceAddress.NormalizedPhoneNumber AS NormalizedPhoneNumber,
  A._PersonWorkAgreement._WorkforcePerson.AuthorizationGroup AS AuthorizationGroup,
  A._PersonWorkAgreement._WorkforcePerson.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_InternalProjectDetails AS A
LEFT OUTER JOIN C_EngmntProjPlnActlExpense AS _Engmntprojplnactlexpense ON InternalProject = _Engmntprojplnactlexpense.EngagementProject  -- association [0..*]
LEFT OUTER JOIN C_EngmentProjEmpWrkPckgDets AS _EngmentProjEmpWrkPckgDets ON InternalProject = _EngmentProjEmpWrkPckgDets.EngagementProject  -- association [0..*]
LEFT OUTER JOIN C_WorkPackagePlanActual AS _WorkPackagePlanActual ON InternalProject = _WorkPackagePlanActual.EngagementProject  -- association [0..*]
LEFT OUTER JOIN C_IntProjFinPerformance AS _IntProjFinPerformance ON InternalProject = _IntProjFinPerformance.InternalProject  -- association [0..*]
LEFT OUTER JOIN C_IntProjWorkPerformance AS _Intprojworkperformance ON InternalProject = _Intprojworkperformance.InternalProject  -- association [0..1]
LEFT OUTER JOIN I_WorkpackagePurchaseOrder AS _WorkpackagePurchaseOrder ON EngagementProjFinPlanUUID = _WorkpackagePurchaseOrder.EngagementProjFinPlanUUID  -- association [0..*]
LEFT OUTER JOIN I_EngagementProjectRole AS _EngagementProjectRole ON InternalProject = _EngagementProjectRole.EngagementProject  -- association [1..*]
LEFT OUTER JOIN I_EngagementProjOverallStatus AS _EngagementProjOverallStatus ON InternalProjectUUID = _EngagementProjOverallStatus.EngagementProjectUUID  -- association [0..1]
LEFT OUTER JOIN C_EngagementProjectTeam AS _Engagementprojectteam ON InternalProject = _Engagementprojectteam.EngagementProject  -- association [1..*]
LEFT OUTER JOIN I_EngmntProjAddlResources AS _EngmntProjAddlResources ON InternalProject = _EngmntProjAddlResources.EngagementProject  -- association [0..*]
LEFT OUTER JOIN C_EngmntProjectRoleAssgmt AS _EngmntProjRoleAssgmt ON InternalProject = _EngmntProjRoleAssgmt.EngagementProject  -- association [1..*]
LEFT OUTER JOIN I_EngmntProjAssgmtToSessionUsr AS _EngagementProject ON InternalProject = _EngagementProject.EngagementProject  -- association [1..1]
;