C_GHONtwkObjReproduceMatRules

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_GHONtwkObjReproduceMatRules.
-- 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_ProductionStartDateTime : gho_prodalloc_datetime, P_ProductionEndDateTime : gho_prodalloc_datetime

CREATE VIEW C_GHONtwkObjReproduceMatRules AS
SELECT
  GHONetworkID,
  cast(GHONetworkObjectID as gho_ntwkobj_id preserving type ) AS GHONetworkObjectID,
  cast(_ReproduceMatRules.NtwkAllocMaterial as gho_reproduced_material preserving type ) AS NtwkAllocMaterial,
  coalesce(_ReproduceMatRules.NetworkMedium, $parameters.P_NetworkMedium) AS NetworkMedium,
  cast(_ReproduceMatRules.NtwkAllocFormPercentage as gho_alloc_form_percentage preserving type ) AS NtwkAllocFormPercentage,
  _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.ExternalNetworkObjectID as gho_ntwk_obj_ext_id preserving type ) AS ExternalNetworkObjectID,
  cast(_NetworkObjectDetails._NetworkObjectType._NtwkObjTypeText[1: Language = $session.system_language ].NetworkObjectTypeDescription as gho_network_object_type preserving type ) AS NetworkObjectTypeDescription,
  _ReproduceMatRules._MediumText[1: Language = $session.system_language ].NetworkMediumDescription AS NetworkMediumDescription,
  cast(_ReproduceMatRules._AllocatedMaterial._Text[1: Language = $session.system_language ].MaterialName as gho_reproduced_material_text preserving type ) AS MaterialName
FROM I_GHOAllNtwkObjAllocRules
;