I_MstrProjStructureElement

DDL: I_MSTRPROJSTRUCTUREELEMENT SQL: IMPSTRUCTURE Type: view COMPOSITE Package: VDM_CPM_WS

Master Project Structure Element

I_MstrProjStructureElement 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, I_ProjectCostObject, I_Project) and exposes 35 fields. Part of development package VDM_CPM_WS.

3 data source(s) 35 fields

Data Sources (3)

SourceAliasJoin Type
I_MasterProjectItemList MasterProject from
I_ProjectCostObject ProjectCostObject inner
I_Project ProjectDefinition inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMPSTRUCTURE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED 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
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_MPStructureElement view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (35)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID I_MasterProjectItemList MasterProjectUUID
MasterProject I_MasterProjectItemList MasterProject
MasterProjectName I_MasterProjectItemList MasterProjectName
MasterProjectType I_MasterProjectItemList MasterProjectType
MasterProjectStage I_MasterProjectItemList MasterProjectStage
StartDate I_MasterProjectItemList StartDate
EndDate I_MasterProjectItemList EndDate
Customer I_MasterProjectItemList Customer
MasterProjectOrganization I_MasterProjectItemList MasterProjectOrganization
MasterProjectIsConfidential I_MasterProjectItemList MasterProjectIsConfidential
Country I_MasterProjectItemList Country
Region I_MasterProjectItemList Region
WorkType I_MasterProjectItemList WorkType
Industry I_MasterProjectItemList Industry
ProjectRisk I_MasterProjectItemList ProjectRisk
FinancialRisk I_MasterProjectItemList FinancialRisk
TechnicalRisk I_MasterProjectItemList TechnicalRisk
OverallRisk I_MasterProjectItemList OverallRisk
MasterProjectItemUUID I_MasterProjectItemList MasterProjectItemUUID
MasterProjectItemObjectType I_MasterProjectItemList MasterProjectItemObjectType
MasterProjectItem I_MasterProjectItemList MasterProjectItem
CreatedByUser I_MasterProjectItemList CreatedByUser
CreationDateTime I_MasterProjectItemList CreationDateTime
LastChangedByUser I_MasterProjectItemList LastChangedByUser
LastChangeDateTime I_MasterProjectItemList LastChangeDateTime
Project I_Project Project
WBSElement I_ProjectCostObject WBSElement
CompanyCode I_ProjectCostObject CompanyCode
BusinessArea I_ProjectCostObject BusinessArea
ControllingArea I_ProjectCostObject ControllingArea
ControllingObject I_ProjectCostObject ControllingObject
ControllingAreaCurrency I_ProjectCostObject ControllingAreaCurrency
WBSElementInternalID I_ProjectCostObject WBSElementInternalID
ControllingObjectInternalID I_ProjectCostObject ControllingObjectInternalID
WBSElementObject I_ProjectCostObject WBSElementObject 
@AbapCatalog.sqlViewName: 'IMPSTRUCTURE'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Master Project Structure Element'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE

//@VDM.lifecycle.contract.status: #DEPRECATED                                               NOTE:2948213

//@VDM.lifecycle.contract.successor: 'I_MPStructureElement'                                 NOTE:2948213

@VDM.lifecycle.status: #DEPRECATED                                                          //NOTE:2948213

@VDM.lifecycle.successor: 'I_MPStructureElement'                                            //NOTE:2948213

@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
define view I_MstrProjStructureElement
  as select from I_MasterProjectItemList as MasterProject
    inner join   I_Project               as ProjectDefinition on MasterProject.MasterProjectItem = ProjectDefinition.ProjectObject
    inner join   I_ProjectCostObject     as ProjectCostObject on ProjectDefinition.Project = ProjectCostObject.Project
{
  MasterProject.MasterProjectUUID,
  MasterProject.MasterProject,
  MasterProject.MasterProjectName,
  MasterProject.MasterProjectType,
  MasterProject.MasterProjectStage,
  MasterProject.StartDate,
  MasterProject.EndDate,
  MasterProject.Customer,
  MasterProject.MasterProjectOrganization,
  MasterProject.MasterProjectIsConfidential,
  MasterProject.Country,
  MasterProject.Region,
  MasterProject.WorkType,
  MasterProject.Industry,
  MasterProject.ProjectRisk,
  MasterProject.FinancialRisk,
  MasterProject.TechnicalRisk,
  MasterProject.OverallRisk,

  //MasterProject.Currency,

  MasterProject.MasterProjectItemUUID,
  // MasterProject.MstrProjParentkeyOfItem,

  MasterProject.MasterProjectItemObjectType,
  MasterProject.MasterProjectItem,
  MasterProject.CreatedByUser,
  MasterProject.CreationDateTime,
  MasterProject.LastChangedByUser,
  MasterProject.LastChangeDateTime,
  ProjectDefinition.Project,
  ProjectCostObject.WBSElement,
  ProjectCostObject.CompanyCode,
  ProjectCostObject.BusinessArea,
  ProjectCostObject.ControllingArea,
  ProjectCostObject.ControllingObject,
  ProjectCostObject.ControllingAreaCurrency,
  ProjectCostObject.WBSElementInternalID,
  ProjectCostObject.ControllingObjectInternalID,
  ProjectCostObject.WBSElementObject
}

Learn More