C_GHOAprvdAllocRslt

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_GHOAprvdAllocRslt.
-- 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_GHOAprvdAllocRslt AS
SELECT
  AllocationRunID,
  cast (GHONetworkID as tplnr_unconverted preserving type ) AS GHONetworkID,
  cast(_FunctionalLocationDetails._FunctionalLocationLabel.FunctionalLocationLabelName as gho_nm_ilom_strno preserving type ) AS ProductionNetworkLabelName,
  cast(_FunctionalLocationDetails._FunctionalLocation._FunctionalLocationText[1: Language = $session.system_language ].FunctionalLocationName as gho_nm_nw_desc preserving type ) AS ProductionNetworkDescription,
  cast( NetworkMedium as gho_de_medium preserving type ) AS NetworkMedium,
  cast(_MediumText[1: Language = $session.system_language ].NetworkMediumDescription as gho_nm_medium_desc_c256 ) AS NetworkMediumDescription,
  cast(AllocationFrequencyCode as gho_de_frequency preserving type ) AS AllocationFrequencyCode,
  cast( _FrequencyText[1: Language = $session.system_language ].FrequencyDescription as gho_de_frequency_des preserving type ) AS FrequencyDescription,
  cast( tstmp_to_dats( dats_tims_to_tstmp( ProductionAllocationDate, ProductionAllocationTime, 'UTC', $session.client, 'NULL' ), _FunctionalLocationDetails.NetworkTimeZone, $session.client, 'NULL') as gho_de_production_date preserving type ) AS ProductionAllocationDate,
  cast( tstmp_to_tims( dats_tims_to_tstmp( ProductionAllocationDate, ProductionAllocationTime, 'UTC', $session.client, 'NULL' ), _FunctionalLocationDetails.NetworkTimeZone, $session.client, 'NULL') as gho_de_production_time preserving type ) AS ProductionAllocationTime,
  _FunctionalLocationDetails.NetworkTimeZone AS NetworkTimeZone,
  cast(' ' as gho_product ) AS NetworkMediumID,
  cast(' ' as gho_alloc_frequency) AS PriorPerdNotifFreqIndepCode,
  _ProdnDatesAndObjectDetails.ProdnPeriodStartDateTime AS ProdnPeriodStartDateTime,
  _ProdnDatesAndObjectDetails.ProdnPeriodEndDateTime AS ProdnPeriodEndDateTime,
  NetworkAllocationStatus
FROM I_GHOProdnAllocationResults
LEFT OUTER JOIN I_GHOFunctionalLocation AS _FunctionalLocationDetails ON GHONetworkID = _FunctionalLocationDetails.FunctionalLocation  -- association [1..1]
;