P_MaintOrdObjectsConsolidated

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_MaintOrdObjectsConsolidated.
-- 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_MaintOrdObjectsConsolidated AS
SELECT
  MaintenanceOrder,
  MaintenanceOrderObjectList,
  MaintenanceObjectListItem,
  Equipment,
  cast( '' as qmnum ) AS MaintenanceNotification,
  cast( '' as bautl ) AS Assembly,
  cast( '' as matnr ) AS Material,
  cast( '' as gernr ) AS SerialNumber,
  cast( '' as uii_char72 ) AS UniqueItemIdentifier,
  cast ( FunctionalLocation as vdm_eam_tplnr preserving type ) AS FunctionalLocation,
  cast( '' as obsort ) AS MaintObjectListItemSequence
FROM P_MaintenanceOrderDirectObject
LEFT OUTER JOIN I_Material AS _Assembly ON _Assembly.Material = Assembly  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON _FunctionalLocation.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON _Equipment.Equipment = Equipment  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceNotification AS _MaintenanceNotification ON _MaintenanceNotification.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _SerialNumber ON ( _SerialNumber.Material = Material AND _SerialNumber.SerialNumber = SerialNumber )  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _UniqueItemIdentifier ON _UniqueItemIdentifier.UniqueItemIdentifier = UniqueItemIdentifier  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON _Product.Product = Material  -- association [0..1]
-- UNION with additional select branch(es): I_MaintOrderObjectListItem
;