I_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 I_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: INTWKACTYVERS

CREATE VIEW I_NetworkActivityWithVersion AS
SELECT
  _NetworkActivityWithVersion.ProjectNetwork AS ProjectNetwork,
  cast ( _NetworkActivityWithVersion.Version as ps_s4_vsnmr ) AS Version,
  _NetworkActivityWithVersion.IsProjectVersionObject AS IsProjectVersionObject,
  _NetworkActivityWithVersion.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  _NetworkActivityWithVersion.NetworkActivityInternalID AS NetworkActivityInternalID,
  _NetworkActivityWithVersion.WBSElementInternalID AS WBSElementInternalID,
  _NetworkActivityWithVersion.Project AS Project,
  _NetworkActivityWithVersion.ProjectWithCodingMask AS ProjectWithCodingMask,
  _NetworkActivityWithVersion.ProjectObject AS ProjectObject,
  _NetworkActivityWithVersion.WBSElementObject AS WBSElementObject,
  _NetworkActivityWithVersion.NetworkActivityControlProfile AS NetworkActivityControlProfile,
  _NetworkActivityWithVersion.ProjectInternalID AS ProjectInternalID,
  _NetworkActivityWithVersion.IsExternalActivity AS IsExternalActivity,
  _NetworkActivityWithVersion.ActivityIsAccountAssigned AS ActivityIsAccountAssigned,
  _NetworkActivityWithVersion.IsServiceActivity AS IsServiceActivity,
  _NetworkActivityWithVersion.IsInternalActivity AS IsInternalActivity,
  _NetworkActivityWithVersion.Plant AS Plant,
  _NetworkActivityWithVersion.NetworkActivityDescription2 AS NetworkActivityDescription2,
  _NetworkActivityWithVersion.NetworkActivityQuantityUnit AS NetworkActivityQuantityUnit,
  _NetworkActivityWithVersion.ActivityQuantity AS ActivityQuantity,
  _NetworkActivityWithVersion.SchedldBasicLatestEndTime AS SchedldBasicLatestEndTime,
  _NetworkActivityWithVersion.ScheduledBasicLatestEndDate AS ScheduledBasicLatestEndDate,
  _NetworkActivityWithVersion.SchedldBasicLatestStartTime AS SchedldBasicLatestStartTime,
  _NetworkActivityWithVersion.SchedldBasicLatestStartDate AS SchedldBasicLatestStartDate,
  _NetworkActivityWithVersion.SchedldFcstdLatestEndTime AS SchedldFcstdLatestEndTime,
  _NetworkActivityWithVersion.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  _NetworkActivityWithVersion.SchedldFcstdLatestStartTime AS SchedldFcstdLatestStartTime,
  _NetworkActivityWithVersion.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  _NetworkActivityWithVersion.SchedldBasicEarliestEndTime AS SchedldBasicEarliestEndTime,
  cast ( _NetworkActivityWithVersion.SchedldBasicEarliestEndDate as ps_s4_getre ) AS SchedldBasicEarliestEndDate,
  _NetworkActivityWithVersion.SchedldBasicEarliestStartTime AS SchedldBasicEarliestStartTime,
  _NetworkActivityWithVersion.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  _NetworkActivityWithVersion.SchedldFcstdEarliestEndTime AS SchedldFcstdEarliestEndTime,
  _NetworkActivityWithVersion.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  _NetworkActivityWithVersion.SchedldFcstdEarliestStartTime AS SchedldFcstdEarliestStartTime,
  _NetworkActivityWithVersion.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  _NetworkActivityWithVersion.TotalFloatForBasicDates AS TotalFloatForBasicDates,
  _NetworkActivityWithVersion.BasicDatesFreeFloat AS BasicDatesFreeFloat,
  _NetworkActivityWithVersion.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  _NetworkActivityWithVersion.ActyConfFcstdEndTime AS ActyConfFcstdEndTime,
  _NetworkActivityWithVersion.ActyConfFcstdEndDate AS ActyConfFcstdEndDate,
  _NetworkActivityWithVersion.ActivityConfFcstdDurationUnit AS ActivityConfFcstdDurationUnit,
  _NetworkActivityWithVersion.ConstraintTimeForBasicEndTime AS ConstraintTimeForBasicEndTime,
  _NetworkActivityWithVersion.ConstraintDateForBscEndDate AS ConstraintDateForBscEndDate,
  _NetworkActivityWithVersion.ConstraintTimeForBscStartTime AS ConstraintTimeForBscStartTime,
  _NetworkActivityWithVersion.ConstraintDateForBscStartDate AS ConstraintDateForBscStartDate,
  _NetworkActivityWithVersion.ActualExecutionStartTime AS ActualExecutionStartTime,
  _NetworkActivityWithVersion.ActualStartDate AS ActualStartDate,
  _NetworkActivityWithVersion.ActualExecutionEndTime AS ActualExecutionEndTime,
  _NetworkActivityWithVersion.ActualEndDate AS ActualEndDate,
  _NetworkActivityWithVersion.ActyFcstEndDateConstraintType AS ActyFcstEndDateConstraintType,
  _NetworkActivityWithVersion.ActyFcstStartDteConstraintType AS ActyFcstStartDteConstraintType,
  _NetworkActivityWithVersion.FcstdStandardDurationUnit AS FcstdStandardDurationUnit,
  _NetworkActivityWithVersion.DispatchedEndTime AS DispatchedEndTime,
  _NetworkActivityWithVersion.DispatchedEndDate AS DispatchedEndDate,
  _NetworkActivityWithVersion.DispatchedStartTime AS DispatchedStartTime,
  _NetworkActivityWithVersion.DispatchedStartDate AS DispatchedStartDate,
  _NetworkActivityWithVersion.ActyBscEndDateConstraintType AS ActyBscEndDateConstraintType,
  _NetworkActivityWithVersion.ActyBscStartDateConstraintType AS ActyBscStartDateConstraintType,
  _NetworkActivityWithVersion.StandardDuration AS StandardDuration,
  _NetworkActivityWithVersion.StandardDurationUnit AS StandardDurationUnit,
  _NetworkActivityWithVersion.NtwkActivityWorkQuantityUnit AS NtwkActivityWorkQuantityUnit,
  _NetworkActivityWithVersion.JointVenture AS JointVenture,
  _NetworkActivityWithVersion.JointVentureSubClass AS JointVentureSubClass,
  _NetworkActivityWithVersion.JointVentureClass AS JointVentureClass,
  _NetworkActivityWithVersion.JointVentureObjectType AS JointVentureObjectType,
  _NetworkActivityWithVersion.JntVentureOriglCostObjectType AS JntVentureOriglCostObjectType,
  _NetworkActivityWithVersion.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  _NetworkActivityWithVersion.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  _NetworkActivityWithVersion.FreeDefinedDate2 AS FreeDefinedDate2,
  _NetworkActivityWithVersion.FreeDefinedDate1 AS FreeDefinedDate1,
  _NetworkActivityWithVersion.FreeDefinedAmount2 AS FreeDefinedAmount2,
  _NetworkActivityWithVersion.FreeDefinedAmount1 AS FreeDefinedAmount1,
  _NetworkActivityWithVersion.FreeDefinedQuantity2 AS FreeDefinedQuantity2,
  _NetworkActivityWithVersion.FreeDefinedQuantity1 AS FreeDefinedQuantity1,
  _NetworkActivityWithVersion.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  _NetworkActivityWithVersion.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  _NetworkActivityWithVersion.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  _NetworkActivityWithVersion.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  _NetworkActivityWithVersion.FreeDefinedAmount1Currency AS FreeDefinedAmount1Currency,
  _NetworkActivityWithVersion.FreeDefinedAmount2Currency AS FreeDefinedAmount2Currency,
  _NetworkActivityWithVersion.FreeDefinedQuantity2Unit AS FreeDefinedQuantity2Unit,
  _NetworkActivityWithVersion.FreeDefinedQuantity1Unit AS FreeDefinedQuantity1Unit,
  _NetworkActivityWithVersion.FunctionalArea AS FunctionalArea,
  _NetworkActivityWithVersion.ExchangeRate AS ExchangeRate,
  cast ( _NetworkActivityWithVersion.GoodsRecipientName as ps_s4_wempf ) AS GoodsRecipientName,
  _NetworkActivityWithVersion.NetworkActivityCurrency AS NetworkActivityCurrency,
  _NetworkActivityWithVersion.SuperiorNtwkActivityInternalID AS SuperiorNtwkActivityInternalID,
  _NetworkActivityWithVersion.CostElement AS CostElement,
  _NetworkActivityWithVersion.NetworkActivityConfirmation AS NetworkActivityConfirmation,
  _NetworkActivityWithVersion.NtwkActyConfirmationCount AS NtwkActyConfirmationCount,
  _NetworkActivityWithVersion.EmployeeSuitability AS EmployeeSuitability,
  _NetworkActivityWithVersion.NetworkActivityPriority AS NetworkActivityPriority,
  _NetworkActivityWithVersion.ProjectTextInternalID AS ProjectTextInternalID,
  _NetworkActivityWithVersion.NetworkActivityObjectCurrency AS NetworkActivityObjectCurrency,
  _NetworkActivityWithVersion.OperationImportance AS OperationImportance,
  _NetworkActivityWithVersion.NtwkActyIsRelevantForMatlPlng AS NtwkActyIsRelevantForMatlPlng,
  _NetworkActivityWithVersion.NtwkAccountAssignmentCode AS NtwkAccountAssignmentCode,
  _NetworkActivityWithVersion.IsMarkedForDeletion AS IsMarkedForDeletion,
  _NetworkActivityWithVersion.NetworkActivityDescription AS NetworkActivityDescription,
  _NetworkActivityWithVersion.EmployeeWageType AS EmployeeWageType,
  _NetworkActivityWithVersion.CostCtrActivityType AS CostCtrActivityType,
  _NetworkActivityWithVersion.PurgInfoRecdDataIsFixed AS PurgInfoRecdDataIsFixed,
  _NetworkActivityWithVersion.FactoryCalendar AS FactoryCalendar,
  _NetworkActivityWithVersion.StandardTextInternalID AS StandardTextInternalID,
  _NetworkActivityWithVersion.PurchasingDocumentItem AS PurchasingDocumentItem,
  _NetworkActivityWithVersion.PurchasingDocument AS PurchasingDocument,
  _NetworkActivityWithVersion.ActyIsTakenAcctForProjSmmry AS ActyIsTakenAcctForProjSmmry,
  _NetworkActivityWithVersion.CompanyCode AS CompanyCode,
  _NetworkActivityWithVersion.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  cast ( _NetworkActivityWithVersion.PurchaseRequisition as ps_s4_banfn ) AS PurchaseRequisition,
  _NetworkActivityWithVersion.NumberOfCapacities AS NumberOfCapacities,
  _NetworkActivityWithVersion.NumberOfEmployees AS NumberOfEmployees,
  _NetworkActivityWithVersion.PartnerCostCenter AS PartnerCostCenter,
  _NetworkActivityWithVersion.RequisitionerUser AS RequisitionerUser,
  _NetworkActivityWithVersion.UnloadingPointName AS UnloadingPointName,
  _NetworkActivityWithVersion.NetworkActivityObject AS NetworkActivityObject,
  _NetworkActivityWithVersion.UsageCode AS UsageCode,
  _NetworkActivityWithVersion.PurchasingOrganization AS PurchasingOrganization,
  _NetworkActivityWithVersion.PurchasingGroup AS PurchasingGroup,
  _NetworkActivityWithVersion.Supplier AS Supplier,
  _NetworkActivityWithVersion.Language AS Language,
  _NetworkActivityWithVersion.WorkCenterInternalID AS WorkCenterInternalID,
  _NetworkActivityWithVersion.IsCostActivity AS IsCostActivity,
  _NetworkActivityWithVersion.ExternalProcessingPrice AS ExternalProcessingPrice,
  _NetworkActivityWithVersion.NetworkActivityCost AS NetworkActivityCost,
  _NetworkActivityWithVersion.BusinessArea AS BusinessArea,
  _NetworkActivityWithVersion.PurchasingInfoRecdAddlGrpgName AS PurchasingInfoRecdAddlGrpgName,
  _NetworkActivityWithVersion.ProfitCenter AS ProfitCenter,
  _NetworkActivityWithVersion.WorkCenter AS WorkCenter,
  _NetworkActivityWithVersion.PurchasingGroupName AS PurchasingGroupName,
  _NetworkActivityWithVersion.RespCostCenterControllingArea AS RespCostCenterControllingArea,
  _NetworkActivityWithVersion.ResponsibleCostCenter AS ResponsibleCostCenter,
  _NetworkActivityWithVersion.RequestingCostCenter AS RequestingCostCenter,
  _NetworkActivityWithVersion.ReqgCostCenterControllingArea AS ReqgCostCenterControllingArea,
  cast ( _NetworkActivityWithVersion.WBSElementHierarchyLevel as row_level ) AS WBSElementHierarchyLevel,
  _NetworkActivityWithVersion.ProjectType AS ProjectType,
  _NetworkActivityWithVersion.ControllingArea AS ControllingArea,
  _NetworkActivityWithVersion.NetworkActivityCategory AS NetworkActivityCategory,
  _NetworkActivityWithVersion.MRPController AS MRPController,
  _NetworkActivityWithVersion.PlannedWorkQuantity AS PlannedWorkQuantity,
  _NetworkActivityWithVersion.ActualWorkQuantity AS ActualWorkQuantity,
  _NetworkActivityWithVersion.RemainingWorkQuantity AS RemainingWorkQuantity,
  _NetworkActivityWithVersion.DueToStartDays AS DueToStartDays,
  _NetworkActivityWithVersion.DueToEndDays AS DueToEndDays,
  _NetworkActivityWithVersion.OverdueToStartDays AS OverdueToStartDays,
  _NetworkActivityWithVersion.OverdueToEndDays AS OverdueToEndDays,
  _NetworkActivityWithVersion.ProjectDescription AS ProjectDescription,
  cast ( _NetworkActivityWithVersion.WBSElement as ps_poski_cl ) AS WBSElement,
  _NetworkActivityWithVersion.WBSElementWithCodingMask AS WBSElementWithCodingMask,
  _NetworkActivityWithVersion.WBSDescription AS WBSDescription,
  _NetworkActivityWithVersion.PlantName AS PlantName,
  _NetworkActivityWithVersion.LeadTimeReductionStrategy AS LeadTimeReductionStrategy,
  _NetworkActivityWithVersion.SupplierName AS SupplierName,
  _NetworkActivityWithVersion.NetworkActivityPriceBaseQty AS NetworkActivityPriceBaseQty,
  _NetworkActivityWithVersion.PurchasingInfoRecord AS PurchasingInfoRecord,
  _NetworkActivityWithVersion.PurchasingOrganizationName AS PurchasingOrganizationName,
  _NetworkActivityWithVersion.MaterialGroup AS MaterialGroup,
  _NetworkActivityWithVersion.StandardDurationIsFlexible AS StandardDurationIsFlexible,
  _NetworkActivityWithVersion.CompanyCodeName AS CompanyCodeName,
  cast ( _ControllingArea.ControllingAreaName as ps_s4_bezei ) AS ControllingAreaName,
  _NetworkActivityWithVersion.OperationCalculationControl AS OperationCalculationControl,
  _NetworkActivityWithVersion.CapacityRequirementDistrKey AS CapacityRequirementDistrKey,
  _NetworkActivityWithVersion.TaxJurisdiction AS TaxJurisdiction,
  _NetworkActivityWithVersion.ControllingObjectClass AS ControllingObjectClass,
  _NetworkActivityWithVersion.ProgressAnlysAggregationWeight AS ProgressAnlysAggregationWeight,
  _NetworkActivityWithVersion.MinimumDuration AS MinimumDuration,
  _NetworkActivityWithVersion.MinimumDurationUnit AS MinimumDurationUnit,
  _NetworkActivityWithVersion.StartDateOffsetDuration AS StartDateOffsetDuration,
  _NetworkActivityWithVersion.StartDateOffsetDurationUnit AS StartDateOffsetDurationUnit,
  _NetworkActivityWithVersion.EndDateOffsetDuration AS EndDateOffsetDuration,
  _NetworkActivityWithVersion.EndDateOffsetDurationUnit AS EndDateOffsetDurationUnit,
  _NetworkActivityWithVersion.ActivityConfFcstdDuration AS ActivityConfFcstdDuration,
  _NetworkActivityWithVersion.ObjectIsConfirmed AS ObjectIsConfirmed,
  _NetworkActivityWithVersion.ObjectIsPartiallyConfirmed AS ObjectIsPartiallyConfirmed,
  cast ( _OperationControlProfile._Text[1:Language = $session.system_language].OperationControlProfileName as ps_s4_pph_steutxt ) AS OperationControlProfileName,
  cast ( _NetworkActivityWithVersion._MaterialGroup._Text[1:Language = $session.system_language].MaterialGroupName as mmim_material_group_name ) AS MaterialGroupName,
  cast ( _ActivityTypeText[1:Language = $session.system_language].CostCtrActivityTypeName as ps_s4_lstar_text ) AS CostCtrActivityTypeName,
  cast ( _NetworkActivityWithVersion._TaxJurisdiction._Text[1:Language = $session.system_language].TaxJurisdictionName as ps_s4_text1_txjt ) AS TaxJurisdictionName,
  cast ( _NetworkActivityWithVersion._ControllingObjectClass._Text[1:Language = $session.system_language].ControllingObjectClassName as ps_s4_val_text ) AS ControllingObjectClassName,
  cast ( _NetworkActivityWithVersion._BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName as fis_busarea_name) AS BusinessAreaName,
  cast ( _FunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName as ps_s4_fkbtx ) AS FunctionalAreaName,
  cast ( _WorkCenter._Text[1:Language = $session.system_language].WorkCenterText as ps_s4_workcentertext ) AS WorkCenterText,
  cast ( _PriorityCode._Text[1:Language = $session.system_language].PriorityCodeName as ps_s4_priotext ) AS PriorityCodeName,
  _NetworkActivityWithVersion.FreeDefinedTableFieldSemantic AS FreeDefinedTableFieldSemantic,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  _NetworkActivityWithVersion._ActivityShortText AS _ActivityShortText
