C_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 C_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: CNTWKACTYVERS

CREATE VIEW C_NetworkActivityWithVersion AS
SELECT
  _NetworkActivity.ProjectNetwork AS ProjectNetwork,
  _NetworkActivity.NetworkActivity AS NetworkActivity,
  SuperiorNtwkActivityExternalID,
  _NetworkActivity.Version AS Version,
  case when _NetworkActivity.ProjectWithCodingMask is null then '' else _NetworkActivity.ProjectWithCodingMask end as Project AS ProjectWithCodingMaskendasProject,
  _NetworkActivity.WBSElementWithCodingMask AS WBSElement,
  _NetworkActivity.NetworkActivityObject AS NetworkActivityObject,
  _NetworkActivity.ProjectInternalID AS ProjectInternalID,
  _NetworkActivity.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  _NetworkActivity.NetworkActivityInternalID AS NetworkActivityInternalID,
  PurchasingDocument,
  _NetworkActivity.WBSElementInternalID AS WBSElementInternalID,
  _NetworkActivity.WBSElementHierarchyLevel AS WBSElementHierarchyLevel,
  NetworkActivityControlProfile,
  Plant,
  ActyBscStartDateConstraintType,
  ActyBscEndDateConstraintType,
  CostCtrActivityTypeName,
  OperationControlProfileName,
  PlantName,
  NetworkActivityPriority,
  PriorityCodeName,
  WorkCenterText,
  NtwkActivityWorkQuantityUnit,
  NetworkActivityQuantityUnit,
  NetworkActivityCurrency,
  StandardDurationUnit,
  PlannedWorkQuantity,
  ActualWorkQuantity,
  RemainingWorkQuantity,
  ActivityQuantity,
  ExternalProcessingPrice,
  cast ( _CostElementOnChartOfAccounts._Text[1:Language = $session.system_language].CostElementName as ps_s4_mcds2 ) AS CostElementName,
  StandardDuration,
  SchedldBasicEarliestStartDate,
  SchedldBasicLatestStartDate,
  SchedldBasicEarliestEndDate,
  ScheduledBasicLatestEndDate,
  SchedldFcstdEarliestStartDate,
  LatestSchedldFcstdStartDate,
  SchedldFcstdEarliestEndDate,
  LatestSchedldFcstdEndDate,
  ActualStartDate,
  ActualEndDate,
  DueToStartDays,
  DueToEndDays,
  OverdueToStartDays,
  OverdueToEndDays,
  IsMarkedForDeletion,
  ProfitCenterName,
  _NetworkActivity.Supplier AS Supplier,
  CostElement,
  _NetworkActivity.NetworkActivityObjectCurrency AS NetworkActivityObjectCurrency,
  _NetworkActivity.PurchasingOrganization AS PurchasingOrganization,
  _NetworkActivity.PurchasingGroup AS PurchasingGroup,
  _NetworkActivity.PurchasingGroupName AS PurchasingGroupName,
  ControllingAreaName,
  _NetworkActivity.CostCtrActivityType AS CostCtrActivityType,
  _NetworkActivity.PurchaseRequisition AS PurchaseRequisition,
  _NetworkActivity.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _NetworkActivity.FactoryCalendar AS FactoryCalendar,
  ControllingObjectClassName,
  BusinessAreaName,
  _NetworkActivity.RequisitionerUser AS RequisitionerUser,
  _NetworkActivity.GoodsRecipientName AS GoodsRecipientName,
  _NetworkActivity.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  _NetworkActivity.ConstraintDateForBscEndDate AS ConstraintDateForBscEndDate,
  _NetworkActivity.ConstraintDateForBscStartDate AS ConstraintDateForBscStartDate,
  _NetworkActivity.ActyFcstStartDteConstraintType AS ActyFcstStartDteConstraintType,
  _NetworkActivity.ActyFcstEndDateConstraintType AS ActyFcstEndDateConstraintType,
  _NetworkActivity.FcstdStandardDurationUnit AS FcstdStandardDurationUnit,
  _NetworkActivity.FunctionalArea AS FunctionalArea,
  FunctionalAreaName,
  _Project.ProjectDescription AS ProjectDescription,
  ProfitCenter,
  case when _WBSElement._WBSElementShortText.LanguageBasedShortText is not initial then _WBSElement._WBSElementShortText.LanguageBasedShortText else _WBSElement.WBSDescription end as WBSDescription AS WBSDescriptionendasWBSDescription,
  LeadTimeReductionStrategy,
  cast ( SupplierName as suppliername ) AS SupplierName,
  NetworkActivityPriceBaseQty,
  PurchasingInfoRecord,
  PurchasingOrganizationName,
  MaterialGroup,
  StandardDurationIsFlexible,
  CompanyCode,
  CompanyCodeName,
  cast ( ControllingArea as kokrs ) AS ControllingArea,
  OperationCalculationControl,
  NetworkActivityCost,
  CapacityRequirementDistrKey,
  TaxJurisdiction,
  ControllingObjectClass,
  BusinessArea,
  ProgressAnlysAggregationWeight,
  PurgInfoRecdDataIsFixed,
  MinimumDuration,
  MinimumDurationUnit,
  ActyConfFcstdEndDate,
  BasicDatesFreeFloat,
  TotalFloatForBasicDates,
  StartDateOffsetDuration,
  StartDateOffsetDurationUnit,
  EndDateOffsetDuration,
  EndDateOffsetDurationUnit,
  ActivityConfFcstdDuration,
  ActivityConfFcstdDurationUnit,
  MaterialGroupName,
  TaxJurisdictionName,
  WBSElementObject,
  cast ( _NetworkActivity._ProjectVersionHeader.ProjectVersionDescription as wty_vetxt ) AS ProjectVersionDescription,
  _NetworkActivity._ProjectVersionHeader.ProjectVersionGroupName AS ProjectVersionGroupName,
  _ProjectNetwork.ProjectNetworkDescription AS ProjectNetworkDescription,
  _UserFieldLabel.FreeDfndTableFieldSemanticName AS FreeDfndTableFieldSemanticName,
  _NetworkActivity.FreeDefinedTableFieldSemantic AS FreeDefinedTableFieldSemantic,
  _UserFieldLabel.FreeDefinedAttribute01Label AS FreeDefinedAttribute01Label,
  _NetworkActivity.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  _UserFieldLabel.FreeDefinedAttribute02Label AS FreeDefinedAttribute02Label,
  _NetworkActivity.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  _UserFieldLabel.FreeDefinedAttribute03Label AS FreeDefinedAttribute03Label,
  _NetworkActivity.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  _UserFieldLabel.FreeDefinedAttribute04Label AS FreeDefinedAttribute04Label,
  _NetworkActivity.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  _NetworkActivity.FreeDefinedAmount1Currency AS FreeDefinedAmount1Currency,
  _NetworkActivity.FreeDefinedAmount2Currency AS FreeDefinedAmount2Currency,
  _UserFieldLabel.FreeDefinedQuantity1Label AS FreeDefinedQuantity1Label,
  _NetworkActivity.FreeDefinedQuantity1Unit AS FreeDefinedQuantity1Unit,
  _NetworkActivity.FreeDefinedQuantity1 AS FreeDefinedQuantity1,
  _UserFieldLabel.FreeDefinedQuantity2Label AS FreeDefinedQuantity2Label,
  _NetworkActivity.FreeDefinedQuantity2Unit AS FreeDefinedQuantity2Unit,
  _NetworkActivity.FreeDefinedQuantity2 AS FreeDefinedQuantity2,
  _UserFieldLabel.FreeDefinedAmount1Label AS FreeDefinedAmount1Label,
  cast ( cast ( _NetworkActivity.FreeDefinedAmount1 * 10 as abap.curr(14,2) ) as abap.curr(13,2) ) AS FreeDefinedAmount1,
  _UserFieldLabel.FreeDefinedAmount2Label AS FreeDefinedAmount2Label,
  cast ( cast ( _NetworkActivity.FreeDefinedAmount2 * 10 as abap.curr(14,2) ) as abap.curr(13,2) ) AS FreeDefinedAmount2,
  _UserFieldLabel.FreeDefinedDate1Label AS FreeDefinedDate1Label,
  _NetworkActivity.FreeDefinedDate1 AS FreeDefinedDate1,
  _UserFieldLabel.FreeDefinedDate2Label AS FreeDefinedDate2Label,
  _NetworkActivity.FreeDefinedDate2 AS FreeDefinedDate2,
  _UserFieldLabel.FreeDefinedIndicator1Label AS FreeDefinedIndicator1Label,
  _NetworkActivity.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  _UserFieldLabel.FreeDefinedIndicator2Label AS FreeDefinedIndicator2Label,
  _NetworkActivity.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  _NetworkActivity._Supplier AS _Supplier
