UPOV_NETOBJ_FROM_MODELING

DDL: UPO_INT_V_NETOBJ_FROM_MODELING SQL: UPOS_NOBJ_MODEL Type: view

Network Obects from UOM Modeling

UPOV_NETOBJ_FROM_MODELING is a CDS View that provides data about "Network Obects from UOM Modeling" in SAP S/4HANA. It reads from 6 data sources and exposes 11 fields.

6 data source(s) 11 fields

Data Sources (6)

SourceAliasJoin Type
gho_iflot_ext dn inner
gho_iflot_ext dn inner
gho_iflot_ext nobj inner
gho_iflot_ext nobj inner
inet objLink from
inet objLink union_all

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_NOBJ_MODEL view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Network Obects from UOM Modeling view

Fields (11)

KeyFieldSource TableSource FieldDescription
ProductionNetwork gho_iflot_ext tplnr
NetObject inet tpnach
datva inet datva
zeitva inet zeitva
datvb inet datvb
tplnrasProductionNetwork
NetObject inet tpvon
datva inet datva
zeitva inet zeitva
datvb inet datvb
zeitvb inet zeitvb 
@AbapCatalog.sqlViewName: 'UPOS_NOBJ_MODEL'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Network Obects from UOM Modeling'
define view UPOV_NETOBJ_FROM_MODELING
  as select from inet          as objLink
    inner join   gho_iflot_ext as dn   on  dn.netid           = objLink.netid
                                       and dn.gho_netobj_type = 'GHO_PN'
    inner join   gho_iflot_ext as nobj on nobj.tplnr = objLink.tpnach
{
  dn.tplnr            as ProductionNetwork,
  objLink.tpnach      as NetObject,
  nobj.gho_netobj_type,
  objLink.datva       as datva,
  objLink.zeitva      as zeitva,
  objLink.datvb       as datvb,
  objLink.zeitvb      as zeitvb
}
where
      objLink.kante <> ''
  and objLink.mlang = $session.system_language
  and objLink.netid <> ''


union all select from inet          as objLink
  inner join          gho_iflot_ext as dn   on  dn.netid           = objLink.netid
                                            and dn.gho_netobj_type = 'GHO_PN'
  inner join          gho_iflot_ext as nobj on nobj.tplnr = objLink.tpvon
{
  dn.tplnr            as ProductionNetwork,
  objLink.tpvon       as NetObject,
  nobj.gho_netobj_type,
  objLink.datva       as datva,
  objLink.zeitva      as zeitva,
  objLink.datvb       as datvb,
  objLink.zeitvb      as zeitvb
}
where
      objLink.kante <> ''
  and objLink.mlang = $session.system_language
  and objLink.netid <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"GHO_IFLOT_EXT",
"INET"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More