P_MaintOrdDirectProcmtViaPR

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_MaintOrdDirectProcmtViaPR.
-- 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: PMTORDPROMTPREQ

CREATE VIEW P_MaintOrdDirectProcmtViaPR AS
SELECT
  I_MaintOrdCompResvnPurgDoc.PurchaseRequisition AS PurchaseRequisition,
  I_MaintOrdCompResvnPurgDoc.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  cast( ' ' as xfeld preserving type ) AS OperationIsProcessedExternally,
  _MaintenanceOrderComponent.MaintenanceOrder AS MaintenanceOrder,
  _MaintenanceOrderComponent.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  _MaintenanceOrderComponent.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  _MaintenanceOrderComponent.Reservation AS Reservation,
  _MaintenanceOrderComponent.ReservationItem AS ReservationItem,
  cast( _MaintenanceOrderComponent.MaintenanceOrderOperation as maintenanceorderoperation preserving type ) AS MaintenanceOrderOperation,
  _MaintenanceOrderComponent.MaintenanceOrderOperation AS ManufacturingOrderOperation,
  _MaintenanceOrderOperation.OperationText AS OperationDescription,
  cast( _MaintenanceOrderComponent.RequirementDate as abap.dats ) AS ReferenceDate,
  _MaintenanceOrder.MaintOrdBasicStartDate AS MaintOrdBasicStartDate,
  cast( '00000000' as fsavd ) AS OpErlstSchedldExecStrtDte,
  _MaintenanceOrderComponent.RequirementDate AS RequirementDate,
  _MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  _MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  _MaintenanceOrder.MaintPriorityType AS MaintPriorityType,
  _MaintenanceOrder.MaintPriority AS MaintPriority,
  _MaintenanceOrder.MaintenanceProcessingPhase AS MaintenanceProcessingPhase,
  _MaintenanceOrder._MaintenancePriority._Text[ 1: Language = $session.system_language ].MaintPriorityDesc AS MaintPriorityDesc,
  _MaintenanceOrder._MaintenancePriority.MaintPriorityColorCode AS MaintPriorityColorCode,
  _MaintenanceOrder.MaintenanceRevision AS MaintenanceRevision,
  _MaintenanceOrder.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _MaintenanceOrder.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _MaintenanceOrder.MaintenancePlant AS MaintenancePlant,
  _MaintenanceOrder.MainWorkCenter AS MainWorkCenter,
  _MaintenanceOrder.MainWorkCenterPlant AS MainWorkCenterPlant,
  _MaintenanceOrder.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  _MaintenanceOrder.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  _MaintenanceOrder.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  _MaintenanceOrder.ScheduledBasicEndTime AS ScheduledBasicEndTime,
  _MaintenanceOrder._LocationAccountAssignment.PlantSection AS PlantSection,
  _MaintenanceOrder.WorkCenterInternalID AS WorkCenterInternalID,
  _MaintenanceOrder.Equipment AS Equipment,
  _MaintenanceOrder._LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  _MaintenanceOrder.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  _MaintenanceOrderComponent.Material AS Material,
  _MaintenanceOrderComponent.ComponentDescription AS MaterialName,
  _PurchaseRequisitionItem.PurchasingDocument AS PurchaseOrder,
  _PurchaseRequisitionItem.PurchasingDocumentItem AS PurchaseOrderItem,
  _PurchaseRequisitionItem.PurReqnCmpltnsCat AS PurReqnCmpltnsCat,
  _PurchaseRequisitionItem.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  _PurchaseRequisitionItem.RequestedQuantity AS RequestedQuantity,
  _PurchaseRequisitionItem.BaseUnit AS BaseUnit,
  _PurchaseRequisitionItem.PurReqnItemCurrency AS PurReqnItemCurrency,
  _PurchaseRequisitionItem.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  _PurchaseRequisitionItem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  _PurchaseRequisitionItem.PurchasingGroup AS PurchasingGroup,
  _PurchaseRequisitionItem.FixedSupplier AS Supplier,
  _PurchaseRequisitionItem._Supplier.SupplierName AS SupplierName,
  _PurchaseRequisitionItem.Supplier AS PreferredSupplier,
  _PurchaseRequisitionItem._Supplier.SupplierName AS PreferredSupplierName,
  _MaintenanceOrderComponent.MaintOrderComponentInternalID AS MaintOrdProcurementDocument,
  _ProcurementMilestone.MaintProcurementMilestone AS MaintProcurementMilestone,
  _ProcurementMilestone.MaintOrdProcmtMilestoneDate AS MaintOrdProcmtMilestoneDate,
  _ProcurementMilestone.MaintOrdProcmtMlstnDateTime AS MaintOrdProcmtMlstnDateTime,
  _PurchaseRequisitionItem._Supplier AS _Supplier
FROM I_MaintenanceOrderComponent_2 AS _MaintenanceOrderComponent
INNER JOIN I_MaintOrdCompResvnPurgDoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_LogisticsOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_LogisticsOrderBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PurchaseRequisitionItem ON _PurchaseRequisitionItem.PurchaseRequisition = PurchaseRequisition AND _PurchaseRequisitionItem.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintOrder ON _MaintOrder.MaintenanceOrder = MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN I_MaintOrdProcurementMilestone AS _ProcurementMilestone ON _ProcurementMilestone.MaintenanceOrder = MaintenanceOrder AND _ProcurementMilestone.MaintOrdProcurementDocument = MaintOrdProcurementDocument AND _ProcurementMilestone.MaintOrdProcmtMlstnIsCurrent = 'X'  -- association [1]
LEFT OUTER JOIN I_FunclocationLabelInternal AS _FuncnlLocationLabel ON _FuncnlLocationLabel.FunctionalLocation = functionallocation  -- association [0..*]
LEFT OUTER JOIN I_OrderOperation AS _MaintenanceOrderOperation ON _MaintenanceOrderOperation.OrderInternalID = _MaintenanceOrderComponent.MaintOrderRoutingNumber AND _MaintenanceOrderOperation.OrderOperationInternalID = _MaintenanceOrderComponent.MaintOrderOperationCounter  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _PreferredSupplier ON _PreferredSupplier.Supplier = PreferredSupplier  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = I_PurReqnAcctAssgmt.OrderID  -- association [1..1]
LEFT OUTER JOIN I_OrderOperationDatesQty AS _OperationDates ON _OperationDates.OrderInternalID = I_OrderOperation.OrderInternalID AND _OperationDates.OrderOperationInternalID = I_OrderOperation.OrderOperationInternalID  -- association [0..1]
-- UNION ALL with additional select branch(es): I_PurReqnAcctAssgmt, I_OrderOperation
;