P_NetworkActivityWithVersion

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_NetworkActivityWithVersion.
-- 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: PNTWKACTYVERSN

CREATE VIEW P_NetworkActivityWithVersion AS
SELECT
  I_NetworkActivityVersion.ProjectNetwork AS ProjectNetwork,
  I_NetworkActivityVersion.NetworkActivity AS NetworkActivity,
  I_NetworkActivityVersion.SuperiorNtwkActivityExternalID AS SuperiorNtwkActivityExternalID,
  I_NetworkActivityVersion.Version AS Version,
  'X' AS IsProjectVersionObject,
  I_NetworkActivityVersion.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  I_NetworkActivityVersion.NetworkActivityInternalID AS NetworkActivityInternalID,
  I_NetworkActivityVersion.WBSElementInternalID AS WBSElementInternalID,
  I_NetworkActivityVersion.Project AS Project,
  I_NetworkActivityVersion.ProjectWithCodingMask AS ProjectWithCodingMask,
  I_NetworkActivityVersion.ProjectObject AS ProjectObject,
  I_NetworkActivityVersion.WBSElementObject AS WBSElementObject,
  I_NetworkActivityVersion.NetworkActivityControlProfile AS NetworkActivityControlProfile,
  I_NetworkActivityVersion.ProjectInternalID AS ProjectInternalID,
  I_NetworkActivityVersion.IsExternalActivity AS IsExternalActivity,
  I_NetworkActivityVersion.ActivityIsAccountAssigned AS ActivityIsAccountAssigned,
  I_NetworkActivityVersion.IsServiceActivity AS IsServiceActivity,
  I_NetworkActivityVersion.IsInternalActivity AS IsInternalActivity,
  I_NetworkActivityVersion.Plant AS Plant,
  I_NetworkActivityVersion.NetworkActivityDescription2 AS NetworkActivityDescription2,
  I_NetworkActivityVersion.NetworkActivityQuantityUnit AS NetworkActivityQuantityUnit,
  I_NetworkActivityVersion.ActivityQuantity AS ActivityQuantity,
  I_NetworkActivityVersion.SchedldBasicLatestEndTime AS SchedldBasicLatestEndTime,
  I_NetworkActivityVersion.ScheduledBasicLatestEndDate AS ScheduledBasicLatestEndDate,
  I_NetworkActivityVersion.SchedldBasicLatestStartTime AS SchedldBasicLatestStartTime,
  I_NetworkActivityVersion.SchedldBasicLatestStartDate AS SchedldBasicLatestStartDate,
  I_NetworkActivityVersion.SchedldFcstdLatestEndTime AS SchedldFcstdLatestEndTime,
  I_NetworkActivityVersion.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  I_NetworkActivityVersion.SchedldFcstdLatestStartTime AS SchedldFcstdLatestStartTime,
  I_NetworkActivityVersion.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  I_NetworkActivityVersion.SchedldBasicEarliestEndTime AS SchedldBasicEarliestEndTime,
  I_NetworkActivityVersion.SchedldBasicEarliestEndDate AS SchedldBasicEarliestEndDate,
  I_NetworkActivityVersion.SchedldBasicEarliestStartTime AS SchedldBasicEarliestStartTime,
  I_NetworkActivityVersion.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  I_NetworkActivityVersion.SchedldFcstdEarliestEndTime AS SchedldFcstdEarliestEndTime,
  I_NetworkActivityVersion.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  I_NetworkActivityVersion.SchedldFcstdEarliestStartTime AS SchedldFcstdEarliestStartTime,
  I_NetworkActivityVersion.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  I_NetworkActivityVersion.TotalFloatForBasicDates AS TotalFloatForBasicDates,
  I_NetworkActivityVersion.BasicDatesFreeFloat AS BasicDatesFreeFloat,
  I_NetworkActivityVersion.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  I_NetworkActivityVersion.ActyConfFcstdEndTime AS ActyConfFcstdEndTime,
  I_NetworkActivityVersion.ActyConfFcstdEndDate AS ActyConfFcstdEndDate,
  I_NetworkActivityVersion.ActivityConfFcstdDurationUnit AS ActivityConfFcstdDurationUnit,
  I_NetworkActivityVersion.ConstraintTimeForBasicEndTime AS ConstraintTimeForBasicEndTime,
  I_NetworkActivityVersion.ConstraintDateForBscEndDate AS ConstraintDateForBscEndDate,
  I_NetworkActivityVersion.ConstraintTimeForBscStartTime AS ConstraintTimeForBscStartTime,
  I_NetworkActivityVersion.ConstraintDateForBscStartDate AS ConstraintDateForBscStartDate,
  I_NetworkActivityVersion.ActualExecutionStartTime AS ActualExecutionStartTime,
  I_NetworkActivityVersion.ActualStartDate AS ActualStartDate,
  I_NetworkActivityVersion.ActualExecutionEndTime AS ActualExecutionEndTime,
  I_NetworkActivityVersion.ActualEndDate AS ActualEndDate,
  I_NetworkActivityVersion.ActyFcstEndDateConstraintType AS ActyFcstEndDateConstraintType,
  I_NetworkActivityVersion.ActyFcstStartDteConstraintType AS ActyFcstStartDteConstraintType,
  I_NetworkActivityVersion.FcstdStandardDurationUnit AS FcstdStandardDurationUnit,
  I_NetworkActivityVersion.DispatchedEndTime AS DispatchedEndTime,
  I_NetworkActivityVersion.DispatchedEndDate AS DispatchedEndDate,
  I_NetworkActivityVersion.DispatchedStartTime AS DispatchedStartTime,
  I_NetworkActivityVersion.DispatchedStartDate AS DispatchedStartDate,
  I_NetworkActivityVersion.ActyBscEndDateConstraintType AS ActyBscEndDateConstraintType,
  I_NetworkActivityVersion.ActyBscStartDateConstraintType AS ActyBscStartDateConstraintType,
  I_NetworkActivityVersion.StandardDuration AS StandardDuration,
  I_NetworkActivityVersion.StandardDurationUnit AS StandardDurationUnit,
  I_NetworkActivityVersion.NtwkActivityWorkQuantityUnit AS NtwkActivityWorkQuantityUnit,
  I_NetworkActivityVersion.JointVenture AS JointVenture,
  I_NetworkActivityVersion.JointVentureSubClass AS JointVentureSubClass,
  I_NetworkActivityVersion.JointVentureClass AS JointVentureClass,
  I_NetworkActivityVersion.JointVentureObjectType AS JointVentureObjectType,
  I_NetworkActivityVersion.JntVentureOriglCostObjectType AS JntVentureOriglCostObjectType,
  I_NetworkActivityVersion.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  I_NetworkActivityVersion.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  I_NetworkActivityVersion.FreeDefinedDate2 AS FreeDefinedDate2,
  I_NetworkActivityVersion.FreeDefinedDate1 AS FreeDefinedDate1,
  I_NetworkActivityVersion.FreeDefinedAmount2 AS FreeDefinedAmount2,
  I_NetworkActivityVersion.FreeDefinedAmount1 AS FreeDefinedAmount1,
  I_NetworkActivityVersion.FreeDefinedQuantity2 AS FreeDefinedQuantity2,
  I_NetworkActivityVersion.FreeDefinedQuantity1 AS FreeDefinedQuantity1,
  I_NetworkActivityVersion.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  I_NetworkActivityVersion.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  I_NetworkActivityVersion.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  I_NetworkActivityVersion.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  I_NetworkActivityVersion.FreeDefinedAmount1Currency AS FreeDefinedAmount1Currency,
  I_NetworkActivityVersion.FreeDefinedAmount2Currency AS FreeDefinedAmount2Currency,
  I_NetworkActivityVersion.FreeDefinedQuantity2Unit AS FreeDefinedQuantity2Unit,
  I_NetworkActivityVersion.FreeDefinedQuantity1Unit AS FreeDefinedQuantity1Unit,
  I_NetworkActivityVersion.FunctionalArea AS FunctionalArea,
  I_NetworkActivityVersion.ExchangeRate AS ExchangeRate,
  I_NetworkActivityVersion.GoodsRecipientName AS GoodsRecipientName,
  I_NetworkActivityVersion.NetworkActivityCurrency AS NetworkActivityCurrency,
  I_NetworkActivityVersion.SuperiorNtwkActivityInternalID AS SuperiorNtwkActivityInternalID,
  I_NetworkActivityVersion.CostElement AS CostElement,
  I_NetworkActivityVersion.NetworkActivityConfirmation AS NetworkActivityConfirmation,
  I_NetworkActivityVersion.NtwkActyConfirmationCount AS NtwkActyConfirmationCount,
  I_NetworkActivityVersion.EmployeeSuitability AS EmployeeSuitability,
  I_NetworkActivityVersion.NetworkActivityPriority AS NetworkActivityPriority,
  I_NetworkActivityVersion.ProjectTextInternalID AS ProjectTextInternalID,
  I_NetworkActivityVersion.NetworkActivityObjectCurrency AS NetworkActivityObjectCurrency,
  I_NetworkActivityVersion.OperationImportance AS OperationImportance,
  I_NetworkActivityVersion.NtwkActyIsRelevantForMatlPlng AS NtwkActyIsRelevantForMatlPlng,
  I_NetworkActivityVersion.NtwkAccountAssignmentCode AS NtwkAccountAssignmentCode,
  I_NetworkActivityVersion.IsMarkedForDeletion AS IsMarkedForDeletion,
  I_NetworkActivityVersion.NetworkActivityDescription AS NetworkActivityDescription,
  I_NetworkActivityVersion.EmployeeWageType AS EmployeeWageType,
  I_NetworkActivityVersion.CostCtrActivityType AS CostCtrActivityType,
  I_NetworkActivityVersion.PurgInfoRecdDataIsFixed AS PurgInfoRecdDataIsFixed,
  I_NetworkActivityVersion.FactoryCalendar AS FactoryCalendar,
  I_NetworkActivityVersion.StandardTextInternalID AS StandardTextInternalID,
  I_NetworkActivityVersion.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_NetworkActivityVersion.PurchasingDocument AS PurchasingDocument,
  I_NetworkActivityVersion.ActyIsTakenAcctForProjSmmry AS ActyIsTakenAcctForProjSmmry,
  I_NetworkActivityVersion.CompanyCode AS CompanyCode,
  I_NetworkActivityVersion.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_NetworkActivityVersion.PurchaseRequisition AS PurchaseRequisition,
  I_NetworkActivityVersion.NumberOfCapacities AS NumberOfCapacities,
  I_NetworkActivityVersion.NumberOfEmployees AS NumberOfEmployees,
  I_NetworkActivityVersion.PartnerCostCenter AS PartnerCostCenter,
  I_NetworkActivityVersion.RequisitionerUser AS RequisitionerUser,
  I_NetworkActivityVersion.UnloadingPointName AS UnloadingPointName,
  I_NetworkActivityVersion.NetworkActivityObject AS NetworkActivityObject,
  I_NetworkActivityVersion.UsageCode AS UsageCode,
  I_NetworkActivityVersion.PurchasingOrganization AS PurchasingOrganization,
  I_NetworkActivityVersion.PurchasingGroup AS PurchasingGroup,
  I_NetworkActivityVersion.Supplier AS Supplier,
  I_NetworkActivityVersion.Language AS Language,
  I_NetworkActivityVersion.WorkCenterInternalID AS WorkCenterInternalID,
  I_NetworkActivityVersion.IsCostActivity AS IsCostActivity,
  I_NetworkActivityVersion.ExternalProcessingPrice AS ExternalProcessingPrice,
  I_NetworkActivityVersion.NetworkActivityCost AS NetworkActivityCost,
  I_NetworkActivityVersion.BusinessArea AS BusinessArea,
  I_NetworkActivityVersion.PurchasingInfoRecdAddlGrpgName AS PurchasingInfoRecdAddlGrpgName,
  I_NetworkActivityVersion.ProfitCenter AS ProfitCenter,
  I_NetworkActivityVersion.WorkCenter AS WorkCenter,
  I_NetworkActivityVersion.PurchasingGroupName AS PurchasingGroupName,
  I_NetworkActivityVersion.RespCostCenterControllingArea AS RespCostCenterControllingArea,
  I_NetworkActivityVersion.ResponsibleCostCenter AS ResponsibleCostCenter,
  I_NetworkActivityVersion.RequestingCostCenter AS RequestingCostCenter,
  I_NetworkActivityVersion.ReqgCostCenterControllingArea AS ReqgCostCenterControllingArea,
  I_NetworkActivityVersion.WBSElementHierarchyLevel AS WBSElementHierarchyLevel,
  I_NetworkActivityVersion.ProjectType AS ProjectType,
  I_NetworkActivityVersion.ControllingArea AS ControllingArea,
  I_NetworkActivityVersion.NetworkActivityCategory AS NetworkActivityCategory,
  I_NetworkActivityVersion.MRPController AS MRPController,
  I_NetworkActivityVersion.PlannedWorkQuantity AS PlannedWorkQuantity,
  I_NetworkActivityVersion.ActualWorkQuantity AS ActualWorkQuantity,
  I_NetworkActivityVersion.RemainingWorkQuantity AS RemainingWorkQuantity,
  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_NetworkActivityVersion.ProjectDescription AS ProjectDescription,
  I_NetworkActivityVersion.WBSElement AS WBSElement,
  I_NetworkActivityVersion.WBSElementWithCodingMask AS WBSElementWithCodingMask,
  I_NetworkActivityVersion.WBSDescription AS WBSDescription,
  I_NetworkActivityVersion.PlantName AS PlantName,
  I_NetworkActivityVersion.LeadTimeReductionStrategy AS LeadTimeReductionStrategy,
  I_NetworkActivityVersion.SupplierName AS SupplierName,
  I_NetworkActivityVersion.NetworkActivityPriceBaseQty AS NetworkActivityPriceBaseQty,
  I_NetworkActivityVersion.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_NetworkActivityVersion.PurchasingOrganizationName AS PurchasingOrganizationName,
  I_NetworkActivityVersion.MaterialGroup AS MaterialGroup,
  I_NetworkActivityVersion.StandardDurationIsFlexible AS StandardDurationIsFlexible,
  I_NetworkActivityVersion.CompanyCodeName AS CompanyCodeName,
  I_NetworkActivityVersion.OperationCalculationControl AS OperationCalculationControl,
  I_NetworkActivityVersion.CapacityRequirementDistrKey AS CapacityRequirementDistrKey,
  I_NetworkActivityVersion.TaxJurisdiction AS TaxJurisdiction,
  I_NetworkActivityVersion.ControllingObjectClass AS ControllingObjectClass,
  I_NetworkActivityVersion.ProgressAnlysAggregationWeight AS ProgressAnlysAggregationWeight,
  I_NetworkActivityVersion.MinimumDuration AS MinimumDuration,
  I_NetworkActivityVersion.MinimumDurationUnit AS MinimumDurationUnit,
  I_NetworkActivityVersion.StartDateOffsetDuration AS StartDateOffsetDuration,
  I_NetworkActivityVersion.StartDateOffsetDurationUnit AS StartDateOffsetDurationUnit,
  I_NetworkActivityVersion.EndDateOffsetDuration AS EndDateOffsetDuration,
  I_NetworkActivityVersion.EndDateOffsetDurationUnit AS EndDateOffsetDurationUnit,
  I_NetworkActivityVersion.ActivityConfFcstdDuration AS ActivityConfFcstdDuration,
  I_NetworkActivityVersion.ObjectIsConfirmed AS ObjectIsConfirmed,
  I_NetworkActivityVersion.ObjectIsPartiallyConfirmed AS ObjectIsPartiallyConfirmed,
  I_NetworkActivityVersion.TaxJurisdictionCalcProcedure AS TaxJurisdictionCalcProcedure,
  I_NetworkActivityVersion.FreeDefinedTableFieldSemantic AS FreeDefinedTableFieldSemantic,
  I_NetworkActivityVersion.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive,
  I_NetworkActivityVersion._BusinessArea AS _BusinessArea,
  I_NetworkActivityVersion._MRPController AS _MRPController,
  I_NetworkActivityVersion._NetworkActivityQuantityUnit AS _NetworkActivityQuantityUnit,
  I_NetworkActivityVersion._NtwkActivityWorkQuantityUnit AS _NtwkActivityWorkQuantityUnit,
  I_NetworkActivityVersion._PurchasingGroup AS _PurchasingGroup,
  I_NetworkActivityVersion._WorkCenter AS _WorkCenter,
  I_NetworkActivityVersion._ControllingObjectClass AS _ControllingObjectClass,
  I_NetworkActivityVersion._MaterialGroup AS _MaterialGroup,
  I_NetworkActivityVersion._TaxJurisdiction AS _TaxJurisdiction,
  I_NetworkActivity._ActivityShortText AS _ActivityShortText
FROM I_NetworkActivityVersion
-- UNION ALL with additional select branch(es): I_NetworkActivity
;