I_MSTRPROJSTRCTRELMNTWBC

CDS View

Master Project Structure Element for WBC

I_MSTRPROJSTRCTRELMNTWBC is a CDS View in S/4HANA. Master Project Structure Element for WBC. It contains 9 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 9 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MPStructureElementVH view from COMPOSITE Master Project Structure Element
P_MPStructureElement view from COMPOSITE Master Project Structure Element

Fields (9)

KeyField CDS FieldsUsed in Views
KEY MasterProject MasterProject 1
ControllingObjectDescription ControllingObjectDescription 1
MasterProjectIsConfidential MasterProjectIsConfidential 1
MasterProjectName MasterProjectName 1
MasterProjectOrganization MasterProjectOrganization 1
MasterProjectType MasterProjectType 1
MasterProjectUUID MasterProjectUUID 1
UserIsInvolved UserIsInvolved 1
WBSElementIsBillingElement WBSElementIsBillingElement 1 
@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'

Learn More