P_ProjScheduleNtwkActAttrib

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_ProjScheduleNtwkActAttrib.
-- 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: PNTWKACTATTR

CREATE VIEW P_ProjScheduleNtwkActAttrib AS
SELECT
  NetworkActivity.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  NetworkActivity.NetworkActivityInternalID AS NetworkActivityInternalID,
  NetworkActivity.WBSElementInternalID AS WBSElementInternalID,
  NetworkActivity.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,
  NetworkActivity.NetworkActivity AS NetworkActivity,
  NetworkActivity.NetworkActivityObject AS NetworkActivityObject,
  NetworkActivity.SuperiorNtwkActivityInternalID AS SuperiorNtwkActivityInternalID,
  _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,
  cast( 0 as abap.int4 ) AS NumberOfAssignedMaterials,
  NetworkActivity.IsMarkedForDeletion AS IsMarkedForDeletion,
  NetworkActivity.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive,
  _WBSElement.ProjectInternalID AS ProjectInternalID,
  _WBSElement._Project AS _Project,
  NetworkActivity.Supplier AS Supplier,
  _NetworkActivityDatesQuantity.ActyConfFcstdEndDate AS ActyConfFcstdEndDate,
  _NetworkActivityDatesQuantity.ConstraintDateForBscStartDate AS ConstraintDateForBscStartDate,
  _NetworkActivityDatesQuantity.ConstraintDateForBscEndDate AS ConstraintDateForBscEndDate,
  _NetworkActivityDatesQuantity.ActyBscStartDateConstraintType AS ActyBscStartDateConstraintType,
  _NetworkActivityDatesQuantity.ActyBscEndDateConstraintType AS ActyBscEndDateConstraintType,
  _NetworkActivityDatesQuantity.ActyFcstEndDateConstraintType AS ActyFcstEndDateConstraintType,
  _NetworkActivityDatesQuantity.ActyFcstStartDteConstraintType AS ActyFcstStartDteConstraintType,
  _NetworkActivityDatesQuantity.ActyConfFcstdEndTime AS ActyConfFcstdEndTime,
  _NetworkActivityDatesQuantity.SchedldBasicLatestEndTime AS SchedldBasicLatestEndTime,
  _NetworkActivityDatesQuantity.SchedldBasicLatestStartTime AS SchedldBasicLatestStartTime,
  _NetworkActivityDatesQuantity.SchedldFcstdLatestEndTime AS SchedldFcstdLatestEndTime,
  _NetworkActivityDatesQuantity.SchedldFcstdLatestStartTime AS SchedldFcstdLatestStartTime,
  _NetworkActivityDatesQuantity.SchedldBasicEarliestEndTime AS SchedldBasicEarliestEndTime,
  _NetworkActivityDatesQuantity.SchedldBasicEarliestStartTime AS SchedldBasicEarliestStartTime,
  _NetworkActivityDatesQuantity.SchedldFcstdEarliestEndTime AS SchedldFcstdEarliestEndTime,
  _NetworkActivityDatesQuantity.SchedldFcstdEarliestStartTime AS SchedldFcstdEarliestStartTime,
  _NetworkActivityDatesQuantity.ConstraintTimeForBasicEndTime AS ConstraintTimeForBasicEndTime,
  _NetworkActivityDatesQuantity.ConstraintTimeForBscStartTime AS ConstraintTimeForBscStartTime,
  NetworkActivity._ProjectNetworkBasicData AS _ProjectNetworkBasicData
FROM I_NetworkActivityByInternalKey AS NetworkActivity
LEFT OUTER JOIN I_NetworkActivityDatesQuantity AS _NetworkActivityDatesQuantity ON ProjectNetworkInternalID = _NetworkActivityDatesQuantity.ProjectNetworkInternalID AND NetworkActivityInternalID = _NetworkActivityDatesQuantity.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN I_StsObjConcatActiveStsILL AS _ConcatenatedStsObjActiveSts ON _ConcatenatedStsObjActiveSts.StatusObject = NetworkActivityObject  -- association [1..1]
LEFT OUTER JOIN I_NetworkActivityUserFields AS _NetworkActivityUserFields ON _NetworkActivityUserFields.ProjectNetworkInternalID = ProjectNetworkInternalID AND _NetworkActivityUserFields.NetworkActivityInternalID = NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN I_WBSElementData_2 AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [1..1]
LEFT OUTER JOIN E_NetworkActivity AS _Extension ON ProjectNetworkInternalID = _Extension.ProjectNetworkInternalID AND NetworkActivityInternalID = _Extension.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN I_NetworkActivityByInternalKey AS _Superior ON SuperiorNtwkActivityInternalID = _Superior.NetworkActivityInternalID AND ProjectNetworkInternalID = _Superior.ProjectNetworkInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectMaterialCompBasicData AS _ProjScheduleMatlCompAttrib ON ProjectNetworkInternalID = _ProjScheduleMatlCompAttrib.ProjectNetworkInternalID AND NetworkActivityInternalID = _ProjScheduleMatlCompAttrib.NetworkActivityInternalID  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON NetworkActivity.Supplier = _Supplier.Supplier  -- association [0..1]
;