C_GHOProdnNtwkStructure

DDL: C_GHOPRODNNTWKSTRUCTURE Type: view_entity CONSUMPTION
31 Fields 1 Data Sources

Production Network Structure with Links

C_GHOProdnNtwkStructure is a Consumption CDS View that provides data about "Production Network Structure with Links" in SAP S/4HANA. It reads from 1 data source (I_GHOProdnNtwkStructure) and exposes 31 fields with key field GHONtwkLinkID.

Data Sources (1)

SourceAliasJoin Type
I_GHOProdnNtwkStructure I_GHOProdnNtwkStructure from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Production Network Structure with Links view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY GHONtwkLinkID _NetworkObjectLinks GHONtwkLinkID
GHONetworkID GHONetworkID Netw Object ID
ProductionNetworkLabelName Production Network ID
ProductionNetworkDescription Production Network Description
NetworkObjectType NetworkObjectType
ProductionNetworkIcon _NetworkObjectType FioriIcon Production Network Icon
NetworkInternalID NetworkInternalID
NetworkTimeZone NetworkTimeZone
NetworkLinkDesc Link Description
GHOFromNtwkObjID _NetworkObjectLinks GHOFromNtwkObjID
FromNetworkObjectLabelName From Network Object ID
FromNetworkObjectDesc From Network Object
FromNetworkObjectIcon From Network Object Icon
FromNetworkObjectType
FromNetworkObjectTypeDesc From Network Object Type
FromExternalNetworkObjectID From Network Object External ID
GHOToNtwkObjID _NetworkObjectLinks GHOToNtwkObjID
ToNetworkObjectLabelName To Network Object ID
ToNetworkObjectDesc To Network Object
ToExternalNetworkObjectID To Network Object External ID
ToNetworkObjectIcon To Network Object Icon
ToNetworkObjectType
ToNetworkObjectTypeDesc To Network Object Type
clientNULLastimestampasValidFromDateTime
LinkNetworkObject
NetworkMedium _NetworkObjectLinks NetworkMedium Medium ID
NetworkMediumDescription Medium
MediumFlowDirection _NetworkObjectLinks MediumFlowDirection
MediumFlowDirectionDesc Flow Direction
Product
ProductDescription

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 C_GHOProdnNtwkStructure.
-- 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 C_GHOProdnNtwkStructure AS
SELECT
  _NetworkObjectLinks.GHONtwkLinkID AS GHONtwkLinkID,
  GHONetworkID,
  _FunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName AS ProductionNetworkLabelName,
  _FunctionalLocation._FunctionalLocationText[1: Language = $session.system_language].FunctionalLocationName AS ProductionNetworkDescription,
  NetworkObjectType,
  _NetworkObjectType.FioriIcon AS ProductionNetworkIcon,
  NetworkInternalID,
  NetworkTimeZone,
  _NetworkObjectLinks._LinkText[1: Language = $session.system_language].ObjectLinkDescription AS NetworkLinkDesc,
  _NetworkObjectLinks.GHOFromNtwkObjID AS GHOFromNtwkObjID,
  _NetworkObjectLinks._FromNetworkObject._FunctionalLocationLabel.FunctionalLocationLabelName AS FromNetworkObjectLabelName,
  _NetworkObjectLinks._LinkFromFunctionalLocation._FunctionalLocationText[1: Language = $session.system_language].FunctionalLocationName AS FromNetworkObjectDesc,
  _NetworkObjectLinks._FromNetworkObject._NetworkObjectType.FioriIcon AS FromNetworkObjectIcon,
  _NetworkObjectLinks._FromNetworkObject.NetworkObjectType AS FromNetworkObjectType,
  _NetworkObjectLinks._FromNetworkObject._NetworkObjectType._NtwkObjTypeText[1: Language = $session.system_language].NetworkObjectTypeDescription AS FromNetworkObjectTypeDesc,
  _NetworkObjectLinks._FromNetworkObject.ExternalNetworkObjectID AS FromExternalNetworkObjectID,
  _NetworkObjectLinks.GHOToNtwkObjID AS GHOToNtwkObjID,
  _NetworkObjectLinks._ToNetworkObject._FunctionalLocationLabel.FunctionalLocationLabelName AS ToNetworkObjectLabelName,
  _NetworkObjectLinks._LinkToFunctionalLocation._FunctionalLocationText[1: Language = $session.system_language].FunctionalLocationName AS ToNetworkObjectDesc,
  _NetworkObjectLinks._ToNetworkObject.ExternalNetworkObjectID AS ToExternalNetworkObjectID,
  _NetworkObjectLinks._ToNetworkObject._NetworkObjectType.FioriIcon AS ToNetworkObjectIcon,
  cast(_NetworkObjectLinks._ToNetworkObject.NetworkObjectType as gho_to_netobj_type preserving type ) AS ToNetworkObjectType,
  cast(_NetworkObjectLinks._ToNetworkObject._NetworkObjectType._NtwkObjTypeText[1: Language = $session.system_language].NetworkObjectTypeDescription as gho_to_netobj_type_text preserving type ) AS ToNetworkObjectTypeDesc,
  cast(dats_tims_to_tstmp( tstmp_to_dats(dats_tims_to_tstmp(_NetworkObjectLinks.FromNetworkLinkValidityDte, _NetworkObjectLinks.FromNetworkLinkValidityTme, 'UTC', $session.client, 'NULL'), NetworkTimeZone, $session.client, 'NULL'), tstmp_to_tims(dats_tims_to_tstmp(_NetworkObjectLinks.FromNetworkLinkValidityDte, _NetworkObjectLinks.FromNetworkLinkValidityTme, 'UTC', $session.client, 'NULL'), NetworkTimeZone, $session.client, 'NULL'), 'UTC', $session.client, 'NULL') as timestamp) as ValidFromDateTime AS clientNULLastimestampasValidFromDateTime,
  cast(_NetworkObjectLinks.LinkNetworkObject as tplnr_unconverted preserving type ) AS LinkNetworkObject,
  _NetworkObjectLinks.NetworkMedium AS NetworkMedium,
  _NetworkObjectLinks._MediumText[1: Language = $session.system_language].NetworkMediumDescription AS NetworkMediumDescription,
  _NetworkObjectLinks.MediumFlowDirection AS MediumFlowDirection,
  _NetworkObjectLinks._MediumFlowDirectionText[1: LanguageCode = $session.system_language].DomainText AS MediumFlowDirectionDesc,
  cast(_NetworkObjectLinks.Product as gho_allocation_material_id preserving type ) AS Product,
  cast(_NetworkObjectLinks._Product._Text[1: Language = $session.system_language].ProductName as gho_allocation_material preserving type ) AS ProductDescription
FROM I_GHOProdnNtwkStructure
;

Learn More