I_MstrProjStructure

DDL: I_MSTRPROJSTRUCTURE SQL: IMSTRPROJSTRUCT Type: view COMPOSITE
23 Fields 3 Data Sources

Master Project Structure Element

I_MstrProjStructure is a Composite CDS View that provides data about "Master Project Structure Element" in SAP S/4HANA. It reads from 3 data sources (I_MasterProjectItemList, P_MstrProjStructure, I_Project) and exposes 23 fields.

Data Sources (3)

SourceAliasJoin Type
I_MasterProjectItemList MasterProject from
P_MstrProjStructure ProjCostObj inner
I_Project ProjectDefinition inner

Annotations (10)

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

Fields (23)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID I_MasterProjectItemList MasterProjectUUID NodeID
MasterProject I_MasterProjectItemList MasterProject Project ID
MasterProjectName I_MasterProjectItemList MasterProjectName
MasterProjectIsConfidential I_MasterProjectItemList MasterProjectIsConfidential
MasterProjectType I_MasterProjectItemList MasterProjectType
MasterProjectOrganization I_MasterProjectItemList MasterProjectOrganization
Currency I_MasterProjectItemList Currency Valuation Crcy
MasterProjectItemObjectType I_MasterProjectItemList MasterProjectItemObjectType
Project I_Project Project WBS Element
ProjectDescription I_Project ProjectDescription Project Name
ProjectObjectendasProjectObject
BusinessArea I_Project BusinessArea Business Area
CompanyCode I_Project CompanyCode Receiver Company Code
ControllingArea I_Project ControllingArea Controlling Area
ObjectName P_MstrProjStructure ObjectName Object name
ControllingObject P_MstrProjStructure ControllingObject Object number
OrderIDendasControllingObjectExternalID
ObjectInternalID P_MstrProjStructure ObjectInternalID Object number
MstrProjCutOffDate I_MasterProjectItemList MstrProjCutOffDate
ControllingObjectCurrency P_MstrProjStructure ControllingObjectCurrency CO Object Currency
WBSElementObject P_MstrProjStructure WBSElementObject Object number
WBSElement P_MstrProjStructure WBSElement WBS Internal ID
ExternalObjectIdentifier CProjectList ExternalObjectIdentifier

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_MstrProjStructure.
-- 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: IMSTRPROJSTRUCT

CREATE VIEW I_MstrProjStructure AS
SELECT
  MasterProject.MasterProjectUUID AS MasterProjectUUID,
  MasterProject.MasterProject AS MasterProject,
  MasterProject.MasterProjectName AS MasterProjectName,
  MasterProject.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  MasterProject.MasterProjectType AS MasterProjectType,
  MasterProject.MasterProjectOrganization AS MasterProjectOrganization,
  MasterProject.Currency AS Currency,
  MasterProject.MasterProjectItemObjectType AS MasterProjectItemObjectType,
  ProjectDefinition.Project AS Project,
  ProjectDefinition.ProjectDescription AS ProjectDescription,
  case when MasterProject.MasterProjectItemObjectType = '0DPO' then CProject.ProjectExternalID else ProjectDefinition.ProjectObject end as ProjectObject AS ProjectObjectendasProjectObject,
  ProjectDefinition.BusinessArea AS BusinessArea,
  ProjectDefinition.CompanyCode AS CompanyCode,
  ProjectDefinition.ControllingArea AS ControllingArea,
  ProjCostObj.ObjectName AS ObjectName,
  ProjCostObj.ControllingObject AS ControllingObject,
  case when ProjCostObj.ObjectSource = 'PRJ' then ProjCostObj.Project when ProjCostObj.ObjectSource = 'WBS' then ProjCostObj.WBSElement when ProjCostObj.ObjectSource = 'ORO' then (concat(ProjCostObj.OrderID, concat(' &', ProjCostObj.NetworkActivity))) else ProjCostObj.OrderID end as ControllingObjectExternalID AS OrderIDendasControllingObjectExternalID,
  ProjCostObj.ObjectInternalID AS ObjectInternalID,
  MasterProject.MstrProjCutOffDate AS MstrProjCutOffDate,
  ProjCostObj.ControllingObjectCurrency AS ControllingObjectCurrency,
  ProjCostObj.WBSElementObject AS WBSElementObject,
  ProjCostObj.WBSElement AS WBSElement,
  CProjectList.ExternalObjectIdentifier AS ExternalObjectIdentifier
FROM I_MasterProjectItemList AS MasterProject
INNER JOIN I_Project AS ProjectDefinition ON /* join condition not captured in parsed metadata */
INNER JOIN P_MstrProjStructure AS ProjCostObj ON /* join condition not captured in parsed metadata */
;

Learn More