I_MstrProjHierarchy

DDL: I_MSTRPROJHIERARCHY SQL: IHIERARCHYLIST Type: view COMPOSITE
28 Fields 1 Data Sources 2 Associations

Master Project Hierarchy List

I_MstrProjHierarchy is a Composite CDS View that provides data about "Master Project Hierarchy List" in SAP S/4HANA. It reads from 1 data source (P_MstrProjHierarchy) and exposes 28 fields. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_MstrProjHierarchy Hierarchy from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IHIERARCHYLIST view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Project Hierarchy List view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (28)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID P_MstrProjHierarchy MasterProjectUUID NodeID
MasterProject P_MstrProjHierarchy MasterProject Project ID
MasterProjectName P_MstrProjHierarchy MasterProjectName
MasterProjectOrganization P_MstrProjHierarchy MasterProjectOrganization
MasterProjectIsConfidential P_MstrProjHierarchy MasterProjectIsConfidential
MasterProjectType P_MstrProjHierarchy MasterProjectType
Currency P_MstrProjHierarchy Currency Valuation Crcy
Project P_MstrProjHierarchy Project WBS Element
ProjectDescription P_MstrProjHierarchy ProjectDescription Project Name
BusinessArea P_MstrProjHierarchy BusinessArea Business Area
CompanyCode P_MstrProjHierarchy CompanyCode Receiver Company Code
ControllingArea P_MstrProjHierarchy ControllingArea Controlling Area
ControllingObject P_MstrProjHierarchy ControllingObject Object number
ControllingObjectExternalID P_MstrProjHierarchy ControllingObjectExternalID WBS Element
ControllingObjectType P_MstrProjHierarchy ControllingObjectType Object Type
SalesDocument P_MstrProjHierarchy SalesDocument SD Document
SalesDocumentItem P_MstrProjHierarchy SalesDocumentItem Sales Document Item
ObjectName P_MstrProjHierarchy ObjectName Object name
MstrProjAnchorObjectInternalID P_MstrProjHierarchy MstrProjAnchorObjectInternalID Object number
ExternalObjectIdentifier P_MstrProjHierarchy ExternalObjectIdentifier Project def.
ControllingObjectCurrency P_MstrProjHierarchy ControllingObjectCurrency CO Object Currency
WBSElementObject P_MstrProjHierarchy WBSElementObject Object number
WBSElement P_MstrProjHierarchy WBSElement WBS Internal ID
_ControllingArea _ControllingArea
_CompanyCode _CompanyCode
_MstrProjType _MstrProjType
_MstrProjFinPlan _MstrProjFinPlan
_MstrProjPerdKPI _MstrProjPerdKPI

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_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: IHIERARCHYLIST

CREATE VIEW I_MstrProjHierarchy AS
SELECT
  Hierarchy.MasterProjectUUID AS MasterProjectUUID,
  Hierarchy.MasterProject AS MasterProject,
  Hierarchy.MasterProjectName AS MasterProjectName,
  Hierarchy.MasterProjectOrganization AS MasterProjectOrganization,
  Hierarchy.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  Hierarchy.MasterProjectType AS MasterProjectType,
  Hierarchy.Currency AS Currency,
  Hierarchy.Project AS Project,
  Hierarchy.ProjectDescription AS ProjectDescription,
  Hierarchy.BusinessArea AS BusinessArea,
  Hierarchy.CompanyCode AS CompanyCode,
  Hierarchy.ControllingArea AS ControllingArea,
  Hierarchy.ControllingObject AS ControllingObject,
  Hierarchy.ControllingObjectExternalID AS ControllingObjectExternalID,
  Hierarchy.ControllingObjectType AS ControllingObjectType,
  Hierarchy.SalesDocument AS SalesDocument,
  Hierarchy.SalesDocumentItem AS SalesDocumentItem,
  Hierarchy.ObjectName AS ObjectName,
  Hierarchy.MstrProjAnchorObjectInternalID AS MstrProjAnchorObjectInternalID,
  Hierarchy.ExternalObjectIdentifier AS ExternalObjectIdentifier,
  Hierarchy.ControllingObjectCurrency AS ControllingObjectCurrency,
  Hierarchy.WBSElementObject AS WBSElementObject,
  Hierarchy.WBSElement AS WBSElement
FROM P_MstrProjHierarchy AS Hierarchy
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1..1]
;

Learn More