I_GHOAllocationRunCount

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_GHOAllocationRunCount.
-- 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_GHOAllocationRunCount AS
SELECT
  count(distinct alloc_run_id) AS NumberOfAllocationResults,
  cast (netid as gho_network_id preserving type) AS GHONetworkID,
  medium AS NetworkMedium,
  alloc_type AS ProductionAllocationType,
  frequency AS AllocationFrequencyCode,
  prod_date AS ProductionAllocationDate,
  prod_time AS ProductionAllocationTime,
  alloc_purpose AS NetworkAllocationPurpose,
  alloc_status AS NetworkAllocationStatus
FROM upot_udm_allocv
-- UNION with additional select branch(es): gho_allocres_h
;