C_MaintOrderOperationTP

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_MaintOrderOperationTP.
-- 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: CMAINTORDOPERTP

CREATE VIEW C_MaintOrderOperationTP AS
SELECT
  I_MaintOrderOperationTP.MaintenanceOrder AS MaintenanceOrder,
  I_MaintOrderOperationTP.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  I_MaintOrderOperationTP.MaintOrderOperationForEdit AS MaintOrderOperationForEdit,
  I_MaintOrderOperationTP.MaintOrdOpProcessPhaseCode AS MaintOrdOpProcessPhaseCode,
  I_MaintOrderOperationTP.MaintOrdOpProcessSubPhaseCode AS MaintOrdOpProcessSubPhaseCode,
  I_MaintOrderOperationTP.TechnicalObject AS TechnicalObject,
  I_MaintOrderOperationTP.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  I_MaintOrderOperationTP.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  I_MaintOrderOperationTP.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  I_MaintOrderOperationTP.OperationDescription AS OperationDescription,
  I_MaintOrderOperationTP.Equipment AS Equipment,
  I_MaintOrderOperationTP.FunctionalLocation AS FunctionalLocation,
  I_MaintOrderOperationTP.Plant AS Plant,
  I_MaintOrderOperationTP.OperationWorkCenterInternalID AS OperationWorkCenterInternalID,
  I_MaintOrderOperationTP.OperationWorkCenter AS OperationWorkCenter,
  I_MaintOrderOperationTP.OperationWorkCenterTypeCode AS OperationWorkCenterTypeCode,
  cast ( I_MaintOrderOperationTP.OperationPersonResponsible as eam_person_responsible ) AS OperationPersonResponsible,
  cast( '' as xfeld ) AS UserIsPersonResponsible,
  I_MaintOrderOperationTP.OperationPlannedWork AS OperationPlannedWork,
  I_MaintOrderOperationTP.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  I_MaintOrderOperationTP.OperationDuration AS OperationDuration,
  I_MaintOrderOperationTP.OperationDurationUnit AS OperationDurationUnit,
  I_MaintOrderOperationTP.OperationCalculationControl AS OperationCalculationControl,
  I_MaintOrderOperationTP.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  I_MaintOrderOperationTP.ConfirmationTotalQuantity AS ConfirmationTotalQuantity,
  MaintOperationExecStageCode,
  _MaintOpExecStageCode.MaintOpExecStageGroupCode AS MaintOpExecStageGroupCode,
  I_MaintOrderOperationTP.EAMOverallObjectStatusProfile AS EAMOverallObjectStatusProfile,
  I_MaintOrderOperationTP.EAMOverallObjectStatus AS EAMOverallObjectStatus,
  _OperationControlKey.ConfirmationIsNotPossible AS ConfirmationIsNotPossible,
  I_MaintOrderOperationTP.IsFinallyConfirmed AS IsFinallyConfirmed,
  OperationSupplier,
  I_MaintOrderOperationTP._TechnicalObject AS _TechnicalObject,
  I_MaintOrderOperationTP._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc,
  I_MaintOrderOperationTP._WorkCenter AS _WorkCenter,
  I_MaintOrderOperationTP._StatusObjectActiveStatus AS _StatusObjectActiveStatus,
  I_MaintOrderOperationTP._OverallStatus AS _OverallStatus,
  I_MaintOrderOperationTP._OperationCalculationControl AS _OperationCalculationControl,
  I_MaintOrderOperationTP._EAMProcessPhase AS _EAMProcessPhase,
  I_MaintOrderOperationTP._EAMProcessSubPhase AS _EAMProcessSubPhase,
  I_MaintOrderOperationTP._MaintOperationExecStageCode AS _MaintOperationExecStageCode
FROM I_MaintOrderOperationTP
LEFT OUTER JOIN C_PMWorkCenterVH AS _WorkCenterVH ON OperationWorkCenter = _WorkCenterVH.WorkCenter AND Plant = _WorkCenterVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_MaintOrderTP AS _MaintOrderTP ON MaintenanceOrder = _MaintOrderTP.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN C_MaintOrderComponentTP AS _MaintOrderComponentTP ON MaintenanceOrder = _MaintOrderComponentTP.MaintenanceOrder AND MaintenanceOrderOperation = _MaintOrderComponentTP.MaintenanceOrderOperation  -- association [0..*]
LEFT OUTER JOIN I_PMTimeUnitVH AS _PlannedWorkUnitOfMeasure ON OperationPlannedWorkUnit = _PlannedWorkUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PMTimeUnitVH AS _DurationUnitOfMeasure ON OperationDurationUnit = _DurationUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PMContactCardEmployee AS _PersonResponsible ON OperationPersonResponsible = _PersonResponsible.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON _WorkCenterText.WorkCenterInternalID = OperationWorkCenterInternalID AND _WorkCenterText.WorkCenterTypeCode = 'A'  -- association [0..*]
LEFT OUTER JOIN C_MaintOrdOperationQuickVw AS _QuickView ON _QuickView.MaintenanceOrder = MaintenanceOrder AND _QuickView.MaintenanceOrderOperation = MaintenanceOrderOperation AND _QuickView.MaintenanceOrderSubOperation = ' '  -- association [0..1]
LEFT OUTER JOIN I_MaintOperationExecStageCode AS _MaintOpExecStageCode ON MaintOperationExecStageCode = _MaintOpExecStageCode.MaintOperationExecStageCode  -- association [0..1]
LEFT OUTER JOIN I_MaintOpExecStageCodeText AS _MaintOpExecStageCodeText ON _MaintOpExecStageCodeText.MaintOperationExecStageCode = MaintOperationExecStageCode  -- association [0..*]
LEFT OUTER JOIN C_MaintOrderSubOperationTP AS _MaintOrderSubOperationTP ON MaintenanceOrder = _MaintOrderSubOperationTP.MaintenanceOrder AND MaintenanceOrderOperation = _MaintOrderSubOperationTP.MaintenanceOrderOperation  -- association [0..*]
;