UPOV_NETOBJS_NETWORK

@AbapCatalog.sqlViewName: 'UPOS_NETOBJS_NW'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@EndUserText.label: 'Network Objects with Network Details'
define view UPOV_NETOBJS_NETWORK
  as select from    inet             as inet
    inner join      gho_iflot_ext    as floc       on floc.netid             = inet.netid
                                                   and(
                                                     floc.gho_netobj_type    = 'GHO_PN'
                                                     or floc.gho_netobj_type = 'GHO_FS'
                                                   )
    left outer join UPOV_NETOBJS     as pn_label   on pn_label.tplnr = floc.tplnr

    left outer join UPOV_NETOBJS     as from_label on from_label.tplnr = inet.tpvon
    left outer join UPOV_NETOBJS     as to_label   on to_label.tplnr = inet.tpnach

    //left outer join UPOV_MIGRATED_DN as mig_dn     on mig_dn.dn_strno = pn_label.strno


{
//  cast(

//  case

//  when mig_dn.dn_no is not null then  mig_dn.status

//  else 'U'

//  end     as upo_mig_status)                           as status,

  floc.tplnr                                           as pn_floc,
  inet.tpvon                                           as from_floc,
  inet.tpnach                                          as to_floc,
  from_label.gho_netobj_type                           as from_netobj_type,
  to_label.gho_netobj_type                             as to_netobj_type,
  pn_label.strno                                       as pn_label,
  from_label.strno                                     as from_label,
  to_label.strno                                       as to_label,

  inet.datva                                           as datva,
  inet.zeitva                                          as zeita,
  inet.datvb                                           as datvb,
  inet.zeitvb                                          as zeitb
}
where
      inet.mlang  = $session.system_language
  and inet.kantyp =  'T'
  and inet.netid  <> ''