I_MasterProject

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_MasterProject.
-- 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: IMASTERPROJECT

CREATE VIEW I_MasterProject AS
SELECT
  cast(MPList.mp_id as /cpd/cpm_comlprojid) AS MasterProject,
  MPList.db_key AS MasterProjectUUID,
  cast(MasterProjectText.text as /cpd/cpm_comlprojname) AS MasterProjectName,
  cast(MPList.mp_type as /cpd/cpm_mp_type) AS MasterProjectType,
  cast(MPList.mp_stage as /cpd/cpm_mp_stage) AS MasterProjectStage,
  MPList.start_date AS StartDate,
  MPList.end_date AS EndDate,
  MPList.active AS StatusIsActive,
  MPList.customer AS Customer,
  cast(MPList.org_id as /cpd/cpm_comlprojorg) AS MasterProjectOrganization,
  cast(MPList.confidential as /cpd/cpm_comlprojcofl ) AS MasterProjectIsConfidential,
  cast(MPList.country as /cpd/cpm_country) AS Country,
  MPList.region AS Region,
  MPList.work_type AS WorkType,
  MPList.industry AS Industry,
  cast(MPList.proj_risk as /cpd/cpm_projrisk) AS ProjectRisk,
  MPList.fin_risk AS FinancialRisk,
  MPList.tech_risk AS TechnicalRisk,
  cast(MPList.overall_risk as /cpd/cpm_overalprojrisk) AS OverallRisk,
  MPList.int_inspect_date AS InspectionDate,
  cast(MPList.int_inspect_date as /cpd/cpm_intinsdate) AS InternalInspectionDate,
  cast(MPList.ext_inspect_date as /cpd/cpm_extinsdate) AS ExternalInspectionDate,
  MPList.created_by AS CreatedByUser,
  cast(MPList.created_on as /cpd/cpm_createdon) AS CreationDateTime,
  cast(MPList.changed_on as /cpd/cpm_changedon) AS ProjectLastChangedDateTime,
  MPList.changed_by AS ChangedBy,
  MPList.proj_mgr_bupa_id AS ProjectManager,
  bintohex(MPList.db_key) AS ProjectUUID,
  MPList.proj_currency AS Currency,
  MPList.cut_off_date AS MstrProjCutOffDate
FROM /cpd/d_mp_hdr AS MPList
INNER JOIN /cpd/d_mp_hdr_s AS MasterProjectText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MasterProjectType AS _MasterProjectType ON MasterProjectType = _MasterProjectType.MasterProjectType  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectStage AS _MasterProjectStage ON MasterProjectStage = _MasterProjectStage.EngagementProjectStage  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ProjectManager ON ProjectManager = _ProjectManager.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrg AS _MasterProjectOrganization ON MasterProjectOrganization = _MasterProjectOrganization.EngagementProjectServiceOrg  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _Region ON Country = _Region.Country AND Region = _Region.Region  -- association [0..1]
LEFT OUTER JOIN I_CpdIndustry AS _Industry ON Industry = _Industry.Industry  -- association [0..1]
LEFT OUTER JOIN I_Cpdprojectrisk AS _ProjectRisk ON ProjectRisk = _ProjectRisk.ProjectRisk  -- association [0..1]
LEFT OUTER JOIN I_Cpdfinancialrisk AS _FinancialRisk ON FinancialRisk = _FinancialRisk.FinancialRisk  -- association [0..1]
LEFT OUTER JOIN I_Cpdtechnicalrisk AS _TechnicalRisk ON TechnicalRisk = _TechnicalRisk.TechnicalRisk  -- association [0..1]
LEFT OUTER JOIN I_Cpdprojectrisk AS _OverallRisk ON OverallRisk = _OverallRisk.ProjectRisk  -- association [0..1]
LEFT OUTER JOIN I_MPContactPerson AS _ContactPerson ON MasterProjectUUID = _ContactPerson.MasterProjectUUID  -- association [1..*]
LEFT OUTER JOIN I_MasterProjectVH AS _MasterProject ON MasterProject = _MasterProject.MasterProject  -- association [0..1]
LEFT OUTER JOIN I_Cpdworktype AS _WorkType ON WorkType = _WorkType.WorkType  -- association [0..1]
LEFT OUTER JOIN I_WorkforcePerson AS _Employee ON ProjectManager = _Employee.Person  -- association [0..1]
LEFT OUTER JOIN E_MasterProject AS _Extension ON MasterProjectUUID = _Extension.MasterProjectUUID  -- association [1..1]
LEFT OUTER JOIN E_MasterProjectKPI AS _ExtensionKPI ON MasterProject = _ExtensionKPI.MasterProject  -- association [0..1]
;