I_MPNetwork

DDL: I_MPNETWORK SQL: IMPNTWRK Type: view COMPOSITE

Get Master Project Network

I_MPNetwork is a Composite CDS View that provides data about "Get Master Project Network" in SAP S/4HANA. It reads from 3 data sources (I_MasterProjectItemList, I_Project, I_ProjectNetwork) and exposes 11 fields with key fields MasterProject, ProjectNetwork.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
I_MasterProjectItemList MasterProject from
I_Project Project inner
I_ProjectNetwork ProjectNetwork inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPNTWRK 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 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 MasterProject I_MasterProjectItemList MasterProject
KEY ProjectNetwork I_ProjectNetwork ProjectNetwork
ProjectNetworkDescription I_ProjectNetwork ProjectNetworkDescription
MasterProjectName I_MasterProjectItemList MasterProjectName
MasterProjectItem I_MasterProjectItemList MasterProjectItem
ProjectDescription I_Project ProjectDescription
ProjectInternalID I_ProjectNetwork ProjectInternalID
ProjectNetworkInternalID I_ProjectNetwork ProjectNetworkInternalID
MasterProjectIsConfidential I_MasterProjectItemList MasterProjectIsConfidential
MasterProjectOrganization I_MasterProjectItemList MasterProjectOrganization
MasterProjectType I_MasterProjectItemList MasterProjectType 
@AbapCatalog.sqlViewName: 'IMPNTWRK'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Get Master Project Network'
@ClientHandling.algorithm: #SESSION_VARIABLE

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

define view I_MPNetwork 
    as select from I_MasterProjectItemList as MasterProject
    inner join I_Project                   as Project       on    MasterProject.MasterProjectItem = Project.ProjectObject
    inner join I_ProjectNetwork            as ProjectNetwork on    Project.ProjectInternalID       = ProjectNetwork.ProjectInternalID
{

key MasterProject.MasterProject,
key ProjectNetwork.ProjectNetwork,
    ProjectNetwork.ProjectNetworkDescription,
    MasterProject.MasterProjectName,
    MasterProject.MasterProjectItem,
    Project.ProjectDescription,
    ProjectNetwork.ProjectInternalID,
    ProjectNetwork.ProjectNetworkInternalID,
    
    //Exposed for DCL

    MasterProject.MasterProjectIsConfidential,
    MasterProject.MasterProjectOrganization,
    MasterProject.MasterProjectType
    
}
 
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MASTERPROJECTITEMLIST",
"I_PROJECT",
"I_PROJECTNETWORK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More