P_ProjSchedMaintOrdOpAttrib

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_ProjSchedMaintOrdOpAttrib.
-- 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: PMAINTOPERATTR

CREATE VIEW P_ProjSchedMaintOrdOpAttrib AS
SELECT
  NetworkActivity.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  NetworkActivity.NetworkActivityInternalID AS NetworkActivityInternalID,
  NetworkActivity.WBSElementInternalID AS WBSElementInternalID,
  _MaintanenceOrder.MaintenanceOrder AS ProjectNetwork,
  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,
  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,
  _MaintanenceOrder.OrderType AS OrderType,
  NetworkActivity.ControllingArea AS ControllingArea,
  _MaintanenceOrder.CostCenter AS CostCenter
FROM I_ProjSchedMaintOrdOpByIntKey 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 E_NetworkActivity AS _Extension ON ProjectNetworkInternalID = _Extension.ProjectNetworkInternalID AND NetworkActivityInternalID = _Extension.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN I_ProjSchedMaintOrderData AS _MaintanenceOrder ON ProjectNetworkInternalID = _MaintanenceOrder.OrderInternalBillOfOperations  -- association [0..1]
LEFT OUTER JOIN I_ProjSchedMaintOrdOpByIntKey AS _Superior ON SuperiorNtwkActivityInternalID = _Superior.NetworkActivityInternalID AND ProjectNetworkInternalID = _Superior.ProjectNetworkInternalID  -- association [0..1]
;