C_GHONtwkObjAllocThrtclRslt

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_GHONtwkObjAllocThrtclRslt.
-- 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_GHONtwkObjAllocThrtclRslt AS
SELECT
  AllocationRunID,
  GHONetworkID,
  cast(GHOFromNtwkObjID as gho_ntwkobj_id preserving type ) AS GHONetworkObjectID,
  GHOToNtwkObjID,
  NetworkMedium,
  AllocationFrequencyCode,
  ProductionAllocationDate,
  ProductionAllocationTime,
  ProdnAllocUTCDteTme,
  ProductionAllocationType,
  GHOQuantityType,
  cast(AllocationRuleUnitOfMsmt as gho_estimated_theo_uom preserving type ) AS GHOEstimatedThrtclUoM,
  cast(_AdjustedTheo.AllocationRuleUnitOfMsmt as gho_adjusted_theo_uom preserving type ) AS GHOAdjustedThrtclUoM,
  cast(_NetworkObjectDetails.ExternalNetworkObjectID as gho_ntwk_obj_ext_id preserving type ) AS ExternalNetworkObjectID,
  _NetworkObjectDetails.NetworkObjectType AS NetworkObjectType,
  cast(_NetworkObjectDetails._NetworkObjectType._NtwkObjTypeText[1: Language = $session.system_language ].NetworkObjectTypeDescription as gho_network_object_type preserving type ) AS NetworkObjectTypeDescription,
  _NetworkObjectDetails._NetworkObjectType.FioriIcon AS NetworkObjectIcon,
  cast(_NetworkObjectDetails._FunctionalLocationLabel.FunctionalLocationLabelName as gho_nm_ilom_strno preserving type ) AS NetworkObjectLabelName,
  cast(_NetworkObjectDetails._FunctionalLocation._FunctionalLocationText[1: Language = $session.system_language ].FunctionalLocationName as gho_network_obj_desc preserving type ) AS NetworkObjectDescription,
  cast(round(cast(AllocationRuleMsmtValue as gho_estimated_theo_qty) ,3) as gho_theoretical_qty_graphical ) AS GHOEstimatedThrtclQty,
  cast(round(cast(_AdjustedTheo.AllocationRuleMsmtValue as gho_adjusted_theo_qty),3) as gho_allocated_qty_graphical) AS GHOAdjustedThrtclQty,
  cast(_NtwkAllocRuleQtyType[1: Language = $session.system_language ].NtwkAllocQtyTypeDesc as gho_quantitytype_text preserving type ) AS NtwkAllocQtyTypeDesc,
  cast(round(cast(_FormationTheoretical.AllocationRuleMsmtValue as gho_formation_theo_qty),3) as gho_formation_theo_qty ) AS GHOFormationThrtclQty,
  coalesce(_FormationTheoretical.AllocationRuleUnitOfMsmt, _AdjustedTheo.AllocationRuleUnitOfMsmt) AS GHOFormationThrtclUoM,
  cast(round(cast(_GasLiftGasTheoretical.AllocationRuleMsmtValue as gho_gasliftgas_theo_qty),3) as gho_gasliftgas_theo_qty) AS GHOGasLiftGasThrtclQty,
  coalesce(_GasLiftGasTheoretical.AllocationRuleUnitOfMsmt, _AdjustedTheo.AllocationRuleUnitOfMsmt) AS GHOGasLiftGasThrtclUoM
FROM I_GHONtwkObjAllocThrtclRslt
;