P_MaintOrdNonStkCompFrmPurReqn

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_MaintOrdNonStkCompFrmPurReqn.
-- 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: PMORDNSTKCMPPREQ

CREATE VIEW P_MaintOrdNonStkCompFrmPurReqn AS
SELECT
  I_PurReqnAcctAssgmt.PurchaseRequisition AS PurchaseRequisition,
  I_PurReqnAcctAssgmt.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_PurReqnAcctAssgmt.PurchaseReqnAcctAssgmtNumber AS PurchaseReqnAcctAssgmtNumber,
  I_LogisticsOrder.OrderID AS MaintenanceOrder,
  I_LogisticsOrder.OrderDescription AS MaintenanceOrderDesc,
  _MaintenanceOrder.MaintOrdProcessPhaseCode AS MaintOrdProcessPhaseCode,
  I_PurReqnAcctAssgmt.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  I_PurReqnAcctAssgmt.NetworkActivityInternalID AS NetworkActivityInternalID,
  I_PurReqnAcctAssgmt.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  I_MaintOrdCompResvnPurgDoc.Reservation AS Reservation,
  I_MaintOrdCompResvnPurgDoc.ReservationItem AS ReservationItem,
  I_MaintOrdCompResvnPurgDoc.RecordType AS ReservationType,
  I_LogisticsOrder.OrderType AS MaintenanceOrderType,
  '0000' AS MaintenanceOrderSubOperation,
  I_OrderOperation.Operation AS MaintenanceOrderOperation,
  I_OrderOperation.OperationText AS OperationDescription,
  I_OrderOperation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  I_OrderOperation.Supplier AS OperationSupplier,
  I_OrderOperation.PurchaseRequisition AS PurReqnAssgdToMaintOrderOp,
  I_OrderOperation.OperationControlProfile AS OperationControlProfile,
  _OperationControlProfile.OperationExternalProcessing AS OperationExternalProcessing,
  _PurchaseRequisitionItem.PurchasingDocument AS PurchaseOrder,
  _PurchaseRequisitionItem.PurchasingDocumentItem AS PurchaseOrderItem
FROM I_PurReqnAcctAssgmt
INNER JOIN I_LogisticsOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_MaintPlngBcktOrder AS _PlanningBucketOrder ON _PlanningBucketOrder.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PurchaseRequisitionItem ON _PurchaseRequisitionItem.PurchaseRequisition = PurchaseRequisition AND _PurchaseRequisitionItem.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = I_PurReqnAcctAssgmt.OrderID  -- association [1..1]
LEFT OUTER JOIN I_ReservationItem AS _ReservationItem ON _ReservationItem.Reservation = Reservation AND _ReservationItem.ReservationItem = ReservationItem AND _ReservationItem.RecordType = ReservationType  -- association [0..1]
LEFT OUTER JOIN I_MaintOperationExecStageCode AS _MaintOperationExecStageCode ON MaintOperationExecStageCode = _MaintOperationExecStageCode.MaintOperationExecStageCode  -- association [1..1]
LEFT OUTER JOIN I_OperationControlProfile AS _OperationControlProfile ON OperationControlProfile = _OperationControlProfile.OperationControlProfile  -- association [0..1]
;