I_MPWBSElement

DDL: I_MPWBSELEMENT SQL: IMPWBS Type: view COMPOSITE Package: VDM_CPM_WS

Get Master Project WBS Elements

I_MPWBSElement is a Composite CDS View that provides data about "Get Master Project WBS Elements" in SAP S/4HANA. It reads from 3 data sources (I_MasterProjectItemList, I_Project, I_WBSElement) and exposes 11 fields with key field WBSElement. Part of development package VDM_CPM_WS.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
I_MasterProjectItemList MasterProject from
I_Project ProjectDefinition inner
I_WBSElement WBSElement inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPWBS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
EndUserText.label Get Master Project WBS Elements view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY WBSElement I_WBSElement WBSElement
WBSElementShortID I_WBSElement WBSElementShortID
MasterProject I_MasterProjectItemList MasterProject
MasterProjectName I_MasterProjectItemList MasterProjectName
MasterProjectItem I_MasterProjectItemList MasterProjectItem
WBSElementInternalID I_WBSElement WBSElementInternalID
WBSDescription I_WBSElement WBSDescription
WBSElementObject I_WBSElement WBSElementObject
MasterProjectIsConfidential I_MasterProjectItemList MasterProjectIsConfidential
MasterProjectOrganization I_MasterProjectItemList MasterProjectOrganization
MasterProjectType I_MasterProjectItemList MasterProjectType 
@AbapCatalog.sqlViewName: 'IMPWBS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Get Master Project WBS Elements'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED


define view I_MPWBSElement  
    as select from I_MasterProjectItemList as MasterProject
    inner join     I_Project               as ProjectDefinition on MasterProject.MasterProjectItem = ProjectDefinition.ProjectObject 
    inner join     I_WBSElement            as WBSElement        on ProjectDefinition.Project       = WBSElement.Project   
{
        key WBSElement.WBSElement,
        WBSElement.WBSElementShortID,
        MasterProject.MasterProject,
        MasterProject.MasterProjectName,
        MasterProject.MasterProjectItem,
        WBSElement.WBSElementInternalID,
        WBSElement.WBSDescription,
        WBSElement.WBSElementObject,
        
        //Exposed for DCL

        MasterProject.MasterProjectIsConfidential,
        MasterProject.MasterProjectOrganization,
        MasterProject.MasterProjectType
        
}

Learn More