UPOV_NETOBJS

@AbapCatalog.sqlViewName: 'UPOS_NETOBJS'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Network Objects with Alternate Label'
define view UPOV_NETOBJS
  as select from    gho_iflot_ext  as functionalloc
    inner join      upoc_udm_alkey as alkeyobj     on alkeyobj.gho_netobj_type = functionalloc.gho_netobj_type
    left outer join upot_int_nobj  as altLabel     on altLabel.tplnr = functionalloc.tplnr
    left outer join iflotx         as funcloc_desc on  funcloc_desc.tplnr = functionalloc.tplnr
                                                   and funcloc_desc.spras = $session.system_language

{
  functionalloc.tplnr                                                       as tplnr,
  functionalloc.gho_netobj_type                                             as gho_netobj_type,
  alkeyobj.alkey                                                            as alkey,
  cast(altLabel.converted_label as ilom_strno)                              as strno,
  funcloc_desc.pltxt,
  functionalloc.gho_pn_tz                                                   as pntimezone
}