I_GhoFcProjResAct_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 I_GhoFcProjResAct_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: IGHOFCPRJRESACT

CREATE VIEW I_GhoFcProjResAct_Al AS
SELECT
  P_GhoFcRsAtCJstPSt_Tl.NetworkObjectID AS NetworkObjectID,
  P_GhoFcRsAtCJstPSt_Tl.NetworkObjectName AS NetworkObjectName,
  P_GhoFcRsAtCJstPSt_Tl.NetworkMedium AS NetworkMedium,
  P_GhoFcRsAtCJstPSt_Tl.AllocationFrequencyCode AS AllocationFrequencyCode,
  P_GhoFcRsAtCJstPSt_Tl.UpstreamProjectID AS UpstreamProjectID,
  P_GhoFcRsAtCJstPSt_Tl.ProjectName AS ProjectName,
  P_GhoFcRsAtCJstPSt_Tl.ProjectDescription AS ProjectDescription,
  P_GhoFcRsAtCJstPSt_Tl.UpstreamProjEffctvDateTo AS UpstreamProjEffctvDateTo,
  P_GhoFcRsAtCJstPSt_Tl.UpstreamProjEffctvDateFrom AS UpstreamProjEffctvDateFrom,
  P_GhoFcRsAtCJstPSt_Tl.UpstreamProjStatusObject AS UpstreamProjStatusObject,
  P_GhoFcRsAtCJstPSt_Tl.ScenarioID AS ScenarioID,
  P_GhoFcRsAtCJstPSt_Tl.ScenarioName AS ScenarioName,
  P_GhoFcRsAtCJstPSt_Tl.ScenarioDescription AS ScenarioDescription,
  P_GhoFcRsAtCJstPSt_Tl.ScenarioState AS ScenarioState,
  P_GhoFcRsAtCJstPSt_Tl.ProductionNetworkID AS ProductionNetworkID,
  P_GhoFcRsAtCJstPSt_Tl.ProductionNetworkDescription AS ProductionNetworkDescription,
  P_GhoFcRsAtCJstPSt_Tl.ProductionNetworkName AS ProductionNetworkName,
  P_GhoFcRsAtCJstPSt_Tl.NetworkObjectType AS NetworkObjectType,
  P_GhoFcRsAtCJstPSt_Tl.NetworkObjectDescription AS NetworkObjectDescription,
  P_GhoFcRsAtCJstPSt_Tl.NetworkObjectEffectiveDateFrom AS NetworkObjectEffectiveDateFrom,
  P_GhoFcRsAtCJstPSt_Tl.NetworkObjectEffectiveDateTo AS NetworkObjectEffectiveDateTo,
  DisplayTimeZone,
  P_GhoFcRsAtCJstPSt_Tl.NetworkChainSourceFlag AS NetworkChainSourceFlag,
  P_GhoFcRsAtCJstPSt_Tl.UnitOfMeasure AS UnitOfMeasure,
  P_GhoFcRsAtCJstPSt_Tl.WBSElement AS WBSElement,
  P_GhoFcRsAtCJstPSt_Tl.CostCenter AS CostCenter,
  P_GhoFcRsAtCJstPSt_Tl.ProfitCenter AS ProfitCenter,
  P_GhoFcRsAtCJstPSt_Tl.StatusObjectNumber AS StatusObjectNumber,
  P_GhoFcRsAtCJstPSt_Tl.UserStatusProfile AS UserStatusProfile,
  P_GhoFcRsAtCJstPSt_Tl.NetworkMediumDescription AS NetworkMediumDescription,
  P_GhoFcRsAtCJstPSt_Tl.CalendarDate AS CalendarDate,
  P_GhoFcRsAtCJstPSt_Tl.CalendarYear AS CalendarYear,
  P_GhoFcRsAtCJstPSt_Tl.CalendarMonth AS CalendarMonth,
  P_GhoFcRsAtCJstPSt_Tl.CalendarDay AS CalendarDay,
  P_GhoFcRsAtCJstPSt_Tl.UpstreamProjectStatus AS UpstreamProjectStatus,
  P_GhoFcRsAtCJstPSt_Tl.ProjectScenarioName AS ProjectScenarioName,
  P_GhoFcRsAtCJstPSt_Tl.ObjectType AS ObjectType,
  I_Ghocrmjest_Db.ObjectOrderNumber AS ObjectOrderNumber,
  I_Ghocrmjest_Db.GHOObjectStatus AS GHOObjectStatus,
  I_Ghocrmjest_Db.ObjectIndicator AS ObjectIndicator,
  I_Ghocrmjest_Db.SystemStatus AS SystemStatus,
  AllocationFrequencyName
FROM P_GhoFcRsAtCJstPSt_Tl
;