UPOV_NETOBJS

CDS View

Network Objects with Alternate Label

UPOV_NETOBJS is a CDS View in S/4HANA. Network Objects with Alternate Label. It contains 2 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
UPOV_DEFERMENTEVENT_BA view left_outer Deferment Event Before After image
UPOV_NETOBJ_WITH_STATUS view left_outer Netobjects with Source Status
UPOV_NETOBJS_NETWORK view left_outer Network Objects with Network Details
UPOV_NWMODELLING_BA view left_outer Network Modelling PPA before after data
UPOV_PPN_DATED_BA view left_outer PPA FOR DATED
UPOV_PPN_MP_BA_UOM view left_outer Event Detail Ref - Before/After data
UPOV_PPN_NETRULE_BA view left_outer Event Detail Ref - Before/After data
UPOV_PPN_NODERULE_BA_UOM view left_outer Event Detail Ref - Before/After data
UPOV_PPN_SET_MP view left_outer PPN for Measurement Point
UPOV_PPN_SET_WC view left_outer PPN for Well Test
UPOV_PPN_WCVOLUME_BA view left_outer WC Volumes Before After Data
UPOV_PPN_WLT_BA view left_outer Event Detail Ref - Before/After data
UPOV_PPN_ZONAL_BA view left_outer PPN for zonal contribution
UPOV_PR_WC_MEAS_UOM view left_outer Well Completion Measurement UOM Data

Fields (2)

KeyField CDS FieldsUsed in Views
gho_netobj_type from_netobj_type,to_netobj_type 1
strno from_label,pn_label,to_label 1
@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
}