P_MaintOrdDirectProcmtViaPO

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_MaintOrdDirectProcmtViaPO.
-- 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: PMTORDPROMTPO

CREATE VIEW P_MaintOrdDirectProcmtViaPO AS
SELECT
  cast( '' as ebeln ) AS PurchaseRequisition,
  cast( '' as ebelp ) AS PurchaseRequisitionItem,
  cast( ' ' as xfeld preserving type ) AS OperationIsProcessedExternally,
  cast( _MaintenanceOrderComponent.MaintenanceOrderOperation as maintenanceorderoperation preserving type ) AS MaintenanceOrderOperation,
  cast( _MaintenanceOrderComponent.RequirementDate as abap.dats ) AS ReferenceDate,
  cast( '00000000' as fsavd ) AS OpErlstSchedldExecStrtDte,
  _MaintenanceOrder._MaintenancePriority._Text[ 1: Language = $session.system_language ].MaintPriorityDesc AS MaintPriorityDesc,
  _MaintenanceOrder._MaintenancePriority.MaintPriorityColorCode AS MaintPriorityColorCode,
  _MaintenanceOrder._LocationAccountAssignment.PlantSection AS PlantSection,
  _MaintenanceOrder._LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  '0000000000' AS MaintOrderRoutingNumber,
  '00000000' AS MaintOrderOperationCounter,
  ' ' AS Reservation,
  ' ' AS ReservationItem,
  '' AS ManufacturingOrderOperation,
  '' AS OperationDescription,
  '00000000' AS RequirementDate,
  I_PurchaseOrderItem._PurchaseOrder.Supplier AS Supplier,
  I_PurchaseOrderItem._PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  I_PurchaseOrderItem._PurchaseOrder.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  I_PurchaseOrderItem._PurchaseOrder.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  0 AS ReceivedQuantity,
  '' AS MaintOrdComponentIsMissing,
  I_PurchaseOrderItem._PurchaseOrder._Supplier AS _Supplier,
  I_LogisticsOrder.OrderID AS MaintenanceOrder,
  I_LogisticsOrder.OrderDescription AS OperationText,
  I_LogisticsOrder.PlannedStartDate AS MaintOrdBasicStartDate,
  I_LogisticsOrder.OrderDescription AS MaintenanceOrderDesc,
  I_LogisticsOrder.MainWorkCenter AS MainWorkCenter,
  I_LogisticsOrder.MainWorkCenterPlant AS MainWorkCenterPlant,
  I_LogisticsOrder.OrderType AS MaintenanceOrderType,
  _MaintenanceOrderComponent.MaintOrderComponentInternalID AS MaintOrdProcurementDocument,
  I_MaintOrdCompResvnPurgDoc.PurchaseOrder AS PurchaseOrder,
  I_MaintOrdCompResvnPurgDoc.PurchaseOrderItem AS PurchaseOrderItem,
  I_PurchaseOrderItem.Material AS Material,
  I_PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  I_PurchaseOrderItem.OrderQuantity AS OrderQuantity,
  I_PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  I_PurchaseOrderItem.ProductType AS ProductType,
  I_PurchaseOrderItem.PurchaseOrderItemText AS PurchaseOrderItemText,
  I_PurchaseOrderItem.Plant AS Plant,
  I_PurchaseOrderItem.StorageLocation AS StorageLocation,
  I_PurchaseOrderItem.NetAmount AS NetAmount,
  I_PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  _MaintenanceOrder.MaintPriorityType AS MaintPriorityType,
  _MaintenanceOrder.MaintPriority AS MaintPriority,
  _MaintenanceOrder.MaintenanceProcessingPhase AS MaintenanceProcessingPhase,
  _MaintenanceOrder.MaintenanceRevision AS MaintenanceRevision,
  _MaintenanceOrder.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _MaintenanceOrder.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _MaintenanceOrder.MaintenancePlant AS MaintenancePlant,
  _MaintenanceOrder.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  _MaintenanceOrder.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  _MaintenanceOrder.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  _MaintenanceOrder.ScheduledBasicEndTime AS ScheduledBasicEndTime,
  _MaintenanceOrder.WorkCenterInternalID AS WorkCenterInternalID,
  _MaintenanceOrder.Equipment AS Equipment,
  _MaintenanceOrder.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr
FROM I_MaintenanceOrderComponent_2 AS _MaintenanceOrderComponent
LEFT OUTER JOIN I_MaintOrdCompResvnPurgDoc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurgDocAccountAssignment ON /* join condition not captured in parsed metadata */
INNER JOIN I_LogisticsOrderBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON _PurchaseOrderItem.PurchaseOrder = PurchaseOrder AND _PurchaseOrderItem.PurchaseOrderItem = PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchaseOrder ON _PurchaseOrder.PurchasingDocument = PurchaseOrder  -- association [0..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 P_MaintOrdCompExpectedDelivs AS _ExpectedDeliveries ON _ExpectedDeliveries.PurchaseOrder = PurchaseOrder AND _ExpectedDeliveries.PurchaseOrderItem = PurchaseOrderItem AND _ExpectedDeliveries.RequirementDate = _MaintenanceOrderComponent.RequirementDate  -- association [0..1]
LEFT OUTER JOIN I_OrderOperation AS _MaintenanceOrderOperation ON _MaintenanceOrderOperation.OrderInternalID = MaintenanceOrder AND _MaintenanceOrderOperation.OrderOperationInternalID = MaintenanceOrderOperation  -- association [0..1]
LEFT OUTER JOIN I_OrderOperationDatesQty AS _OperationDates ON _OperationDates.OrderInternalID = I_OrderOperation.OrderInternalID AND _OperationDates.OrderOperationInternalID = I_OrderOperation.OrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _PreferredSupplier ON _PreferredSupplier.Supplier = preferredsupplier  -- association [0..1]
-- UNION ALL with additional select branch(es): I_LogisticsOrder, I_PurgDocAccountAssignment, I_OrderOperation
;