C_ProjectNetworkRelationship

@AbapCatalog.sqlViewName: 'CPRNTWKREL'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Project Network Relationship'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #CONSUMPTION

define view C_ProjectNetworkRelationship
  as select from I_ProjectNetworkRelationship

  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

  association [0..1] to I_NetworkActivityByInternalKey as _NetworkActivityPredecessor on  (
      _NetworkActivityPredecessor.ProjectNetworkInternalID      = $projection.PredecessorProjNtwkIntID
      and _NetworkActivityPredecessor.NetworkActivityInternalID = $projection.PredecessorNtwkActyIntID
    )
  association [0..1] to I_NetworkActivityByInternalKey as _NetworkActivitySuccessor   on  (
        _NetworkActivitySuccessor.ProjectNetworkInternalID      = $projection.SuccessorProjNtwkIntID
        and _NetworkActivitySuccessor.NetworkActivityInternalID = $projection.SuccessorNtwkActyIntID
      )

  association [0..1] to I_ProjectNetworkBasicData      as _ProjectNetworkPredecessor  on  (
       _ProjectNetworkPredecessor.ProjectNetworkInternalID = $projection.PredecessorProjNtwkIntID
     )

  association [0..1] to I_ProjectNetworkBasicData      as _ProjectNetworkSuccessor    on  (
         _ProjectNetworkSuccessor.ProjectNetworkInternalID = $projection.SuccessorProjNtwkIntID
       )

  association [0..1] to I_ProjSchedMaintOrderData      as _MaintOrderPredecessor      on  (
           _MaintOrderPredecessor.OrderInternalBillOfOperations = $projection.PredecessorProjNtwkIntID
         )

  association [0..1] to I_ProjSchedMaintOrderData      as _MaintOrderSuccessor        on  (
             _MaintOrderSuccessor.OrderInternalBillOfOperations = $projection.SuccessorProjNtwkIntID
           )

  association [0..1] to I_NtwkActTimeIntervalRelshpVH  as _TimeIntervalVH             on  _TimeIntervalVH.DomainValue = $projection.TimeInterval
                                                                                      and _TimeIntervalVH.Language    = $session.system_language

  association [0..1] to I_WorkCenterVH                 as _WorkCenterVH               on  _WorkCenterVH.WorkCenterInternalID = $projection.WorkCenterInternalID
                                                                                      and _WorkCenterVH.WorkCenterTypeCode   = 'A'
{
  key PredecessorProjNtwkIntID,
  key PredecessorNtwkActyIntID,
  key SuccessorProjNtwkIntID,
  key SuccessorNtwkActyIntID,
  key NetworkActivityRelationType,
  key MaxTimeIntvlIsUsedForSchedg,
      @EndUserText.label: 'Relationship Description'
      _RelshpTypeText.PhaseRelationshipTypeDesc                                                        as NetworkActyRelationDescription,
      ProjectNetworkObject,
      NetworkActivityIntmsnDuration,
      NetworkActivityIntmsnDurnUnit,
      ObjectIsDeleted,
      cast (ltrim(TimeIntvlBtwnRelshpInPct, '0') as aob_prznt )                                        as TimeIntvlBtwnRelshpInPct,
      TimeInterval,
      @EndUserText.label: 'Time Interval Key'
      _TimeIntervalVH.DomainValueName,
      FactoryCalendar,
      _FactoryCalendarText.FactoryCalendarName,
      Plant,
      WorkCenterInternalID,
      _WorkCenterVH.WorkCenter                                                                         as WorkCenter,
      cast(substring(_NetworkActivityPredecessor.NetworkActivityObject,1,2) as ps_project_object_type) as ProjectObjectNodeType,
      _ProjectNetworkPredecessor.ProjectNetwork                                                        as PredecessorProjectNetwork,
      _NetworkActivityPredecessor.NetworkActivity                                                      as PredecessorNetworkActivity,
      _NetworkActivityPredecessor.NetworkActivityObject                                                as PredecessorProjectObjectNode,
       case 
       when _NetworkActivityPredecessor._ActivityShortText.LanguageBasedShortText is not initial
       then _NetworkActivityPredecessor._ActivityShortText.LanguageBasedShortText
       else _NetworkActivityPredecessor.NetworkActivityDescription
       end as PredecessorNtwkActDescription, 
      //_NetworkActivityPredecessor.NetworkActivityDescription                                           as PredecessorNtwkActDescription,

      _ProjectNetworkSuccessor.ProjectNetwork                                                          as SuccessorProjectNetwork,
      _NetworkActivitySuccessor.NetworkActivity                                                        as SuccessorNetworkActivity,
      _NetworkActivitySuccessor.NetworkActivityObject                                                  as SuccessorProjectObjectNode,
       case 
       when _NetworkActivitySuccessor._ActivityShortText.LanguageBasedShortText is not initial
       then _NetworkActivitySuccessor._ActivityShortText.LanguageBasedShortText
       else _NetworkActivitySuccessor.NetworkActivityDescription
       end as SuccessorNtwkActyDescription, 
      //_NetworkActivitySuccessor.NetworkActivityDescription                                             as SuccessorNtwkActyDescription,


      _FactoryCalendarText,
      _WorkCenterVH,
      _NetworkActivityPredecessor,
      _NetworkActivitySuccessor,
      _TimeIntervalVH,
      _RelshpTypeText,
      _ProjectNetworkPredecessor,
      _ProjectNetworkSuccessor,
      _MaintOrderPredecessor,
      _MaintOrderSuccessor
}