P_ProjNetworkWithVersion

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_ProjNetworkWithVersion.
-- 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: PPROJNTWKVERS

CREATE VIEW P_ProjNetworkWithVersion AS
SELECT
  I_ProjectNetworkVersion.ProjectNetwork AS ProjectNetwork,
  I_ProjectNetworkVersion.Version AS Version,
  'X' AS IsProjectVersionObject,
  I_ProjectNetworkVersion.ProjectNetworkDescription AS ProjectNetworkDescription,
  I_ProjectNetworkVersion.ProjectInternalID AS ProjectInternalID,
  I_ProjectNetworkVersion.WBSElementInternalID AS WBSElementInternalID,
  I_ProjectNetworkVersion.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  I_ProjectNetworkVersion.BusinessArea AS BusinessArea,
  I_ProjectNetworkVersion.CompanyCode AS CompanyCode,
  I_ProjectNetworkVersion.ControllingArea AS ControllingArea,
  I_ProjectNetworkVersion.ProfitCenter AS ProfitCenter,
  I_ProjectNetworkVersion.CostCenter AS CostCenter,
  I_ProjectNetworkVersion.Plant AS Plant,
  I_ProjectNetworkVersion.SalesOrder AS SalesOrder,
  I_ProjectNetworkVersion.SalesOrderItem AS SalesOrderItem,
  I_ProjectNetworkVersion.MRPController AS MRPController,
  I_ProjectNetworkVersion.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  I_ProjectNetworkVersion.ChangeNumber AS ChangeNumber,
  I_ProjectNetworkVersion.PriorityCode AS PriorityCode,
  I_ProjectNetworkVersion.SuperiorProjectNetwork AS SuperiorProjectNetwork,
  I_ProjectNetworkVersion.ProductConfiguration AS ProductConfiguration,
  I_ProjectNetworkVersion.LastScheduledDate AS LastScheduledDate,
  I_ProjectNetworkVersion.ConfirmedEndDate AS ConfirmedEndDate,
  I_ProjectNetworkVersion.ScheduledReleaseDate AS ScheduledReleaseDate,
  I_ProjectNetworkVersion.ActualReleasedDate AS ActualReleasedDate,
  I_ProjectNetworkVersion.ActualStartDate AS ActualStartDate,
  I_ProjectNetworkVersion.ActualEndDate AS ActualEndDate,
  I_ProjectNetworkVersion.PlannedStartDate AS PlannedStartDate,
  I_ProjectNetworkVersion.PlannedEndDate AS PlannedEndDate,
  I_ProjectNetworkVersion.ScheduledFcstdReleaseDate AS ScheduledFcstdReleaseDate,
  I_ProjectNetworkVersion.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  I_ProjectNetworkVersion.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  I_ProjectNetworkVersion.Reservation AS Reservation,
  I_ProjectNetworkVersion.CreationDate AS CreationDate,
  I_ProjectNetworkVersion.CreationTime AS CreationTime,
  I_ProjectNetworkVersion.CreatedByUser AS CreatedByUser,
  I_ProjectNetworkVersion.LastChangeDate AS LastChangeDate,
  I_ProjectNetworkVersion.LastChangeTime AS LastChangeTime,
  I_ProjectNetworkVersion.LastChangedByUser AS LastChangedByUser,
  I_ProjectNetworkVersion.OrderType AS ProjectNetworkType,
  I_ProjectNetworkVersion.OrderCategory AS OrderCategory,
  I_ProjectNetworkVersion.JointVentureOriginalCostObject AS JointVentureOriginalCostObject,
  I_ProjectNetworkVersion.JointVentureObjectType AS JointVentureObjectType,
  I_ProjectNetworkVersion.JointVenture AS JointVenture,
  I_ProjectNetworkVersion.JointVentureClass AS JointVentureClass,
  I_ProjectNetworkVersion.JointVentureSubClass AS JointVentureSubClass,
  I_ProjectNetworkVersion.TaxJurisdiction AS TaxJurisdiction,
  I_ProjectNetworkVersion.CostingSheet AS CostingSheet,
  I_ProjectNetworkVersion.CostElement AS CostElement,
  I_ProjectNetworkVersion.ProjectNetworkObject AS ProjectNetworkObject,
  I_ProjectNetworkVersion.Currency AS Currency,
  I_ProjectNetworkVersion.OverheadCode AS OverheadCode,
  I_ProjectNetworkVersion.ProjNtwkInterestCalcProfile AS ProjNtwkInterestCalcProfile,
  I_ProjectNetworkVersion.NetworkActivityConfirmation AS NetworkActivityConfirmation,
  I_ProjectNetworkVersion.IsMarkedForDeletion AS IsMarkedForDeletion,
  I_ProjectNetworkVersion.ActualCostsCostingVariant AS ActualCostsCostingVariant,
  I_ProjectNetworkVersion.PlannedCostsCostingVariant AS PlannedCostsCostingVariant,
  I_ProjectNetworkVersion.BasicSchedulingType AS BasicSchedulingType,
  I_ProjectNetworkVersion.BaseUnit AS BaseUnit,
  I_ProjectNetworkVersion.NetworkIsAccountAssigned AS NetworkIsAccountAssigned,
  I_ProjectNetworkVersion.NetworkProfile AS NetworkProfile,
  I_ProjectNetworkVersion.FunctionalArea AS FunctionalArea,
  I_ProjectNetworkVersion.CapacityRequirement AS CapacityRequirement,
  I_ProjectNetworkVersion.ControllingObjectClass AS ControllingObjectClass,
  I_ProjectNetworkVersion.OrderID AS OrderID,
  I_ProjectNetworkVersion.OrderIsNotCostedAutomatically AS OrderIsNotCostedAutomatically,
  I_ProjectNetworkVersion.OrdIsNotSchedldAutomatically AS OrdIsNotSchedldAutomatically,
  cast( 0 as int4 ) AS DueToStartDays,
  cast( 0 as int4 ) AS DueToEndDays,
  cast( 0 as int4 ) AS OverdueToStartDays,
  cast( 0 as int4 ) AS OverdueToEndDays,
  I_ProjectNetworkVersion.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive,
  I_ProjectNetworkVersion._BusinessArea AS _BusinessArea,
  I_ProjectNetworkVersion._CompanyCode AS _CompanyCode,
  I_ProjectNetworkVersion._ControllingArea AS _ControllingArea,
  I_ProjectNetworkVersion._CostCenter AS _CostCenter,
  I_ProjectNetworkVersion._Currency AS _Currency,
  I_ProjectNetworkVersion._MRPController AS _MRPController,
  I_ProjectNetworkVersion._Plant AS _Plant,
  I_ProjectNetworkVersion._ProfitCenter AS _ProfitCenter,
  I_ProjectNetworkVersion._SalesOrder AS _SalesOrder,
  I_ProjectNetworkVersion._SalesOrderItem AS _SalesOrderItem,
  I_ProjectNetworkVersion._OrderCategory AS _OrderCategory,
  I_ProjectNetworkVersion._FunctionalArea AS _FunctionalArea,
  I_ProjectNetworkVersion._NetworkProfile AS _NetworkProfile,
  I_ProjectNetworkVersion._ResponsiblePlannerGroup AS _ResponsiblePlannerGroup,
  I_ProjectNetworkVersion._ControllingObjectClass AS _ControllingObjectClass,
  I_ProjectNetworkVersion._Prioritycode AS _Prioritycode,
  I_ProjectNetworkVersion._OrderType AS _OrderType,
  I_ProjectNetworkVersion._TaxJurisdiction AS _TaxJurisdiction,
  case when I_ProjectNetwork.ActualEndDate = '00000000' and I_ProjectNetwork.ScheduledBasicEndDate != '00000000' and I_ProjectNetwork.ScheduledBasicEndDate > $session.system_date then dats_days_between( cast($session.system_date as sydatum), I_ProjectNetwork.ScheduledBasicEndDate ) else case when I_ProjectNetwork.ActualEndDate = '00000000' and I_ProjectNetwork.PlannedEndDate != '00000000' and I_ProjectNetwork.PlannedEndDate > $session.system_date then dats_days_between( cast($session.system_date as sydatum), I_ProjectNetwork.PlannedEndDate ) else 0 end end as DueToEndDays AS PlannedEndDateelse0endendasDueToEndDays,
  I_ProjectNetwork._NetworkShortText AS _NetworkShortText
FROM I_ProjectNetworkVersion
-- UNION ALL with additional select branch(es): I_ProjectNetwork
;