P_GhoFcResActDtlDate_Tl

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_GhoFcResActDtlDate_Tl.
-- 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: PGHOFCRSACTDTLDT

CREATE VIEW P_GhoFcResActDtlDate_Tl AS
SELECT
  P_GhoFcResActPrjDet_Tl.NetworkObjectID AS NetworkObjectID,
  P_GhoFcResActPrjDet_Tl.NetworkObjectName AS NetworkObjectName,
  P_GhoFcResActPrjDet_Tl.NetworkMedium AS NetworkMedium,
  P_GhoFcResActPrjDet_Tl.AllocationFrequencyCode AS AllocationFrequencyCode,
  P_GhoFcResActPrjDet_Tl.UpstreamProjectID AS UpstreamProjectID,
  P_GhoFcResActPrjDet_Tl.ProjectName AS ProjectName,
  P_GhoFcResActPrjDet_Tl.ProjectDescription AS ProjectDescription,
  P_GhoFcResActPrjDet_Tl.UpstreamProjEffctvDateTo AS UpstreamProjEffctvDateTo,
  P_GhoFcResActPrjDet_Tl.UpstreamProjEffctvDateFrom AS UpstreamProjEffctvDateFrom,
  P_GhoFcResActPrjDet_Tl.UpstreamProjStatusObject AS UpstreamProjStatusObject,
  P_GhoFcResActPrjDet_Tl.ScenarioID AS ScenarioID,
  P_GhoFcResActPrjDet_Tl.ScenarioName AS ScenarioName,
  P_GhoFcResActPrjDet_Tl.ScenarioDescription AS ScenarioDescription,
  P_GhoFcResActPrjDet_Tl.ScenarioState AS ScenarioState,
  P_GhoFcResActPrjDet_Tl.ProductionNetworkID AS ProductionNetworkID,
  P_GhoFcResActPrjDet_Tl.ProductionNetworkDescription AS ProductionNetworkDescription,
  P_GhoFcResActPrjDet_Tl.ProductionNetworkName AS ProductionNetworkName,
  P_GhoFcResActPrjDet_Tl.NetworkObjectType AS NetworkObjectType,
  P_GhoFcResActPrjDet_Tl.NetworkObjectDescription AS NetworkObjectDescription,
  P_GhoFcResActPrjDet_Tl.NetworkObjectEffectiveDateFrom AS NetworkObjectEffectiveDateFrom,
  P_GhoFcResActPrjDet_Tl.NetworkObjectEffectiveDateTo AS NetworkObjectEffectiveDateTo,
  P_GhoFcResActPrjDet_Tl.DisplayTimeZone AS DisplayTimeZone,
  RoundOffPrecision,
  P_GhoFcResActPrjDet_Tl.NetworkChainSourceFlag AS NetworkChainSourceFlag,
  P_GhoFcResActPrjDet_Tl.UnitOfMeasure AS UnitOfMeasure,
  P_GhoFcResActPrjDet_Tl.WBSElement AS WBSElement,
  P_GhoFcResActPrjDet_Tl.CostCenter AS CostCenter,
  P_GhoFcResActPrjDet_Tl.ProfitCenter AS ProfitCenter,
  P_GhoFcResActPrjDet_Tl.StatusObjectNumber AS StatusObjectNumber,
  P_GhoFcResActPrjDet_Tl.UserStatusProfile AS UserStatusProfile,
  P_GhoFcResActPrjDet_Tl.NetworkMediumDescription AS NetworkMediumDescription,
  I_CalendarDate.CalendarDate AS CalendarDate,
  I_CalendarDate.CalendarYear AS CalendarYear,
  I_CalendarDate.CalendarMonth AS CalendarMonth,
  I_CalendarDate.CalendarDay AS CalendarDay,
  I_CalendarDate.CalendarQuarter AS CalendarQuarter,
  I_CalendarDate.WeekDay AS WeekDay,
  I_CalendarDate.YearMonth AS YearMonth,
  I_CalendarDate._CalendarMonth AS _CalendarMonth,
  I_CalendarDate._CalendarQuarter AS _CalendarQuarter,
  I_CalendarDate._CalendarYear AS _CalendarYear,
  P_GhoFcResActPrjDet_Tl._NetObjType AS _NetObjType,
  P_GhoFcResActPrjDet_Tl._NetObjType.NetworkObjectTypeDescription AS NetworkObjectTypeDescription,
  P_GhoFcResActPrjDet_Tl._ObjectStatus AS _ObjectStatus,
  P_GhoFcResActPrjDet_Tl._Scenario AS _Scenario,
  I_CalendarDate._WeekDay AS _WeekDay,
  I_CalendarDate._YearMonth AS _YearMonth
FROM P_GhoFcResActPrjDet_Tl
INNER JOIN I_CalendarDate ON /* join condition not captured in parsed metadata */
;