I_MPNetworkActivity

DDL: I_MPNETWORKACTIVITY SQL: IMPNWACT Type: view COMPOSITE

Get Master Project Network Activity

I_MPNetworkActivity is a Composite CDS View that provides data about "Get Master Project Network Activity" in SAP S/4HANA. It reads from 2 data sources (I_MasterProjectItemList, I_NetworkActivity) and exposes 12 fields with key fields MasterProject, ProjectNetwork.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_MasterProjectItemList MasterProject from
I_NetworkActivity NetworkActivity inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPNWACT 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 Network Activity view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MasterProject I_MasterProjectItemList MasterProject
KEY ProjectNetwork I_NetworkActivity ProjectNetwork
NetworkActivity I_NetworkActivity NetworkActivity
NetworkActivityDescription I_NetworkActivity NetworkActivityDescription
MasterProjectName I_MasterProjectItemList MasterProjectName
MasterProjectItem I_MasterProjectItemList MasterProjectItem
ProjectNetworkInternalID I_NetworkActivity ProjectNetworkInternalID
NetworkActivityInternalID I_NetworkActivity NetworkActivityInternalID
NetworkActivityObject
MasterProjectIsConfidential I_MasterProjectItemList MasterProjectIsConfidential
MasterProjectOrganization I_MasterProjectItemList MasterProjectOrganization
MasterProjectType I_MasterProjectItemList MasterProjectType 
@AbapCatalog.sqlViewName: 'IMPNWACT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Get Master Project Network Activity'
@ClientHandling.algorithm: #SESSION_VARIABLE

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



define view I_MPNetworkActivity 
    as select from I_MasterProjectItemList as MasterProject
    inner join I_NetworkActivity as NetworkActivity on MasterProject.MasterProjectItem = NetworkActivity.ProjectObject
                                            
 {
 
 key    MasterProject.MasterProject,
 key    NetworkActivity.ProjectNetwork,
        NetworkActivity.NetworkActivity,
        NetworkActivity.NetworkActivityDescription,
        MasterProject.MasterProjectName,
        MasterProject.MasterProjectItem,
        NetworkActivity.ProjectNetworkInternalID,
        NetworkActivity.NetworkActivityInternalID,
        
        concat(concat(NetworkActivity.ProjectNetwork,'-'), NetworkActivity.NetworkActivity) as NetworkActivityObject,
        //for getting Network and Network Activity together in one column

        
        //Exposed for DCL

        MasterProject.MasterProjectIsConfidential,
        MasterProject.MasterProjectOrganization,
        MasterProject.MasterProjectType
        
        
        
        
    //case NetworkActivity

    //when 

     //   '0000'

    //then 

       // NetworkActivity.ProjectNetwork

    //else 

    
    
        
        
        
        
   // end as 

 }

Learn More