I_MstrProjWBSElement

DDL: I_MSTRPROJWBSELEMENT SQL: IWBSELEMPRJCMPA Type: view COMPOSITE

PROJECT COMPANION WBS ELEM

I_MstrProjWBSElement is a Composite CDS View that provides data about "PROJECT COMPANION WBS ELEM" in SAP S/4HANA. It reads from 3 data sources (I_MasterProjectItemList, I_Project, I_WBSElement) and exposes 16 fields. It has 1 association to related views.

3 data source(s) 16 fields

Data Sources (3)

SourceAliasJoin Type
I_MasterProjectItemList MasterProject from
I_Project ProjectDefinition inner
I_WBSElement WBSElement inner

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_MstrProjTeamRespy _TeamMembers $projection.WBSElementObject = _TeamMembers.WBSElementObject

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWBSELEMPRJCMPA view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label PROJECT COMPANION WBS ELEM view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (16)

KeyFieldSource TableSource FieldDescription
MasterProject I_MasterProjectItemList MasterProject
MasterProjectUUID I_MasterProjectItemList MasterProjectUUID
MasterProjectIsConfidential I_MasterProjectItemList MasterProjectIsConfidential
MasterProjectOrganization I_MasterProjectItemList MasterProjectOrganization
MasterProjectType I_MasterProjectItemList MasterProjectType
WBSElementObject I_WBSElement WBSElementObject
WBSElement I_WBSElement WBSElement
WBSDescription I_WBSElement WBSDescription
WBSElementHierarchyLevel I_WBSElement WBSElementHierarchyLevel
BasicStartDate I_WBSElement BasicStartDate
BasicEndDate I_WBSElement BasicEndDate
CreationDate I_WBSElement CreationDate
CreatedByUser I_WBSElement CreatedByUser
LastChangedByUser I_WBSElement LastChangedByUser
LastChangeDate I_WBSElement LastChangeDate
_TeamMembers _TeamMembers 
@AbapCatalog.sqlViewName: 'IWBSELEMPRJCMPA'
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'PROJECT COMPANION WBS ELEM'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MIXED
define view I_MstrProjWBSElement 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
    association [1..*] to I_MstrProjTeamRespy            as _TeamMembers            on  $projection.WBSElementObject = _TeamMembers.WBSElementObject
 {

        MasterProject.MasterProject as MasterProject,
        MasterProject.MasterProjectUUID,
        MasterProject.MasterProjectIsConfidential,
        MasterProject.MasterProjectOrganization,
        MasterProject.MasterProjectType,
//        ProjectDefinition._WBSElement.WBSElementObject as WBSElementObject,

//        ProjectDefinition._WBSElement.WBSElement as WBSElement,

//        ProjectDefinition._WBSElement.WBSDescription as WBSDescription,

//        ProjectDefinition._WBSElement.WBSElementHierarchyLevel as WBSElementHierarchyLevel,

//        ProjectDefinition._WBSElement.BasicStartDate as BasicStartDate,

//        ProjectDefinition._WBSElement.BasicEndDate as BasicEndDate,

//        ProjectDefinition._WBSElement.CreationDate as CreationDate,

//        ProjectDefinition._WBSElement.CreatedByUser as CreatedByUser,

//        ProjectDefinition._WBSElement.LastChangedByUser as LastChangedByUser,

//        ProjectDefinition._WBSElement.LastChangeDate,

        WBSElement.WBSElementObject as WBSElementObject,
        WBSElement.WBSElement as WBSElement,
        WBSElement.WBSDescription as WBSDescription,
        WBSElement.WBSElementHierarchyLevel as WBSElementHierarchyLevel,
        WBSElement.BasicStartDate as BasicStartDate,
        WBSElement.BasicEndDate as BasicEndDate,
        WBSElement.CreationDate as CreationDate,
        WBSElement.CreatedByUser as CreatedByUser,
        WBSElement.LastChangedByUser as LastChangedByUser,
        WBSElement.LastChangeDate,
        _TeamMembers

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

Learn More