UPOV_PR_ALKEY_OBJ

DDL: UPO_INT_V_ALKEY_VIEW SQL: UPOS_P_ALKEY_OBJ Type: view

Alternate Labelling for Network objects

UPOV_PR_ALKEY_OBJ is a CDS View that provides data about "Alternate Labelling for Network objects" in SAP S/4HANA. It reads from 4 data sources (gho_iflot_ext, iflotx, iflos, upoc_udm_alkey) and exposes 4 fields.

Data Sources (4)

SourceAliasJoin Type
gho_iflot_ext fun_loc from
iflotx fun_loc_desc inner
iflos fun_loc_id inner
upoc_udm_alkey nteobj inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_P_ALKEY_OBJ view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label Alternate Labelling for Network objects view

Fields (4)

KeyFieldSource TableSource FieldDescription
object_id iflos strno Functional Loc.
obj_type upoc_udm_alkey gho_netobj_type Nw Obj Type
desc_in_caps iflotx pltxu Description
obj_id_desc iflotx pltxt Description

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_PR_ALKEY_OBJ.
-- 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_P_ALKEY_OBJ

CREATE VIEW UPOV_PR_ALKEY_OBJ AS
SELECT
  fun_loc_id.strno AS object_id,
  nteobj.gho_netobj_type AS obj_type,
  fun_loc_desc.pltxu AS desc_in_caps,
  fun_loc_desc.pltxt AS obj_id_desc
FROM gho_iflot_ext AS fun_loc
INNER JOIN upoc_udm_alkey AS nteobj ON /* join condition not captured in parsed metadata */
INNER JOIN iflos AS fun_loc_id ON /* join condition not captured in parsed metadata */
INNER JOIN iflotx AS fun_loc_desc ON /* join condition not captured in parsed metadata */
;