FROM P_NetworkActivityWithVersion AS _NetworkActivityWithVersion
LEFT OUTER JOIN I_WBSElementWithVersion AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID AND Version = _WBSElement.Version  -- association [0..1]
LEFT OUTER JOIN I_ProjNetworkWithVersion AS _ProjectNetwork ON _ProjectNetwork.ProjectNetwork = ProjectNetwork AND _ProjectNetwork.Version = Version  -- association [1..1]
LEFT OUTER JOIN I_OperationControlProfile AS _OperationControlProfile ON NetworkActivityControlProfile = _OperationControlProfile.OperationControlProfile  -- association [1..1]
LEFT OUTER JOIN I_Prioritycode AS _PriorityCode ON OperationImportance = _PriorityCode.PriorityCode  -- association [1..1]
LEFT OUTER JOIN I_CostElementOnChartOfAccounts AS _CostElementOnChartOfAccounts ON CostElement = _CostElementOnChartOfAccounts.CostElement AND chartofaccounts = _CostElementOnChartOfAccounts.ChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _ActivityTypeText ON CostCtrActivityType = _ActivityTypeText.CostCtrActivityType AND ControllingArea = _ActivityTypeText.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_StsObjConcatActiveStsILL AS _ConcatenatedStsObjActiveSts ON _ConcatenatedStsObjActiveSts.StatusObject = NetworkActivityObject  -- association [0..1]
LEFT OUTER JOIN E_NetworkActivity AS _Extension ON _NetworkActivityWithVersion.ProjectNetworkInternalID = _Extension.ProjectNetworkInternalID AND _NetworkActivityWithVersion.NetworkActivityInternalID = _Extension.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN E_NetworkActivityVersion AS _VersionExtension ON _NetworkActivityWithVersion.Version = _VersionExtension.Version AND _NetworkActivityWithVersion.ProjectNetworkInternalID = _VersionExtension.ProjectNetworkInternalID AND _NetworkActivityWithVersion.NetworkActivityInternalID = _VersionExtension.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN I_ProjectVersionVH AS _ProjectVersionVH ON Project = _ProjectVersionVH.ProjectObjectExternalID AND Version = _ProjectVersionVH.Version  -- association [0..*]
LEFT OUTER JOIN I_ProjectVersionHeader AS _ProjectVersionHeader ON ProjectWithCodingMask = _ProjectVersionHeader.Project AND Version = _ProjectVersionHeader.Version  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _NetworkActivityWithVersion.Supplier = _Supplier.Supplier  -- association [0..1]
;