P_MaintOrderForComplPreAggr

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_MaintOrderForComplPreAggr.
-- 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.

CREATE VIEW P_MaintOrderForComplPreAggr AS
SELECT
  I_MaintenanceOrder.MaintenanceOrder AS MaintenanceOrder,
  MaintenanceOrderDesc,
  MaintOrdPersonResponsible,
  cast( max( case when PurchasingDocumentItemCategory <> '9' then 'X' end ) as xfeld preserving type ) AS MaintOrdHasOpenPurchaseOrders,
  cast( max( case when PurchasingDocumentItemCategory = '9' then 'X' end ) as xfeld preserving type ) AS MaintOrdHasOpenServices,
  cast( max( case when ReservationItemIsFinallyIssued = '' and MaterialCompIsProcuredDirectly = '' then 'X' end ) as xfeld preserving type ) AS MaintOrderHasOpenReservations,
  MaintOrdBasicEndDate AS ReferenceDate,
  MaintenanceRevision,
  I_MaintenanceOrder.ControllingArea AS ControllingArea,
  MaintenanceOrderInternalID,
  Currency,
  MainWorkCenter,
  MainWorkCenterPlant,
  ResponsibleCostCenter,
  MaintenancePlanningPlant,
  MaintenanceOrderType,
  MaintenancePlannerGroup,
  MaintenancePlant,
  MaintObjectLocAcctAssgmtNmbr,
  Equipment
FROM I_MaintenanceOrder
;