C_GHONtwkObjMeterAllocRules

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_GHONtwkObjMeterAllocRules.
-- 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.
-- Parameters: P_NetworkMedium : gho_product, P_AllocationFrequencyCode : gho_alloc_frequency, P_ProductionStartDateTime : gho_prodalloc_datetime, P_ProductionEndDateTime : gho_prodalloc_datetime

CREATE VIEW C_GHONtwkObjMeterAllocRules AS
SELECT
  GHONetworkID,
  GHONetworkObjectID,
  _MeterAllocRules.NetworkAllocRuleUUID AS NetworkAllocRuleUUID,
  cast(_MeterAllocRules._MeterRuleitems.NtwkAllocMaterial as gho_allocation_material_id preserving type ) AS NtwkAllocMaterial,
  cast(_MeterAllocRules._MeterRuleitems.NtwkAllocQtyType as gho_quantity_type preserving type ) AS NtwkAllocQtyType,
  cast(_MeterAllocRules._MeterRuleitems.CustomCalculationIdentifier as gho_custom_calc_id preserving type ) AS CustomCalculationIdentifier,
  _MeterAllocRules._MeterRuleitems.QuantityRequirement AS QuantityRequirement,
  cast(_MeterAllocRules._MeterRuleitems.NtwkAllocDepdntMaterial as gho_depended_alloc_mat preserving type ) AS NtwkAllocDepdntMaterial,
  cast(_MeterAllocRules._MeterRuleitems.NtwkAllocDepdntMatlQtyType as gho_depended_mat_qty_type preserving type ) AS NtwkAllocDepdntMatlQtyType,
  _NetworkObjectDetails._NetworkObjectType.FioriIcon AS NetworkObjectIcon,
  cast(_NetworkObjectDetails._FunctionalLocationLabel.FunctionalLocationLabelName as gho_networkobject_label preserving type ) AS NetworkObjectLabelName,
  cast(_NetworkObjectDetails._FunctionalLocation._FunctionalLocationText[1: Language = $session.system_language ].FunctionalLocationName as gho_network_obj_desc preserving type ) AS NetworkObjectDescription,
  _NetworkObjectDetails.NetworkObjectType AS NetworkObjectType,
  cast(_NetworkObjectDetails._NetworkObjectType._NtwkObjTypeText[1: Language = $session.system_language ].NetworkObjectTypeDescription as gho_network_object_type preserving type ) AS NetworkObjectTypeDescription,
  cast(_NetworkObjectDetails.ExternalNetworkObjectID as gho_ntwk_obj_ext_id preserving type ) AS ExternalNetworkObjectID,
  coalesce(_MeterAllocRules.NetworkMedium, $parameters.P_NetworkMedium) AS NetworkMedium,
  _MeterAllocRules._MediumText[1: Language = $session.system_language ].NetworkMediumDescription AS NetworkMediumDescription,
  coalesce(_MeterAllocRules.AllocationFrequencyCode,$parameters.P_AllocationFrequencyCode) AS AllocationFrequencyCode,
  _MeterAllocRules._FrequencyText[1: Language = $session.system_language ].FrequencyDescription AS FrequencyDescription,
  cast(_MeterAllocRules.NtwkObjIsTerminationPoint as gho_node_termn_point preserving type ) AS NtwkObjIsTerminationPoint,
  cast(_MeterAllocRules.NtwkObjIsNonAdjustable as gho_non_adjustable preserving type ) AS NtwkObjIsNonAdjustable,
  cast(_MeterAllocRules._MeterRuleitems._AllocatedMaterial._Text[1: Language = $session.system_language ].MaterialName as gho_allocation_material preserving type ) AS MaterialName,
  cast(_MeterAllocRules._MeterRuleitems._QuantityTypeText[1: Language = $session.system_language ].NtwkAllocQtyTypeDesc as gho_quantitytype_text preserving type ) AS NtwkAllocQtyTypeDesc,
  cast(_MeterAllocRules._MeterRuleitems._DependedQuantityTypeText[1: Language = $session.system_language ].NtwkAllocQtyTypeDesc as gho_depended_mat_qty_type_text preserving type ) AS NtwkAllocDepdntMatlQtyTypeDesc,
  cast(_MeterAllocRules._MeterRuleitems._DependedAllocMaterial._Text[1: Language = $session.system_language ].MaterialName as gho_depended_alloc_mat_text preserving type ) AS NtwkAllocDepdntMaterialDesc,
  cast(_MeterAllocRules._MeterRuleitems._QuantityRequired[1: LanguageCode = $session.system_language ].DomainText as gho_quantity_indicator preserving type ) AS QuantityRequirementDesc,
  cast(_MeterAllocRules._MeterRuleitems._QuantityType.GHOQuantityCategory as gho_quantity_category_id preserving type ) AS GHOQuantityCategory,
  cast(_MeterAllocRules._MeterRuleitems._QuantityType._QuantityCategoryText[1: LanguageCode = $session.system_language ].DomainText as gho_quantity_category_text preserving type ) AS GHOQuantityCategoryText
FROM I_GHOAllNtwkObjAllocRules
;