P_GhoFcProj_Al

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 P_GhoFcProj_Al.
-- 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.
-- SQL view name: PGHOFCPROJAL

CREATE VIEW P_GhoFcProj_Al AS
SELECT
  P_GhoFcProjFreq_Tl.UpstreamProjectID AS UpstreamProjectID,
  P_GhoFcProjFreq_Tl.ProjectName AS ProjectName,
  P_GhoFcProjFreq_Tl.UpstreamProjEffctvStartDate AS UpstreamProjEffctvStartDate,
  P_GhoFcProjFreq_Tl.UpstreamProjEffctvEndDate AS UpstreamProjEffctvEndDate,
  P_GhoFcProjFreq_Tl.UpstreamProfileID AS UpstreamProfileID,
  P_GhoFcProjFreq_Tl.ProjectDescription AS ProjectDescription,
  P_GhoFcProjFreq_Tl.AllocationFrequencyCode AS AllocationFrequencyCode,
  DisplayTimeZone,
  P_GhoFcProjFreq_Tl.StatusObjectNumber AS StatusObjectNumber,
  P_GhoFcProjFreq_Tl.UpstreamUserGroupID AS UpstreamUserGroupID,
  P_GhoFcProjFreq_Tl.StatusProfile AS StatusProfile,
  P_GhoFcProjFreq_Tl.FrequencyDescription AS FrequencyDescription,
  _Project[1:inner].NetworkMedium AS NetworkMedium,
  _Project[1:inner].UnitOfMeasure AS UnitOfMeasure,
  _Project[1:inner].RoundOffPrecision AS RoundOffPrecision,
  _Project[1:inner].NetworkMediumDescription AS NetworkMediumDescription
FROM P_GhoFcProjFreq_Tl
LEFT OUTER JOIN P_GhoFcProjMedUom_Tl AS _Project ON UpstreamProjectID = _Project.UpstreamProjectID  -- association [0..1]
;