R_ProjNetworkActivityElementTP

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 R_ProjNetworkActivityElementTP.
-- 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.

CREATE VIEW R_ProjNetworkActivityElementTP AS
SELECT
  ProjectNetworkInternalID,
  NetworkActivityInternalID AS ProjNetworkActivityInternalID,
  ProjectNetwork,
  NetworkActivity,
  _ActivityShortText.LanguageBasedShortText AS NtwkActyLangBsdDescription,
  NetworkActivityDescription,
  NetworkActivityObject,
  SuperiorNtwkActivityInternalID,
  SuperiorNtwkActivityExternalID,
  WBSElementInternalID,
  WorkCenterInternalID,
  _WorkCenter.WorkCenter AS WorkCenter,
  Plant,
  _NtwkActivityDatesQuantity.PlannedWorkQuantity AS PlannedWorkQuantity,
  _NtwkActivityDatesQuantity.StandardWorkQuantityUnit1 AS StandardWorkQuantityUnit1,
  OperationCalculationControl,
  CostCtrActivityType,
  NetworkActivityControlProfile,
  ActyIsTakenAcctForProjSmmry,
  CapacityRequirementDistrKey,
  NumberOfCapacities,
  OperationWorkPercent,
  StandardTextInternalID,
  StandardDurationIsFlexible,
  FactoryCalendar,
  ExtProcgOperationHasSubcontrg,
  PurchasingInfoRecord,
  PurchasingOrganization,
  Supplier,
  PurchasingGroup,
  OpPurchaseOutlineAgreement,
  OpPurchaseOutlineAgreementItem,
  ExternalProcessingPrice,
  NetworkActivityCurrency,
  NetworkActivityPriceBaseQty,
  CostElement,
  PurgInfoRecdDataIsFixed,
  _NtwkActivityDatesQuantity.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  _NtwkActivityDatesQuantity.OperationQuantity AS OperationQuantity,
  _NtwkActivityDatesQuantity.OperationQuantityUnit AS OperationQuantityUnit,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  MaterialGroup,
  PurchasingInfoRecdAddlGrpgName,
  RequisitionerUser,
  GoodsRecipientName,
  OperationTrackingNumber,
  UnloadingPointName,
  _NtwkActivityDatesQuantity.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  _NtwkActivityDatesQuantity.SchedldBasicEarliestStartTime AS SchedldBasicEarliestStartTime,
  _NtwkActivityDatesQuantity.SchedldBasicEarliestEndDate AS SchedldBasicEarliestEndDate,
  _NtwkActivityDatesQuantity.SchedldBasicEarliestEndTime AS SchedldBasicEarliestEndTime,
  _NtwkActivityDatesQuantity.SchedldBasicLatestStartDate AS SchedldBasicLatestStartDate,
  _NtwkActivityDatesQuantity.SchedldBasicLatestStartTime AS SchedldBasicLatestStartTime,
  _NtwkActivityDatesQuantity.ScheduledBasicLatestEndDate AS ScheduledBasicLatestEndDate,
  _NtwkActivityDatesQuantity.SchedldBasicLatestEndTime AS SchedldBasicLatestEndTime,
  _NtwkActivityDatesQuantity.ActualStartDate AS ActualStartDate,
  _NtwkActivityDatesQuantity.ActualExecutionStartTime AS ActualExecutionStartTime,
  _NtwkActivityDatesQuantity.ActualEndDate AS ActualEndDate,
  _NtwkActivityDatesQuantity.ActualExecutionEndTime AS ActualExecutionEndTime,
  _NtwkActivityDatesQuantity.ActyConfFcstdEndDate AS ActyConfFcstdEndDate,
  _NtwkActivityDatesQuantity.ActyConfFcstdEndTime AS ActyConfFcstdEndTime,
  _NtwkActivityDatesQuantity.ActualWorkQuantity AS ActualWorkQuantity,
  _NtwkActivityDatesQuantity.ActivityConfFcstdDuration AS ActivityConfFcstdDuration,
  _NtwkActivityDatesQuantity.ActivityConfFcstdDurationUnit AS ActivityConfFcstdDurationUnit,
  _NtwkActivityDatesQuantity.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  _NtwkActivityDatesQuantity.SchedldFcstdEarliestStartTime AS SchedldFcstdEarliestStartTime,
  _NtwkActivityDatesQuantity.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  _NtwkActivityDatesQuantity.SchedldFcstdEarliestEndTime AS SchedldFcstdEarliestEndTime,
  _NtwkActivityDatesQuantity.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  _NtwkActivityDatesQuantity.SchedldFcstdLatestStartTime AS SchedldFcstdLatestStartTime,
  _NtwkActivityDatesQuantity.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  _NtwkActivityDatesQuantity.SchedldFcstdLatestEndTime AS SchedldFcstdLatestEndTime,
  CompanyCode,
  BusinessArea,
  NetworkActivityObjectCurrency,
  TaxJurisdictionCalcProcedure,
  ProfitCenter,
  OverheadCode,
  ChangeNumber,
  TaxJurisdiction,
  FunctionalArea,
  ControllingObjectClass,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  _NetworkActivityUserFields.FreeDefinedTableFieldSemantic AS FreeDefinedTableFieldSemantic,
  _NetworkActivityUserFields.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  _NetworkActivityUserFields.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  _NetworkActivityUserFields.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  _NetworkActivityUserFields.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  _NetworkActivityUserFields.FreeDefinedQuantity1 AS FreeDefinedQuantity1,
  _NetworkActivityUserFields.FreeDefinedQuantity1Unit AS FreeDefinedQuantity1Unit,
  _NetworkActivityUserFields.FreeDefinedQuantity2 AS FreeDefinedQuantity2,
  _NetworkActivityUserFields.FreeDefinedQuantity2Unit AS FreeDefinedQuantity2Unit,
  _NetworkActivityUserFields.FreeDefinedAmount1 AS FreeDefinedAmount1,
  _NetworkActivityUserFields.FreeDefinedAmount1Currency AS FreeDefinedAmount1Currency,
  _NetworkActivityUserFields.FreeDefinedAmount2 AS FreeDefinedAmount2,
  _NetworkActivityUserFields.FreeDefinedAmount2Currency AS FreeDefinedAmount2Currency,
  _NetworkActivityUserFields.FreeDefinedDate1 AS FreeDefinedDate1,
  _NetworkActivityUserFields.FreeDefinedDate2 AS FreeDefinedDate2,
  _NetworkActivityUserFields.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  _NetworkActivityUserFields.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  ProgressAnlysAggregationWeight,
  NetworkActivityCost,
  PartnerCostCenter,
  Language,
  NtwkAccountAssignmentCode,
  IsMarkedForDeletion,
  cast (case when ProjNtwkIsRlvtForMatlPlng = ' ' then '3' when ProjNtwkIsRlvtForMatlPlng = 'X' then '2' when ProjNtwkIsRlvtForMatlPlng = '1' then '1' when ProjNtwkIsRlvtForMatlPlng = 'B' then '4' end as abap.char( 1 ) ) as PurReqnOrResvnGeneration AS char1asPurReqnOrResvnGeneration,
  _NetworkActivityUserFields.JointVenture AS JointVenture,
  _NetworkActivityUserFields.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  _NetworkActivityUserFields.JointVentureEquityType AS JointVentureEquityType,
  _NetworkActivityUserFields.JointVentureObjectType AS JointVentureObjectType,
  _NetworkActivityUserFields.JointVentureClass AS JointVentureClass,
  _NetworkActivityUserFields.JointVentureSubClass AS JointVentureSubClass,
  _NetworkActivityUserFields.JntVentureOriglCostObjectType AS JntVentureOriglCostObjectType,
  _NtwkActivityDatesQuantity.StandardWorkQuantityUnit AS StandardWorkQuantityUnit,
  cast ( '' as char1 ) AS SetOfDatesForOffsets,
  _NtwkActivityDatesQuantity.StartDateOffsetDurationUnit AS StartDateOffsetDurationUnit,
  _NtwkActivityDatesQuantity.StartDateOffsetDuration AS StartDateOffsetDuration,
  _NtwkActivityDatesQuantity.EndDateOffsetDuration AS EndDateOffsetDuration,
  _NtwkActivityDatesQuantity.EndDateOffsetDurationUnit AS EndDateOffsetDurationUnit,
  MatPlanningPrimaryCost,
  ReferenceElement,
  _ControllingArea.ControllingAreaCurrency AS ControllingAreaCurrency,
  _ProjNtwkObjPurReqGrpgInd.PurReqnCollectiveIndicatorCode AS PurReqnCollectiveIndicatorCode,
  _ProjectNetwork.ProjectInternalID AS ProjectInternalID,
  I_NtwkActyByInternalKeyData.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive
FROM I_NtwkActyByInternalKeyData
LEFT OUTER JOIN R_ProjectNetworkTP AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [1..1]
LEFT OUTER JOIN I_WBSElementData_2 AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjNtwkObjPurReqGrpgInd AS _ProjNtwkObjPurReqGrpgInd ON _ProjNtwkObjPurReqGrpgInd.ProjectNetworkComponentID = '00000000000000E' AND ProjectNetwork = _ProjNtwkObjPurReqGrpgInd.ProjectNetwork AND SuperiorNtwkActivityExternalID = _ProjNtwkObjPurReqGrpgInd.NetworkActivity AND NetworkActivity = _ProjNtwkObjPurReqGrpgInd.OrderSuboperation AND PurchaseRequisition = _ProjNtwkObjPurReqGrpgInd.PurchaseRequisition  -- association [1..*]
LEFT OUTER JOIN E_NetworkActivity AS _Extension ON ProjectNetworkInternalID = _Extension.ProjectNetworkInternalID AND ProjNetworkActivityInternalID = _Extension.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN R_ProjNtwkActyElmntConfTP AS _NtwkActElementConfirmation ON /* condition not available in parsed metadata */  -- association [0..*]
;