Deprecated PUBLIC_LOCAL_API
This CDS view is deprecated in S/4HANA. Use I_MstrProjHierarchy instead. View all deprecated CDS views →

I_MstrProjHierList

DDL: I_MSTRPROJHIERLIST SQL: IMPHIERLIST Type: view COMPOSITE
33 Fields 2 Data Sources

Master Project Hierarchy List

I_MstrProjHierList is a Composite CDS View that provides data about "Master Project Hierarchy List" in SAP S/4HANA. It reads from 2 data sources (I_SDItemOrganization, I_MstrProjStructureElement) and exposes 33 fields.

Data Sources (2)

SourceAliasJoin Type
I_SDItemOrganization SalesOrg left_outer
I_MstrProjStructureElement StructureElement from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMPHIERLIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
EndUserText.label Master Project Hierarchy List view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.lifecycle.successor I_MstrProjHierarchy view
VDM.lifecycle.status #DEPRECATED view

Fields (33)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID I_MstrProjStructureElement MasterProjectUUID NodeID
MasterProject I_MstrProjStructureElement MasterProject Project ID
MasterProjectName I_MstrProjStructureElement MasterProjectName
MasterProjectType I_MstrProjStructureElement MasterProjectType
MasterProjectStage I_MstrProjStructureElement MasterProjectStage
StartDate I_MstrProjStructureElement StartDate Valid From
EndDate I_MstrProjStructureElement EndDate Term to
Customer I_MstrProjStructureElement Customer Sold-to Party
MasterProjectOrganization I_MstrProjStructureElement MasterProjectOrganization
MasterProjectIsConfidential I_MstrProjStructureElement MasterProjectIsConfidential
Country I_MstrProjStructureElement Country Venue: Ctry/Reg
Region I_MstrProjStructureElement Region Venue Region
WorkType I_MstrProjStructureElement WorkType SAF-T Work Type
Industry I_MstrProjStructureElement Industry Industry Sector
ProjectRisk I_MstrProjStructureElement ProjectRisk
FinancialRisk I_MstrProjStructureElement FinancialRisk
TechnicalRisk I_MstrProjStructureElement TechnicalRisk
OverallRisk I_MstrProjStructureElement OverallRisk
MasterProjectItemUUID I_MstrProjStructureElement MasterProjectItemUUID
MasterProjectItemObjectType I_MstrProjStructureElement MasterProjectItemObjectType
MasterProjectItem I_MstrProjStructureElement MasterProjectItem
WBSElement I_MstrProjStructureElement WBSElement WBS Internal ID
CompanyCode I_MstrProjStructureElement CompanyCode Receiver Company Code
BusinessArea I_MstrProjStructureElement BusinessArea Business Area
ControllingArea I_MstrProjStructureElement ControllingArea Controlling Area
ControllingObject I_MstrProjStructureElement ControllingObject Object number
ControllingAreaCurrency I_MstrProjStructureElement ControllingAreaCurrency
WBSElementInternalID I_MstrProjStructureElement WBSElementInternalID WBS Internal ID
ControllingObjectInternalID I_MstrProjStructureElement ControllingObjectInternalID
WBSElementObject I_MstrProjStructureElement WBSElementObject Object number
ExternalId
SalesDocument I_SDItemOrganization SalesDocument SD Document
SalesDocumentItem I_SDItemOrganization SalesDocumentItem Sales Document Item

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_MstrProjHierList.
-- 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: IMPHIERLIST

CREATE VIEW I_MstrProjHierList AS
SELECT
  StructureElement.MasterProjectUUID AS MasterProjectUUID,
  StructureElement.MasterProject AS MasterProject,
  StructureElement.MasterProjectName AS MasterProjectName,
  StructureElement.MasterProjectType AS MasterProjectType,
  StructureElement.MasterProjectStage AS MasterProjectStage,
  StructureElement.StartDate AS StartDate,
  StructureElement.EndDate AS EndDate,
  StructureElement.Customer AS Customer,
  StructureElement.MasterProjectOrganization AS MasterProjectOrganization,
  StructureElement.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  StructureElement.Country AS Country,
  StructureElement.Region AS Region,
  StructureElement.WorkType AS WorkType,
  StructureElement.Industry AS Industry,
  StructureElement.ProjectRisk AS ProjectRisk,
  StructureElement.FinancialRisk AS FinancialRisk,
  StructureElement.TechnicalRisk AS TechnicalRisk,
  StructureElement.OverallRisk AS OverallRisk,
  StructureElement.MasterProjectItemUUID AS MasterProjectItemUUID,
  StructureElement.MasterProjectItemObjectType AS MasterProjectItemObjectType,
  StructureElement.MasterProjectItem AS MasterProjectItem,
  StructureElement.WBSElement AS WBSElement,
  StructureElement.CompanyCode AS CompanyCode,
  StructureElement.BusinessArea AS BusinessArea,
  StructureElement.ControllingArea AS ControllingArea,
  StructureElement.ControllingObject AS ControllingObject,
  StructureElement.ControllingAreaCurrency AS ControllingAreaCurrency,
  StructureElement.WBSElementInternalID AS WBSElementInternalID,
  StructureElement.ControllingObjectInternalID AS ControllingObjectInternalID,
  StructureElement.WBSElementObject AS WBSElementObject,
  '' AS ExternalId,
  SalesOrg.SalesDocument AS SalesDocument,
  SalesOrg.SalesDocumentItem AS SalesDocumentItem
FROM I_MstrProjStructureElement AS StructureElement
LEFT OUTER JOIN I_SDItemOrganization AS SalesOrg ON /* join condition not captured in parsed metadata */
;

Learn More