C_MaintOrderOutputParamDetn

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 C_MaintOrderOutputParamDetn.
-- 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: CMNTORDPRMDR

CREATE VIEW C_MaintOrderOutputParamDetn AS
SELECT
  MaintenanceOrder,
  MaintenanceOrderType,
  MaintPriority,
  MaintenancePlant,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  _LocationAccountAssignment.PlantSection AS PlantSection,
  MainWorkCenter,
  Equipment,
  _Equipment.EquipmentCategory AS EquipmentCategory,
  _LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  _LocationAccountAssignment._FunctionalLocation.FunctionalLocationCategory AS FunctionalLocationCategory,
  Assembly,
  BusinessArea,
  MaintObjectLocAcctAssgmtNmbr,
  _LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  MaintenanceActivityType,
  cast ( MaintenanceProcessingPhase as eam_opd_ord_status preserving type ) AS MaintenanceProcessingPhase,
  MaintOrdProcessPhaseCode,
  MaintOrdProcessSubPhaseCode
FROM I_MaintenanceOrder
LEFT OUTER JOIN I_LocationAccountAssignment AS _LocationAccountAssignment ON MaintObjectLocAcctAssgmtNmbr = _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrder AS _MaintenanceOrderExtension ON MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder  -- association [0..1]
;