UPOV_NETOBJS

DDL: UPO_INT_V_NETOBJS SQL: UPOS_NETOBJS Type: view

Network Objects with Alternate Label

UPOV_NETOBJS is a CDS View that provides data about "Network Objects with Alternate Label" in SAP S/4HANA. It reads from 4 data sources (upoc_udm_alkey, upot_int_nobj, iflotx, gho_iflot_ext) and exposes 5 fields.

Data Sources (4)

SourceAliasJoin Type
upoc_udm_alkey alkeyobj inner
upot_int_nobj altLabel left_outer
iflotx funcloc_desc left_outer
gho_iflot_ext functionalloc from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_NETOBJS 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 Objects with Alternate Label view

Fields (5)

KeyFieldSource TableSource FieldDescription
tplnr gho_iflot_ext tplnr Functional loc.
alkey upoc_udm_alkey alkey Labeling system
strno
pltxt iflotx pltxt Description
pntimezone gho_iflot_ext gho_pn_tz Network Timezone

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view UPOV_NETOBJS.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: UPOS_NETOBJS

CREATE VIEW UPOV_NETOBJS AS
SELECT
  functionalloc.tplnr AS tplnr,
  alkeyobj.alkey AS alkey,
  cast(altLabel.converted_label as ilom_strno) AS strno,
  funcloc_desc.pltxt AS pltxt,
  functionalloc.gho_pn_tz AS pntimezone
FROM gho_iflot_ext AS functionalloc
INNER JOIN upoc_udm_alkey AS alkeyobj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN upot_int_nobj AS altLabel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN iflotx AS funcloc_desc ON /* join condition not captured in parsed metadata */
;