P_MstrProjHierarchy

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 P_MstrProjHierarchy.
-- 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: PMPHIER

CREATE VIEW P_MstrProjHierarchy AS
SELECT
  StructureElement.MasterProjectUUID AS MasterProjectUUID,
  StructureElement.MasterProject AS MasterProject,
  StructureElement.MasterProjectName AS MasterProjectName,
  StructureElement.MasterProjectOrganization AS MasterProjectOrganization,
  StructureElement.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  StructureElement.MasterProjectType AS MasterProjectType,
  StructureElement.Currency AS Currency,
  StructureElement.Project AS Project,
  StructureElement.ProjectDescription AS ProjectDescription,
  StructureElement.BusinessArea AS BusinessArea,
  StructureElement.CompanyCode AS CompanyCode,
  StructureElement.ControllingArea AS ControllingArea,
  cast(StructureElement.ControllingObject as abap.char(34)) AS ControllingObject,
  cast(StructureElement.ControllingObjectExternalID as abap.char(34)) AS ControllingObjectExternalID,
  cast(StructureElement.ControllingObjectType as /cpd/pws_ws_mp_rel_obj) AS ControllingObjectType,
  StructureElement.ObjectInternalID AS ObjectInternalID,
  cast('' as vbeln) AS SalesDocument,
  cast('' as posnr) AS SalesDocumentItem,
  StructureElement.ObjectName AS ObjectName,
  StructureElement.ProjectObject AS MstrProjAnchorObjectInternalID,
  StructureElement.MstrProjCutOffDate AS MstrProjCutOffDate,
  StructureElement.ControllingObjectCurrency AS ControllingObjectCurrency,
  $session.system_date AS CurrentDate,
  StructureElement.WBSElementObject AS WBSElementObject,
  StructureElement.WBSElement AS WBSElement,
  CProject.ProjectExternalID AS ExternalObjectIdentifier
FROM I_MstrProjStructure AS StructureElement
LEFT OUTER JOIN I_SDItemOrganization AS SalesOrg ON /* join condition not captured in parsed metadata */
INNER JOIN I_SDItemOrganization AS SDItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_Project AS ProjectDefinition ON /* join condition not captured in parsed metadata */
INNER JOIN I_MPWBSObject AS WBSElement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CProjectList AS CProject ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_MstrProjStructure, I_MasterProjectItemList, I_MasterProjectItemList
;