I_GHONetworkObjectLabel

DDL: I_GHONETWORKOBJECTLABEL Type: view_entity COMPOSITE
7 Fields 1 Data Sources 2 Associations

Network Objects Label

I_GHONetworkObjectLabel is a Composite CDS View that provides data about "Network Objects Label" in SAP S/4HANA. It reads from 1 data source (I_GHONtwkObjAlternateLabeling) and exposes 7 fields with key field GHONetworkObjectID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_GHONtwkObjAlternateLabeling I_GHONtwkObjAlternateLabeling from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_GHOProdnNtwkLabel _FunctionalLocationLabel $projection.GHONetworkObjectID = _FunctionalLocationLabel.ProductionNetworkID and $projection.FuncLocationStructure = _FunctionalLocationLabel.FuncLocationStructure and $projection.AlternateLabelingSystem = _FunctionalLocationLabel.AlternateLabelingSystem and _FunctionalLocationLabel.FunctionalLocLabelIsActive = 'X'
[0..1] I_FunctionalLocationText _NetworkObjectText $projection.GHONetworkObjectID = _NetworkObjectText.FunctionalLocation and _NetworkObjectText.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Network Objects Label view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY GHONetworkObjectID GHONetworkObjectID
NetworkObjectType NetworkObjectType
FuncLocationStructure FuncLocationStructure
AlternateLabelingSystem AlternateLabelingSystem
FunctionalLocationLabelName _FunctionalLocationLabel FunctionalLocationLabelName Functional Loc.
_FunctionalLocationLabel _FunctionalLocationLabel
_NetworkObjectText _NetworkObjectText

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 I_GHONetworkObjectLabel.
-- 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.

CREATE VIEW I_GHONetworkObjectLabel AS
SELECT
  GHONetworkObjectID,
  NetworkObjectType,
  FuncLocationStructure,
  AlternateLabelingSystem,
  _FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName
FROM I_GHONtwkObjAlternateLabeling
LEFT OUTER JOIN I_GHOProdnNtwkLabel AS _FunctionalLocationLabel ON GHONetworkObjectID = _FunctionalLocationLabel.ProductionNetworkID AND FuncLocationStructure = _FunctionalLocationLabel.FuncLocationStructure AND AlternateLabelingSystem = _FunctionalLocationLabel.AlternateLabelingSystem AND _FunctionalLocationLabel.FunctionalLocLabelIsActive = 'X'  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _NetworkObjectText ON GHONetworkObjectID = _NetworkObjectText.FunctionalLocation AND _NetworkObjectText.Language = $session.system_language  -- association [0..1]
;

Learn More