FROM I_NetworkActivityWithVersion AS _NetworkActivity
LEFT OUTER JOIN C_ProjectBasicInfo AS _Project ON ProjectInternalID = _Project.ProjectInternalID AND Version = _Project.Version  -- association [1..1]
LEFT OUTER JOIN C_WBSElementBasicInfo AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID AND Version = _WBSElement.Version  -- association [0..1]
LEFT OUTER JOIN C_ProjectNetworkBasicInfo AS _ProjectNetwork ON ProjectNetworkInternalID = _ProjectNetwork.ProjectNetworkInternalID AND Version = _ProjectNetwork.Version  -- association [0..1]
LEFT OUTER JOIN C_ProjMatlCompBasicInfo AS _ProjectMaterialComponent ON ProjectNetwork = _ProjectMaterialComponent.ProjectNetwork AND NetworkActivity = _ProjectMaterialComponent.NetworkActivity AND Version = _ProjectMaterialComponent.Version  -- association [0..*]
LEFT OUTER JOIN C_MilestoneBasicInfo AS _ProjectMilestone ON ProjectNetworkInternalID = _ProjectMilestone.ProjectNetworkInternalID AND NetworkActivityInternalID = _ProjectMilestone.NetworkActivityInternalID AND Version = _ProjectMilestone.Version  -- association [0..*]
LEFT OUTER JOIN C_ProjectStsObjActiveSts AS _Status ON NetworkActivityObject = _Status.StatusObject  -- association [0..*]
LEFT OUTER JOIN C_ProjPurDocItems AS _ProjPurDocItems ON ProjectNetworkInternalID = _ProjPurDocItems.ProjectNetworkInternalID AND NetworkActivityInternalID = _ProjPurDocItems.NetworkActivityInternalID  -- association [0..*]
LEFT OUTER JOIN I_ProjectValueHelp AS _ProjectValueHelp ON Project = _ProjectValueHelp.Project  -- association [0..1]
LEFT OUTER JOIN I_WBSElementValueHelp AS _WBSElementValueHelp ON WBSElement = _WBSElementValueHelp.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElementWithCodingMaskVH AS _WBSElementWithCodingMaskVH ON _WBSElementWithCodingMaskVH.WBSElement = WBSElement  -- association [0..1]
LEFT OUTER JOIN I_ProjectWithCodingMaskVH AS _ProjectWithCodingMaskVH ON _ProjectWithCodingMaskVH.Project = Project  -- association [0..1]
LEFT OUTER JOIN I_ProjectNtwkValueHelp AS _ProjectNtwkValueHelp ON ProjectNetwork = _ProjectNtwkValueHelp.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityValueHelp AS _NetworkActivityValueHelp ON ProjectNetwork = _NetworkActivityValueHelp.ProjectNetwork AND NetworkActivity = _NetworkActivityValueHelp.NetworkActivity  -- association [0..1]
LEFT OUTER JOIN I_ProjectVersionVH AS _ProjectVersionVH ON Project = _ProjectVersionVH.ProjectObjectExternalID AND Version = _ProjectVersionVH.Version AND _ProjectVersionVH.ObjectType = 'PD'  -- association [0..1]
LEFT OUTER JOIN I_FreeDfndTblFieldSemanticText AS _UserFieldLabel ON FreeDefinedTableFieldSemantic = _UserFieldLabel.FreeDefinedTableFieldSemantic AND _UserFieldLabel.Language = $session.system_language  -- association [0..1]
;