I_PROJECTNETWORKRELATIONSHIP

CDS View

Project Network Relationships

I_PROJECTNETWORKRELATIONSHIP is a CDS View in S/4HANA. Project Network Relationships. It contains 19 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 19 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_ProjectNetworkRelationship view from CONSUMPTION Project Network Relationship
C_RSHOperationRelationships view from CONSUMPTION Operation Relationships for display on the Gantt Chart
I_MfgOrderOpRelationship view_entity from COMPOSITE Relationships of Manufacturing Orders
I_NtwkActRelationshipBasicData view from COMPOSITE Network Activity Relationship Basic Data
I_ProcOrdOpsMgmtRelationships view inner COMPOSITE Process Order Operations Relationships
I_ProjNtwkActRltnByProjNtwkAct view from COMPOSITE Relationships for Project Network Activity
I_ProjNtwkActRltnByProjNtwkAct view union_all COMPOSITE Relationships for Project Network Activity
P_RSHOperationExplicitRelation view from CONSUMPTION Operations with explicit Relations
P_RSHOperationsWOExplicitRelat view left_outer CONSUMPTION Operations without explicit Relations
P_SchedProdnOperReln view from BASIC

Fields (19)

KeyField CDS FieldsUsed in Views
KEY MaxTimeIntvlIsUsedForSchedg MaxTimeIntvlIsUsedForSchedg 1
KEY NetworkActivityRelationType NetworkActivityRelationType 2
KEY PredecessorNtwkActyIntID NetworkActivityInternalID,PredecessorNtwkActyIntID,ReltdNetworkActivityInternalID 2
KEY PredecessorProjNtwkIntID PredecessorProjNtwkIntID,ProjectNetworkInternalID,ReltdProjNetworkInternalID 2
KEY SuccessorNtwkActyIntID NetworkActivityInternalID,ReltdNetworkActivityInternalID,SuccessorNtwkActyIntID 2
KEY SuccessorProjNtwkIntID ReltdProjNetworkInternalID,SuccessorProjNtwkIntID 2
_FactoryCalendarText _FactoryCalendarText 1
_RelshpTypeText _RelshpTypeText 1
_WorkCenter _WorkCenter 1
FactoryCalendar FactoryCalendar 2
MaxTimeIntvlBtwnRelshp MaxTimeIntvlBtwnRelshp 1
NetworkActivityIntmsnDuration NetworkActivityIntmsnDuration,OpRelationshipTimeIntervalDurn 2
NetworkActivityIntmsnDurnUnit NetworkActivityIntmsnDurnUnit,OpRelationshipTimeIntervalUnit 2
ObjectIsDeleted IsMarkedForDeletion,ObjectIsDeleted 2
Plant Plant 2
ProjectNetworkObject ObjectInternalID 1
TimeInterval TimeInterval 2
TimeIntvlBtwnRelshpInPct TimeIntvlBtwnRelshpInPct 2
WorkCenterInternalID WorkCenterInternalID 2 
@AbapCatalog.sqlViewName: 'IPROJNTWKREL'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Project Network Relationships'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view I_ProjectNetworkRelationship
  as select from afab

  association [0..1] to I_WorkCenter                 as _WorkCenter          on  _WorkCenter.WorkCenterInternalID = $projection.WorkCenterInternalID
                                                                             and _WorkCenter.WorkCenterTypeCode   = 'A'
  association [0..1] to I_FactoryCalendarText        as _FactoryCalendarText on  _FactoryCalendarText.FactoryCalendar = $projection.FactoryCalendar
                                                                             and _FactoryCalendarText.Language        = $session.system_language
  association [0..1] to I_MasterRecipeRelshpTypeText as _RelshpTypeText      on  _RelshpTypeText.PhaseRelationshipTypeKey = $projection.NetworkActivityRelationType
                                                                             and _RelshpTypeText.Language                 = $session.system_language

{
  key aufpl_vor                     as PredecessorProjNtwkIntID,
  key aplzl_vor                     as PredecessorNtwkActyIntID,
  key aufpl_nch                     as SuccessorProjNtwkIntID,
  key aplzl_nch                     as SuccessorNtwkActyIntID,
  key cast ( aobar as ps_s4_aobar ) as NetworkActivityRelationType,
  key mimax                         as MaxTimeIntvlIsUsedForSchedg,
      objnr                         as ProjectNetworkObject,
      @Semantics.quantity.unitOfMeasure: 'NetworkActivityIntmsnDurnUnit'
      dauer                         as NetworkActivityIntmsnDuration,
      // begin - added to extend I_MfgOrderOpRelationship with GFN MaxTimeIntvlBtwnRelshp for CDS Extension Order Relationship AOB

      @Semantics.quantity.unitOfMeasure: 'NetworkActivityIntmsnDurnUnit'
      dauermax                      as MaxTimeIntvlBtwnRelshp,
      // end - added to extend I_MfgOrderOpRelationship with GFN MaxTimeIntvlBtwnRelshp for CDS Extension Order Relationship AOB

      @Semantics.unitOfMeasure: true
      zeinh                         as NetworkActivityIntmsnDurnUnit,
      loekz                         as ObjectIsDeleted,
      prznt                         as TimeIntvlBtwnRelshpInPct,
      provg                         as TimeInterval,
      kalid                         as FactoryCalendar,
      werks                         as Plant,
      arbid                         as WorkCenterInternalID,

      _WorkCenter,
      _FactoryCalendarText,
      _RelshpTypeText
}

Learn More