P_ProjSchedNtwkActVersAttrib

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_ProjSchedNtwkActVersAttrib.
-- 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: PNWKACTVERSATTR

CREATE VIEW P_ProjSchedNtwkActVersAttrib AS
SELECT
  NetworkActivity.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  NetworkActivity.NetworkActivityInternalID AS NetworkActivityInternalID,
  Version,
  NetworkActivity.WBSElementInternalID AS WBSElementInternalID,
  _ProjectNetworkBasicData.ProjectNetwork AS ProjectNetwork,
  case when _WBSElement._Project.ProjectObject is not initial then _WBSElement._Project.ProjectObject else NetworkActivity._ProjectNetworkBasicData._Project.ProjectObject end as ProjectObject AS ProjectObjectendasProjectObject,
  _ProjectNetworkBasicData.RelatedProjectNetwork AS RelatedProjectNetwork,
  NetworkActivity.NetworkActivity AS NetworkActivity,
  NetworkActivity.NetworkActivityObject AS NetworkActivityObject,
  NetworkActivity.SuperiorNtwkActivityInternalID AS SuperiorNtwkActivityInternalID,
  NetworkActivity.NetworkActivityDescription AS NetworkActivityDescription,
  _NetworkActivityDatesQuantity.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  _NetworkActivityDatesQuantity.SchedldBasicEarliestEndDate AS SchedldBasicEarliestEndDate,
  _NetworkActivityDatesQuantity.SchedldBasicLatestStartDate AS SchedldBasicLatestStartDate,
  _NetworkActivityDatesQuantity.ScheduledBasicLatestEndDate AS ScheduledBasicLatestEndDate,
  _NetworkActivityDatesQuantity.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  _NetworkActivityDatesQuantity.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  _NetworkActivityDatesQuantity.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  _NetworkActivityDatesQuantity.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  _NetworkActivityDatesQuantity.ActualStartDate AS ActualStartDate,
  _NetworkActivityDatesQuantity.ActualEndDate AS ActualEndDate,
  _NetworkActivityDatesQuantity.ActualExecutionStartTime AS ActualExecutionStartTime,
  _NetworkActivityDatesQuantity.ActualExecutionEndTime AS ActualExecutionEndTime,
  _NetworkActivityDatesQuantity.StandardDuration AS StandardDuration,
  _NetworkActivityDatesQuantity.StandardDurationUnit AS StandardDurationUnit,
  _NetworkActivityDatesQuantity.FcstdStandardDurationUnit AS FcstdStandardDurationUnit,
  _NetworkActivityDatesQuantity.PlannedWorkQuantity AS PlannedWorkQuantity,
  _NetworkActivityDatesQuantity.NtwkActivityWorkQuantityUnit AS NtwkActivityWorkQuantityUnit,
  _NetworkActivityDatesQuantity.ActualWorkQuantity AS ActualWorkQuantity,
  _NetworkActivityUserFields.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  _NetworkActivityUserFields.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  _NetworkActivityUserFields.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  _NetworkActivityUserFields.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  _NetworkActivityUserFields.FreeDefinedQuantity1Unit AS FreeDefinedQuantity1Unit,
  _NetworkActivityUserFields.FreeDefinedQuantity1 AS FreeDefinedQuantity1,
  _NetworkActivityUserFields.FreeDefinedQuantity2Unit AS FreeDefinedQuantity2Unit,
  _NetworkActivityUserFields.FreeDefinedQuantity2 AS FreeDefinedQuantity2,
  _NetworkActivityUserFields.FreeDefinedAmount1Currency AS FreeDefinedAmount1Currency,
  _NetworkActivityUserFields.FreeDefinedAmount1 AS FreeDefinedAmount1,
  _NetworkActivityUserFields.FreeDefinedAmount2Currency AS FreeDefinedAmount2Currency,
  _NetworkActivityUserFields.FreeDefinedAmount2 AS FreeDefinedAmount2,
  _NetworkActivityUserFields.FreeDefinedDate1 AS FreeDefinedDate1,
  _NetworkActivityUserFields.FreeDefinedDate2 AS FreeDefinedDate2,
  _NetworkActivityUserFields.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  _NetworkActivityUserFields.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  NetworkActivity._WorkCenter.WorkCenter AS WorkCenter,
  NetworkActivity.OperationImportance AS OperationImportance,
  _WBSElement.WBSElementHierarchyLevel AS WBSElementHierarchyLevel,
  NetworkActivity.NetworkActivityCurrency AS NetworkActivityCurrency,
  NetworkActivity.NetworkActivityObjectCurrency AS NetworkActivityObjectCurrency,
  _NetworkActivityDatesQuantity.TotalFloatForBasicDates AS TotalFloatForBasicDates,
  _NetworkActivityDatesQuantity.BasicDatesFreeFloat AS BasicDatesFreeFloat,
  NetworkActivity.Plant AS Plant,
  NetworkActivity.CompanyCode AS CompanyCode,
  NetworkActivity.NetworkActivityControlProfile AS NetworkActivityControlProfile,
  _NetworkActivityDatesQuantity.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  NetworkActivity.CostElement AS CostElement,
  FactoryCalendar,
  NetworkActivity.IsMarkedForDeletion AS IsMarkedForDeletion,
  NetworkActivity._ProjectNetworkBasicData AS _ProjectNetworkBasicData
FROM I_NetworkActivityVersByIntKey AS NetworkActivity
LEFT OUTER JOIN I_NetworkActVersDatesQuantity AS _NetworkActivityDatesQuantity ON ProjectNetworkInternalID = _NetworkActivityDatesQuantity.ProjectNetworkInternalID AND NetworkActivityInternalID = _NetworkActivityDatesQuantity.NetworkActivityInternalID AND Version = _NetworkActivityDatesQuantity.Version  -- association [1..1]
LEFT OUTER JOIN I_StsObjConcatActiveStsILL AS _ConcatenatedStsObjActiveSts ON _ConcatenatedStsObjActiveSts.StatusObject = NetworkActivityObject  -- association [1..1]
LEFT OUTER JOIN I_NtwkActivityVersUserFields AS _NetworkActivityUserFields ON _NetworkActivityUserFields.ProjectNetworkInternalID = ProjectNetworkInternalID AND _NetworkActivityUserFields.NetworkActivityInternalID = NetworkActivityInternalID AND _NetworkActivityUserFields.Version = Version  -- association [1..1]
LEFT OUTER JOIN I_WBSElementVersionData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID AND Version = _WBSElement.Version  -- association [1..1]
LEFT OUTER JOIN E_NetworkActivityVersion AS _Extension ON ProjectNetworkInternalID = _Extension.ProjectNetworkInternalID AND NetworkActivityInternalID = _Extension.NetworkActivityInternalID AND Version = _Extension.Version  -- association [1..1]
LEFT OUTER JOIN I_NetworkActivityVersByIntKey AS _Superior ON SuperiorNtwkActivityInternalID = _Superior.NetworkActivityInternalID AND ProjectNetworkInternalID = _Superior.ProjectNetworkInternalID AND Version = _Superior.Version  -- association [0..1]
LEFT OUTER JOIN I_ProjMatCompVersBasicData AS _ProjScheduleMatlCompAttrib ON ProjectNetworkInternalID = _ProjScheduleMatlCompAttrib.ProjectNetworkInternalID AND NetworkActivityInternalID = _ProjScheduleMatlCompAttrib.NetworkActivityInternalID AND Version = _ProjScheduleMatlCompAttrib.Version  -- association [0..1]
;