I_MstrProjStrctrElmntWBC

DDL: I_MSTRPROJSTRCTRELMNTWBC SQL: IMPSTRELMNWBS Type: view COMPOSITE

Master Project Structure Element for WBC

I_MstrProjStrctrElmntWBC is a Composite CDS View that provides data about "Master Project Structure Element for WBC" in SAP S/4HANA. It reads from 7 data sources and exposes 41 fields.

7 data source(s) 41 fields

Data Sources (7)

SourceAliasJoin Type
iaom_cpro_exat CProject inner
I_MasterProjectItemList MasterProject from
I_MasterProjectItemList MasterProject union
P_WBSObject ProjCostObj inner
P_WBSObject ProjCostObj inner
I_Project ProjectDefinition inner
I_Project ProjectDefinition inner

Annotations (10)

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

Fields (41)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID I_MasterProjectItemList MasterProjectUUID
MasterProject I_MasterProjectItemList MasterProject
MasterProjectName I_MasterProjectItemList MasterProjectName
MasterProjectIsConfidential I_MasterProjectItemList MasterProjectIsConfidential
MasterProjectType I_MasterProjectItemList MasterProjectType
MasterProjectStage I_MasterProjectItemList MasterProjectStage
MasterProjectOrganization I_MasterProjectItemList MasterProjectOrganization
UserIsInvolved I_MasterProjectItemList UserIsInvolved
Project I_Project Project
ProjectDescription I_Project ProjectDescription
BusinessArea I_Project BusinessArea
CompanyCode I_Project CompanyCode
ControllingArea I_Project ControllingArea
ProfitCenter I_Project ProfitCenter
ResponsiblePerson I_Project ResponsiblePerson
WBSElementIsBillingElement P_WBSObject WBSElementIsBillingElement
WBSElementShortID P_WBSObject WBSElementShortID
ControllingObjectDescription P_WBSObject WBSDescription
ControllingObject P_WBSObject WBSElementObject
ControllingObjectExternalID P_WBSObject Object
MasterProjectUUID
MasterProject I_MasterProjectItemList MasterProject
MasterProjectName I_MasterProjectItemList MasterProjectName
MasterProjectIsConfidential I_MasterProjectItemList MasterProjectIsConfidential
MasterProjectType I_MasterProjectItemList MasterProjectType
MasterProjectStage I_MasterProjectItemList MasterProjectStage
MasterProjectOrganization I_MasterProjectItemList MasterProjectOrganization
UserIsInvolved I_MasterProjectItemList UserIsInvolved
Project I_Project Project
ProjectDescription I_Project ProjectDescription
BusinessArea I_Project BusinessArea
CompanyCode I_Project CompanyCode
ControllingArea I_Project ControllingArea
ProfitCenter I_Project ProfitCenter
ResponsiblePerson I_Project ResponsiblePerson
WBSElementIsBillingElement P_WBSObject WBSElementIsBillingElement
WBSElementShortID P_WBSObject WBSElementShortID
ControllingObjectDescription P_WBSObject WBSDescription
ControllingObject P_WBSObject WBSElementObject
ControllingObjectExternalID P_WBSObject Object
ObjectInternalID P_WBSObject ObjectInternalID 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IMPSTRELMNWBS'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Project Structure Element for WBC'
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #REQUIRED

define view I_MstrProjStrctrElmntWBC
  as select from I_MasterProjectItemList as MasterProject
    inner join   I_Project               as ProjectDefinition on MasterProject.MasterProjectItem = ProjectDefinition.ProjectObject
    inner join   P_WBSObject             as ProjCostObj       on ProjectDefinition.Project = ProjCostObj.Project
{
  MasterProject.MasterProjectUUID,
  MasterProject.MasterProject,
  MasterProject.MasterProjectName,
  MasterProject.MasterProjectIsConfidential,
  MasterProject.MasterProjectType,
  MasterProject.MasterProjectStage,
  MasterProject.MasterProjectOrganization,
  MasterProject.UserIsInvolved,

  ProjectDefinition.Project,
  ProjectDefinition.ProjectDescription,
  ProjectDefinition.BusinessArea,
  ProjectDefinition.CompanyCode,
  ProjectDefinition.ControllingArea,
  ProjectDefinition.ProfitCenter,
  ProjectDefinition.ResponsiblePerson,
  ProjCostObj.WBSElementIsBillingElement,
  ProjCostObj.WBSElementShortID,
  ProjCostObj.WBSDescription    as ControllingObjectDescription,
  ProjCostObj.WBSElementObject  as ControllingObject,
  ProjCostObj.Object            as ControllingObjectExternalID,
  case when ProjCostObj.ObjectType = 'PR'
  then 'WBS'
  end                           as ControllingObjectType,
  ProjCostObj.ObjectInternalID

} where MasterProject.MasterProjectItemObjectType = '0PD'

union select from I_MasterProjectItemList as MasterProject
    inner join   iaom_cpro_exat          as CProject          on MasterProject.MasterProjectItem = CProject.ext_object_id
    inner join   I_Project               as ProjectDefinition on CProject.project_id = ProjectDefinition.Project
    inner join   P_WBSObject             as ProjCostObj       on ProjectDefinition.Project = ProjCostObj.Project
{
  MasterProject.MasterProjectUUID,
  MasterProject.MasterProject,
  MasterProject.MasterProjectName,
  MasterProject.MasterProjectIsConfidential,
  MasterProject.MasterProjectType,
  MasterProject.MasterProjectStage,
  MasterProject.MasterProjectOrganization,
  MasterProject.UserIsInvolved,

  ProjectDefinition.Project,
  ProjectDefinition.ProjectDescription,
  ProjectDefinition.BusinessArea,
  ProjectDefinition.CompanyCode,
  ProjectDefinition.ControllingArea,
  ProjectDefinition.ProfitCenter,
  ProjectDefinition.ResponsiblePerson,
  ProjCostObj.WBSElementIsBillingElement,
  ProjCostObj.WBSElementShortID,
  ProjCostObj.WBSDescription    as ControllingObjectDescription,
  ProjCostObj.WBSElementObject  as ControllingObject,
  ProjCostObj.Object            as ControllingObjectExternalID,
  case when ProjCostObj.ObjectType = 'PR'
  then 'WBS'
  end                           as ControllingObjectType,
  ProjCostObj.ObjectInternalID

} where MasterProject.MasterProjectItemObjectType = '0DPO'







/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MASTERPROJECTITEMLIST",
"I_PROJECT",
"P_WBSOBJECT",
"IAOM_CPRO_EXAT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More